Skip to main content

Notifications

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

pastedimage1574923398873v1.png  

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.

pastedimage1574923398874v2.png

  

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

pastedimage1574923398877v3.png

  

OR 

on the PO header to distribute among PO lines.

pastedimage1574923398878v4.png  

First use maintain charges to add the charge details

pastedimage1574923398881v5.png

 

and then allocate charges to lines

pastedimage1574923398886v6.png

 

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

pastedimage1574923398887v7.png

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

pastedimage1574923398888v8.png

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

pastedimage1574923398888v9.png

  

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

Comments

*This post is locked for comments