Axpert · v1.0
Axpert ERP — Local Purchase Module

Local Purchase Module

The Local Purchase Module in Axpert ERP manages the complete procurement lifecycle for locally sourced materials — from raising a Purchase Request through goods receipt, billing, returns, and reporting.

Module: Local Purchase
Company: Axpert
Scope: Materials Only

About This Module

The Local Purchase Module covers all transactions related to procuring materials from local suppliers. It provides a structured, trackable workflow that ensures every purchase is properly authorized, received, and accounted for.

The module is designed for materials procurement only. Service-related procurement is handled through a separate process outside this module.

#TransactionPurpose
01Purchase RequestRaise an internal requisition for materials
02Request Short CloseClose a partially fulfilled or cancelled purchase request
03Local Purchase OrderIssue a formal purchase order to a supplier
04PO Short CloseClose a partially fulfilled purchase order
05Local GRNRecord goods received and process supplier invoice
06Direct PurchaseRecord cash purchases made without a purchase order
07Purchase ReturnReturn defective or incorrect goods to supplier
08Purchase RegisterView and print all purchase transactions
09Indent RegisterTrack all purchase request status and balances

Procurement Flow

The standard procurement cycle follows the flow below. Short close options are available at both the Purchase Request and Purchase Order stages when full fulfillment is not required.

LOCAL PURCHASE — PROCUREMENT FLOW 01 Purchase Request Approved ? Rejected / Revised No Yes 02 Request Short Close Partial/ Cancelled 03 Local Purchase Order Fully Supplied? 04 PO Short Close No Yes 05 Local GRN Quality OK? 07 Purchase Return No Yes Payment by Finance ALTERNATE PATH (No PO Required) 06 Direct Purchase Payment by Finance REPORTS 08 Purchase Register All purchase transactions 09 Indent Register PR status & balances Main Transaction Short Close Exception Path Finance
ℹ️
Standard Path The normal procurement cycle is: Purchase Request → Purchase Order → Local GRN → Payment. All other transactions (Short Close, Purchase Return, Direct Purchase) are exception or alternate paths.
⚠️
Materials Only This module is strictly for material procurement. Service requisitions are handled through a separate process and are not covered here.
💡
Direct Purchase — No PO Needed For urgent or small-value cash purchases, use Direct Purchase (06) to bypass the Purchase Request and Purchase Order steps entirely.
Local Purchase Module — Transaction

Purchase Request

A Purchase Request is an internal requisition raised by a department to request procurement of materials only. It is the starting point of the local purchase cycle in Axpert's ERP.

Screen Name: Local Purchase Request
Module: Local Purchase
Default Location: Axpert
⚠️
Materials Only — Not for Services This screen is used exclusively for requesting stock materials (physical goods). Service requisitions such as repair work, labour contracts, or consultancy are not processed through the Purchase Request screen. Please use the appropriate service request process for those requirements.

Navigation Path

Screen Overview

Local Purchase Request — Entry Screen (Axpert)
Local Purchase Request Screen

Toolbar Buttons

New
💾 Save
💾 Save and Print
📄 PDF
🔍 Search
List View
View History
ButtonDescription
NewClears the form and opens a blank Purchase Request for entry
SaveSaves the current record to the database without printing
Save and PrintSaves the record and immediately opens the print dialog
PDFExports the Purchase Request as a PDF file for sharing or archiving
SearchOpens a search dialog to find existing Purchase Requests by date, number, or item
List ViewDisplays all Purchase Requests in a tabular list for quick browsing
View HistoryShows the full modification history (who created/edited and when) for this record

Header Fields

The header section appears at the top of the form and captures the key details of the Purchase Request before entering item lines.

Header Section
Field NameDescription & InstructionsRequired
Location* The branch or warehouse raising this Purchase Request. Defaults to Axpert. Select a different location from the dropdown if raising on behalf of another branch. Yes
Requisition Date The date on which the Purchase Request is being raised. Click the calendar icon to select the date. Defaults to today's date. Yes
Requisition No. A unique system-generated reference number assigned to this Purchase Request on saving. Use the … button to search for and open an existing Requisition. Leave blank when creating new. Auto

Form Tabs

The lower section of the form has two tabs. The Item Particulars tab is where you enter all item lines. The Attachment tab allows supporting documents to be uploaded.

Item Particulars — Grid Columns

Each row in the Item Particulars grid represents one item being requested. Enter as many rows as needed.

Item Particulars Tab — Column Reference
ColumnDescription & InstructionsRequired
S No Serial number of the row. Auto-increments as rows are added. Cannot be edited manually. Auto
Item* The material being requested. This field is for stock items only — services cannot be requested using this form. Click the 🔍 search icon on the right of the field to open the item search popup. You can search by item code or item name. Once selected, the item description and default unit are auto-filled.

ⓘ If the item is not found, contact the Inventory/Admin team to add it to the item master before proceeding.
Yes
Unit* Unit of measure for the item (e.g., PCS, KG, LTR, MTR, BOX). Auto-filled from the item master when the item is selected. Can be changed using the dropdown if a different UOM is required for this request. Yes
Qty* The quantity of the item being requested. Enter a numeric value. The system automatically adds this to the Total Quantity in the footer. Decimal quantities are allowed where applicable. Yes
Due Date The date by which this specific item is required. Click the calendar icon to select. This helps the Purchase team prioritize orders. Leave blank if no specific deadline. Optional
Remarks Any additional notes, specifications, or instructions specific to this item line. For example: brand preference, quality grade, packaging size, or technical specification. Free-text field. Optional

Attachment Tab

Use this tab to upload supporting documents alongside the Purchase Request. Typical attachments include:

  • Technical specifications or datasheets for the requested materials
  • Approval emails from department head
  • Sample images or reference documents
  • Quotations or comparative statements (if available at PR stage)

Footer Fields

Footer Section
FieldDescription
Total Quantity Auto-calculated sum of all Qty values entered across all item lines. Read-only — updates automatically as items are added or modified.
Notes A free-text field for overall remarks about the entire Purchase Request — not specific to any single item. Use this for general instructions to the Purchase department (e.g., urgency, budget code, project reference).

Step-by-Step: Creating a Purchase Request

1
Open a New Form

Click the New button in the toolbar. A blank Purchase Request form opens with Location pre-filled as Axpert.

2
Set the Header

Confirm or change the Location. Set the Requisition Date using the calendar. Leave Requisition No. blank — it is assigned on save.

3
Add Items in the Grid

Click the first row in the Item Particulars grid. Use the 🔍 search icon on the Item column to find and select the item. Enter Qty, confirm the Unit, and optionally set a Due Date and Remarks.

4
Add More Item Rows

Press Enter or Tab at the end of a row to move to the next row automatically. Repeat for all items needed.

5
Attach Supporting Documents (if any)

Click the Attachment tab and upload any relevant files before saving.

6
Enter Notes (Optional)

Fill the Notes field in the footer with any overall instructions or context for the Purchase team.

7
Save the Record

Click Save to save the record. The system assigns a Requisition No. automatically. Click Save and Print if a printed copy is required immediately.

💡
Adding Multiple Items Quickly Press Enter or Tab after filling the last column of a row — the cursor automatically moves to a new row. This avoids clicking each new row manually.
⚠️
Mandatory Fields The fields marked with an asterisk (*) — Location, Item, Unit, and Qty — must be filled before the record can be saved. The system will highlight missing mandatory fields if you attempt to save without them.
ℹ️
Searching Existing Requests To open an existing Purchase Request, click Search in the toolbar or click the … button next to the Requisition No. field and search by date range, item, or requisition number.
🚫
Item Not Found? If an item does not appear in the item search popup, do not enter a free-text item name. Contact the system administrator to add the item to the Item Master first. Entering unregistered items will cause errors in the purchase order and GRN stages.
Local Purchase Module — Transaction

Purchase Request Short Close

Request Short Close is used to close a Purchase Request that has been partially fulfilled or is no longer required. The remaining balance quantity is permanently closed and will not be available for future Purchase Orders.

Screen Name: Request Short Close
Module: Local Purchase
Default Location: Axpert
🚫
Irreversible Action Once a Short Close is saved, the closed quantity cannot be reopened. If materials are still required, a fresh Purchase Request must be raised. Verify all quantities carefully before saving.

Navigation Path

Screen Overview

Request Short Close — Entry Screen (Axpert)
Request Short Close Screen

