Click here to view the Estimated Delivery Date menu.

Click here to view the complete Optifacts User Documentation Index.

Click here to Contact us.

Introduction

This document provides instructions for .....

Procedure

Coming soon....an explanation on how the Estimated Delivery Date is calculated and also shows what tables are used.

Procedure

Programs:

$CWD/progs/ofdemon (update to use tt_ststop table)

$CWD/progs/edd

$CWD/progs/edd_report

Tables:

1. The edd_acct table is where each account’s cut off time is entered. Any job coming in after the cut off time will start counting from the next day.
2. The edd_cal table is where the lab enters what days and hours they work. The days worked can either be Y (full day), H (half day) or N (don’t work).
3. The edd_courier table is where each courier’s pickup time is entered. Any job expected after the pickup time will have 1 day added to the time.
4. The edd_ctrl table is the control table to find the length of time needed for the lens.
5. The edd_liteups table is where each lite-up is entered a length of time needed.
6. The grp_style table is where you can enter a name set with certain criteria and use that name set in the edd_ctrl table.
7. The grp_rx table is where you can enter a name set with certain criteria and use that name set in the edd_ctrl table.
8. The grp_mat table is where you can enter a name set with certain criteria and use that name set in the edd_ctrl table.
9. The grp_color table is where you can enter a name set with certain criteria and use that name set in the edd_ctrl table.

Where are the menu options located?

From the Optifacts main menu:

• Type 3 – Editor Utilities and press enter.
• Type 13 - Estimated Delivery Date and press enter.

Here you have two options either the editor or reports. 

• The editor menu will have the menus for all of the tables above to use for this project.
• The reports are on the EDD tables only listed above.

Here is how the calculation is done

1. Job gets entered in.
2. Take the entered time and compare it against the cut-off time for this account. If the time is under the cut-off time, start counting the days from today.  If the entered time is above the cut-off time, start counting the days from the next day instead of today.
3. If there is NO cut-off time for an account, the program will NOT continue to estimate the date.
4. Next the program will go to the edd_liteup table and search through each lite-up the job has turned on and add the appropriate time for each one. It will look for a specific account entry first and then try account 0.
5. Then we go to the edd_ctrl control to see what type of job it is. It starts with the highest number first and works it way down until it finds a match.  It does each eye separately.  Once it finds a match, it looks if any lite-ups are in the record.  If there are lite-ups in the entry and the lite-up is turned on, it will override the value from the edd_liteups table.  If the job is a split and the value for each eye is different, the computer will select the largest time.  Special Note:  The style, material and color fields use both name sets and regular Optifacts codes.  The program will try to find a group name set first and if not there then tray the regular Optifacts code and if that fails go to all Optifacts codes.  An example is SV for Single Vision lens.  The program looks for SV as a group name set, then it will look for SV code and finally it will look for all style codes.
6. Now we have the time needed, we go to the calendar to find out the date. The program looks at each day to see if the lab works and finds the date the job will be done.
7. Once the date is found, the program puts a record in the job_data table with the date. This allows you to print the date on the work ticket and invoice.

Click here to return to the top of the page.