Customer file
New or changed customer details are created after comparing the Customer Masterfile to the original customer masterfile details sent previously. To send a complete refresh to the warehouse, clear the original customer file which will treat all customer master details as new. The original customer file represents all the information that the warehouse has been currently sent.
Note: Another way to process customer details would be to have a generic customer number on the warehouse system. The customer number on an order will be that number and all the delivery information will be retrieved from the Warehouse Interface Order Header file. This method will prevent the warehouse from being able to track deliveries by customer. The tracking will need to be done in Bookmaster. If using a generic customer number, this could be handled by the translation on the warehouse side. It will be programmed to only use the generic customer number. This would be if the client did not want the warehouse to have the customer information.
Item file
New or changed item details are created after comparing the item masterfile to the original item masterfile details sent previously. This uses the same logic as the Customer File.
Pick Slip file
Once a warehouse run is created, details can be automatically added to the pick slip files. This is determined by specific entries in TMSDS/WI-PGM. These files can be updated as each warehouse run is released (interactively) or updated once or more per day (either EOD or as a scheduled job). If not updating interactively, this gives the option of backing out of a run before the pick slip data is sent. When sending pick slips to the warehouse, the whole order can be sent (including the backorder lines), so that a complete despatch document can print in the warehouse or just send what needs to be picked. (TMSWH/WI-ORTYP determines the method).
The information retrieved from the transaction text file like Special instructions will usually need to print on the invoice.
The Warehouse Interface Order files for pick slip details retrieve the information from the Distribution transaction file. If sending complete orders, both the process number and the line number are retrieved from the transaction detail file. If sending pick information only, the line number is retrieved from the warehouse movement’s file and the process number will be blank. The Warehouse interface order text file for pick slip text retrieves warehouse instructions and line item text from the transaction text file. Warehouse instructions usually print on the pick slip. If sending complete orders, this file will have the same line numbers as the transaction detail file. If sending pick information only, no line text details will exist.
Shipping files
The Warehouse interface shipment header file sends the shipment receipts header to the external warehouse as an expected receipt. The information is retrieved from the warehouse receipt details file and can be a shipment or a P.O. The warehouse interface shipment details file sends Shipment receipts details to the warehouse. Information is retrieved from the warehouse receipt details file.
The warehouse shipment original file uses the same logic as the customer changes file for customer masterfile changes and applies to changes made to the warehouse interface shipment detail file. As shipments are received, old receipt details are purged so they no longer appear as outstanding in the Warehouse Interface shipments original details sent file.
Returns Authorization file
Returns authorisation details are created from details entered in the Claims Entry/Approval menu option. Once the claim is “released” details can be generated in the returns authorisation extract files. A “RRA” entry needs to be placed in print control for this data to be created and when the claims authorisation print process is run (CLR091) this data will be ready for the external warehouse to use when receiving stock for claim returns purposes.
