Calculating Landed Cost

hsmex

We are in the import business, and calculating the landed cost for each import is very important to us. Some of the charges involved are : freight, taxes, port charges, customs agent costs, etc.....

We want to be able to divide the expenses of the entire container across several invoices that are in the same container, according to weight, volume, product value, etc.... How does can Navision handle that?

By the way generally our suppliers, and the shipping company invoice us in USD, and the dock charges, and customs agents invoice is in local currency....

thank you in advance for you help in the matter

kriki

Navision does not handle that. So you will have to write something.
An idea could be:
An extra table under unposted (and also posted) purchase invoice. In this you put the unposted sales invoices and how you want to divide the amount. When you post the purchase invoice, this also creates extra G/L lines on the unposted sales invoices according your extra table.
When you post the sales invoice, you have to change the sales invoice no. from the unposted to the posted one in the extra table, so you don't loose the connection between purchase and sales invoice.

Different currencies are handled standard by Navision. So your Purchase Invoice has also the amount in LCY. Look at the statistics form of the invoice.

shepherd

Hi

We have an add-on to handle this requirement. Email me on paulsh@one.co.nz if you want more information.

Regards

Alex_Chow

hsmex wrote:

We are in the import business, and calculating the landed cost for each import is very important to us. Some of the charges involved are : freight, taxes, port charges, customs agent costs, etc.....

We want to be able to divide the expenses of the entire container across several invoices that are in the same container, according to weight, volume, product value, etc.... How does can Navision handle that?

By the way generally our suppliers, and the shipping company invoice us in USD, and the dock charges, and customs agents invoice is in local currency....

thank you in advance for you help in the matter

In the US, most distribution companies share the same problem with you. There are 2 ways we resolve this:

1. Use Warehouse Management in Navision to receive by Item (no programming)

2. Program a list of all the purchase lines, allow the users to enter the Qty. to Receive and the container number, then batch post those receipts. Then allocate the freight based on the container number (programming).