Purchase Orders Payment Report

Report Overview

The purchase order payment reports display the payment status of each purchase invoice associated with each supplier over a specified period. For every invoice, it shows the net total, amount paid, outstanding balance, and any returns. This report is used to track pending supplier payments and identify invoices that are not fully settled, helping improve cashflow management and prioritize payments effectively.

Steps to View the Report

1. From the main menu, click on “Reports“.
2. Click “Purchases Reports“.
3. From the purchase reports page, select “Purchase Orders Payments“.
4. Before displaying the report, you can apply the following filters:
   • Supplier: Select one or more suppliers to display payments for their invoices only. You can search by name.
     • If no supplier is selected, the report will include all suppliers.
   • Date From: Select the start date of the period for which you want to display payments.
   • Date To: Select the end date of the period for which you want to display payments.
   • Branch: Select one or more branches to display payments for that branch only.
     • If no branch is selected, the report will include all branches.
   • Group By: Choose how the report results should be grouped:
     • Supplier: Display invoices grouped under each supplier.
     • Invoice: Display each invoice independently.
     • Branch: Display invoices grouped by branch.
   • Ordered By: Choose how invoices are ordered within each group:
     • Date Descending: From newest to oldest.
     • Date Ascending: From oldest to newest.
     • Number Descending: From highest document number to lowest.
     • Number Ascending: From lowest document number to highest.
   • Currency: Select the currency in which to display the report:
     • All to (SAR): Display all payments converted to Saudi Riyal.
     • Separate: Display each currency in a separate table.
     • Or select a specific currency (e.g., SAR)
5. After setting the filters, click “View Report” to update the result, or click “Clear Filters” to reset to default settings.
6. You can switch between the “Summary” view to display total payments per supplier, or “Details” view to display invoice-level data within each supplier group.
7. You can print the report using “Print“, or export it via “Export” to:
   • CSV
   • Excel
   • PDF
   • PDF (without chart)

Report Columns

The table displays purchase invoices grouped by supplier, along with detailed payment status for each invoice. The columns are as follows:

• Date: Purchase invoice creation date.
• Type: The document type (e.g., Purchase Invoice or Purchase Return).
• Name: The supplier associated with the invoice.
• Document Number: The invoice’s serial number in the system, with a direct link to view full details.
• Branch: The branch where the invoice was created.
• Net: The total invoice amount after discounts and taxes, in the selected currency.
• Paid: The amount that has been actually paid toward the invoice up to the report date.
• Remaining: The unpaid amount of the invoice, calculated as Net – Paid.
• Return: The value of any returns associated with the invoice, in the selected currency.

At the end of each supplier section, a total row appears summarizing the net, paid, remaining, and return amounts for all invoices within the selected period.  At the button of the table, a grand total row aggregate the data for all suppliers across the entire period.