Toolbar Buttons

New
💾 Save
💾 Save and Print
📄 PDF
🔍 Search
List View
View History
ButtonDescription
NewClears the form and opens a blank Request Short Close for entry
SaveSaves the short close record permanently — closes the selected quantities
Save and PrintSaves the record and opens the print dialog immediately
PDFExports the short close document as a PDF file
SearchSearch for existing Short Close records by date, Doc ID, or PR number
List ViewDisplays all Request Short Close records in a list
View HistoryShows who created or modified this record and when

When to Use Request Short Close

  • A Purchase Request was raised but the material is no longer required (project cancelled, requirement changed)
  • Only a partial quantity was delivered and the balance is not expected to arrive
  • The material was procured through another channel and the PR balance needs to be cleared
  • The PR has been pending for too long and needs to be administratively closed

Header Fields

The header section captures the date and identifies the Short Close document.

Header Section
Field NameDescription & InstructionsRequired
Location* The branch or location for which the short close is being done. Defaults to Axpert. Select a different location from the dropdown if required. Yes
Doc Date The date on which the short close is being processed. Click the calendar icon to select. Defaults to today's date. Yes
Doc ID. A unique system-generated reference number assigned to this Short Close document on saving. Use the … button to search for and open an existing Short Close record. Auto

Item Particulars — Grid Columns

Each row represents one item line from a Purchase Request being short-closed. Enter the PR number first — the system populates item details automatically.

Item Particulars Tab — Column Reference
ColumnDescription & InstructionsRequired
S No Serial number of the row. Auto-increments as rows are added. Auto
PR No The Purchase Request number to be short-closed. Type the PR number directly or click the field to search. Once a valid PR No is entered, the system auto-fills PR Date and populates the Item Name dropdown with items from that PR.

ⓘ Only Purchase Requests with a pending balance quantity will appear.
Yes
PR Date The date of the original Purchase Request. Auto-filled when PR No is selected. Read-only. Auto
Item Name The material item from the selected Purchase Request to be short-closed. Select from the dropdown — populated automatically based on PR No. Only items with a pending balance are shown. Yes
Unit* Unit of measure for the selected item. Auto-filled from the original Purchase Request. Read-only. Auto
Balance Qty* The remaining unfulfilled quantity from the original Purchase Request for this item. Auto-calculated (Original PR Qty − Received via GRN). Read-only — for reference only. Auto
Short Close Qty* The quantity to be permanently closed. Enter a value equal to or less than the Balance Qty. This quantity will be removed from the pending procurement queue after saving.

⚠ Cannot exceed Balance Qty. Cannot be changed after saving.
Yes

Footer Fields

Footer Section
FieldDescription
Total Quantity Auto-calculated sum of all Short Close Qty values entered across all rows. Read-only.
Notes Free-text field to record the reason for short close. Strongly recommended for audit trail (e.g., "Requirement cancelled", "Procured from alternate source", "Project on hold").

Step-by-Step: Processing a Request Short Close

1
Open a New Form

Click the New button in the toolbar. A blank Request Short Close form opens with Location pre-filled as Axpert.

2
Set the Header

Confirm the Location and set the Doc Date using the calendar. Leave Doc ID. blank — it is assigned on save.

3
Enter the PR Number

In the Item Particulars grid, type the PR No in the first row. The system auto-fills the PR Date and loads the items from that request.

4
Select the Item

Click the Item Name dropdown and select the material to be short-closed. The Unit and Balance Qty fill automatically.

5
Enter Short Close Quantity

Type the quantity to close in the Short Close Qty field. Must be ≤ Balance Qty. To close the full balance, enter the same value as Balance Qty.

6
Add More Rows if Needed

Press Enter or Tab to add a new row. Repeat steps 3–5 to short-close items from other PRs in the same document.

8
Enter Notes

Fill the Notes field in the footer with the reason for short close. Important for audit and reporting.

8
Save

Click Save. The system assigns a Doc ID and permanently closes the specified quantities. The PR balance is updated immediately.

⚠️
Short Close Qty Cannot Exceed Balance Qty The system will not allow saving if Short Close Qty is greater than Balance Qty. Always check the Balance Qty before entering the close quantity.
ℹ️
Partial Short Close Allowed You do not have to close the full balance. Enter a partial quantity in Short Close Qty — the remaining balance will still be available for Purchase Order creation.
💡
Multiple PRs in One Document You can short-close items from multiple Purchase Requests in a single document by adding multiple rows, each with a different PR No.
Local Purchase Module — Transaction

Local Purchase Order

A Local Purchase Order (LPO) is a formal document issued to a supplier authorising the supply of materials as per agreed terms. It is generated against an approved Purchase Request and is the contractual basis for procurement in Axpert ERP.

Screen Name: Local Purchase Order
Module: Local Purchase
Default Location: Axpert

Navigation Path

Screen Overview

Local Purchase Order — Entry Screen (Axpert)
Local Purchase Order Screen

Toolbar Buttons

New
💾 Save
💾 Save and Print
📄 PDF
🔍 Search
List View
View History
ButtonDescription
NewOpens a blank Local Purchase Order form for entry
SaveSaves the PO record to the database
Save and PrintSaves the PO and immediately opens the print dialog
PDFExports the Purchase Order as a PDF for sending to the supplier
SearchSearch for existing POs by date, PO number, or supplier
List ViewDisplays all Purchase Orders in a tabular list
View HistoryShows the modification history of this PO record

Header Fields

The header section captures the supplier details, PO reference, currency, and payment terms before item lines are entered.

Header Section — Left Column
Field NameDescription & InstructionsRequired
Location* The branch raising the Purchase Order. Defaults to Axpert. Select a different location from the dropdown if required. Yes
PO Type Indicates whether the Purchase Order is raised against an approved Purchase Request or directly without one. Select from the dropdown:

Indent Based — PO is linked to an approved Purchase Request. The PR No must be entered in the item grid and PR Balance Qty will be tracked.

Direct PO — PO is raised directly without a Purchase Request. No PR linking is required. Typically used for urgent or pre-approved purchases.

ⓘ Selecting the correct PO Type is important as it determines whether the system will validate PR linkage and update indent balances.
Yes
Supplier* Select the supplier using the 🔍 search button. Search by supplier code or name. On selection, Contact Email is auto-filled from the supplier master. Yes
Currency The currency in which the PO is raised. Only two currencies are allowed:

Local Currency — The local reporting currency of the company.

Base Currency — The base accounting currency configured in the system. When Base Currency is selected, the Exchange Rate (to Base) and Exchange Rate (to Local) fields must be filled.

ⓘ No other currencies are permitted in Local Purchase Orders.
Yes
Exchange Rate (to Base)* The conversion rate from Local Currency to Base Currency. Required only when Base Currency is selected in the Currency field. Auto-filled if a default rate is configured in the system. If Base Currency
Exchange Rate (to Local)* The conversion rate from Base Currency to Local Currency. This field is always displayed regardless of the currency selected and must always be filled before saving. Yes
Credit Days Number of credit days allowed by the supplier for payment (e.g., 30, 45, 60 days). Used by Finance for payment scheduling. Optional
Header Section — Right Column
Field NameDescription & InstructionsRequired
PO Date The date on which the Purchase Order is being issued. Click the calendar icon to select. Defaults to today's date. Yes
PO No* A unique system-generated PO reference number assigned on saving. Use the … button to search for and open an existing PO. Auto
Contact Email Supplier's contact email address. Auto-filled from the supplier master when the supplier is selected. Can be edited if a different email is needed for this PO. Auto
Transaction Type Select the transaction type from the dropdown. Determines how the PO is processed and accounted for in the system. Yes
Reference No An external reference number such as the supplier's quotation number, tender reference, or any other external document number for cross-referencing. Optional
Advance (%) The advance payment percentage required by the supplier before delivery. If applicable, enter the percentage here. Finance will use this for advance payment processing. Optional

Item Particulars — Grid Columns

Each row in the Item Particulars grid represents one material line being ordered. Link to a Purchase Request by entering the PR No — the system will auto-fill related details.

