Overview
The Accounts Payable Summary report in DizLog shows, in one page, how much you owe your suppliers and how overdue those amounts are.
You can find it in:
Financials → Accounts Payable → Accounts Payable Summary
The page lists each vendor, the total amount you owe, and how much falls into aging buckets such as Current, 1–30 days past due, 31–60 days past due, 61–90 days past due, and Over 90 days past due.
The report is generated from the backend ACCOUNT_PAYABLE_AGING report type.
Key Features
Based on the code and screens, the Accounts Payable Summary module includes:
Multi-location filter
Choose one or more locations using the MultiLocationSelect control.
Supplier filter
Filter the report by a single supplier or show All suppliers using the Suppliers dropdown.
As-of date filter
Set an As of date with a single-date picker; the report uses this as the reference date when calculating aging buckets.
Aging summary by vendor
For each vendor, the table shows: Total, Total Outstanding, Current, 1–30 days past due, 31–60 days past due, 61–90 days past due, and Over 90 days past due amounts.
Overall totals row
A totals row at the bottom sums each aging bucket across all vendors, stored in a summary object and displayed as the Total row.
Top summary “X Vendors” row
Above the detailed table, the report shows the number of vendors and the total and outstanding balances, all formatted in your business currency using useBusinessCurrency.
Clickable vendor names (drill-down)
Clicking a vendor name opens Accounts Payable Detail for that vendor and dat
Export, print, and share
Download CSV and Download PDF buttons, powered by DownloadCSVButton and DownloadPDFButton.
Print icon that uses useReactToPrint to print the report view.
Share button that prepares email, WhatsApp, and Facebook share links using the current URL.
Inline help (“Learn more”)
A LearnMore component under the title links to a help-center article about understanding Accounts Payable.
Getting Started
These are the basic steps to open and prepare the report.
1. Open the Accounts Payable Summary page
Log in to DizLog.
In the left menu, go to Financials.
Under Accounts Payable, click Accounts Payable Summary.
The Accounts Payable Summary header and Learn more link will appear at the top of the page.
2. Understand the connected modules
This report pulls its data from your Accounts Payable aging reports in the backend (types ACCOUNT_PAYABLE_AGING and ACCOUNT_PAYABLE_AGING_DETAIL).
From the UI and routing, it connects to these modules:
Accounts Payable Detail
Opened when you click a vendor name from the summary table.
Bill Payments (Financials → Accounts Payable → Bill)
In the Detail view, each row’s invoice number
Inventory → Supplier Invoice
In the Detail view, payables of type
Because of these links, the Accounts Payable Summary is best used together with:
Accounts Payable Detail – for invoice-level breakdown.
Bill Payments and Supplier Invoice – for the original documents behind each balance.
How to Use
A. Set filters
Choose Locations
In the filters row, click the Locations multi-select (powered by MultiLocationSelect).
Select one or more locations you want to include.
If you leave it empty, the code fills it with all available locations on first load.
Choose Supplier (optional)
Open the Suppliers dropdown.
Select:
All – to see all vendors; or
A specific supplier name – to see only that vendor.
The code filters the report client-side when a supplier is selected.
Set the As-of Date
Look for the As of label beside the date picker.
Use the single date picker to choose the relevant closing date.
The chosen date is stored as startDate and passed to the aging query as part of query.
The system then calls the ACCOUNT_PAYABLE_AGING report with your location and date filters and refreshes the table.
B. Read the summary rows
Top “Vendors” row
At the top of the report table you will see a row similar to:X Vendors – how many vendors are included in the current filter.
Total – sum of all payables to these vendors.
Total Outstanding – total still unpaid.
Current, 1–30, 31–60, 61–90, Over 90 days past due – sums for each aging bucket, all formatted in your business currency.
Vendor-level rows
Below the top row, each line shows:Vendor name (companyName) – clickable.
Total and Outstanding for that vendor.
Current, 1–30 days, 31–60 days, 61–90 days, Over 90 days buckets.
Total row
The code appends a “Total” vendor line to the data for export and uses a summary object to sum all amounts.
C. Drill down to invoice details
To investigate a vendor’s balance:
In the Accounts Payable Summary table, click the vendor name (it is styled as a blue, clickable label).
You will be redirected to Accounts Payable Detail with vendor and asOfDate set in the URL.
In Accounts Payable Detail, you can:
Filter again by location, supplier, and As-of date.
View invoices grouped by aging category.
Click an invoice number to go to either:
Supplier Invoice
Bill Payments
This gives you a complete chain: Summary → Detail → Original Bill/Supplier Invoice.
D. Export, print, or share the report
Download as CSV
Click the CSV button in the top-right action bar.
The component DownloadCSVButton uses the headers and data array prepared from accountsPayable plus the total row.
Download as PDF
Click the PDF button next to CSV.
DownloadPDFButton uses the same headers and data.
Print
Click the printer icon.
The page content referenced by reportEl is sent to your browser’s print dialog via useReactToPrint.
Share
Click the share button.
ShareButtonComponent builds links using the current URL so you can share via email, WhatsApp, or Facebook.
Troubleshooting
Here are common situations and how they relate to what the code actually does.
1. “The table is empty”
Possible reasons:
No data returned from the backend
The component checks accountsPayable; if it is empty or undefined, the table will show no vendor rows and may display only the headers.
Filters exclude all data
Check that:
At least one location is selected (the code auto-selects all locations only on first load).
The supplier filter is set to All or a supplier with transactions.
The As-of date is within the period when you actually have payables.
2. “The totals look wrong”
The totals are calculated in code by summing each field with Big decimal math: total, outstanding, current, and each aging bucket.
Check that:
You applied the expected filters (locations, supplier, date).
You are comparing against the formatted currency values, which are rounded to 2 decimal places.
3. “I clicked a vendor but nothing happened”
The click handler only navigates when the company name is not "Total".
Make sure you are clicking an actual vendor row, not the Total row.
4. “The printed report doesn’t match what I see”
The printed content is exactly what is inside the reportEl container (the main report section).
If you changed filters after opening the print dialog, close the dialog, adjust filters, wait for the table to refresh, and then click the print icon again.
5. “I can’t find where a number comes from”
Use the built-in navigation chain:
From Accounts Payable Summary, click the vendor.
In Accounts Payable Detail, look at the invoices under the relevant aging bucket.
Click the invoice number to open the Supplier Invoice or Bill Payments page that created that payable.
If the chain stops because there is no link, it means the underlying record is not one of the supported types (po_invoice or bill payment) according to the mapping in the detail view.
This article is based only on the actual code and routes for the Accounts Payable Summary and its connected modules in the dizlog/web-portal and dizlog/payroll-nest repositories, plus the provided screens.