XL Reporter- Sales in System Currency
For comparitive sales reports which we have created for two months we needed to get the sales data in system currency.
E.g. Currently Sales in Local Currency appears in Local Currency and System Currency in Local currency as well.
We need both the data(LC and FC) to appear in System Currency.
The Sales Data field which is picked in the report is the "SO_Line Total"