Skip to main content
Solved

How to convert Price using currency rate in GI?

J
Freshman I
Forum|alt.badge.img

Hello ,

I have created a GI but I want to convert the price base on customer currency (or by changing currency ID in Parameter ), How can I do it? My Default Currency is SGD but i want that when I will choose USD in my parameter it will change the Price in USD.

 

Thank you

Jennifer

Best answer by Ahmed

@jennifer39 you can do the following:

  1. Join CurrencyRate table on the To Currency
  2. Filter records for the specific currency only
  3. Do a formula in the Results tab multiplying/dividing the price by the Currency Rate to get the converted amount

Make sure to automate the Currency Rates screen at a daily level at least to get the most accurate conversions.

View original
1 Attachments
Did this topic help you find an answer to your question?

4 replies

Ahmed
Varsity II
Forum|alt.badge.img+1
  • Ahmed
  • Varsity II
  • 52 replies
  • Answer
  • April 15, 2022

@jennifer39 you can do the following:

  1. Join CurrencyRate table on the To Currency
  2. Filter records for the specific currency only
  3. Do a formula in the Results tab multiplying/dividing the price by the Currency Rate to get the converted amount

Make sure to automate the Currency Rates screen at a daily level at least to get the most accurate conversions.

Kandy Beatty
Chris Hackett
2 people like this
  • Kandy Beatty
    Kandy Beatty
  • Chris Hackett
    Chris Hackett
J
Freshman I
Forum|alt.badge.img
  • jennifer39
  • Author
  • Freshman I
  • 27 replies
  • April 16, 2022

Hello Ahmed,

I have joined attached table and used below formula in my result but it is not working, please let me know what is wrong?

=[ARSalesPrice.SalesPrice] * IsNull(IIF([CurrencyRate2.CuryMultDiv]='D', [CurrencyRate2.CuryRate], [CurrencyRate2.RateReciprocal]), 1)

 

Thank you

Jennifer

1 Attachments
Ahmed
Varsity II
Forum|alt.badge.img+1
  • Ahmed
  • Varsity II
  • 52 replies
  • April 16, 2022

@jennifer39 it’s not showing anything? do share the GI XML and I can try

J
Freshman I
Forum|alt.badge.img
  • jennifer39
  • Author
  • Freshman I
  • 27 replies
  • April 16, 2022

Here is my GI XML.

1 Attachments

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved