Purchase GRN (Internal) Applet

Purpose and Overview

The Purchase GRN (Internal) Applet is a powerful tool designed to streamline the entire goods receipt process for internal purchase transactions. It moves beyond simple receipt recording by integrating inventory management, supplier verification, and quality control workflows.

A short introduction to the Purchase GRN (Internal) Applet:

Key Features Overview

Who Benefits from This Applet?

Warehouse Staff & Receivers:

• Easy recording of goods received with barcode scanning
• Real-time inventory updates
• Quality inspection workflows
• Exception handling for discrepancies

Purchase Teams & Buyers:

• Automated PO matching and closure
• Supplier performance tracking
• Cost verification and approval
• Complete audit trail

Finance & Accounting Teams:

• Automated three-way matching (PO, GRN, Invoice)
• Accurate cost allocation
• Reduced processing time
• Compliance with procurement policies

Management & Supervisors:

• Better control over inventory levels
• Reduced receiving errors
• Improved supplier relationships
• Data-driven procurement analysis

What Problems Does This Solve?

The Manual Receipt Process Problem:

Traditional goods receipt relies on paper forms and manual data entry. Common issues include:

• Lost paperwork and missing receipts
• Inventory discrepancies and stock errors
• Manual quantity verification leading to mistakes
• Difficult supplier performance tracking
• No centralized receiving records

The Purchase GRN (Internal) Solution:

• Digital receipt recording - Capture receipts anytime with mobile support
• Automated PO matching - Intelligent linking to purchase orders
• Real-time inventory updates - Automatic stock-in processing
• Quality control workflows - Built-in inspection and approval steps
• Complete traceability - Full audit history for every receipt
• Integration ready - Connects with inventory and accounting systems

Key Concepts

Understanding the GRN Framework

Every goods receipt system must address three fundamental aspects. The Purchase GRN (Internal) Applet provides structured handling:

GRN Hierarchy Structure

Think of the GRN process as a structured flow:

Purchase Order
│
├── Supplier Delivery ──→ WHAT is being received?
│   │
│   └── GRN Header ──→ WHO received it and WHEN?
│       │
│       └── GRN Line Items ──→ SPECIFIC quantities and conditions
│           │
│           └── Quality Checks ──→ INSPECTION results
│
└── Inventory Update ──→ HOW stock levels change
    │
    └── Financial Impact ──→ COST allocation and matching

Flow Through the Hierarchy:

1. Purchase Order: Original purchase request
2. Supplier Delivery: Physical goods arrival
3. GRN Header: Receipt document creation
4. Line Items: Item-by-item verification
5. Quality Checks: Inspection and approval
6. Inventory Update: Stock-in processing

This structure enables:

• Precise tracking of all receipts
• Flexible reporting by any dimension
• Clear accountability for quality
• Automated financial processing

The “Golden Triangle” of GRN Processing

To effectively manage the system, it is crucial to understand how Purchase Orders, GRN Records, and Inventory Updates work together.

How they link:

1. You create a Purchase Order (e.g., 100 laptops from Tech Supplier).
2. You receive goods and create a GRN Record (e.g., 95 laptops actually received).
3. The system processes an Inventory Update (e.g., +95 laptops to stock).
4. Any discrepancies (e.g., 5 missing laptops, price/quantity variances) are flagged for follow-up:
   • Over-receipts are flagged as a “Quantity Over-receipt” in the approval workflow, requiring manager sign-off.
   • Price changes are flagged as a “Price Variance” for Finance team review.
   • Shortages/Damaged goods are visible in the Line Items status and sent to the Quality Hold queue.

Advanced Transaction Attributes

The applet captures rich metadata for every transaction to ensure legal and operational compliance.

For Warehouse Staff (Receivers)

This section is your personal guide to recording goods receipts and managing warehouse inventory.

Quick Receipt Workflow

    graph TD
    A[Delivery Arrives] --> B[Create GRN Header]
    B --> C[Link Purchase Order]
    C --> D[Verify Line Items]
    D --> E[Record Actual Quantities]
    E --> F[Submit for Approval]
    F --> G[Inventory Updated]
  

Create Your First GRN

Goal: Record a goods receipt and update inventory in 5 simple steps.

1. Navigate: Go to Purchase GRN (Internal) from the sidebar
2. Create Header: Click "+" → Enter GRN details (Supplier, Date, Reference) → Create
3. Link Purchase Order (Optional but Recommended):
   • You do not need a PO to be linked beforehand; you can create a standalone manual GRN by adding lines manually under the Lines tab.
   • To link a Purchase Order, navigate to the KO For tab:
     • Go to the Purchase Order sub-tab.
     • Search: Use the search bar to locate the PO document number.
     • Select: Check the box next to the relevant PO number.
     • Knock Off: Click the KNOCK OFF button to import all expected line items and quantities into your GRN and link the documents.
