Skip to main content

Notifications

Announcements

No record found.

Landed cost in Microsoft Dynamics 365 Finance and Operations One version

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

1-same-vendor-misc-charge.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.

2-item-and-ledger.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

3-PO-line-misc-chahrge-enter.png

  

OR 

on the PO header to distribute among PO lines.

4-PO-header-misc-charge-enter.png  

First use maintain charges to add the charge details

5-misc-charge-value-details.png

 

and then allocate charges to lines

6-allocate-charges.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

7-adjustment-of-charges-PO-invoice.png

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

8-misc-change-adjustment-allocation-on-PO-invoice.png

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

9-voucher-charge.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