How to Add GRN and Bulk Add GRN Using Excel

Step 1: Navigate to the Add GRN Section

To add a Goods Received Note (GRN), go to the Purchase Module from the sidebar and select Add Purchase/GRN.

Step 2: Click on "Add Purchase"

Click on the + Add Purchase button to start adding a new GRN.

Step 3: Fill in the Purchase Details

• Select the Date for the purchase.

• Choose the Warehouse where the items will be stored.

• Enter the Invoice Number and select the Supplier.

• Attach any supporting document, if required.

Step 4: Add Products to the Order Table

Search for products by typing the product code or name, then select the correct batch and enter the quantity.

Step 5: Select Batch for the Product

Click Select Batch, then choose either a New Batch or an Existing Batch. Enter the batch number, expiry date, unit cost, and unit price.

Step 6: Enter Additional Details

Specify tax, discount, shipping cost, and any other charges related to the GRN.

Step 7: Click "Add Purchase"

Once all details are filled in correctly, click the Add Purchase button to save the GRN.

How to Bulk Add GRN Using Excel

If you have multiple GRNs to add, follow these steps to import them via Excel.

Step 1: Navigate to "Bulk Purchase/GRN"

Go to the Purchase Module and select Bulk Purchase/GRN.

Step 2: Download the Sample File

Click Download Sample File to get the correct template for bulk uploading.

Step 3: Fill in the Excel File

Open the downloaded file and enter the following details for each GRN:

• Product Code

• Quantity

• Purchase Unit Code

• Cost

• Selling price

• Discount per Unit

• Tax Name

Ensure all columns are correctly filled; otherwise, the system may reject the file.

Step 4: Upload the Excel File

Click Choose File and select the completed Excel sheet.

Step 5: Click "Import Bulk Purchase"

After selecting the file, click Import Bulk Purchase to upload the data.

Important Notes

Warnings