Dynamics Community Forum Thread Details

Landed cost split with Purchase order

Hi Team,

I have 10 purchase orders, and what I want is to set up one landed cost.

This landed cost should be split among all 10 purchase orders.

Is it possible in D365 F&O?

Ex.

PO No	PO amount
1	100
2	200
3	250
4	150
…	…
10	125
Total	725
Landed cost	120

Thanks, Team

Hi,

Yes, splitting landed cost or apportioning is possible. There are few setups used in landed cost which can cater your requirement.

Approach:

In landed cost module, you can define Auto cost based on either Voyage, Shipping container, Item , Purchase order line etc. Treat this as equivalent of trade agreement.

Considering your example, In landed cost module, using concept of Voyage all 10 purchase order lines can be added in a container (or splitted in multiple container) in single voyage. This may vary depending on how you want.

Now, once this step is completed estimated auto cost will reflect, as defined in Auto cost for a journey template.

Landed cost will be added either to Item or specific main account depending on how you want cost to be accrued.

Now, lets assume there were multiple items in 10 purchase order. Here, landed Cost 120 will be apportioned based on apportionment method ex- percent, quantity, amount, volume, weight, measurement, volumetric.

Then depending on Posting Debit/credit config in Cost type codes this cost will be accrued. EX- if we want cost to be added to Item, then this landed cost will be Net amount + landed cost portion.

I hope this approach helps you to answer your query.

Quick Links