Shipment Tracking Report

Report Options

Field

Description

Report type

Current shipments

Select this to generate a report only for shipments that have not yet arrived.

When printing the Current shipments, the ETA date is used to filter the shipments.

By default, the values displayed in the Actual cost and GRN value columns are displayed as zero because the report only reflects shipments against which no receipts have been captured.

You can, however, select the Assume total receipt when calculating actual cost options to show values in the Actual cost and GRN value columns as if the total shipment had been received.

Received shipments

Select this to generate a report only for those shipments that have arrived.

The shipment Arrival date is used to filter the report based on Received shipments.

Shipments that have been received into inspection are included only if you processed a partial receipt into stock.

Archived shipments

Select this to generate a report for only those shipments which are archived.

Shipment content notes

Select this to generate a report showing the merchandise lines of current shipments.

When printing the Shipment content notes, the ETA date is used to filter the shipments.

It does not list any cost elements or shipment totals.

The contents note can be used by the warehouse staff to check the shipment before it is received into stock.

Options

Use supplier xref for expected merchandise cost

Select this to calculate the Expected cost of a merchandise line based on the purchase order quantity multiplied by the LCT merchandise price defined against the supplier.

You assign the LCT merchandise price against the supplier using the Browse on Supplier Stock Code Cross Ref program. If you do not select this option, then the actual cost and GRN value printed for a merchandise line equals the Expected cost.

Assume total receipt when calculating actual merchandise cost

This applies when you select Current shipments at the Report type field.

Select this to print values in the Actual cost and GRN value columns (against merchandise lines) as if the total shipment quantity had been received into stock.


	The GRN value column is displayed only if the GRN system is required (Purchase Orders Setup).

Assume expected element value when actual element value is zero

This applies when you select Current shipments at the Report type field.

Select this to print the expected value of the element in the Actual value column when no invoices have been processed against the element and the actual cost is zero.

Selection criteria

Field	Description
Vessel selection	Indicate the vessel(s) for which you want to generate the report. You can browse on the vessel selections using the Shipment Tracking Entry program.
Stock code selection	Indicate the stock code(s) to include in the report.
Arrival date selection	The date required depends on the Report type you selected. If you selected to print the Report types: Current shipments or Shipment contents note, then you are prompted for the required Arrival date selection. When printing the Current shipments or Shipment content notes, the ETA date is used to filter the shipments. If you selected to print the Report types: Received shipments or Archived shipments, then you are prompted for the required Receipt date selection. When printing the Received shipments or Archived shipments, the shipment Arrival date is used to filter the report. Indicate the arrival/receipt date(s) for which to generate the report. You can browse on Archived shipment references using the LCT Browse on Archived Shipments program and on other shipment references using the LCT Shipment Reference Query program.
Shipment reference selection	Indicate the shipment reference(s) for which to generate the report.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

The report lists the cost elements attached to each purchase order line and accumulates the expected and actual costs against a shipment. The total for each line is then compared to the current Inventory cost, or to the Last cost if you are using FIFO or LIFO costing. The Actual cost is calculated as the merchandise expected cost (price on purchase order multiplied by the quantity) divided by the quantity ordered multiplied by the quantity received. If the GRN suspense system is required (Purchase Orders Setup) then the GRN value will equal the actual cost.

When you process a shipment for a foreign currency supplier, the foreign value of the purchase order line is displayed in the supplier's currency next to the exchange rate. The supplier's currency code is printed next to the supplier code.

Where a fixed exchange rate was not used for a shipment, the exchange rate printed on the report is the current exchange rate as per the exchange rate table (Browse on Currencies). The merchandise cost is, however calculated at the entry rate. This is because the merchandise cost local value is calculated at the time the purchase order is attached to the shipment and this is the value reflected on the report. The report does not recalculate the merchandise cost local values based on the current exchange rate.

If an actual arrival date was entered for the vessel using the LCT Vessels program, then this date is printed in the Est arrival date column. If no actual arrival date was entered, then the estimated arrival date is printed in the Est arrival date column.

The merchandise value on the report will only equal the value of the corresponding purchase order if all of the following are true:

All the purchase order lines are on the shipment
You have not change the quantity, discount, price, etc of any line
You have not altered the exchange rate