Inward Report
Lists every movement of stock coming in over a period, one row per item line, with the document it came in on, the quantity, the cost and the value. Use it to see what you received, on which document, and at what cost.
Quick look
- Go to Reports › Inventory Reports and click the Inward Report card.
- Pick a Time Period. It starts on Last 30 Days.
- Narrow it with Document Type, Location or Condition if you need to.
- Click Run Report.
Done. You see every inward line of the period, newest first, with the totals under the table.
Full guide
What it shows, and when to use it
Each row is one item line of one document that moved stock in. That covers goods receipt notes, bills, purchase returns, stock conversions, stock adjustments and stock transfers. Only the latest saved version of each document counts, and deleted documents are left out. Use it to reconcile stock with your documents, or to see what came in in a period.
Filters and period
Click the filter button beside Run Report to show or hide the filters.
Fields in this section
| Field | Required | What to enter |
|---|---|---|
| Reports | No | Switch to another Inventory report. |
| Location | No | All locations or one location. |
| Store | No | All stores, Unassigned, or one store of the chosen location. It stays greyed out until you pick a location. |
| Condition | No | All, Good, Damaged, Expired or Defective. |
| Time Period | No | Last 7 Days, Last 30 Days, This Month, Last Month or Custom. |
| Custom Range | If Custom | A start and an end day. Future days cannot be picked. |
| Document Type | No | All, or one of: GRN, Bill, Purchase Return, Stock Conversion, Stock Adjustment or Stock Transfer. |
There is no As of day on this report: it lists movements in a period. Use the Stock Ledger for opening and closing stock.
Columns
Fields in this section
| Column | What it shows |
|---|---|
| Item Name | The item. |
| Document Type | The kind of document. |
| Document No. | The number of that document. |
| Date | The date of the movement. |
| Qty | The quantity moved. |
| Unit Cost | The cost of one unit, to two decimals. |
| Value | Qty times Unit Cost. |
| Location | The location of the movement. It shows a dash for now. |
| Condition | The condition of the stock moved. |
Under the table a bar shows Total Qty and Total Value for the whole result, not only the page.
The report opens sorted by Date, newest first. You can sort on Item Name, Date, Qty, Unit Cost, Value and Condition; the arrow shows the direction. The sort is done on the whole report and is remembered. Use the column chooser in the table header to hide, show, drag into a new order or reset the columns. The pager at the bottom has Go to page and Items per page.
Drill-down
None. Rows do not open the document. Search for the Document No. on the document's own list.
Export, print, PDF and email
Not available on the web. The mobile app can share the rows it shows as a CSV file.
Who can see it
Open the report with View on Inventory Reports. Without it the report list shows a No Access page. Inventory 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. The report shows all stock movements of the business units you can open, not only records you created.
On mobile
In the mobile app open Reports, choose Inventory Reports, then the Inward Report. The filters are Location, Time Period and Document Type. There is no Store or Condition on the phone. Tap a heading to sort. The report opens sorted by Date, newest first. Rows come 10, 25 or 50 at a time.
Custom is in the Time Period list, but the phone shows no dates to pick and the list is not limited to any period. Use a fixed period, or the web for a custom range. Same on iPhone and Android.
The download icon shares a CSV file of the rows on the current page through your phone's share sheet. What you can do with it depends on the phone. The app asks for no storage permission on either.
The Android app is on Google Play. The iPhone app is coming soon to the App Store.
Problems and fixes
Choosing a Document Type shows nothing
The Document Type list does not narrow the report correctly yet. Set it to All and use the Date and Document No. columns to find the document.
A row shows a code like GOODS_RECEIPT_NOTE and a dash for Document No.
Some document kinds (goods receipts, purchase returns and stock conversions) do not get their name and number filled in on this report yet. Find the document by Date and Item Name on its own list.
Location shows a dash
The report does not fill the Location column yet. Use the Location filter to see one location at a time.
A document I saved is missing
The period matches the date of the movement. Widen Time Period, and check Condition, Location and Store. Deleted documents are not listed.
The report page says No Access
Your role does not have View on Inventory Reports. Ask an administrator to turn it on.