GRN
Upload GRNs in bulk from any of your external MIS or template into RazorpayX.
You can import GRNs in bulk from your external MIS or template into RazorpayX and manage all your POs, Items and GRNs in one dashboard.
To import GRNs in bulk, you must download the
from your dashboard.Watch Out!
Only those GRNs can be imported whose linked Purchase Orders are in issued status in your dashboard.
To generate GRNs, the file you upload should follow the format of the template.
Watch the video to know how to download the template for your GRN file.
-
Log in to the
. -
Go to Vendor Payments in the left navigation and click GRN.
-
In the GRN window, click + GRN dropdown button on the top right and select Bulk upload GRN from the dropdown list. You can see the Template link just below the Upload File link.
-
Click Template to download the template. You can also
to download the template.
- Enter all the required details in the template as per the validations.
- Green coloured columns in the template are mandatory. If the entry in a field is not done as per format, the field turns red.
- Hover over the empty cells to see the validation criteria.
- Default values will be picked if any of the columns are left blank. Refer to find out the default value for each column.
- If you are copy-pasting data using an internal tool, use these shortcuts:
- MacOS : Cmd+Opt+V, then press V again
- WindowsOS : Ctrl+Alt+V then press V again
Watch Out!
-
Do not use Command+V or Ctrl+V for pasting data. The validation and formatting which help to identify errors will be removed.
-
If you are generating a file in a template format from an internal tool, copy-paste the validations and formatting from the template to your file.
| Column | Requirement |
|---|---|
| GRN Number (Mandatory) | Enter complete GRN number with pre-fix. Supports alpha-numeric. |
| PO Number (Mandatory) | Add the PO number to be linked with the GRN. The PO must be be issued on the RazorpayX dashboard. |
| Received Date | Enter the goods/services received date in DD/MM/YYYY format. Date of upload will be the default date. |
| Item Name (Mandatory) | The name needs to match exactly with the name of the item set up in your RazorpayX. |
| Item Rate (Mandatory) | Enter the item rate in ₹. Supports upto two decimal places and needs to be greater than 0. |
| Received Quantity | Enter the quantity of item received. The default quantity will be 1. Supports upto two decimal places. |
Watch the video to know how to upload your GRN file.
- Once the file is completed as per the template and saved in your computer, log in to the .
- Go to Vendor Payments in the left navigation and click GRN.
- Click + GRN dropdown button and select Bulk upload GRN from the dropdown list.
- The Upload file window opens. Here, you can select the saved file from your system or drag and drop it into the window. Alternatively, you can also upload the file by navigating to Vendor Payments→Import→GRNs tab→Import GRNs→Upload.
- If the file gets uploaded succesfully without any format errors, the system gives the preview of the top 3 line items of your file. This helps to ensure that you have uploaded the right file.
- Click Create GRN. You can see the accepted GRNs under Accepted and erroneous GRNs under Invalid GRNs.
- Click on the error sign on the rows to view the error report of the respective GRNs.
- Click View GRN against each accepted GRN to view it. This shows the GRN as a line item.
- Click on the line item to preview the generated GRN.
Was this page helpful?