Historical AP by Supplier VS Balance Sheet VS Ageing

Please use the excel sheet for the data comparison



(A) To get the data,go to Supplier > Creditors > Historical AP Balance.

  • Select the company,date ( for opening & closing) & generate report.

  • After generating report  click on GL code,so all the GL code are arrange in  sequence.
  • Take the balance  amount for one time supplier,accPayable & otherPayable(credit or debit amount) & compare it with Balancesheet & supplier historical transaction ageing.


 (B) For Balancesheet go to Accounting > Financial statement > Balancesheet.

  • Select the Company,Date for opening & closing & Generate Report:




(C) To get the data,go to Supplier > Creditors > Supplier Historical Transaction Aging Analysis.




  • Select company,branch & date for opening & closing & generate report.


  • Compare the amount of Aging Summary with balancesheet & historical AP balance.


Private & Confidential