Viewing the Invoice-Returns Cross-Reference Report
This report allows you to review all sales invoices that have at least one return associated with them, displaying the details of each return under its original invoice and calculating the net amount after deducting the returns.
Before You Begin
- Make sure you have the permission to view sales reports in your role.
- Invoices with no associated returns do not appear in this report.
Steps to View the Report
- “From the main menu click “Reports“.
- Click “Sales Reports“.
- Under “Invoices Segmented Reports“
- Select the “Invoice-Returns Cross-Reference” report.
- Set the required filters:
- Date: The invoice date range. (Default: last month)
- Client: To narrow down the results to a specific customer. (Optional)
- Status: The invoice status — Paid, Unpaid, Partial, etc. (Optional)
- Return Type: Credit note or refund receipt. (Optional)
- E-Invoice Status: Sent, Pending, Failed, etc. (Optional)
- Click “View Report“.
Report Elements
The report displays the following columns:
| Column | Description |
|---|---|
| Invoice Number | A link to navigate directly to the invoice page |
| Client | The name of the client associated with the invoice |
| Date | The invoice issue date |
| Invoice Total | The full invoice value |
| Total Returns | The sum of all associated return values |
| Net Amount | Invoice total minus total returns |
| Status | The invoice status |
| Returns | Sub-rows under each invoice displaying the details of each return |
A summary bar appears at the top of the report displaying:
- Total number of invoices with returns.
- Total returns value.
- Return rate %.
- Clicking on the invoice number takes you to the invoice view page, and clicking on the return number takes you to the return view page.
- Report results can be exported by clicking the Export button in PDF or Excel format.
Validation Rules
- Invoices with no returns are excluded from the report and do not appear even if they match the other filters.
- Debit notes and advance payment invoices are excluded.
- Multi-currency amounts in the summary bar are converted to the system currency at the exchange rate at the time the document was created.