Skip to content
+1-888-319-3663

COMMUNITY FORUM

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?
Answers
Best Answer
lorren answered 7 years ago
Jeanenne,

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 support@eonesolutions.com. It would be billable work.

Lorren

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