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.
*This post is locked for comments