Landed cost in Microsoft Dynamics 365 Supply Chain

Landed cost in Microsoft Dynamics 365 Supply Chain

When using miscellaneous charges, it is not easy to get accurate landed cost, this blog is intended to help arrive at it in D365FO

How to load incoming cost such as freight, handling fees, insurance, bank charges, etc. to the cost of item as landed cost in Microsoft Dynamics 365 Finance and Operations One version

Sharing two scenarios:

1) When same vendor gives the charges and needs to be loaded on the item on incoming PO

Consider adding the cost to the field 'Price misc charges' on PO lines

OR

If the value is known during or after invoice is posted, then use the below charges setup to load cost on item and credit the same supplier

2) When a separate vendor gives charges bill and needs to be loaded to the item cost on PO from different vendor.

Let us define misc. charges code to load cost on item and offset goes to a ledger account.

When the invoice from the freight forwarder arrives use the offset as ledger account specified above.

Here one needs to add the charges directly on the item line

OR 

on the PO header to distribute among PO lines.

First use maintain charges to add the charge details

and then allocate charges to lines

This should add the charges line to each PO line per the distribution formula

After invoice is posted if charges are received then Go to the vendor invoice and select charges - adjustment

Specify the misc. charges code defined earlier where debit was to item and credit to a ledger account with value as below.

From GL - audit trail or from inventory transactions - view financial ledger

There are many opportunities to automate how charges could be created and loaded on inventory. This blog shows out of box options.