What it shows
The Materialized view report (menu IRD Reports › Materialized View) is the list of your invoices and sales returns in the form the IRD receives them: one row per bill, with the amounts, the customer's PAN and a column that says whether the bill reached the IRD.
It opens for the period from the start of the active fiscal year to today. Use From date, Sync with IRD, Bill no, Customer and PAN to narrow it, and export to Excel or PDF. It needs the permission for IRD reports.
The columns
| Column | Meaning |
|---|---|
| Fiscal year | The IRD name of the fiscal year the bill's date falls in |
| Bill no, Bill date | The invoice or return number and its date |
| Reference bill no, Reference date | For a return: the invoice it returns |
| Customer, PAN | The party and PAN on the bill (a cancelled invoice shows the company's Cancel customer) |
| Amount | The total of the line amounts before bill-level adjustments |
| Discount | Discounts that come before VAT |
| Taxable amount | Amount less discounts |
| Tax amount | The VAT |
| Net amount | The bill total |
| Sync with IRD | Yes when the IRD accepted it, No when it has not reached the IRD yet |
| Is real time | Yes when it was sent right after saving, No when a retry sent it |
| Is printed, Printed time, Printed by user, Entered by user | Who made and printed it |
| Active | N for an invoice that was cancelled |
| Payment mode | Cash for a cash sale, Credit otherwise |
How to read it
- Sync with IRD = No on a recent bill is normal for a few minutes. After an hour, follow How bills reach the IRD, and what to check when one does not.
- A cancelled invoice stays in the list with Active N and its amounts shown as zero. Its credit note is sent separately and is not a row of this report.
- A return has the invoice's number in Reference bill no.
- A bill with no Fiscal year is left out. If a bill you expect is missing, check that its date falls in a fiscal year that has a Fiscal year IRD name (The fiscal year).