Hi everyone,
I’m using Dynamics 365 Finance & Operations (Supply Chain) with inventory valuation Average cost (PMP / moving average).
Scenario:
-
I purchase items from a vendor and post the product receipt (packing slip / goods receipt).
-
Later, I receive the vendor invoice for the products.
-
Separately, I receive a third-party freight carrier invoice (a different vendor than the product supplier).
-
The key point: I do NOT know the freight amount at the time of receipt. I only know it when the carrier invoice arrives (sometimes days/weeks later).
What I need:
-
I want the freight cost to be capitalized into inventory so it increases the item cost and impacts Average cost (PMP) (not just posted as an expense).
-
I want to do this without using the Landed Cost module (domestic flows only, keep it simple).
Constraints:
-
The carrier can send one invoice covering multiple product receipts / multiple packing slips, sometimes across multiple purchase orders.
-
I’m looking for the simplest and fastest standard approach to distribute the freight amount across all relevant items/receipts and have it update Average cost.
Questions:
-
What is the recommended standard way in D365 to post a third-party freight invoice after receipt so it is capitalized and updates Average cost (PMP)?
-
Can this be handled using charges / miscellaneous charges and an allocation/distribution method (by value, quantity, weight, etc.) when the freight invoice covers multiple receipts?
-
If possible, what is the best practice process to link the carrier invoice to the correct receipts and distribute the cost efficiently?
Thanks in advance for your help, and happy holidays to everyone!
