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