AP transaction report

SOLVED

Good day

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

Abhi

Parents
  • +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 

Reply
  • +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 

Children
No Data