Receiving Overseas Trade containers supported in TWL

Total Warehouse Logistics (TWL) is enhanced to now include Overseas Trade (OT) tracking documents when receiving products in a TWL warehouse. Tracking documents are created in OT Transaction Entry to assign purchase orders for an overseas vendor to a container or vessel. When the container is received in your TWL warehouse using an OT tracking number in Purchase Receipt of Inventory Entry or processed in EDI Entry Processing Ship Notice Report, TWL is updated via an Advance Ship Notice (ASN) record.

To support ASN receiving in TWL, OT Transaction Entry transactions that are created manually in OT Transaction Entry or received in the EDI 856i Advance Ship Notice are updated to include Purchase Batch Receiving Entry records (POEBT which include POEBH and POELB records). These POEBT records are temporary database records that are sent in a WL Transaction Inquiry receipt update as standard ASNs are. When receiving is completed against the ASN document in TWL, either automatically or manually, the WL Transaction Inquiry record updates the purchase orders and the temporary POEBT records are deleted.

WL Entry Batch Receiving Report is also updated to allocate any OT addons across all purchase orders in an OT transaction. This mimics the same allocation method used when receiving POs assigned to an OT tracking document in Purchase Receipt of Inventory Entry for a standard warehouse. OT addons are still entered in OT Transaction Entry.

To support search and analysis of Overseas Trade transactions in Birst, these Overseas Trade tables are added to the export process for the Data Lake:
  • OTEH: OT Transaction Entry header
  • OTEPH: OT Transaction Entry PO header
  • OTEPL: OT Transaction Entry PO lines
  • OTEVH: OT Vessel Entry header
  • OTEVL: OT Vessel Entry lines

To activate these tables for Data Lake export, select the Replicate to Data Lake option for each table in SA Administrator Options-System-Options. The tables are exported to the Data Lake when you run the SA Data Extraction for Data Lake and Birst Report.

Feature activation

No activation is required to support receipt of Overseas Trade containers in TWL. The POEBT records in the ASNs are created automatically when you receive against an OT tracking number in Purchase Receipt of Inventory Entry or process the EDI 856i ASN containing an OT tracking number.

The existing options for controlling ASN receipts in TWL are honored by this new process. We recommend you review these options in Vendor Setup-Ordering and TWL Administrator-System Parameters and determine how they should be set for your company:
  • If the Create TWL ASN option is selected for each overseas vendor in Vendor Setup-Ordering, ASNs are sent to TWL immediately upon receipt in Purchase Receipt of Inventory Entry. If this option is not selected, you can hold the ASNs for review using the Load ASN function on the RF. Then use Shipment ASN to receive the ASN.
  • To enable automatic receipt of ASNs in TWL, select Yes for the TWL system parameter 6264-Auto Receive ASN. Then, select WL Auto Receive ASN for each overseas vendor in Vendor Setup-Ordering. If you have not implemented auto receiving of ASNs in TWL, you must manually receive each ASN.
  • Select the Block POs option in Vendor Setup-Ordering to block individual purchase orders that are associated with an ASN from being sent to TWL in a receipt transaction (RT) when the PO is printed in Distribution SX.e. Instead, all POs for the vendor are contained in the ASN and the receiving is done against this ASN.