ℹ️
Scroll Right for More Columns The Item Particulars grid has additional columns beyond what is visible on screen. Scroll horizontally to access all columns including Discount Type, Discount, Discount Amount, and more.
Item Particulars Tab — Column Reference
ColumnDescription & InstructionsRequired
S No Serial number of the row. Auto-increments as rows are added. Auto
PR No Purchase Request number against which this PO line is being raised. Enter the PR No to auto-fill the PR Balance Qty and link the PO to the original indent for tracking. Leave blank if no PR exists for this line. Optional
Item* The material being ordered. Click the 🔍 search icon to find and select the item by code or name. Item description and default unit auto-fill on selection.

ⓘ If the item is not found, contact admin to add it to the item master before proceeding.
Yes
Unit* Unit of measure for the item (e.g., PCS, KG, LTR). Auto-filled from the item master. Can be changed using the dropdown if a different UOM is required for this order. Yes
Stock Current stock on hand for this item at the selected location. Displayed automatically for reference to help assess whether the purchase is necessary. Auto
PR Balance Qty The pending unfulfilled quantity from the linked Purchase Request. Auto-filled when PR No is entered. Helps ensure the PO quantity does not exceed the approved indent. Auto
PO Qty The quantity being ordered from the supplier in this PO. Enter the required quantity. Should not exceed the PR Balance Qty if the PO is linked to a PR. Yes
Free Qty Free or bonus quantity offered by the supplier at no charge (e.g., buy 10 get 1 free). Enter if applicable. This quantity is received in GRN but does not affect the billed amount. Optional
Last Purchase Rate (in Base) The rate at which this item was last purchased from any supplier, displayed in base currency. Shown for reference only to help negotiate and validate the current rate. Auto
Rate The agreed purchase rate per unit for this PO line in the selected currency. Enter the negotiated rate. This is the basis for the PO value calculation. Yes
Discount Type* Select the type of discount being applied: % (percentage) or Amount (fixed value). Determines how the Discount field is interpreted. Yes
Discount The discount value — either a percentage or a fixed amount depending on the Discount Type selected. Leave as 0 if no discount applies. Optional
Discount Amount The calculated discount value in currency terms. Auto-calculated by the system based on Rate, Qty, and Discount entered. Read-only. Auto

Footer Summary Fields

The footer displays auto-calculated totals across all line items. All fields are read-only.

Footer Section
FieldDescription
Total Gross Amount Sum of (PO Qty × Rate) across all line items before discount and tax.
Total Discount Total discount amount across all line items.
Total Tax Amount Total tax amount across all line items.
Net Amount Final PO value — Gross Amount minus Discount plus Tax. This is the amount the supplier will be paid.
Total Quantity Sum of all PO Qty values across line items.
Total Free Qty. Sum of all Free Qty values across line items.
Notes Free-text field for any special instructions to the supplier — delivery instructions, packaging requirements, or other notes to be printed on the PO.

Step-by-Step: Creating a Local Purchase Order

1
Open a New Form

Click New in the toolbar. A blank PO form opens with Location pre-filled as Axpert.

2
Select the Supplier

Click the 🔍 search button next to Supplier and select the supplier. Contact Email auto-fills from the supplier master.

3
Fill Header Details

Set the PO Date and select PO Type — choose Indent Based if this PO is linked to an approved Purchase Request, or Direct PO if no PR exists. Then select Currency and Transaction Type. Enter Exchange Rate fields if Base Currency is selected. Enter Credit Days and Advance % if applicable.

4
Enter PR No (if linked to a Purchase Request)

In the Item Particulars grid, enter the PR No in the first row. The system auto-fills the PR Balance Qty to help you track against the approved indent.

5
Select the Item

Click the 🔍 search icon on the Item column and select the material. Unit auto-fills. Current Stock is displayed for reference.

6
Enter PO Qty and Rate

Enter the quantity to be ordered and the agreed Rate per unit. Select Discount Type and enter a discount value if applicable.

7
Add More Rows if Needed

Press Enter or Tab to add new rows. Repeat steps 4–6 for each material line.

8
Review Footer Totals

Verify the Total Gross Amount, Total Discount, Tax Amount, and Net Amount in the footer before saving.

9
Add Notes and Save

Enter any supplier instructions in the Notes field. Click Save — the system assigns the PO No. Use Save and Print or PDF to send the PO to the supplier.

ℹ️
Linking PO to Purchase Request Always enter the PR No in the grid when a Purchase Request exists for the item. This links the PO to the indent and allows the system to track PR balance, GRN quantity, and pending quantity accurately in the Indent Register.
⚠️
PO Qty Should Not Exceed PR Balance Qty If a PR is linked, ensure the PO Qty does not exceed the PR Balance Qty. Ordering more than the approved indent quantity requires a revised or fresh Purchase Request.
💡
Sending PO to Supplier Use the PDF button to export the PO as a PDF and email it to the supplier, or use Save and Print for a physical copy. The supplier's Contact Email is auto-filled in the header for reference.
🚫
Base Currency POs When raising a PO in Base Currency, always fill in both Exchange Rate (to Base) and Exchange Rate (to Local). Missing exchange rates will cause errors in accounting and GRN posting.
Local Purchase Module — Transaction

Local PO Short Close

Local PO Short Close is used to close a Purchase Order when the supplier has delivered less than the ordered quantity and no further delivery is expected. The remaining balance quantity is permanently closed, releasing the pending commitment from the system.

Screen Name: Local PO Shortclose
Module: Local Purchase
Default Location: Axpert
🚫
Irreversible Action Once a PO Short Close is saved, the closed quantity cannot be reopened. If the remaining material is still required, a fresh Purchase Request and Purchase Order must be raised. Verify all quantities carefully before saving.

Navigation Path

Screen Overview

Local PO Shortclose — Entry Screen (Axpert)
Local PO Short Close Screen

Toolbar Buttons

New
💾 Save
🔍 Search
List View
View History
ButtonDescription
NewOpens a blank PO Short Close form for entry
SaveSaves the short close record and permanently closes the specified quantities
SearchSearch for existing PO Short Close records by date, Doc ID, supplier, or PO number
List ViewDisplays all PO Short Close records in a tabular list
View HistoryShows the modification history of this record

When to Use PO Short Close

  • Supplier confirms they are unable to supply the remaining quantity
  • Only a partial quantity was delivered and the balance is no longer expected
  • The material specification has changed making the remaining PO balance obsolete
  • The project or requirement is cancelled after partial delivery
  • Material was sourced from an alternate supplier and the original PO balance needs to be cleared

Header Fields

The header identifies the supplier and the specific Purchase Order to be short-closed.

Header Section
Field NameDescription & InstructionsRequired
Location* The branch or location for which the PO short close is being processed. Defaults to Axpert. Select a different location from the dropdown if required. Yes
Supplier* Select the supplier from the dropdown. The list shows only suppliers who have open Purchase Orders at the selected location. On selection, the PO No dropdown is populated with open POs for that supplier. Yes
PO No* Select the Purchase Order to be short-closed from the dropdown. The list is filtered based on the supplier selected above. On selection, the item lines from that PO are loaded into the Item Particulars grid automatically. Yes
Date The date on which the PO short close is being processed. Click the calendar icon to select. Defaults to today's date. Yes
Doc Id.* A unique system-generated reference number assigned to this PO Short Close document on saving. Use the … button to search for and open an existing PO Short Close record. Auto

Item Particulars — Grid Columns

The Item Particulars grid is not manually editable. Items cannot be typed or selected directly. The grid must be filled using the FillGrid → Fill PO Details option accessed by right-clicking inside the grid. Once filled, review the Balance Qty for each line and enter the SC Qty to close.

💡
How to Fill Item Details — Right-Click → FillGrid → Fill PO Details Items cannot be entered manually in this grid. To populate the item lines from the selected PO:
  1. Select the Location, Supplier, and PO No in the header
  2. Right-click anywhere inside the Item Particulars grid
  3. From the context menu, hover over FillGrid
  4. Click Fill PO Details from the submenu
  5. All item lines from the selected PO are loaded automatically with Item, Unit, and Balance Qty filled
Item Particulars Tab — Column Reference
ColumnDescription & InstructionsRequired
S No Serial number of the row. Auto-incremented. Auto
Item Item name from the selected Purchase Order. Populated automatically using the FillGrid → Fill PO Details option (right-click in the grid). Cannot be entered or edited manually. Auto
Unit Unit of measure for the item. Populated automatically via FillGrid. Read-only. Auto
Balance Qty The remaining undelivered quantity from the Purchase Order for this item line. Auto-calculated as PO Qty minus GRN Qty already received. Populated via FillGrid. Read-only — for reference only. Auto
SC Qty* Short Close Quantity — the quantity to be permanently closed from this PO line. Enter a value equal to or less than the Balance Qty. To close the full balance, enter the same value as Balance Qty shown.

