• GRNs are used to systematically arrange the products that are arrived at warehouse or store due to new purchases, cancelled orders or returned orders, and so on in suitable shelves.

  • This interface facilitates you to bulk upload the GRNs through an Excel sheet.

  • All you need is to download the latest format of the Excel, update the data and upload.

  • Each upload is listed under task history with relevant upload details.

How do I upload the GRNs in bulk quantity?


To bulk upload the GRNs, do the following:

  • Log in to the 'MartJack Control Panel' by using your User Name (Email Address) and Password.


 GRN Bulk Upload

  • You will be navigated to the Dashboard page.


 GRN Bulk Upload

  • Click the  GRN Bulk Upload icon. The Products section will be displayed as shown in the figure.


 GRN Bulk Upload

  • Click Stock Management, and select GRN Bulk Upload. You will be navigated to the Stock Management > Bulk GRN Upload page.


 GRN Bulk Upload

  • Now you need to download the latest Excel format. To do so, click the Click Here link under the Bulk GRN Upload section. Then the respective Excel, i.e. GRNBulkUploadDefaultExcelFormat.xlsx will be downloaded.
  • To open the Excel, double-click the same. The Excel will be displayed as shown in the figure.


 GRN Bulk Upload

  • There are three sheets here, namely - GRNGRNProducts and Definitions.
  • You need to fill the respective data in the GRN and the GRNProducts sheets.
  • You can find the definitions of each field in the Definitions sheet. Click the Definitions sheet and it will be displayed as mentioned below.


 GRN Bulk Upload

  • Read the definitions carefully and navigate to the GRN sheet again.


'GRN' Sheet:

  • Enter the unique reference code for the GRN in the GRNRefCode column. It's a MANDATORY field. This will help in mapping the products against the GRN.
  • Enter the unique inbound number in the InboundNo column. This is the GRN number and if you leave it blank, the system will allot a number automatically. It's a numeric field.
  • Enter the quantity received against the GRN in the ReceivedQuantity column. It's a numeric field.
  • Enter the date of receipt in the ReceivedDate column.
  • If the GRN is to be created for the Vendor products, enter the 'Vendor reference code' in the VendorRefCode column.
  • Enter the name of the transporter in the TransporterName column.
  • Enter the Vehicle number through which the goods arrived in the VehicleNo column.
  • Enter the number of boxes through which the goods arrived in the NoofBoxes column. It's a numeric field.
  • Enter the invoice number in the InvoiceNos column.
  • Enter the date of invoice in the InvoiceDate column.
  • Enter the invoice quantity in the InvoiceQuantity column. It's a numeric field.
  • Enter the tax amount of the invoice in the InvoiceTax column. You can enter a decimal number here.
  • Enter the total amount of invoice in the InvoiceAmount column. You can enter a decimal number here.
  • Enter the challan number in the ChallanNo column.
  • Enter the challan date in the ChallanDate column.
  • Enter the location code in the LocationCode column. It's a MANDATORY field.
  • Enter the GRN date in the GRNDate column. It's a MANDATORY field.
  • Enter the transportation charge in the TransportAmount column. You can enter a decimal number here.
  • Enter the total duty amount for the GRN here. You can enter a decimal number in the TotalDuty column.
  • Enter the additional duty amount for the GRN here. You can enter a decimal number in the AdditonalDuty column.


'GRNProducts' Sheet:.

  • Enter the reference code of the GRN in the GRNRefCode column. It's a MANDATORY field for uploading products to the GRN.
  • Enter the 'SKU' of the product in the SKU/Variant SKU Code column. In the case of 'Variant product', enter the 'Variant SKU' here. It's a MANDATORY field for uploading products to the GRN.
  • Enter the code of the shelf in which you want to put the product in the Shelf Code column. It's a MANDATORY field for uploading products to the GRN.
  • Enter the received quantity of the product in the ReceivedQuantity column. It's a MANDATORY field for uploading products to the GRN.
  • Enter the invoice quantity of the product in the InvoiceQnty column. It's a MANDATORY field for uploading products to the GRN.
  • Enter the unit price of the product in the UnitPrice column.
  • Enter the date of manufacturing of the product in the MfgDate column.
  • Save the Excel in a suitable location.
  • Navigate to the Bulk GRN Upload section in the Stock Management > Bulk GRN Upload page.


 GRN Bulk Upload

  • Click Browse. An Open dialog box will be displayed.


 GRN Bulk Upload

  • Select the updated GRNBulkUploadDefaultExcelFormat.xlsx file and click Open. The dialog box will be closed and the name of the selected file will be updated in the Upload Excel text box.


 GRN Bulk Upload

  • Click Upload. The Excel file will be uploaded and you can verify the number of updated rows, the number of rows failed due to the validations and exceptions in the run-time i.e. dynamically under the Task History section during upload.


 GRN Bulk Upload

  • In the case some rows are not updated due to some problems, you can find a  GRN Bulk Upload icon under the Actions column, by clicking which you can be navigated to the Error Logs Summary page. By reading the error messages, you and find the respective fault. Then, rectify the data accordingly and upload the respective rows again.
  • If all rows are uploaded successfully, then Total Rows and Updated Rows will be same and you can't find the  GRN Bulk Upload icon under the Actions column as shown in the figure (Example).


 GRN Bulk Upload

  • After the successful upload, the GRNs will be in the Draft mode and the stock will be updated only after you confirm the GRN.
  • To confirm the GRNs, navigate to the Stock Management Manage GRNs page through the Products > Stock Management > GRN. Search the required GRNs.


 GRN Bulk Upload

  • Click the  GRN Bulk Upload icon of the GRN under the Actions column. You will be navigated to the Add/Edit GRN page.


 GRN Bulk Upload

  • You can find the respective SKUs of the GRN here and the stock is not updated yet.
  • You can delete some SKSs if required by clicking the respecting  GRN Bulk Upload icon under the Actions column.
  • To confirm the GRN, click Confirm. You will be asked for confirmation through a dialog box.


 GRN Bulk Upload

  • The dialog box will be closed and the GRN will be confirmed. You will be displayed a relevant success message.


 GRN Bulk Upload

  • You can also find the stock is updated now.