AP transaction report

Question

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

Bennie Pienaar · Accepted 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

Sage 200 Evolution

AP transaction report

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING