Today , I have faced this new issue while I was trying to import Purchase Orders to Dynamics using Integration Manager and eConnect.
After solving some issues with the connection , date…etc purchase orders were imported to Dynamics GP, but guess what … no taxes were imported. I searched for a Tax fields in the integration Manager but did not find any … and I would love to have any comments telling where can I find such information to map. (By the way I riffled the sample data text file in the Samples folder)
So here is what I did to solve it after importing the POs.
- Update the tax details per line item using SQL.
- Run a macro to recalculate the tax on Dynamics Purchase Orders Window.
SQL scripts will be provided.