Skip to main content
Solved

Showing Converted Prices Using Currency Rates in Report Designer

  • September 29, 2021
  • 1 reply
  • 236 views

Forum|alt.badge.img+2

I am customizing the Sales Order Report in Acumatica (so641010.rpx) and there is a requirement to convert [SOLine.CuryUnitPrice] to USD given that the unit price is not already in USD, and also currency rate type should be MONTH rate (rate type ID in currency rate types form) and currency effective date in the same month and year range of the Sales Order Date [SOOrder.OrderDate]. I created the joins and values to be picked as follows,

SOOrder Left CurrencyRate2 → =Month(OrderDate) Equal Month(CuryEffDate)

                                                      Year(OrderDate) Equal Year(CuryEffDate)

=IIf(([SOOrder.CuryID]<>'USD' And [CurrencyRate2.CuryRateType]='MONTH' And [CurrencyRate2.FromCuryID]=[SOOrder.CuryID]),
+IIf([CurrencyRate2.CuryMultDiv]<>'Multiply',[SOLine.CuryUnitPrice]/[CurrencyRate2.CuryRate],[SOLine.CuryUnitPrice]*[CurrencyRate2.CuryRate]), '-' )

At the moment the column always displays ‘-’, so I need verification if this is the right method to carry out conversions according to the requirement given above.

Best answer by Naveen Boga

Hi @TharidhiP ,

Below article may help you. Please review.

https://asiablog.acumatica.com/2018/11/reporting-currency-conversion-on-the-fly.html

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

1 reply

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3393 replies
  • Answer
  • October 4, 2021

Reply


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