PIA Aging (GR/IR Clearing)
This report is meant to list the two kinds of purchase paperwork that have not found their match: bills posted before the goods were received, and goods received that have no bill yet. It sorts them by how long they have been waiting. Today the report opens with no rows in every business, so there is nothing to read from it yet. Use the Pending Purchase Order Items report to find goods still to receive or bill.
Quick look
- Go to Reports › Purchase Reports and click the PIA Aging (GR/IR Clearing) card. The page heading reads Purchase Invoice Accruals Aging.
- The report runs by itself and shows "No data available for the selected filters".
- Changing a filter and clicking Run Report does not change that.
Done. You open the report and see that it has no rows to show yet.
Full guide
What it is meant to show, and when to use it
Each row is meant to be one document, of one of two kinds:
- Invoice Not Received: a bill posted to the goods-received clearing account with no goods receipt note linked to it. You have been billed, but the goods have not been recorded as received.
- Received Not Invoiced: a goods receipt note against a purchase order that no bill refers to. The goods are in, but no bill has been recorded.
Only documents at least a set number of days old are meant to be listed. Drafts and cancelled documents, and drop-shipped ones, are left out. Use it at month-end to clear the clearing account between receipts and bills.
Filters and date range
The page shows a Reports switcher, a Date Range and one dropdown that offers Invoice Not Received and Received Not Invoiced. The report is not narrowed by any of them today, and the date range, which opens filled in with last month, has no effect. The Aging Bucket filter (under 7 days, 7-30 days, over 30 days) is not shown on the screen.
Columns
Fields in this section
| Column | What it is meant to show |
|---|---|
| Document # | The bill or goods receipt note number. |
| Type | Bill or Goods Receipt Note. |
| Direction | Invoice Not Received or Received Not Invoiced. |
| Supplier | The supplier. The column shows a dash for every row. |
| Document Date | The date on the document. |
| Net Amount | The document total, in whole currency units, rounded. |
| Aging Days | Whole days since the document date. |
| Aging Bucket | Under 7 days, 7-30 days, or over 30 days. |
Drill-down
None. A row cannot be opened.
Export, print, PDF and email
The green spreadsheet icon downloads an Excel file (.xlsx) once there are rows. Print, PDF and email are not available on this report.
Who can see it
Open the report with View on Purchase Reports. Without it the report list shows a No Access page. Purchase Reports has only View and Add/Edit, and Delete comes with Add/Edit. A report changes no record, so Add/Edit and Delete make no difference here.
On mobile
Not available yet. The card is listed under Reports, Purchase Reports in the mobile app, but the report does not load there. Use the web app.
Same on iPhone and Android. The Android app is on Google Play. The iPhone app is coming soon to the App Store.
Problems and fixes
The report shows "No data available for the selected filters"
That is what the report shows today, whatever documents you have and whatever the filters. It is not caused by your data or your role. To find goods still to receive or bill, use Pending Purchase Order Items; for unpaid bills use Accounts Payable.
The report page says No Access
Your role does not have View on Purchase Reports. Ask an administrator to turn it on.