How to capture Freight and Duty charges for STOCK on a PO?

Finance and Operations/AX
1

How to capture 3 different AP Invoices to avoid variances against Standard Cost

  • Supplier 1 = Goods
  • Supplier 2 = Duty and Fees
  • Supplier 3 = Freight

How to consolidate this in one place to get better variance analysis.

2

Hi,

Very common pain point, here’s how D365 F&O handles it cleanly

Best Option, Landed Cost Module (v10.0.18+)

  • Create a Voyage and attach all 3 invoices (Goods, Duty, Freight)

  • System apportions costs to items automatically

  • Compares estimated vs actual and gives you a clean variance report per cost type

Fallback, Misc. Charges on PO

  • Add Duty & Freight as charge lines on the Goods PO

  • All 3 invoices tie back to one document

  • Simple and works without Landed Cost enabled

Tip - Map each cost type to its own GL account. This makes your variance analysis meaningful rather than one big unexplained number.

Landed Cost is definitely the way to go if you’re on a recent version. Happy to help further!

3

Issue here is all 3 Invoices are from 3 different Suppliers, not one supplier otherwise we would use Duty and Freight option on the PO.

4

Since it’s 3 different suppliers, this is actually the perfect use case for Landed Cost, that’s exactly what it’s designed for. Each supplier posts their own invoice, and F&O ties it all together under one Voyage, giving you the variance analysis you need.

Might this work for you?

If you need help with the setup, feel free to reach out. We’ve done this a few times and know the nuances well. Happy to help!