Skip to content


inventory adjustment using exchange rate

Jeanenne Turpin asked 7 years ago
I have an inventory adjustment import already created in SmartConnect which works in our US company. I am trying to take the same data from the US company and convert the costs using Exchange Rates set up in GP to import into our Canadian company. Does anyone know how to do this?
Best Answer
lorren answered 7 years ago

The end result will require writing an additional column, using .NET, that would be a calculated field to make a call to SQL Server which calculates the correct rate. I don't know what data you are looking at for your original transaction so I can't say what is or is not available to use in your calculation.

If you don't have anyone available to write the script you could contact It would be billable work.


If you would like to submit an answer or comment, please sign in to the eOne portal.