Total GRN items
—
All inward receipts
Total GIN items
—
All dispatches
Items in stock
—
GRN minus GIN
Inward value
—
Total INR
Discrepancies
—
GRN qty mismatches
Active projects
—
Across GRN + GIN
Stock by commodity
From GRN records
Zone utilisation
Items per zone
Recent activity
Last 10 GRN / GIN records
Recent GRN
Recent GIN
| GRN No. | Date | Project | Item | Vendor | Accepted Qty | Zone | Pkg ID |
|---|
New Goods Received Note (GRN)
Fill all required fields. Package ID is auto-generated.
Receipt Identity
Parties
Item Details
Quantity & Discrepancy
Inbound Logistics
Physical / Package Details
Fill Project + Vendor to generate
Finance
Storage
New Goods Issued Note (GIN)
Fill all required fields. Package ID links back to GRN.
Dispatch Identity
Package ID Lookup (link to GRN)
Parties
Item Details
Outbound Logistics
Physical / Package
Export Documentation
Packing Operations
Live Inventory
Auto-calculated from GRN and GIN records
| Project | Items In (GRN) | Items Out (GIN) | In Stock | Value (INR) | Last GRN | Last GIN | Status |
|---|
Search & Track
Search by Package ID, GRN/GIN number, project, or item description
Enter a search term above to find GRN or GIN records. Search by Package ID to see full item traceability from receipt to dispatch.
Setup Guide — Connect to Google Sheets
Follow these steps to go live. Takes about 20 minutes.
This web app connects to your Google Sheet via a Google Apps Script Web App URL. You paste that URL below once, and all forms will submit directly to your Sheet.
✓
Download Sheet
✓
Upload to Drive
3
Add Apps Script
4
Paste URL here
5
Go Live
Step 3 — Apps Script Code
In your Google Sheet, go to Extensions → Apps Script. Delete any existing code and paste this entire script:
Step 4 — Paste your Web App URL
After deploying the Apps Script as a Web App (Deploy → New deployment → Web app → Execute as Me → Anyone), paste the URL here:
Email Configuration
Set email addresses for the 7 automated alerts. These are stored in your Apps Script properties.