Announcements
Hello everyone,
I have a question regarding landed cost allocation in Microsoft Dynamics 365 Business Central.
In my case, I already know the total landed cost amount for a specific Purchase Order, and I have to pay the full landed cost amount.
However, the Purchase Order is received through multiple partial receipts during the year. Because of that, I do not know how much landed cost should be assigned to the first receipt.
Purchase Order: PO-00001
Item A – Qty 100
Item B – Qty 200
Item C – Qty 100
Total Landed Cost = 1,000
First Receipt:
Item A – 50 Qty
Item B – 50 Qty
Item C – 10 Qty
My question is:
How can I calculate the correct landed cost amount for the first receipt based on the total landed cost of 1,000?
Should I use:
By Amount
Equally
By Weight
By Volume
Currently, we are calculating this manually.
Is there any standard function in Business Central that can automatically calculate and allocate the proportional landed cost for each partial receipt?
Thank you in advance.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,358 Super User 2026 Season 1
YUN ZHU 1,160 Super User 2026 Season 1
Dhiren Nagar 1,093 Super User 2026 Season 1