4. Record Actual Receipt:
   • On the Lines tab, enter the Actual Quantity Received for each item.
   • Note Quality Issues or Damage: Go to the Item Details tab of the selected line item and enter notes/damage details in the line-level Remarks field. (Alternatively, enter header-level notes in Remarks under the Main Details tab).
   • Upload Delivery Note Photos: Go to the Attachment tab within the GRN form to upload photos or scanned documents of the supplier’s Delivery Note.
5. Finalize: Click Submit → GRN goes for approval → Inventory updates automatically

What happens next? You’ll get notifications when approved. Inventory updates automatically upon finalization.

Pro Tip: Use barcode scanning to speed up item identification and reduce errors.

For Purchase Teams (Buyers)

This section helps you verify receipts against orders and maintain procurement accuracy.

Approval & Verification Workflow

    graph TD
    A[Pending GRN Approval] --> B[Review PO vs Receipt]
    B --> C{Discrepancy?}
    C -- Yes --> D[Query Warehouse]
    C -- No --> E[Approve GRN]
    D --> B
    E --> F[Inventory Released]
  

Verify Your First Receipt

Goal: Review and approve goods receipts in 3 steps.

1. Check Pending: Go to the Purchase GRN (Internal) listing and select the Submitted tab to view GRNs awaiting approval.
2. Review Details:
   • Click on the GRN to open
   • Check: Quantities received vs ordered, supplier delivery note
   • Verify Financials: Check currency rates, contra entries, and expense allocation.
   • Verify any discrepancies are explained
3. Decide:
   • Approve: Click ✓ Approve → Inventory gets updated
   • Reject: Click ✗ Reject → Add reason → Warehouse notified
   • Query: Click Query → Ask for more information

Deep-Dive: Financial & Budgetary Control

The system ensures every GRN is accounted for within the company’s financial framework:

• Departmental Allocation: Assign receipts to specific Profit Centers, Segments, or Projects.
• Budget Register: Track utilization against Fiscal Periods and specific Budget Items.
• Foreign Exchange History: Maintain a history of currency rates (Forex Source) used at the time of receipt.

For Managers & Supervisors

Track warehouse efficiency and supplier performance.

Monitor Receipt Performance

Goal: Track warehouse efficiency and supplier performance in 4 steps.

1. Access Dashboard: Go to GRN Reports or Dashboard
2. Review Key Metrics:
   • Receipt accuracy rates
   • Average processing time
   • Supplier delivery performance
3. Identify Issues:
   • Check for recurring discrepancies
   • Review quality problems by supplier
4. Take Action:
   • Follow up on problem suppliers
   • Provide feedback to warehouse team

Ongoing: Set up automated reports for weekly performance reviews.

Detailed Line Items Management (Lines Tab)

To record or edit items within a specific GRN document, you use the Lines tab inside the GRN creation/editing form.

How to Record Line Items:

1. Open a GRN from the listing (or create a new one).
2. Go to the Lines tab.
3. For each item received:
   • Expected Quantity: Auto-populated from PO (if knocked off).
   • Received Quantity: Enter actual amount received.
   • Remarks: Any special observations or notes on the item.
   • Serial/Batch: If applicable.

Global Line Items Listing Workspace

Apart from editing individual GRN documents, the applet provides a global Line Items listing accessed from the sidebar. This workspace compiles all line items from all GRN documents, allowing purchase and inventory teams to search, filter, and track received items globally without opening each GRN document individually.

Visual Example:

Item: Laptop Model ABC-123
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Expected: 100 units     Received: 95 units     Status: Good
Missing: 5 units        Reason: Short delivery by supplier

[████████████████████░░] 95% received

Detailed PO Matching & Quality Control

PO Matching is the process of linking received goods to their originating purchase orders. This ensures that what you receive matches what you ordered and enables automated processing workflows.

Knock-Off (KO For Tab) vs. Manual Entry (Search Items)

While linking a PO is a best practice, a GRN does not strictly require a pre-existing Purchase Order. Depending on your operational flow, you can choose between two methods:

• Knock-Off (KO For Tab) — Linked Entry: Use this when receiving goods against an existing Purchase Order. Under the KO For tab, search for the PO, select it, and click KNOCK OFF. This automatically imports the lines and deducts the remaining open balance from the PO upon finalization. This is required for three-way matching (PO vs. GRN vs. Invoice).
• Manual Entry (Lines Tab Search) — Standalone Entry: Use this when goods arrive without a pre-existing PO in the system. Go directly to the Lines tab and search for individual items to add them one by one. No PO balance is updated since no document is linked.

Matching Process Steps:

1. PO Selection: Search by PO number or supplier under the KO For tab.
2. Line Item Population: Check the PO checkbox and click KNOCK OFF to import GRN lines for the selected PO.
3. Receipt Recording: Enter actual quantities received.
4. Validation: System checks for over-receipts or quality flags.