⚠ Cannot exceed Balance Qty. Cannot be changed after saving.
Yes

Footer Fields

Footer Section
FieldDescription
Notes Free-text field to record the reason for PO short close. Strongly recommended for audit trail and future reference (e.g., "Supplier unable to supply balance", "Requirement cancelled", "Alternative source used").

Step-by-Step: Processing a PO Short Close

1
Open a New Form

Click New in the toolbar. A blank PO Short Close form opens with Location pre-filled as Axpert.

2
Select the Supplier

Choose the supplier from the Supplier dropdown. Only suppliers with open POs will appear in the list.

3
Select the PO Number

Choose the Purchase Order from the PO No dropdown. The item lines from that PO are loaded automatically into the Item Particulars grid.

4
Set the Date

Confirm or select the Date of the short close using the calendar. Leave Doc Id. blank — it is assigned on save.

5
Fill Item Details Using FillGrid

Right-click inside the Item Particulars grid, hover over FillGrid in the context menu, then click Fill PO Details. All item lines from the selected PO are loaded automatically with Item name, Unit, and Balance Qty.

6
Review Balance Qty

Check the Balance Qty for each item line. This is the remaining undelivered quantity. Verify it matches your expectation before entering the SC Qty.

7
Enter SC Qty

Enter the quantity to close in the SC Qty field for each applicable line. Must be ≤ Balance Qty. To fully close, enter the same value as Balance Qty.

8
Enter Notes

Fill the Notes field in the footer with the reason for short close. This is important for audit and reporting purposes.

9
Save

Click Save. The system assigns a Doc Id and permanently closes the specified quantities. The PO balance is updated immediately.

ℹ️
Other Right-Click Grid Options The right-click context menu in the Item Particulars grid also provides these options:
  • AddRow — Adds a new empty row to the grid
  • InsertRow — Inserts a row above the selected row
  • DeleteRow — Deletes the selected row from the grid
  • Export to Excel — Exports the grid data to an Excel file
  • Import From Excel — Imports data into the grid from an Excel file
  • FillGrid → Fill PO Details — Populates all item lines from the selected PO
⚠️
SC Qty Cannot Exceed Balance Qty The system will not allow saving if SC Qty is greater than the Balance Qty shown. Always verify the Balance Qty before entering the close quantity.
ℹ️
Partial Short Close Allowed You do not need to close the full balance. Enter a partial SC Qty if only part of the pending quantity needs to be closed — the remaining balance will continue to be available for GRN.
💡
Multiple Item Lines If the selected PO has multiple item lines, each line is shown as a separate row in the grid. You can short-close all lines or only specific lines in a single document.
Local Purchase Module — Transaction

Local GRN

The Local GRN (Goods Receipt Note) is used to record the physical receipt of materials from a supplier against a Purchase Order. It simultaneously processes the supplier invoice, updates stock, and creates the payable entry in the system.

Screen Name: Local GRN
Module: Local Purchase
Default Location: Axpert
ℹ️
Pre-Requisites Before creating a GRN, ensure the following are available:
  • An approved and open Purchase Order exists for the supplier
  • Physical goods have been delivered to the store/warehouse
  • Original Supplier Invoice with invoice number and date is available

Navigation Path

Screen Overview

Local GRN — Entry Screen (Axpert)
Local GRN Screen

Toolbar Buttons

New
💾 Save
💾 Save and Print
📄 PDF
🔍 Search
List View
View History
Voucher Details
ButtonDescription
NewOpens a blank Local GRN form for entry
SaveSaves the GRN, updates stock, and posts the supplier payable entry
Save and PrintSaves the GRN and opens the print dialog immediately
PDFExports the GRN document as a PDF
SearchSearch for existing GRNs by date, GRN number, PO number, or supplier
List ViewDisplays all GRN records in a tabular list
View HistoryShows the modification history of this GRN record
Voucher DetailsDisplays the accounting journal entries (Debit/Credit) that will be posted on saving this GRN

Header Fields

The header section captures the GRN location, linked Purchase Order, supplier invoice details, and GRN date.

Header Section — Left Column
Field NameDescription & InstructionsRequired
GRN Location* The store or warehouse where the goods are being received. Defaults to Axpert. Select a different location from the dropdown if goods are received at a different branch or warehouse. Yes
PO No Select the Purchase Order against which goods are being received. On selection, the Supplier field is auto-filled from the PO. The Item Particulars grid is populated with the PO item lines and their balance quantities. Yes
Supplier* Auto-filled from the selected Purchase Order. Read-only. Confirms the supplier from whom goods are being received. Auto
Header Section — Right Column
Field NameDescription & InstructionsRequired
GRN Date* The date on which the goods are physically received at the store. Click the calendar icon to select. This date is used for stock valuation and accounting entries. Yes
GRN No* A unique system-generated GRN reference number assigned on saving. Use the … button to search for and open an existing GRN record. Auto
Supplier. Inv. No* The invoice number printed on the supplier's physical invoice. Must be entered exactly as it appears on the invoice. Used for duplicate invoice prevention and GST reconciliation. Yes
Supplier Inv. Date* The invoice date printed on the supplier's physical invoice. Click the calendar icon to select. Must match the date on the physical invoice document. Yes
Location Batch Flag Check this flag to enable batch and location tracking for items received in this GRN. When enabled, Batch No. and Expiry Date fields become available in the item grid. Typically used for pharma and perishable items. Optional

Form Tabs

The lower section of the GRN form has two tabs:

  • Item Particulars — Enter the quantities received and other item-level details for each line
  • Voucher Details — View the accounting journal entries that will be posted on saving. Also accessible via the toolbar button

Item Particulars — Grid Columns

The Item Particulars grid is pre-populated with item lines from the selected PO. For each line, enter the GRN Qty actually received. All other columns are auto-filled from the PO.

Item Particulars Tab — Column Reference
ColumnDescription & InstructionsRequired
S No Serial number of the row. Auto-incremented. Auto
Item* Item name from the selected Purchase Order. Auto-filled when the PO is selected. Select from the dropdown to pick the specific item being received if the PO has multiple items. Auto
Unit Unit of measure for the item. Auto-filled from the PO. Read-only. Auto
PO Qty Total quantity ordered in the Purchase Order for this item. Auto-filled from the PO. Read-only — for reference only. Auto
Balance Qty The remaining quantity yet to be received against the PO for this item line. Auto-calculated as PO Qty minus quantities already received in previous GRNs. Read-only — for reference only. Auto
Balance Free Qty The remaining free/bonus quantity yet to be received against the PO. Auto-calculated. Read-only. Auto
Rate The purchase rate per unit as agreed in the Purchase Order. Auto-filled from the PO. Can be edited if the supplier's invoice rate differs from the PO rate. Auto
GRN Qty The actual quantity of this item physically received in this GRN. Enter the quantity as counted at the store. Must not exceed the Balance Qty shown.

ⓘ This is the only field that must be entered manually — all other columns are auto-filled from the PO.
Yes
Free Qty The free or bonus quantity received in this GRN for this item. Enter if the supplier has provided free goods. Does not affect the billed amount. Optional
Amount Auto-calculated as GRN Qty × Rate. The value of goods received. Read-only. Auto
Taxcode The tax code applicable for this item. Auto-filled from the item master or PO. Determines the tax percentage to be applied. Auto
Tax (%) Tax percentage applicable for this item based on the Taxcode selected. Auto-filled. Can be verified against the supplier invoice. Auto
Tax Amount Auto-calculated tax value for this line (Amount × Tax %). Read-only. Auto

Footer Summary Fields

Footer Section
FieldDescription
Total Qty Sum of all GRN Qty values entered across all item lines. Read-only.
Total Free Qty. Sum of all Free Qty values across all item lines. Read-only.
Gross Amount Total value of all items received before discount and tax. Read-only.
Discount Total discount amount across all lines. Read-only.
Tax Amount Total tax amount across all item lines. Read-only.
Net Amount Final payable amount to the supplier — Gross Amount minus Discount plus Tax. This is the amount that will be posted to the supplier payable account. Read-only.
Notes Free-text field for any remarks about this goods receipt — e.g., condition of goods, partial delivery notes, or store keeper observations.

