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 setting up the configuration to calculate the next expected pick-up time for a fixed bin and output it to the XML Invoice (delivery note) when a job is mailed out. This is used best when there are multiple pick-up times a day or different pick-up times on different days.

Procedure

Programs:

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

$CWD/progs/custed (update to include Track Stages Editor)

$CWD/tt_forms/bin_close.frm (update to include steps)

Note:  A new table bin_close_times has been created.

Custom Configurations

From the Optifacts main menu:

Type 3 – Editor Utilities and press enter.

Type 6 –Configuration Editor and press enter.

Type 6 – Edit Custom Configuration and press enter

The Custom Configuration Editor displays

• Press Q to Query to ensure that the table below exists.

If the table does not exist:

• Type A to add a new record.

• Enter all the information as shown below.

• Press Escape to save the data.

• Type E to exit.

Account Configuration

Pick-up times are assigned by Zone which is stored in the Fixed Bin # field for a customer account.

From the Optifacts main menu:

Type 3 – Editor Utilities and press enter.

Type 1 – Customer Database Editor and press enter.

Type 4 – Add/Edit Account and press enter.

• Fill in the Company code, Branch code, Sales Territory code and Account number. Press enter after the account number.

The Account information displays on screen.

• Press enter until you reach the Fixed Bin # field.

• Type the bin number and continue to press enter past all fields.

Is the data correct (Y/N)?

• Type Y if correct and save the data

• Or, type N to edit.

• Press Escape 4 times to exit.

Expected Pick-up Time Configuration

The pick-up times for the zone must be entered for each day of the week that there is a pick-up. If there is not pick-up on a day, do not put in an entry for it.

                Sunday = 0

                Monday = 1

                Tuesday = 2

                Wednesday = 3

                Thursday = 4

                Friday = 5

                Saturday = 6

Times are entered using 24 hour format as HHMMSS. For example 4 pm would be entered as 160000. The screen shot example shown below is for a 1:30 pm pick-up on Tuesday (weekday number 2) for Zone/Fixed Bin 1.

From the Optifacts main menu:

Type 3 – Editor Utilities and press enter.

Type 1 – Customer Database Editor and press enter.

Type 18 – Expected Pick-Up Time Editor and press enter.

The Expected Pick-up Times Editor displays.

• Type A to add a new record.
• Fill in all the information as applicable, pressing enter past each field.
• Press Escape to save the data.
• Type E to exit.

The example shown below is for a 1:30 pm pick-up on Tuesday (weekday number 2) for Zone/Fixed Bin 125.

Entering a Job

• Enter a job as normal in Order Entry that fits the criteria for an expected pick-up time as entered in the steps above.

At Mailout, the expected pick-up time will then be output into /delivery_note/courier_info/courier_pickup?time tag:

<courier_pickup_time>2010-01-25 08:00</courier_pickup_time>

Example Process

Zone/Fixed Bin 125 has three daily pick-ups Monday through Friday: 8 am, 10:30 am and 1:30 pm. Account 12345 is assigned to Zone/Fixed Bin 125.

There will be fifteen entries in the bin_close_times table for Zone/Fixed Bin 1:

If today is Friday and the job for account 12345 is mailed out at 9 am, Friday’s date and 10:30 will be output into the courier_pickup_time tag because 10:30 is the next expected pick-up time for that zone.

If today is Friday and the job for account 12345 is mailed out at 2 pm, after the last pick-up of the day for that zone on Friday, Optifacts will look to see what the next pick-up time for that zone would be which is next Monday at 8 am as there are no pick-ups for this zone on Saturday or Sunday. Monday’s date and 08:00 will then be output into the courier_pickup_time tab.

Click here to return to the top of the page.