Precalculation Cargo Chain 1

IMPORT FILES - SALES

Sales:

  1.  Trucking

Amount: the value from Excel file

Unit: container

Nr of unit: number of containers

2. Handling fee:

Amount: the value from Excel file

Unit: file

Nr of unit: 1,2,3 (max 3 per file)

3. Handling IMO:

Amount: the value from Excel file

Unit: container

Nr of unit: 1,2,3 (max 3 per file)

IMPORT FILES - PURCHASE

Purchase:

  1. Trucking:

Amount: the value from Excel file

Unit: container

Nr of unit: 1

Important! In purchase the number of trucking lines is the same with the number of the containers from the precalculation print and we must link each line on each container.

CUSTOMER

You will precalculate the files for customers: Clariant, Lanxess, Archorma, Stahl;

  • Each customer has an Excel tariffs; You must pay attention to customers excel tariffs and follow the indications mentioned for each one (Handling fee, Inland Haulage).
  • For each customer we must precalculate the Sales side and the Purchase side;
  • For each customer, for sales side, we have to select Vat Status T1 and VAT „T1 Netherland TN” for Dutch cutomers (Almatis BS, Thermphos BV, De Burg BV, Minelco BV, St. Martinus BV, Vd Anker BV, Zandbergen BV, Basf Netherland BV) and „T1Overige N9” for the foreign customers (for e.g. Lanxess Europe, Lanxess Deutschland, Almatis Inc, Almatis GmbH, Almatis Limited, Ineos);

TRANSPORT TYPE

Transport Type: truck, barge, truck-barge, rail, truck-rail;

LOADING PLACE

Loading Place: Leverkusen, Krefeld, Dormagen, Duisburg, Neuss, Hurth, etc;

HAULAGE TYPE

Haulage type: MH, CH or MICH;

CONTAINER TYPE

Container type: 20/40 GP, 20/40 RF, 20 TC.

If on the precalculation print is mentioned for ex. 1 BL with 5 containers and are descripted only 3 containers we precalculate the file for 1 BL with 3 containers and check/wait for purchase invoice;

If on the precalculation print are 2 BLs with 1 Container we precalculate the file for 1 BL with 1 container, we delete the invoice for the other BL and then check/wait for purchase invoice.

PRECALCULATION

  • 1 Incomplete billing info: when the information on the precalculation  print is not complete (e.g. undefined transport, no loading place);
  • 15 Finance check: we use this status when we have 2 different loading places and the rates are different;
  • 20 To be calculated: files have this staus before precalculating process:
  • 20 To be calculated: check for purchase invoice: for IMP files which don’t have THC/ISPS/Seafreight charged in Sales;
  • 25 Unknown Rates: we use this status when we do not find rates in excel for a carrier/place of discharge/loading place/container type;
  • 30 Preclaculated: we use this status when a file was precalculated.

IMPORT CUSTOMERS

For each IMP customer we have to precalculate the following lines:

  • Handling fee in Sales;
  • Inland Haulage: in Sales we have to add a line for all containers; but in Purchase we have a line for each container and the IH line from purchase must be with link on CT;
  • for IMP files for sales we must have one invoice number without link. If there Inland Haulage invoices with link on container we must modify Inland haulage on the same invoice with Hanling fee and the invoice(s) with link on container must be removed (like in the image bellow):

EXPORT CUSTOMERS

When on the precalculation print we have dangerous goods we add 50 Eur or 50 Usd to seafreight and for inland haulage (except transport per barge and train) we add in purchase a line with code 914 “Hazardous goods surcharge” with 30 Eur with link on CT and for sales we summarize the amount for inland haulage with the amount for Imo (e.g. file 10.50653.2010);