Step-by-Step: Creating a Local GRN

1
Open a New Form

Click New in the toolbar. A blank GRN form opens with GRN Location pre-filled as Axpert.

2
Select the PO Number

Choose the relevant Purchase Order from the PO No dropdown. The Supplier field auto-fills and the item lines from the PO are loaded into the Item Particulars grid with their Balance Qty.

3
Set the GRN Date

Select the GRN Date — the actual date goods were physically received at the store.

4
Enter Supplier Invoice Details

Enter the Supplier. Inv. No and Supplier Inv. Date exactly as printed on the physical invoice received from the supplier.

5
Enable Location Batch Flag (if required)

If the items need batch and expiry date tracking (e.g., pharma products), check the Location Batch Flag checkbox before entering item quantities.

6
Enter GRN Qty for Each Item

In the Item Particulars grid, enter the GRN Qty — the actual quantity physically received — for each item line. Verify it does not exceed the Balance Qty. Enter Free Qty if free goods were received.

7
Verify Rate and Tax Details

Check that the Rate, Taxcode, and Tax % match the supplier's invoice. Edit the Rate if the invoiced rate differs from the PO rate.

8
Review Footer Totals

Verify Gross Amount, Tax Amount, and Net Amount in the footer match the supplier invoice total before saving.

9
Check Voucher Details (Optional)

Click Voucher Details in the toolbar to preview the accounting journal entries that will be posted on saving.

10
Save

Click Save. The system assigns a GRN No, updates the stock quantity, and posts the supplier payable accounting entry automatically.

⚠️
GRN Qty Must Not Exceed Balance Qty The system will not allow saving if GRN Qty entered exceeds the Balance Qty for any item line. If more goods have been received than ordered, verify the PO or contact the Purchase department before proceeding.
🚫
Supplier Invoice Details Are Mandatory Always enter the exact Supplier Inv. No. and Supplier Inv. Date from the physical invoice. The system checks for duplicate invoice numbers per supplier to prevent double-entry. Missing or incorrect invoice details will cause issues in GST reconciliation and payment processing.
💡
Partial GRN Allowed You do not need to receive the full PO quantity in one GRN. Enter only the quantity physically received. The remaining Balance Qty will continue to be available for future GRNs against the same PO.
ℹ️
Voucher Details On saving a GRN, the system automatically posts the following accounting entries:
  • Dr Stock / Inventory A/c    Cr Supplier Payable A/c
  • Dr Input Tax A/c             Cr Supplier Payable A/c
Local Purchase Module — Transaction

Direct Purchase

Direct Purchase is used to record purchases made directly from a supplier without a Purchase Order. It updates stock and creates the supplier payable entry in one step. Typically used for urgent, small-value, or cash purchases where raising a PO is not practical.

Screen Name: Direct Purchase
Module: Local Purchase
Default Location: Axpert
⚠️
No Purchase Order Required Direct Purchase bypasses the Purchase Request and Purchase Order steps entirely. Use this transaction only for purchases that are pre-approved or within the authorised direct purchase limit. All purchases must be supported by an original supplier invoice.

Navigation Path

Screen Overview

Direct Purchase — Entry Screen (Axpert)
Direct Purchase Screen

Toolbar Buttons

New
💾 Save
💾 Save and Print
📄 PDF
🔍 Search
List View
View History
Voucher Details
ButtonDescription
NewOpens a blank Direct Purchase form for entry
SaveSaves the record, updates stock, and posts the supplier payable entry
Save and PrintSaves and immediately opens the print dialog
PDFExports the Direct Purchase document as a PDF
SearchSearch for existing Direct Purchase records by date, Doc No, or supplier
List ViewDisplays all Direct Purchase records in a tabular list
View HistoryShows the modification history of this record
Voucher DetailsDisplays the accounting journal entries that will be posted on saving

Header Fields

The header section captures the supplier, currency, document date, and supplier invoice details before items are entered.

Header Section — Left Column
Field NameDescription & InstructionsRequired
Location* The store or warehouse where the purchased goods are being received. Defaults to Axpert. Select a different location if goods are received elsewhere. Yes
Supplier* Select the supplier using the 🔍 search button. Search by supplier code or name. The supplier must exist in the supplier master before a Direct Purchase can be raised. Yes
Currency* The currency for this purchase. Only two currencies are allowed: Local Currency — the local reporting currency of the company, and Base Currency — the base accounting currency. Select from the dropdown. Yes
Exchange Rate (to Base)* The conversion rate from Local Currency to Base Currency. Required only when Base Currency is selected in the Currency field. If Base Currency
Exchange Rate (to Local) The conversion rate from Base Currency to Local Currency. This field is always displayed regardless of the currency selected and must always be filled before saving. Yes
Header Section — Right Column
Field NameDescription & InstructionsRequired
Doc Date* The date of the purchase transaction. Click the calendar icon to select. This is typically the date on the supplier invoice. Yes
Doc No* A unique system-generated document reference number assigned on saving. Use the … button to search for and open an existing Direct Purchase record. Auto
Supplier. Inv. No* The invoice number printed on the supplier's physical invoice or cash bill. Must be entered exactly as it appears. Used for duplicate invoice prevention and reconciliation. Yes
Supplier Inv. Date* The invoice date printed on the supplier's physical invoice. Click the calendar icon to select. Must match the date on the physical document. Yes
Location Batch Flag Check this flag to enable batch and expiry date tracking for items in this purchase. Typically used for pharma or perishable items. Optional

Form Tabs

  • Item Particulars — Enter the items purchased, quantities, rates, and discount details
  • Free Item Details — Enter details of any free or bonus items received separately from the main item lines
  • Voucher Details — View the accounting journal entries that will be posted on saving

Item Particulars — Grid Columns

Each row represents one material item being purchased. Unlike GRN, items are entered manually here as there is no linked Purchase Order.

Item Particulars Tab — Column Reference
ColumnDescription & InstructionsRequired
S No Serial number of the row. Auto-incremented. Auto
Item* The material being purchased. Click the 🔍 search icon to find and select the item by code or name. Unit and Last Purchase Price auto-fill on selection.

ⓘ Item must exist in the item master. Contact admin if the item is not found.
Yes
Unit* Unit of measure for the item (e.g., PCS, KG, LTR). Auto-filled from the item master. Can be changed using the dropdown if a different UOM is required. Yes
Stock Current stock on hand for this item at the selected location. Displayed automatically for reference. Auto
Qty* The quantity of the item being purchased. Enter the actual quantity as per the supplier invoice. Yes
Free Qty Free or bonus quantity received from the supplier at no charge. Enter if applicable. Does not affect the billed amount. Optional
Last Purchase Price (in Base) The last price paid for this item from any supplier, shown in base currency. Displayed for reference to help validate the current purchase rate. Auto
Rate* The purchase rate per unit as per the supplier invoice. Enter the rate in the selected currency. Yes
Discount Type Select the type of discount being applied: % (percentage) or Amount (fixed value). Determines how the Discount field is interpreted. Optional
Discount The discount value — either a percentage or a fixed amount depending on Discount Type. Leave as 0 if no discount applies. Optional
Discount Amount The calculated discount value in currency terms. Auto-calculated based on Qty, Rate, and Discount entered. Read-only. Auto
Rate After Discount The effective purchase rate after applying the discount. Auto-calculated. Read-only. Auto

Footer Summary Fields

Footer Section
FieldDescription
Gross Amount Total value of all items before discount and tax. Auto-calculated. Read-only.
Discount Amount Total discount across all item lines. Auto-calculated. Read-only.
Tax Amount Total tax amount across all item lines. Auto-calculated. Read-only.
Net Amount Final payable amount — Gross Amount minus Discount plus Tax. This is the amount posted to the supplier payable account. Read-only.
Total Qty Sum of all Qty values across all item lines. Read-only.
Total Free Qty. Sum of all Free Qty values across all item lines. Read-only.
Notes Free-text field for any remarks about this purchase — purpose of purchase, cost centre, or any other relevant information.

Step-by-Step: Creating a Direct Purchase

1
Open a New Form

Click New in the toolbar. A blank Direct Purchase form opens with Location pre-filled as Axpert.

2
Select the Supplier

Click the 🔍 search button next to Supplier and select the supplier from the search popup.

3
Set Currency and Exchange Rate

Select the Currency. Enter Exchange Rate (to Base) if Base Currency is selected. Always fill Exchange Rate (to Local).

