AP transaction report

SOLVED

Good day

is there anyway we can add Opening Balances for Foreign Amount values in Accounts Payable transaction report?

Abhi

  • +1
    verified answer

    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