# Purchase Return Report
Lists all purchase return transactions with supplier, original purchase invoice, item lines, tax reversal, and return totals for inventory and payables adjustment.
Overview
Go to Purchase → Reports → Purchase Return Report.
Report title in ERP: Purchase Return Report
What it shows. Each purchase return with linked supplier and original purchase invoice, item rate and quantity, taxable amount, tax, and net return value. Click a return invoice number to open the full document.
When to use it. Use to track goods returned to suppliers, verify supplier credit notes, and reconcile inventory and tax adjustments.
Report view
Date filter
Return reason filter
Use Cases
- Warehouse team — What items were returned to suppliers this month and why? Run after return dispatches or during stock discrepancy reviews.
- Accounts payable — Have supplier balances been reduced for returns linked to original purchase invoices? Run before supplier statement reconciliation.
- Quality control — Which return reasons (damage, expiry, wrong delivery) are most frequent? Run monthly with the Return Reason filter.
- Tax compliance — What tax was reversed on purchase returns in a period? Run during VAT/GST filing or audit preparation.
Filters
Date, Return Reason, Employee. Advanced Filter: Supplier, Item, Purchase Invoice, Branch, Center.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Date | Return transaction date. |
| Inv No. | Purchase return invoice number. Click to open the return. |
| Supplier | Supplier to whom goods were returned. |
| PurchaseInv | Original purchase invoice reference. |
| Item | Returned item name or description. |
| Rate | Unit rate on the return line. |
| Qty | Quantity returned. |
| Taxable Amount | Amount subject to tax before tax calculation. |
| Tax % | Tax rate on the return line. |
| Tax Amount | Tax reversed on the return. |
| Net Amount | Net return value after tax. |
| Bill Total | Total return invoice amount. |
Actions
- Generate — run the report for the selected filters
- Export — export to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active advanced filters
FAQ
How do I find returns for one purchase invoice?
Filter by Purchase Invoice in Advanced Filter, or locate the invoice in the PurchaseInv column.
Can I filter by return reason?
Yes. Use the Return Reason filter on the report screen.
Does this report include return orders that are not invoiced?
It lists recorded purchase return invoices. Open return orders from Purchase → Purchase Return Orders if still in draft.
How does this affect supplier outstanding?
Approved returns reduce supplier payables. Cross-check with Supplier Outstanding Invoices or Supplier Aging.
Which debit note statuses are included?
Approved and Closed debit notes linked to purchase returns in the period.
Why is my report empty?
No return debit notes match the date range, return reason, or item type filters.
Are purchase return orders without debit notes included?
No. This report focuses on posted return debit notes. Open return orders appear in purchase return order lists.