GRN Report
GRN REPORT​
Menu path: Store -> Reports -> GRN Report
The GRN Report lists, line by line, every part/item that has been received against a Supplier PO through a Purchase/GRN Inward, along with its inspection status.
1.1 Search GRN Report​
Search a GRN Report - Step-by-Step
Step 1: Reach the GRN Report Screen
- From the main side menu, click on "Store", then go to "Reports", and finally choose "GRN Report". This opens the GRN Report Search page.
Step 2: Fill in the Search Criteria
All fields with a (*) are mandatory, so remember to fill them all.
- Select Supplier: [Dropdown] Select one or more suppliers to restrict the report to. Selecting a supplier here narrows the PO Number dropdown to only the POs raised against that supplier. Leave it empty to include all suppliers.
- PO Number: [Dropdown] Select a specific PO. Picking a PO here automatically selects that PO's supplier in the Select Supplier field above.
- GRN Number: [Text Field] Enter the GRN (Purchase/GRN Inward) number to search for.
- From GRN Date (Mandatory): [Date Field] Start of the GRN date range to search within. Defaults to the first day of the current month.
- To GRN Date (Mandatory): [Date Field] End of the GRN date range to search within. Defaults to the current date. It cannot be earlier than the From GRN Date, and the From GRN Date cannot be later than this date.
- Inspection Status: [Dropdown] Select an inspection status to restrict the report to GRN lines currently in that status.
Step 3: Search or Clear
- Click "Search" to generate the report for the selected criteria.
- Click "Clear" to reset all the filters back to their defaults and hide the results grid.
1.2 View GRN Report Results​
Once you click Search, the results grid appears below with one row per GRN line item:
| Column | Description |
|---|---|
| S.No | Sequence number of the row. |
| Party Name | Name of the supplier the GRN was raised against. |
| Internal Ref No | The supplier's quotation number referenced on the PO. |
| PO Number | The Supplier PO number the GRN line was received against. |
| Inward Date | The Purchase/GRN Inward date. |
| Inward Ref No | The GRN (Purchase/GRN Inward) number. |
| Inward Ref Date | The GRN date. |
| Invoice Number | Supplier invoice number recorded on the GRN. |
| Invoice Date | Supplier invoice date recorded on the GRN. |
| DC Number | Delivery challan number recorded on the GRN, if any. |
| DC Date | Delivery challan date recorded on the GRN, if any. |
| Part No. | Part number of the item received. |
| Item | Item code of the item received. |
| Product | Display name of the product/part received. |
| Material Type | Type/category of the material received. |
| UOM | Unit of measurement of the line item. |
| Rate | Rate per unit, as on the PO/GRN. |
| Inward Qty | Quantity received on this GRN line. |
| Amount | Rate multiplied by the Inward Qty for the line. |
| GRN Status | Inspection status of the overall GRN (defaults to "OPEN" when not yet set). |
| Line Status | Inspection status of this specific line item (defaults to "OPEN" when not yet set). |
| Remarks | Any remarks recorded against the line. |
Each row on the grid can be filtered further using the search box built into the results table, independent of the Search filters above.
1.3 Export & Print Options​
Above the results grid, the following buttons are available once a report has been generated:
- Excel: Downloads the results grid as an Excel file titled "GRN Report", with column filters (AutoFilter) enabled.
- Print: Opens a print-friendly version of the results grid.
- PDF: Downloads the results grid as a PDF file.
That's it! You've learned how to SEARCH and VIEW a GRN Report using the DMeX app. If you need help, contact the support team.