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((fSOOrder.CuryID]<>'USD' And OCurrencyRate2.CuryRateType]='MONTH' And aCurrencyRate2.FromCuryID]=ASOOrder.CuryID]),
+IIf(]CurrencyRate2.CuryMultDiv]<>'Multiply',CSOLine.CuryUnitPrice]/lCurrencyRate2.CuryRate],rSOLine.CuryUnitPrice]*rCurrencyRate2.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.