Reports
Compare Purchase Activity by Supplier
Supplier Details is a receiving summary despite its older Sale labels. Read each row as purchase activity grouped by supplier, then reconcile the totals with the Purchase register.
- Menu path
- Reports -> Purchase -> Supplier -> Supplier Details
- Verified from
- Posnic demo and current POS source reviewed on 2026-09-08
Technical source evidence
demo.posnic.io Supplier Reports -> Supplier Details captured 2026-09-11, frontend/modules/supplierReport.html Supplier Details table filters pagination and export, frontend/static/script/js/modules/js/report_suppliers.js supplierreportTable, api/src/controllers/receivings.controller.js supplierReceivingReportTable, api/src/models/receiving.model.js supplier receiving aggregation
Run the Summary
- Open Reports -> Purchase -> Supplier.
- Choose Supplier Details.
- Open the filter and select the date range and one or more branches.
- Apply the filter and review the displayed row count.
- Increase rows per page or move through every page.
- Refresh after purchases are received, edited, returned or cancelled.
Interpret the Legacy Labels
| Displayed column | Operational meaning | Check |
|---|---|---|
| Name | Supplier name grouped from receiving records. | Match the supplier master record. |
| Phone | Supplier phone retained for identification. | Do not merge suppliers on phone alone. |
| No. Of Sale | Number of qualifying receiving/purchase records. | Read this as purchase count. |
| Avg.Sale | Average receiving value for the supplier. | Read this as average purchase value. |
| Total Sale | Combined receiving value for the supplier. | Read this as total purchased value. |
Export and Reconcile
- The CSV requests all matching suppliers, not only the visible page.
- PDF, CSV, Excel and Email above the report use the shared report export surface.
- The report does not prove that supplier invoices have been paid.
- Apply the final scope before export.
- Use Export All To CSV to create supplier-reports.
- Compare supplier count and value with the Purchase Register for the same dates and branches.
- Review Return Purchase separately before reconciling a supplier statement.
- Record unexplained differences and their owner.
Troubleshooting
| Symptom | Check | Action |
|---|---|---|
| Supplier is missing | Date, branch, receiving records and supplier identity | Correct the scope or source purchase, then refresh. |
| Count seems wrong | Whether draft, cancelled or returned purchases qualify | Compare document ids in Purchase Register. |
| Labels say Sale | Current legacy headings | Interpret these rows as receiving activity; use Supplier Based Sale for downstream sales. |
| Export is disabled | Rows, plan and Report Read access | Correct access or filters without fabricating data. |