Good day
is there anyway we can add Opening Balances for Foreign Amount values in Accounts Payable transaction report?
Abhi
Hi Abhi
So sorry, I don't think it may be possible. This is because t he report layout doesn't carry a field for the Foreign Currency opening balance
Of course, you can try to customise it
I tried it on my side by inserting a new Variable field.
However, the closest I got was to hard code the conversion factor between local and foreign currency in the inserted variable's calculation string as below:
Value := Account['OpeningBal'] / 10;
The value 10 above is obviously fixed and you should therefore have to carefully and manually calculate it and change it before running the report each time.
Kind Regards
Bennie
*Community Hub is the new name for Sage City