Reports
Review Purchase Returns by Document and Product
The Purchase Return report is the audit trail for goods sent back to suppliers. It separates return documents from product-level movement so operators can reconcile supplier credit, stock reduction and the original receiving record.
- Menu path
- Reports -> Purchase -> Return Purchase
- Verified from
- Posnic demo and current POS source reviewed on 2026-09-08
Technical source evidence
demo.posnic.io Reports -> Purchase -> Return Purchase reviewed 2026-09-10, frontend/modules/returnreceivingReport.html filters tabs tables detail drawer and export controls, frontend/static/script/js/modules/js/report_receivingreturn.js document and product queries pagination drill-down and CSV schemas, api/src/models/receiving-return.model.js return record stock movement tax and purchase status updates, api/src/services/receiving.service.js Return Receiving inventory log
Run the Purchase Return Report
- Report Read permission is required.
- The Free plan displays an upgrade boundary instead of full report access.
- No Records means no saved purchase return matched the selected dates and branches; it is not proof that no stock was physically sent away.
- Open Reports -> Purchase -> Return Purchase.
- Select the filter icon.
- Choose the return-date range and one or more branches.
- Select Apply.
- Start with Return Details to reconcile saved return documents.
- Use Refresh after another operator completes a supplier return.
Read Return Details
| Column | Meaning | Control check |
|---|---|---|
| Receiving Id | The original receiving/purchase reference linked to the return. | Match the received purchase and supplier paperwork. |
| Date | Saved purchase-return date. | Use this date for the report range and supplier credit-note period. |
| Supplier name | Supplier retained on the return. | Confirm goods went back to the correct supplier. |
| Payment Method | Payment-mode label saved with the source transaction context. | Do not treat the label alone as proof that cash or bank credit settled. |
| No. of Item | Count of returned item lines. | Open the detail view when unit quantity is required. |
| Return Amount | Saved total value of the return. | Reconcile against line totals and the supplier credit note. |
Inspect a Return Document
- The report is read-only; correct the underlying purchase or return workflow through Purchase screens.
- A return without supplier paperwork still changes recorded stock and must be investigated.
- Select the Receiving Id in Return Details.
- Confirm the branch and user shown in the detail drawer.
- Check supplier name and available phone, email or address evidence.
- Review every product-history row and its returned quantity and amount.
- Move through all detail pages before closing the drawer.
Use Return Based Product
Return Based Product reorganizes the same operational subject around item movement. Use it to answer which products were returned, to whom, in what quantity and for what value.
| Column | Use |
|---|---|
| ID | Open the return detail associated with the product row. |
| Date | Place the movement in the supplier return period. |
| Product Name | Identify the exact catalog item returned. |
| Supplier | Group the item movement by vendor. |
| Qty | Reconcile units removed from stock. |
| Total Amount | Reconcile the value assigned to that product return. |
Export and Reconcile
- The report share controls request all matching rows, not only the visible page.
- Current CSV filenames are return-reports and return-product-reports.
- PDF, CSV, Excel and Email controls above the report export the visible report surface; inspect the output before distribution.
- Apply the final date and branch filters before exporting.
- Export Return Details for one row per return document.
- Export Return Based Product when item-level analysis is required.
- Compare both exports with Purchase -> Purchases, Inventory Logs and supplier credit notes.
- Record unresolved quantity or value differences with an owner and due date.
Troubleshooting
| Problem | Check | Action |
|---|---|---|
| Expected return is missing | Return date, branch, saved transaction and Report Read access | Open the original purchase and return evidence, correct the filter, then refresh. |
| No Records | Whether any supplier return was actually saved in the range | Do not create a dummy return; retain the empty review result when appropriate. |
| Quantity differs from stock | Product detail, original receiving quantity and Inventory Logs | Stop reconciliation and investigate the Return Receiving stock movement. |
| Return amount differs from credit note | Line values, tax, discounts and supplier document | Resolve with purchasing/accounting before marking the supplier statement complete. |
| Export is disabled | Matching rows, plan boundary and access | Correct the filter or account access; do not reconstruct an unofficial report. |
Purchase Return Review Record
- Branch and return-date range reviewed.
- Receiving ids and suppliers matched.
- Returned item quantities matched to Inventory Logs.
- Return values matched to supplier credit notes.
- Export filename or retained report reference.
- Reviewer, review time and unresolved discrepancy owner.