Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Production Statistics Report reports on completed orders and orders that are pending completion (shipped but not gone through a day end). It displays a variety of information and in some cases shows it in more than one way. This report does not include Stock orders.

You can select a date range, a print by option, a customer, a report group and whether you want subtotals by customer. Each of these options will be discussed below.

...

Print By - you can select from Ordered By or Ship ToCustomer - you can select one specific customer, “All”, or (none). You will only select (none) when you want to report by Report GroupBill To, Ship To, or Ordered By. Ordered By is the same as Bill To unless the Billing account is flagged as a VSP, in which case orders will be printed using the Ship To account.

Start Customer - You can select a customer to begin reporting from, “First” or “(none)”. Choosing “(none)” will switch to using a Report Group, the same as the Use Group button.

End Customer - You can select a customer to end reporting with or “Last” or “(none)”.

Report Group - you can select one specific report group or (none). Please see Report Groups for details on how to create.

...

Please see a sample report below for customer #001, ABC LAB.

...

Image Removed

Image RemovedImage Removed

Image Removed

PDF
nametest.PDF

Information on how fields are calculated:

...

Days/Job - Number of Days to Complete Job / Number of Jobs The number of days to complete job is the number of days from the order receive date to the order completion date minus any days that are marked as holiday dates in the Holiday Dates database. *NOTE - if the order receive date and the order completion date are the same, the Number of Days to Complete Job is zero. This is consistent with other Rx-Universe reports.

Sales - Total of all Jobs

Avg. Lens Price (Pair) - Total Lens Price / Total number of Lenses, then multiplied by 2

...

Avg. Other Price - Total Other Price / Total number of jobs that had Other Prices Other prices are addons, misc fields, etc. (any price that is not a frame, temple, side shield or a lens).

Avg. Total Price - Sales / Number of Jobs

Avg Days - Days taken to complete jobs / Number of Jobs

Finished Lenses - Number of Jobs using Finished Lenses / Number of Jobs

Information on what is included in the different tables:

...

Job Type - There are five possible types: New Jobs, Redo Jobs, Warranty Jobs, Third Party Jobs and Outsourced Jobs

Material Group - Will report on material reporting groups. If a material/treatment/tint does not belong to a material reporting group, the material/treatment/tint will be shown. Please see Material Reporting Groups for information on how to set up.

Seg Group - Will report on lens style reporting groups. If a lens style does not belong to a lens style reporting group, the lens style will be shown. Please see Lens Style Reporting Groups for information on how to set up.

Priority - There are two possible types: Regular and Hot

Remakes - There are five possible types: Dr. Redo, Lab Redo, Warranty, Non-Adapt and Misc. The remakes will only appear if there are jobs with remakes for the reporting criteria.

Lens Breakage - Will depend on the breakage codes you have set up and will only appear if there are jobs with breakages for the reporting criteria.

Services - Will report on anything that has been applied to a lens as well as addons that have been used for the reporting criteria.

Material Attribute - Will report on pre-treatments that are already on lenses that have been used for the reporting criteria.

Shipping - Will depend on the shipping codes you have set up and will only appear if there are jobs with shipping for the reporting criteria..

Percent Completed Jobs - Breaks down completed jobs into 4 categories:

  • Uncut jobs are Uncut with or without a frame

  • Addon Jobs are Addon or Edge Only jobs

  • Safety Jobs are any job with a safety frame that are not Uncut/Addon

  • Dress Jobs are everything else

    Note on Addon jobs: These include Edge-Only jobs. Addon jobs never increase the Lenses count of tables becasue the lab has not sold the blanks in these cases.

View file
nametest.PDF