4
Enter Document and Invoice Details

Set the Doc Date. Enter the Supplier Inv. No and Supplier Inv. Date exactly as on the physical invoice. Doc No is assigned automatically on save.

5
Enable Location Batch Flag (if required)

Check the Location Batch Flag if items require batch and expiry date tracking.

6
Add Item Lines

In the Item Particulars grid, click the 🔍 search icon on the Item column and select the material. Enter Qty and Rate as per the supplier invoice. Add discount details if applicable.

7
Add More Rows if Needed

Press Enter or Tab to move to the next row. Repeat step 6 for each item on the invoice.

8
Add Free Items (if any)

Click the Free Item Details tab to enter any bonus or free items received separately.

9
Review Footer Totals

Verify Gross Amount, Tax Amount, and Net Amount match the supplier invoice total.

10
Save

Click Save. The system assigns a Doc No, updates stock, and posts the accounting entries automatically.

🚫
Supplier Invoice Is Mandatory Always enter the exact Supplier Inv. No and Supplier Inv. Date from the physical invoice. The system checks for duplicate invoice numbers per supplier. Never save a Direct Purchase without a valid invoice reference.
ℹ️
Voucher Details On saving a Direct Purchase, the system automatically posts the following accounting entries:
  • Dr Stock / Inventory A/c    Cr Supplier Payable A/c
  • Dr Input Tax A/c             Cr Supplier Payable A/c
💡
Difference from Local GRN Direct Purchase does not require a Purchase Order. Use Local GRN when a Purchase Order exists. Use Direct Purchase for urgent or pre-approved purchases made without a PO.
Local Purchase Module — Transaction

Purchase Return

Purchase Return is used to return goods to the supplier that were received but found to be defective, damaged, of wrong specification, or in excess. The transaction reverses the stock receipt and adjusts the supplier payable accordingly.

Screen Name: Purchase Return
Module: Local Purchase
Default Location: Axpert
ℹ️
Pre-Requisites Before creating a Purchase Return, ensure the following:
  • The goods were previously received via a Local GRN or Direct Purchase
  • The original Supplier Bill Number is available for reference
  • The Batch Number of the goods to be returned is known (for batch-tracked items)

Navigation Path

Screen Overview

Purchase Return — Entry Screen (Axpert)
Purchase Return Screen

Toolbar Buttons

New
💾 Save
💾 Save and Print
📄 PDF
🔍 Search
List View
View History
Voucher Details
ButtonDescription
NewOpens a blank Purchase Return form for entry
SaveSaves the return, reduces stock, and reverses the supplier payable entry
Save and PrintSaves and opens the print dialog immediately
PDFExports the Purchase Return document as a PDF
SearchSearch for existing Purchase Return records by date, Doc ID, or supplier
List ViewDisplays all Purchase Return records in a tabular list
View HistoryShows the modification history of this record
Voucher DetailsDisplays the reversal accounting journal entries that will be posted on saving

When to Use Purchase Return

  • Goods received in damaged or broken condition
  • Items do not match the ordered specification or description
  • Wrong item delivered against the Purchase Order
  • Excess quantity delivered beyond what was ordered or required
  • Expired items received (for pharma or perishable goods)
  • Packaging defects making the goods unusable

Header Fields

The header section identifies the supplier, the original bill against which the return is being made, and the currency of the transaction.

Header Section — Left Column
Field NameDescription & InstructionsRequired
Location* The store or warehouse from which goods are being returned. Defaults to Axpert. Select a different location if returning from another branch. Yes
Supplier* Select the supplier to whom goods are being returned using the 🔍 search button. On selection, the Bill Number dropdown is filtered to show only bills from this supplier. Yes
Bill Number* The original GRN or Direct Purchase bill number against which the goods were received. Use the 🔍 search button to select from the list of bills for the selected supplier. On selection, the item lines from that bill are available in the Item Particulars grid. Yes
Currency* The currency of the original transaction. Auto-filled from the selected bill. Only Local Currency and Base Currency are allowed. Yes
Header Section — Right Column
Field NameDescription & InstructionsRequired
Date The date of the return transaction. Click the calendar icon to select. Auto-filled with today's date — edit if the physical return was made on a different date. Yes
Doc Id.* A unique system-generated reference number assigned to this Purchase Return on saving. Use the … button to search for and open an existing Purchase Return record. Auto
Exchange Rate (to Base)* The conversion rate from Local Currency to Base Currency. Required only when Base Currency is selected. If Base Currency
Exchange Rate (to Local) The conversion rate from Base Currency to Local Currency. Always displayed and must always be filled before saving. Yes

Form Tabs

  • Item Particulars — Select the items being returned, batch number, and return quantity
  • Free Items — Return any free or bonus items that were originally received at no charge
  • Voucher Details — View the reversal accounting entries that will be posted on saving

Item Particulars — Grid Columns

Each row represents one item line being returned to the supplier. Select the item and batch, then enter the return quantity.

Item Particulars Tab — Column Reference
ColumnDescription & InstructionsRequired
S No Serial number of the row. Auto-incremented. Auto
Item* The item being returned. Click the 🔍 search icon to find and select the item. Only items that were received in the selected bill will be available for return. Yes
Unit* Unit of measure for the item. Auto-filled from the original receipt. Can be changed using the dropdown if required. Auto
Pack Size The pack size of the item as received (e.g., number of units per box or carton). Auto-filled for applicable items. Auto
Batch No.* The batch number of the goods being returned. Select from the dropdown — only batches that were received for this item from this supplier will appear. Ensures the correct batch is reduced from stock on return.

ⓘ Batch No. is mandatory for batch-tracked items. Ensure the correct batch is selected before entering the return quantity.
Yes
Balance Qty. The quantity available for return from the selected batch — i.e., the quantity received in that batch minus any quantities already returned. Auto-filled on batch selection. Read-only. Auto
Return Qty The quantity being returned to the supplier in this transaction. Enter a value equal to or less than the Balance Qty. The system reduces this quantity from the stock of the selected batch.

⚠ Cannot exceed Balance Qty. Cannot be changed after saving.
Yes
Balance Free Qty The free or bonus quantity available for return from the selected batch. Auto-filled. Read-only. Auto
Free Qty The free or bonus quantity being returned in this transaction. Enter if returning free goods received earlier. Optional
Supplier Batch No. The supplier's own batch reference number — as printed on the supplier's invoice or packaging. Used for cross-referencing with the supplier's records during return. Optional
Stock Current stock on hand for this item at the selected location. Displayed for reference to confirm stock availability before processing return. Auto
Rate* The rate at which the goods were originally purchased. Auto-filled from the original GRN or Direct Purchase bill. The return is valued at this rate. Auto

Footer Summary Fields

Footer Section
FieldDescription
Total Gross Amount Total value of all goods being returned before tax. Auto-calculated as Return Qty × Rate across all lines. Read-only.
Tax Amount Total tax amount being reversed on the returned goods. Auto-calculated. Read-only.
Net Amount Final amount to be credited or debited from the supplier payable account — Gross Amount plus Tax Amount. Read-only.
Notes Free-text field for the reason for return and any other relevant remarks (e.g., "Damaged goods", "Wrong item delivered", "Expired batch").

Step-by-Step: Creating a Purchase Return

1
Open a New Form

Click New in the toolbar. A blank Purchase Return form opens with Location pre-filled as Axpert.

2
Select the Supplier

Click the 🔍 search button next to Supplier. Select the supplier to whom goods are being returned.

3
Select the Bill Number

Click the 🔍 search button next to Bill Number. Select the original GRN or Direct Purchase bill against which the goods were received. Currency and exchange rates auto-fill from the bill.

4
Set the Date and Exchange Rate

Confirm the Date of the return. Fill Exchange Rate (to Local) — always required. Fill Exchange Rate (to Base) if Base Currency is selected.

5
Select the Item

In the Item Particulars grid, click the 🔍 search icon on the Item column and select the material being returned.

6
Select the Batch Number

Select the Batch No. from the dropdown. The Balance Qty and Rate are auto-filled from the original receipt for that batch.

7
Enter Return Qty

Enter the quantity to be returned in the Return Qty field. Must be ≤ Balance Qty. Enter Supplier Batch No. if available for the supplier's reference.

8
Add More Rows if Needed

Press Enter or Tab to add a new row. Repeat steps 5–7 to return multiple items or multiple batches of the same item.

