IP.33: Shipment Register - Generate

Note that you can click the button (or press F5) to invoke field help at any time from within the job panel itself.

Business Benefits

With a variety of activities going on and numerous transactions being processed during the day, it is critical that you produce an Invoice Register that reflects what happened. This information is generated by this program.

Note: For related documentation and workflows, see IP - Invoice Processing.

Usage

Use this job to:

• Create the Invoice Register which summarizes the day's Invoicing showing
  • An audit trail by Invoice number, Receipt Invoices, Recurring Invoices, and Ancillary/Accessorial Invoices
  • A summary of General Ledger entries (prior to the update to the G/L Collector file)
  • An audit list of confirmed Orders for the day printed in Warehouse and Client sequence.
• Adjust Inventory balances for the shipped quantities of all confirmed Orders and log all transactions to the Inventory Movement file.

Note: This is the end-of-day program and is normally the last program to be run each day. If time is short, it can be allowed to run unattended; i.e., overnight. In such a case, the program will perform its tasks and go to normal end-of-job. The Work Register can be printed the following morning.

Preconditions

The Daily Work Register will report transactions generated from programs:

RE.31 [Receipt Invoices]
OE.21 [Enter Shipped Orders]
OE.06 [Pick Confirmation]
OE.01 [Enter Orders (Shipping)]
OE.20 [Confirm or Modify Shipments].

Also, Invoices generated by programs:
IP.31 [Recurring Storage - Generate]
IP.32 [Accessorial Charges - Generate].

These transactions must be printed prior to producing the Daily Work Register, in programs:

RE.32 [Receipt Invoices - Print]
IP.52 [Recurring Storage - Invoices]
IP.53 [Accessorial Charges - Invoices].

The Work Register will not generate if there are Warehouse Receipts or Invoices in the system which have not been printed and accepted.

Subsequent Actions

Once the Register information has been generated, it can be printed in program IP.90 [Register - Shipments].

End-of-Month Special Run

After the last Daily Work Register for the month has been generated and printed:

• Generate Recurring Invoices for the month-end Recurring Clients, using program IP.31 [Recurring Storage - Generate]
• Generate Ancillary Charge Invoices in program IP.32 [Accessorial Charges - Generate] print the Invoices in programs IP.52 [Recurring Storage - Invoices] and IP.53 [Accessorial Charges - Invoices]
• Generate the final Work Register for the month
• Print the final Work Register.

Note: Ancillary Charge lines on a Shipping Document are moved to an Ancillary Charge Collector file for later Billing with all other collected Charges. Consequently, the month-end generation of Invoices for such Charges must follow the last Daily Work Register. Each Ancillary Charge is given the same date as the date of confirmation' i.e., ship date.

Program Fields and Functions

To review a text version of the field help, click here. Click the button (or press F5) to invoke field help at any time from within the job panel itself.

Technical Notes

Overlay "00"

This is the setup overlay which opens all files, verifies that all invoices have been printed. It also calls the temporary file setup routine to create all files.

Overlay "01"

2800: Collection of GL entries into OEGL.
3000: Table update of GL, revenue credit & AR debit.
3800: Read OEIF and set default parameters.
3880-3897: Unitary 5 date definition.
3900: MRMO/MRNM decision upon invoice date & sales date.
4100: Line detail processing , Deferred revenue calculations
4160-4199: Unitary 5 detail records
4200: General ledger and sales transactions, Calculate deferred revenue split.
4400-4420: Write back to OEOO, Remove LSLT.1 records
5400-5490: Ancillary/Accessorial line update, Deferred revenue & profit monitor collection of data.
5500-5999: Unitary charge collection, Update to OEAC from CALL of "AAOE0008"
6000-6040: X0$ is the variable used to build updates for MRTR and PMHC (Tonnage and Profit Monitor) contains lines, cases, weight, cubes, revenue, deferred revenue.
7500: Revenue code collection for update to MRMO or MRNM.
8300: Table update.
8340-8360: T3$ used for collection of automatic charges collected from printing of the invoice; e.g., Minimums, VAT.
8600: Verify T1=T(0) ie: invoice dollar amount printed on the invoice is equal to the amount to be updated to the general ledger and the sales system.
8650: MRMO/MRNM update
8665-8667: Transmission storer, set the OEOO indicator and update OECO.8 reference.
8675: PM updates into PMHC/PMHN files, should really be PMPM003.

Overlay "03"

2000: Pick rates for MR and WC from OESC. MR - Bill of lading charge, WC - Withdrawal charge
3600: Movement file update, set line status to an "S". Remove sub-location references by line.
4100: Line detail records. ICPR, ICLR, Movement call. Set weight if random weight (Action code RW). Reset OEOO line. Renewal calculations, redundant now since IP.31 uses the movement file now.
4151: If withdrawal is qualified on "B", it means only charge on broken case.
4153: Old calculation for deferred revenue, no longer applicable.
4240: Set J4$=J5$, this sets the 'shipped value' from the 'to ship value'. This is important to remember when interfacing to EDI or the batched communications system.
4500: Withdrawal Charges calculation. If unitary 5, then flags the movement file. Charges are normally calculated as per lot or as per line. If it is not per LOT or LN or LNS then the program assumes that it is per item.
4800: Write serial numbers into ICSL with the date shipped.
5300-5399: Table collection which will be ultimately updated to OEAC.
5400: Acessorial charges from the order are transferred to OEAC by running overlay "04".
6000: X0$ string update just like overlay "01".
6200: Linear capped weights used in the haulage calcuation for the UK.
8300: Collection of MR/WC charges for table update in overlay "04"

Overlay "04"

2100: Setup header records for deletion. Update of the order monitoring file MROM.
5400: Write accessorial charges to OEAC by calling AAOE0008.
8900: End of order routine. Profit Monitor files update. Shipped orders file update (OESO). Register file update (OEIR).
8986-8988: Write type "8" records to OECO if a transmission storer.
9300: Remove the bill of lading file reference OESD if not a freight consolidation order or regular freight order.
9400: Broker order control routine. For broker orders, the system goes to the end of order routine for each new storer in the order.

Overlay "05"

This overlay recalculates the register totals if the system went down processing an order.

Overlay "07"

This overlay processes the sub location records for the order line confirmed. The on order reference in SLLF is removed and the balance in SLLF is adjusted. The order line records in LSLT.4 are removed also.

Overlay "09"

This overlay is used by the freight consolidation system and/or the FS system to automatically rate bills of lading.