OT Transaction Entry - Details - Totals overview

Overseas Trade > Entry > Transaction

Use this page to view, create, or modify the dates of the tracking document. These dates are critical to managing the acquisition of inventory from an overseas vendor, from production to its final receipt in your warehouse.

On this page you can perform these actions:

  • Specify all of the addons associated with a tracking document. Four addon fields are provided, plus an Additional Addon window can be accessed to enter up to 99 more.
  • Specify tracking dates. Three different date columns are provided to track your shipment: estimated, revised, and actual. The estimated dates are entered when the tracking document is first created. They are an estimate of each stage of the shipment. The revised dates are entered as you are provided a more accurate estimated date. They are not actual dates. Neither the estimated nor revised dates are required.
  • View Totals information for the ordered quantity, weight and cube values.

The actual dates should be entered after-the-fact and represent the actual date of each stage. You are prevented from entering future dates in these fields. Only the current system date or earlier can be entered. The actual dates govern the stages of the tracking document. After you enter an actual date, the stage of the tracking document moves forward.

Tracking document stages are:

0 – Entered: The stage the tracking document is in when you first create it, before any actual dates are entered.

1 – Production: Document moves to this stage when the Actual Production Start date is updated.

2 – Complete: Document moves to this stage when the Actual Production Complete date is updated.

3 – Shipped: Document moves to this stage when the Actual Departure date is updated.

4 – Arrived: Document moves to this stage when the Actual Arrival date is updated.

5 – Demurrage: Document moves to this stage when the Actual Demurrage date is updated.

6 – At Whse: Document moves to this stage when the Actual Whse Received date is updated.

7 – Received: This is the only stage that is not controlled by an Actual date entry. After the Tracking # is receiving in Purchase Receipt of Inventory Entry, the Actual Whse Unload date and the stage is updated.

8 – Empty: Document moves to this stage when the Actual Empty date is updated, if it is in Received stage.

9 – Closed: Document moves to this stage when the Actual Container Out date is updated, if it has been received.

Dates can also be maintained in OT Vessel Entry-Detail if you have created a document for one or more containers on a single vessel in transit. The Departure, Arrival and Dock Ready dates can be maintained in the OT Vessel Entry-Header window, and OT Transaction Entry-Totals is updated automatically.

Demurrage and Container Fees

Avoid Stage 5 (Demurrage). This stage occurs when your container arrives on the dock and is held by the shipping company beyond the date scheduled for pick up. The importer company is charged a daily rate until the container is picked up. These charges are most likely be passed on to you. Ensure that the container is picked up on or within a day of the Dock Ready date. Ensure that the container is received in your warehouse before the Actual Demurrage date.

Container rental fees are charged for the containers in which your shipments are stored, once you have passed the Last Free date. Monitor last free dates to ensure that containers are unloaded and returned to the shipper to avoid any container fees.

Additional Addons

You can specify addons here in addition to the four on the Totals window. These addons are distributed to the purchase order when it is received in Purchase Receipt of Inventory Entry and are costed with the purchase order in Vendor Invoice Center Entry. You can view all addons applied to a purchase order in OT by accessing Purchase Order Inquiry and on the Purchase Tracking Master Report.

To add an addon, click New in the Add Ons section. To remove an addon, select it and click Delete. Addon types are defined in SA Table Code Value Setup-PO Addons.

After addons are entered, the total is displayed on the Totals window. Additional addon amounts are also included in the Totals section.

If an addon set up with a manual allocation method is selected, this message is displayed:

Manual Allocation Addon Selected. Unit Allocation Method Will Default.

The allocation method defined for the unit of measure is used to allocate the addon costs to the line items.