Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Brian Bennet]

Hi
We are currently working through configuration of our new D365FO implementation.
We need to apply the international tax duties that can vary across our product range to our suppliers purchase orders.
The cost needs to be included in the FIFO cost of the items when shipped.
Both our partners and ourselves are struggling with a suitable solution.
I’m sure we are not alone in importing goods using D365FO. Anybody have any ideas?
Thanks
Brian

——————————
Brian Bennet
Head of IT
Carte Blanche Greetings Ltd
Chichester
——————————

[Zvika Rimalt]

I am not sure I understood your question, but will try anyway.
Are you simply trying to encumber your inventory cost with duty (and other charges) that you incur, but is not included in your vendor invoice?

If that’s the case, then you can use “Charges” functionality on the PO to add these additional amounts, and they will be added on top of the purchase price into your FIFO cost of goods.

——————————
Zvika Rimalt
Functional Consultant
Vancouver BC Canada
——————————
——————————————-

[Bradley Bertchie, PMP]

Brian;

Have you considered using charge code functionality?  You can apply to the specific line or the PO overall and allocate via each line.

For your situation – you’ll create a charge with the debit to item and the credit to either ledger or customer/vendor

——————————
Bradley Bertchie, PMP
Dynamics AX Project Manager / Financial Functional Consultant
Edgewater Fullscope
Denver CO
——————————
——————————————-

[Michael Walsh]

We’re also currently in the middle of implementing a D365 installation. We’re currently using AX 2009, and we’re fairly heavily customized. In our current version, we had to have add-ins done to allow for this. We’re also a little more complicated because simply importing would be fairly straight forward. The problem is we both import and export and that’s much more complicated.

We’re not too happy with the standard way AX handles duties with only a single Harm code tied to an item. The Harm associated with an item would depend on where it is coming to.

I can’t off too much advice, but we found an add-on called Sable37 which seems to handle simply importing fine. I would take a look at it.

——————————
Michael Walsh
InterDesign
Solon OH
——————————
——————————————-

[Allen Rupp]

We import food from numerous nations. Sometime, the same item imported from Serbia verses China will have a different Duty Rate. I think I understand your situation.

I’m in AX 2012, but we have the ability to setup a table for vendor item charges.

For me it lives here:
Procurement and Sourcing
 >Setup
  >Charges
   >Automatic Charges
    >Lines
     >Then I can set up a vendor item relationship with a charge

For us, we find that most of our duties are both a percentage of the cost and a flat rate by weight. the attached picture shows you how we handle these. These charges go through a clearing account in AP.

Please let me know if this is helpful.

——————————
Allen Rupp
Commercial Purchasing Manager
Woodland Foods
Waukegan IL
——————————
——————————————-