Solved

How to convert Price using currency rate in GI?

  • 15 April 2022
  • 4 replies
  • 295 views
J
Rank
Userlevel 2
Badge

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

icon

Best answer by Ahmed 15 April 2022, 22:19

View original
1 Attachment

4 replies

Ahmed
Rank
Badge +1

@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.

J
Rank
Userlevel 2
Badge

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 Attachment
Ahmed
Rank
Badge +1

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

J
Rank
Userlevel 2
Badge

Here is my GI XML.

1 Attachment

Reply


Terms & ConditionsCookie 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