-
Notifications
You must be signed in to change notification settings - Fork 134
Pharmacy Procurement GRN Returns
A GRN Return records items that were received via Goods Received Note (GRN) but need to be sent back to the supplier — due to damage, wrong items, expired stock, or quantity discrepancies. The system tracks the return, updates stock levels, and creates a refund payment to the supplier.
The workflow has three stages, usually performed by different staff:
| Stage | Performed by | Result |
|---|---|---|
| 1. Create | Pharmacy staff | A return is created with selected items and quantities |
| 2. Finalize | Senior staff | The return is reviewed and locked for approval |
| 3. Approve | Supervisor | Stock is deducted, refund payment is created |
Use the GRN Return feature when:
- Damaged Items: Items received via GRN are damaged and need to be sent back
- Wrong Items: Supplier delivered incorrect items in a GRN
- Expired Items: Items received are expired or close to expiry
- Quantity Discrepancy: Received quantity is more than ordered or invoiced
- Quality Issues: Items do not meet quality standards on inspection
- From the main menu, go to Pharmacy → Returns and Cancellations
- Click the GRN Returns tab
- You will see options:
- Create GRN Return — Start a new return
- Finalize GRN Return — Review and finalize saved drafts
- Approve GRN Return — Approve finalized returns
- Completed GRN Returns — View completed returns
- Click Create GRN Return
- The Search GRN Bills page opens with filter options:
- From Date / To Date — Select the date range (set From Date far enough back to find GRNs)
- GRN No — Enter a specific GRN number if known
- Invoice Number — Search by supplier invoice
- Supplier — Filter by supplier name
- Item Name — Search for GRNs containing a specific item
- Click Search
- A table appears listing GRN bills with columns: Supplier, PO No, GRN No, Invoice No, PO Value, GRN Value
Tip: Use the date range filter to narrow results. GRNs from the last 30-90 days are most likely to have returnable stock.
- Review the search results
- Find a GRN that has items you want to return (not already fully returned)
- Click the Create Return button on that row
- A confirmation dialog appears — click Yes to confirm
- You are taken to the GRN Return Form page
Note: If you see an error "There is already a pending return for this GRN", you must complete, approve, or close the existing return before creating a new one.
The return form shows all items from the original GRN in a table with these columns:
| Column | Description |
|---|---|
| Item Name | Medicine or supply name (with View Item Details button) |
| Date of Expiry | When the batch expires |
| Batch No | Batch/lot number |
| Current Stock | Available stock in the pharmacy |
| Purchased Quantity | Original quantity received in the GRN |
| Free Quantity | Free-of-charge quantity included |
| Already Returned Qty | Quantity already returned previously |
| Remaining Total Qty | Remaining quantity available to return |
| Return rate | Cost per unit (total cost rate) |
| Returning Total Qty | Enter the quantity you want to return |
| Return Value | Calculated automatically (quantity × rate) |
| Action | Remove this item from return button |
For each item you want to return:
- Click in the Returning Qty column for the item
- Enter the quantity you are returning
- The Return Value calculates automatically
- The Return Amount in the right panel updates
Validation Rules:
- You cannot return more than the Remaining Qty
- You cannot return items already fully returned
- Quantities must be positive numbers
Tip: You don't have to return every item. Leave the quantity at 0 for items you want to keep.
You can remove individual items you decide not to return:
- Click the Remove this item from return button () in the Action column on the item's row
- The item is removed from the return form immediately
Note: The GRN Return form does not have a multi-select "Delete Selected" button with checkboxes like the Disposal Issue Return form. Each item is removed individually using its own Remove button.
In the right panel, fill in:
- Return Comments — Enter a reason for the return (e.g., "Damaged items", "Wrong delivery")
- Payment Method — Select from the dropdown (Cash, Credit, etc.)
- Actual Net Value — Leave as-is (auto-calculated from return quantities)
Important: Both Return Comments and Payment Method are required before finalizing. If you try to finalize without them, the system will show an error.
Option A: Save
- Click the Save button
- Use this to save your work and continue later
- You can save multiple times before finalizing
- The system shows "Return saved successfully" when done
Option B: Finalize
- Click the Finalize button
- The system validates all required fields
- If validation passes, the return is submitted for approval
- A print preview of the return receipt is shown
If you saved a return as a draft:
- Click List of GRN Returns to Finalize (button in the top navigation)
- OR go to Returns and Cancellations → GRN Returns → Finalize GRN Return
- Set From Date and To Date to find your return
- Click Search
- Find your return in the list (shows supplier, return number, value)
- Click the Finalize button
- Review the items and quantities
- Click Finalize to submit for approval
Note: You need the "Approve GRN Return" privilege for this step.
- Click List of GRN Returns To Approve
- OR go to Returns and Cancellations → GRN Returns → Approve GRN Return
- Set date range and click Search To Approve Requests
- Find your return (status shows "Pending Approval")
- Click the Approve button
- Review the return one final time
- Click Approve to complete the transaction
What Happens on Approval:
- Stock levels are updated (returned items are deducted)
- A refund payment to the supplier is created
- The return is marked as "Approved"
- A printable receipt is displayed
If you need to cancel a return and start fresh:
- Draft returns: Can be closed from the Finalize list
- Finalized returns: Can be closed from the Approve list
- Approved returns: Cannot be closed — contact a supervisor for corrective actions
| Message | Meaning | Action Required |
|---|---|---|
| "GRN Return Request Saved Successfully" | Draft saved | Continue editing or finalize later |
| "GRN Return Request Finalized Successfully" | Return submitted for approval | View print preview, print, or wait for approval |
| "Return approved successfully" | Return completed, stock updated | None — process complete |
| Message | Meaning | How to Fix |
|---|---|---|
| "There is already a pending return for this GRN" | A return already exists for this GRN | Complete, approve, or close the existing return |
| "Please enter return comments" | Comment field is empty | Enter a reason for the return |
| "Please select payment method" | Payment method not selected | Select Cash, Credit, or other from the dropdown |
| "You can't return more than remaining quantity" | Return qty exceeds remaining | Reduce the quantity |
| "Insufficient stock for [Item] (Batch: [batch]). Current stock: X. Total return quantity: Y" | Return quantity exceeds current physical stock | Reduce return quantity to current stock level or below |
| "At least one item must have a return quantity" | All quantities are 0 | Enter return quantities for at least one item |
| "Cannot finalize: Stock validation failed" | Return quantity exceeds available stock for one or more items | Correct quantities and try again |
| "You are NOT authorized" | Insufficient privileges | Contact your administrator for access |
| Dialog | When It Appears | Action |
|---|---|---|
| "Are you sure you want to create a return for this GRN?" | After clicking Create Return | Click Yes to proceed |
| "Are you sure you want to finalize this GRN return? Once finalized, it will require approval to complete." | After clicking Finalize | Click Yes to submit |
- Verify the GRN: Ensure you have the correct GRN
- Check Stock Levels: Review current stock before returning
- Confirm Return Reason: Document the reason clearly
- Review Previous Returns: Check if items were already returned
- Count Physical Items: Double-check quantities before entering
- Match Batch Numbers: Ensure you're returning from the correct batch
- Consider Expiry: Return items approaching expiry first
- Document Everything: Use the comments field to record details
- Save Frequently: Save drafts if you need to pause
- Review Before Finalizing: Double-check all quantities
- Print Immediately: Print return receipts for records
- Timely Approval: Approve returns promptly to maintain accurate stock
Problem: "Create Return" button is disabled or shows error
Solutions:
- Check if the GRN has been fully returned already
- Verify there isn't a pending return for this GRN
- Ensure the original GRN was completed successfully
- Try a different GRN if this one has issues
Problem: Finalize button shows validation errors
Solutions:
- Ensure Return Comments are filled in
- Select a Payment Method
- Verify at least one item has a return quantity
- Check that no quantities exceed remaining amounts
Problem: Approve button is not visible or disabled
Solutions:
- Verify the return has been finalized first
- Check you have "Approve GRN Return" privilege
- Ensure the return hasn't been approved already
- Confirm you're in the correct department
Problem: "Insufficient stock for [Item]" error when finalizing
Solutions:
- Check the current stock shown for the item
- Reduce return quantity to match or be below current stock
- If stock was recently used, wait for stock levels to update and try again
- The system checks physical stock, not original purchase quantity
| Task | Required Privilege |
|---|---|
| Create GRN returns | CreateGrnReturn |
| Finalize returns | FinalizeGrnReturn |
| Approve returns | ApproveGrnReturn |
| View completed returns | ViewGrnReturn |
Administrators can configure print formats:
- Click Settings (gear icon) in print preview
- Select from available paper formats (A4, 5×5, POS)
- Click Apply & Close to save
Q: Can I edit a return after finalizing? A: No, once finalized a return cannot be edited. If not yet approved, it can be closed and a new return created.
Q: What happens to stock when I approve a return? A: Returned items are deducted from pharmacy stock, and a refund payment to the supplier is created.
Q: Can I return items from multiple GRNs at once? A: No, each return must be for a single GRN. Process each GRN separately.
Q: Can I return partial quantities? A: Yes, you can return any quantity up to the current stock level. However, you cannot return more than the current physical stock, even if the original GRN had higher quantities.
Q: How do I remove an item from the return I don't want to return? A: Click the Remove this item from return button () in the Action column for that row. Note: the GRN Return form removes items individually — there is no multi-select delete function.
Q: Why can't I finalize even though I entered quantities? A: Check for two common issues: (1) Return Comments field is empty — fill it in. (2) A return quantity exceeds current stock — the system checks physical stock, not original purchase quantity.
Q: How do I verify a return was processed? A: Go to Completed GRN Returns, search by date range, and find your return with "Approved" status.
- Pharmacy Procurement — GRN and Goods Receipt — Creating and managing GRNs
- Pharmacy Procurement — Purchase Orders — Purchase order management
- Direct Purchase Returns — Returning items from direct purchases
- Disposal Issue Returns — Returning disposal/issue items
- Pharmacy Navigation Guide — Complete pharmacy module navigation