9
Enter Notes

Fill the Notes field in the footer with the reason for return. This is important for audit trail and supplier communication.

10
Save

Click Save. The system assigns a Doc Id, reduces stock for the returned batch, and reverses the supplier payable accounting entries automatically.

⚠️
Return Qty Cannot Exceed Balance Qty The system will not allow saving if Return Qty is greater than the Balance Qty for the selected batch. Always check the Balance Qty before entering the return quantity.
🚫
Correct Batch Selection Is Critical Always select the exact batch from which the goods were received. Selecting the wrong batch will result in incorrect stock adjustment and incorrect reversal of accounting entries.
💡
Partial Return Allowed You do not need to return the full received quantity. Enter only the quantity being physically returned. The remaining balance stays in stock and can be returned in a separate transaction later if required.
ℹ️
Voucher Details On saving a Purchase Return, the system automatically posts the following reversal accounting entries:
  • Dr Supplier Payable A/c    Cr Stock / Inventory A/c
  • Dr Supplier Payable A/c    Cr Input Tax A/c
Local Purchase Module — Report

Local Purchase Register

The Local Purchase Register provides a complete listing of all local purchase transactions — Direct Purchases and GRNs — within a selected period. It is the primary reference for accounts payable, supplier reconciliation, and purchase analysis.

Report Name: Local Purchase Register
Module: Local Purchase
Type: Report / Register

Navigation Path

Step 1 — Parameters Screen

When the report is opened, a Parameters dialog appears. Set the required filters and click OK to generate the report. All parameters default to ALL — narrow them down for a more focused report.

Local Purchase Register — Parameters Dialog
Parameters Screen
Parameters — Filter Fields
ParameterDescription & InstructionsDefault
Company Filter by a specific company or select ALL to include transactions across all companies. Select from the dropdown. ALL
Branch Filter by a specific branch or select ALL to include all branches. Select from the dropdown. ALL
Location Filter by a specific store or warehouse location, or select ALL to include all locations. Select from the dropdown. ALL
Vendor Name Filter by a specific supplier or leave as ALL to include all suppliers. Use the 🔍 search button to find and select a specific vendor. ALL
Currency Filter by a specific currency (Local or Base) or select ALL to include transactions in all currencies. Select from the dropdown. ALL
Type Filter by transaction type — Direct Purchase, GRN, or ALL. Select from the dropdown to show only the type of purchase required. ALL
Item Name Filter by a specific item or leave as ALL to include all items. Use the 🔍 search button to find and select a specific item. ALL
From Date The start date of the report period. Click the calendar icon to select. Only transactions on or after this date will be included. 1 year ago
To Date The end date of the report period. Click the calendar icon to select. Only transactions on or before this date will be included. Today
💡
Click OK to Generate After setting the parameters, click OK to run the report. To cancel without running, click the X button on the Parameters dialog.

Step 2 — Report Output

After clicking OK, the Local Purchase Register is displayed. Records are grouped by Transaction Number — each group shows all items in that transaction, followed by a Total row in red showing the cumulative Qty, Rate, and Amount for that transaction.

Local Purchase Register — Report Output
Local Purchase Register Report

Report Toolbar

🖨 Print
📄 Preview
Page Setup
📋 View
🔍 Find
Tasks
ButtonDescription
PrintSends the report directly to the printer
PreviewShows a print preview of the report before printing
Page SetupConfigure paper size, orientation, and margins for printing
ViewRefreshes or toggles the report display
FindSearch for a specific value within the report (e.g., supplier name, item, transaction number)
TasksAdditional options such as export to Excel or email the report

Report Columns

The report displays one row per item line per transaction. Transactions are grouped by Transaction Number with a Total row at the end of each group showing cumulative values in red/bold.

Report Columns — Column Reference
ColumnDescription
Type The type of purchase transaction — Direct Purchase or GRN. Identifies how the goods were received into the system.
Location Name The store or warehouse where goods were received. Useful when the report is run for ALL locations.
Supplier Name The name of the supplier from whom the goods were purchased.
Transaction Number The system-generated document reference number (e.g., 261001LDP000012). Records are grouped by this number. Clicking the Transaction Number hyperlink opens the original transaction directly.
Transaction Date The date of the purchase transaction (Doc Date or GRN Date).
Supplier Bill No The supplier's invoice number as entered in the transaction (Supplier Inv. No).
Supplier Bill Date The date on the supplier's invoice as entered in the transaction (Supplier Inv. Date).
Purchase Currency The currency in which the transaction was recorded (e.g., USD, CDF).
Item Name The item code and description of the material purchased (e.g., PM000013-FLACON 60 CC AMBER BOTTEL).
Unit The unit of measure for the item (e.g., PCS, KG, PLQ).
Qty The quantity purchased in this transaction line. The Total row shows the cumulative quantity for the transaction group.
Rate (Base) The purchase rate per unit expressed in base currency.
Amount (Base) The total value of this line in base currency (Qty × Rate). The Total row shows the cumulative amount for the transaction group.
Tax Amount (Base) The tax amount for this line expressed in base currency.
Net Amount (Base) The net payable amount for this line in base currency — Amount plus Tax Amount. The Total row shows the cumulative net amount for the transaction group.
ℹ️
Grouping and Totals Records are grouped by Transaction Number. Each group ends with a Total row (shown in red/bold) displaying the cumulative Qty, Rate, Amount and Net Amount for that transaction. This makes it easy to reconcile against supplier invoices.
💡
Drill Down to Original Transaction Click any Transaction Number shown as a blue hyperlink in the report to open the original Direct Purchase or GRN transaction directly for review or verification.
💡
Filter by Type for Specific Reports Use the Type parameter to run separate reports — select Direct Purchase to see only cash/direct purchases, or GRN to see only PO-based receipts.

How to Run the Report

1
Open the Report

Navigate to Local Purchase → Reports → Local Purchase Register. The Parameters dialog opens automatically.

2
Set Parameters

Set Company, Branch, Location, Vendor Name, Currency, Type, and Item Name as required. Set From Date and To Date to define the reporting period. Leave all as ALL for a complete report.

3
Click OK

Click OK. The report is generated and displayed showing all matching transactions grouped by Transaction Number.

4
Review, Find, or Print

Use Find to search for specific values. Click any Transaction Number to drill down to the original entry. Use Print or Tasks to export or print the report.

Local Purchase Module — Report

Purchase Order Register

The Purchase Order Register (Local PO) provides a summary of all Purchase Orders raised within a selected period, showing PO quantities, GRN quantities received, Short Close quantities, and the balance yet to be received. It is used to track open PO commitments and delivery status.

Report Name: Local PO
Module: Local Purchase
Type: Report / Register

Navigation Path

Step 1 — Parameters Screen

When the report is opened, a Parameters dialog appears. Set the required filters and click OK to generate the report.

PO Register — Parameters Dialog
PO Register Parameters Screen
Parameters — Filter Fields
ParameterDescription & InstructionsDefault
Locationname Filter by a specific store or warehouse location, or select ALL to include all locations. Select from the dropdown. ALL
Vendor Filter by a specific supplier or select ALL to include all vendors. Select from the dropdown. ALL
Item Filter by a specific item or leave as ALL to include all items. Use the 🔍 search button to find and select a specific item. ALL
Fromdate The start date of the report period. Click the calendar icon to select. Only POs with a date on or after this date will be included. 1 year ago
Todate The end date of the report period. Click the calendar icon to select. Only POs with a date on or before this date will be included. Today
💡
Click OK to Generate After setting the parameters, click OK to run the report. To cancel without running, click the X button on the Parameters dialog.

Step 2 — Report Output

After clicking OK, the Local PO report is displayed. The report header shows the applied filter criteria — Location, Vendor, Item, and Period. Records are grouped by PO No, with PO Date and Vendor shown in the group header row.

Local PO — Report Output
PO Register Report

Report Toolbar

📄 Parameters
📋 View
ButtonDescription
ParametersRe-opens the Parameters dialog to change filters and regenerate the report without closing and reopening
ViewRefreshes or toggles the report display

Report Structure

The report is organised in two levels:

  • Group header row — Shows PO No, PO Date, and Vendor for each Purchase Order group
  • Detail rows — Shows one row per item line within the PO, with all quantity and value details

Report Columns

