Once the goods are received through PO, the GRN is created automatically. GRN can also be created individually through which one can receive items but cannot have track over the payments.
PO Ref Number: Reference number of the Purchase Order where GRN already exists. Multiple GRNs of the same PO can be imported, where GRNs are grouped under a single PO reference number. If you are creating a new GRN, this column can be left empty.
Invoice No: GRN invoice number.
Vendor Name : Vendor name is from where the stock is bought. Vendor should be first created in the system to be used here.
Location Name: Location where the stock has to be received and added to the inventory.
Assignee Username: Approver user name who should approve the GRN.
Notes: Reference notes for the GRN.
Item Name: Name of the item variation.
SKU: SKU of the item variation.
Quantity: Quantity of stock to be ordered.
MRP: Maximum Retail Price of the item.
Buying Price: Buying price of the item.
Selling Price: Selling price of the item.
Received Date: YYYY-MM-DD Date on which the GRN is to be received.
If the received date is given, it means items were already received on the given date. This scenario is for past dates.
If left empty the GRN will be pending for approval. Once approved the items in GRN are received.
Expiry Date: Expiry Date of the item YYYY-MM-DD.
Note: Columns names marked with RED colour in Download Sample XL sheet are mandatory fields.
Updated on: 06/10/2021