Quality Control Workflows:

Quality Control Workflows ensure that received goods meet your organization’s standards.

• Good Status: Items accepted into inventory immediately.
• Hold Status: Items require additional inspection or testing.
• Rejected Status: Items fail quality standards and initiate return process.

Real-World Scenarios:

For Administrators (System Setup)

Configure the system settings to customize field visibility, default options, and printable formats.

Core Configuration & Integration

Administrators are responsible for setting up the foundational parameters of the applet:

• Application Settings (Field Settings): Toggle tab visibility (e.g., KO For, Lines, Account, Attachments), and make specific fields mandatory or hidden.
• Default Selection: Pre-fill default values for new GRN documents (e.g., default Company, Branch, and Location) to speed up warehouse receiving operations.
• Printable Format Settings: Configure the Jasper report templates used when printing GRN receipts.
• Branch Settings: Adjust receiving behaviors and defaults for specific branches.

Configuration & Settings

Tailor the Purchase GRN (Internal) Applet to your specific workflow for faster processing.

Customizing Your View

The applet allows individual users to personalize their interface:

• Sidebar Shortcuts: Pin the “Pending Approvals” or “Recent GRNs” to your sidebar for one-click access.
• Table Customization: Show or hide columns in the main listing (e.g., hide “Reference” if not used).
• Default Filters: Save your preferred filters (e.g., “Status = Pending” and “Branch = My Branch”) as the default view.
• Favorite Suppliers: Mark frequently used suppliers as favorites to find them faster when creating manual GRNs.

Applet Settings Reference

Administrators configure the applet settings under the Settings menu:

FAQ

Q: Why can’t I see a specific Purchase Order when creating a GRN? A: The PO might be fully received, closed, or assigned to a different branch. Ensure the PO is in “Approved” status and has open quantities.

Q: How do I handle over-receipts when the supplier delivers more than ordered? A: Record the actual quantity. The system will flag a “Quantity Over-receipt” which requires approval from the Purchase Manager.

Q: What happens if I mark items as damaged during receipt? A: They are moved to a Quality Hold bucket. They do not increase “Available Stock” until a Quality Inspector releases them or initiates a supplier return.

Q: Can I receive against multiple Purchase Orders in a single GRN? A: Yes. Use the “Link Multi-PO” feature to consolidate several small deliveries into one GRN document.

Q: How do I track serial numbers? A: For serialized items, a “Serial Input” button appears on the line item. You can scan or type each individual serial number.

Q: Can I modify a GRN after it’s been approved? A: No. Approved GRNs are “Locked” for audit purposes. You must use a “GRN Reversal” or “Adjustment” to correct errors.

Q: What if the cost on the GRN differs from the PO? A: The system flags a “Price Variance”. Depending on settings, this may trigger an additional approval level from Finance.

Q: Why is my GRN stuck in “Submitted” status? A: Check the Approval Queue. It likely requires a second-level approval from a Department Head or Purchase Manager.

Q: What is the difference between a GRN and a GRN Stock Report? A: A GRN (Goods Received Note) is an individual, operational transaction document that records the physical receipt of specific items and quantities from a supplier, updating stock levels upon finalization. A GRN Stock Report (found in reporting applets) is an analytical report aggregating data across many GRNs to show receipt history, trends, costing layers, and supplier performance over a selected timeframe.

Q: Does a GRN need a Purchase Order (PO) to be linked beforehand? A: No, a pre-existing PO is not mandatory. If goods arrive without an order, you can create a standalone manual GRN and add items directly. However, linking a PO is highly recommended to enforce three-way matching controls.

Q: What is the difference between Search Documents/Items and the KO For tab, and which do I use? A:

• KO For (Knock-Off For) is used when creating a GRN from an existing PO. You search for the PO under this tab, check the box, and click KNOCK OFF. This imports the line items automatically and links the GRN to that PO, updating the remaining open quantities.
• Search/Item Search is used for manual entries where you add items one by one on the Lines tab without any upstream document link.
• To link a PO, you must use KO For and click the KNOCK OFF button.

Q: Where are discrepancies and variances flagged in the system? A: Discrepancies between expected and actual received quantities/costs are flagged in several places:

1. Line Items: Quantities received vs. expected are shown line-by-line.
2. Document Approval Alerts: Over-receipts trigger a “Quantity Over-receipt” flag, routing the document to the Purchase Manager for approval.
3. Financial Warnings: Unit price differences between the PO and GRN trigger a “Price Variance” flag for Finance review.

Q: Can I export the GRN data to Excel for offline analysis? A: Yes. You can filter and export the main GRN listing or the global Line Items workspace directly to Excel by using the export button on the listings.