Report Columns — Column Reference
ColumnDescription
PO No The system-generated Purchase Order number. Shown in the group header row along with PO Date and Vendor. All item lines below belong to this PO.
PO Date The date on which the Purchase Order was raised. Shown in the group header row.
Vendor The supplier to whom the Purchase Order was issued. Shown in the group header row.
Itemname The name of the material item ordered in this PO line.
Locationname The store or warehouse location associated with this PO line.
PO Qty The total quantity ordered in the Purchase Order for this item line.
GRN Qty The quantity already received via GRN against this PO line. Helps identify how much has been delivered so far.
SC Qty The quantity that has been short-closed via PO Short Close for this line. Quantity that will not be delivered.
Balance Qty The remaining quantity yet to be received — calculated as PO Qty − GRN Qty − SC Qty. A Balance Qty of 0 means the PO line is fully fulfilled or closed.
Purchase Unit The unit of measure for the ordered item (e.g., PCS, KG, LTR).
Rate The agreed purchase rate per unit as specified in the Purchase Order.
Currency The currency in which the Purchase Order was raised (Local or Base Currency).
Amount The total value of this PO line — calculated as PO Qty × Rate in the PO currency.
ℹ️
Balance Qty = PO Qty − GRN Qty − SC Qty The Balance Qty column is the key field for tracking open PO commitments. Use this report regularly to identify POs with pending deliveries and follow up with suppliers accordingly.
💡
Re-run with Different Filters Use the Parameters button in the toolbar to change filters and regenerate the report instantly — without closing and reopening the report screen.

How to Run the Report

1
Open the Report

Navigate to Local Purchase → Reports → PO Register. The Parameters dialog opens automatically.

2
Set Parameters

Select Locationname, Vendor, and Item as required. Set Fromdate and Todate to define the reporting period. Leave all as ALL for a complete report.

3
Click OK

Click OK. The report is generated showing all POs matching the selected filters, grouped by PO No.

4
Review or Re-filter

Review the Balance Qty column to identify open PO commitments. Click Parameters in the toolbar to change filters and re-run without closing the screen.

Local Purchase Module — Report

Purchase Request Register

The Purchase Request Register (also called the Indent Register) provides a complete listing of all Purchase Requests raised within a selected period and location. It is used to track the status and details of all material requisitions.

Report Name: Purchase Request Details
Module: Local Purchase
Type: Report / Register

Navigation Path

Step 1 — Parameters Screen

When the report is opened, a Parameters dialog appears before the report is generated. Set the filters here and click OK to run the report.

Purchase Request Register — Parameters Dialog
Parameters Screen
Parameters — Filter Fields
ParameterDescription & InstructionsDefault
Locationname Filter the report by a specific location or select ALL to include Purchase Requests from all locations. Select from the dropdown. ALL
Fromdate The start date of the report period. Click the calendar icon to select. Only Purchase Requests raised on or after this date will be included. 1 year ago
Todate The end date of the report period. Click the calendar icon to select. Only Purchase Requests raised on or before this date will be included. Today
💡
Click OK to Generate After setting the parameters, click the OK button to generate the report. To cancel without running the report, click the X button on the Parameters dialog.

Step 2 — Report Output

After clicking OK, the report is displayed showing all Purchase Requests matching the selected parameters. The report title shows the applied filters — Location, Item, and Period — for confirmation.

Purchase Request Details — Report Output
Purchase Request Register Report

Report Toolbar

📋 View
📄 Preview
Page Setup
🖨 Print
🔍 Find
Tasks
ButtonDescription
ViewRefreshes or toggles the report display
PreviewShows a print preview of the report before printing
Page SetupConfigure paper size, orientation, and margins for printing
PrintSends the report to the printer
FindSearch for a specific value within the report (e.g., item name, PR number)
TasksAdditional options such as export to Excel or email the report

Report Columns

The report displays one row per item line per Purchase Request. The report header shows the applied filter criteria — Location, Item, and Period.

Report Columns — Column Reference
ColumnDescription
Locationname The branch or location where the Purchase Request was raised. Useful when the report is run for ALL locations to identify which location raised each request.
PR No The unique Purchase Request reference number assigned by the system when the PR was saved.
PR Date The date on which the Purchase Request was raised.
Itemname The name of the material item requested in the Purchase Request line.
Request Qty The quantity of the item requested in the Purchase Request.
Unit The unit of measure for the requested item (e.g., PCS, KG, LTR).
ℹ️
One Row Per Item Line If a single Purchase Request contains multiple items, each item appears as a separate row in the report. All rows for the same PR will share the same PR No and PR Date.
💡
Using Find for Quick Lookup Use the Find button in the toolbar to quickly locate a specific item, PR number, or location within the report without scrolling through all records.

How to Run the Report

1
Open the Report

Navigate to Local Purchase → Reports → Purchase Request Register. The Parameters dialog opens automatically.

2
Set Parameters

Select the Locationname (or leave as ALL). Set the Fromdate and Todate to define the reporting period.

3
Click OK

Click the OK button. The report is generated and displayed showing all Purchase Requests matching the selected filters.

4
Review or Print

Use Find to search within the report. Use Preview to check layout before printing. Click Print to print or use Tasks to export.

Local Purchase Module — Reports

Purchase Reports

The Purchase Reports screen provides analytical reports on purchase transactions. Apply filters once and generate two different views — Itemwise Purchase and Supplierwise Purchase — along with a Supplier List. All reports use the same set of filter parameters.

Screen Name: Purchase Reports
Module: Local Purchase
Type: Analytical Reports

Navigation Path

Screen Overview

Purchase Reports — Filter & Report Selection Screen
Purchase Reports Screen

Filter Parameters

Set the required filters before clicking any report button. All filters default to ALL. Fields marked with * are mandatory.

Filter Fields
FieldDescription & InstructionsRequired
From Date* The start date of the report period. Click the calendar icon to select. Only transactions on or after this date will be included in the report. Yes
To Date* The end date of the report period. Click the calendar icon to select. Only transactions on or before this date will be included. Yes
Transaction Type* Filter by the type of purchase transaction. Select from the dropdown — e.g., Direct Purchase, GRN, or ALL for both. Yes
Branch Filter by a specific branch or select ALL to include all branches. Select from the dropdown. ALL
Location Filter by a specific store or warehouse location, or select ALL to include all locations. Select from the dropdown. ALL
Supplier Category* Filter by a supplier category (e.g., Local, Import) or select ALL. Select from the dropdown. Yes
Supplier* Filter by a specific supplier or select ALL to include all suppliers. Select from the dropdown. Yes
Item Group Filter by a specific item group or select ALL to include all item groups. Select from the dropdown. ALL
Item Filter by a specific item or select ALL to include all items. Select from the dropdown. ALL

Report Buttons

After setting the filters, click one of the three buttons to generate the required report. Each button produces a different view of the same filtered data.

Available Reports
ButtonReport Generated
Supplier List Generates a list of all suppliers who have transactions within the selected filter criteria. Useful for reviewing which suppliers were active during the selected period.
Itemwise Purchase Generates a report showing purchase totals grouped by item. Displays the quantity and value of each item purchased across all selected suppliers and locations within the period. Useful for analysing which materials were purchased most.
Supplierwise Purchase Generates a report showing purchase totals grouped by supplier. Displays the total quantity and value purchased from each supplier within the period. Useful for supplier spend analysis and performance review.
ℹ️
Same Filters, Three Views All three report buttons — Supplier List, Itemwise Purchase, and Supplierwise Purchase — use the same set of filter parameters. Set the filters once, then click the desired button to switch between report views without re-entering the filters.
💡
Use Transaction Type to Separate Reports Set Transaction Type to Direct Purchase or GRN to analyse each transaction type separately. This is useful when comparing PO-based purchases against cash/direct purchases for the same period.

How to Generate a Report

1
Open the Screen

Navigate to Local Purchase → Reports → Purchase Reports. The filter screen opens directly — no separate Parameters dialog.

2
Set From Date and To Date

Click the calendar icons to set the report period. These are mandatory fields.

3
Set Transaction Type

Select the transaction type — ALL, Direct Purchase, or GRN. This is a mandatory field.

4
Apply Additional Filters (Optional)

Set Branch, Location, Supplier Category, Supplier, Item Group, and Item as required to narrow the report scope.

5
Click a Report Button

Click Supplier List, Itemwise Purchase, or Supplierwise Purchase to generate the required report. The report opens in a new window or panel.