Skip to main content

Report Queries

Report Queries
The reports & query screen shown here opens the options for the users to print important reports related to the payables/purchase modules.  

image.png

The main documents are the Statement of Account, Outstanding Statement and the Aging Analysis. These reports will enable the users to see the outstanding amount due to the suppliers, the transactions made as well as the aging report of outstanding transactions.

GL & AP Diagnostic
This screen will help you identify transactions that causes unbalanced of your GL Code and AP Accounts. 
  •  Click on Payables – AP Operations – Report Queries - GL & AP Diagnostic and the following screen will appear. 

image.png

  • Must filter the From To Date accordingly when was the unbalanced started and click filter so system will show you transactions that causes your unbalance if any. 
AP Invoice Status Query

This screen will show AP Invoices such as how many were invoiced, paid and its remaining balance. 

  •  Click on Payables – AP Operations – Report Queries - AP Invoice Status Query and the following screen will appear.

 image.png

  • Filter accordingly the necessaries such as Type of transaction, tick show only outstanding invoices if you want to, Supplier, PDSU if any, Type Date and Filter. 

Below photo as a sample, 

image.png

  •  You may click ZOOM IN and it will redirect you to the transaction itself.

image.png

  • Meanwhile, when Payment Voucher is click, following screen will appear. 
  • Needed to select line detail, Payment Voucher and you may tick Zoom In for you to be redirect in the transaction itself. 

image.png