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.
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.
| # | Transaction | Purpose |
|---|---|---|
| 01 | Purchase Request | Raise an internal requisition for materials |
| 02 | Request Short Close | Close a partially fulfilled or cancelled purchase request |
| 03 | Local Purchase Order | Issue a formal purchase order to a supplier |
| 04 | PO Short Close | Close a partially fulfilled purchase order |
| 05 | Local GRN | Record goods received and process supplier invoice |
| 06 | Direct Purchase | Record cash purchases made without a purchase order |
| 07 | Purchase Return | Return defective or incorrect goods to supplier |
| 08 | Purchase Register | View and print all purchase transactions |
| 09 | Indent Register | Track 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.
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.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Clears the form and opens a blank Purchase Request for entry |
| Save | Saves the current record to the database without printing |
| Save and Print | Saves the record and immediately opens the print dialog |
| Exports the Purchase Request as a PDF file for sharing or archiving | |
| Search | Opens a search dialog to find existing Purchase Requests by date, number, or item |
| List View | Displays all Purchase Requests in a tabular list for quick browsing |
| View History | Shows 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.
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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.
| Column | Description & Instructions | Required |
|---|---|---|
| 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
| Field | Description |
|---|---|
| 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
Click the New button in the toolbar. A blank Purchase Request form opens with Location pre-filled as Axpert.
Confirm or change the Location. Set the Requisition Date using the calendar. Leave Requisition No. blank — it is assigned on save.
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.
Press Enter or Tab at the end of a row to move to the next row automatically. Repeat for all items needed.
Click the Attachment tab and upload any relevant files before saving.
Fill the Notes field in the footer with any overall instructions or context for the Purchase team.
Click Save to save the record. The system assigns a Requisition No. automatically. Click Save and Print if a printed copy is required immediately.
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.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Clears the form and opens a blank Request Short Close for entry |
| Save | Saves the short close record permanently — closes the selected quantities |
| Save and Print | Saves the record and opens the print dialog immediately |
| Exports the short close document as a PDF file | |
| Search | Search for existing Short Close records by date, Doc ID, or PR number |
| List View | Displays all Request Short Close records in a list |
| View History | Shows 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.
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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.
| Column | Description & Instructions | Required |
|---|---|---|
| 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
| Field | Description |
|---|---|
| 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
Click the New button in the toolbar. A blank Request Short Close form opens with Location pre-filled as Axpert.
Confirm the Location and set the Doc Date using the calendar. Leave Doc ID. blank — it is assigned on save.
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.
Click the Item Name dropdown and select the material to be short-closed. The Unit and Balance Qty fill automatically.
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.
Press Enter or Tab to add a new row. Repeat steps 3–5 to short-close items from other PRs in the same document.
Fill the Notes field in the footer with the reason for short close. Important for audit and reporting.
Click Save. The system assigns a Doc ID and permanently closes the specified quantities. The PR balance is updated immediately.
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.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Local Purchase Order form for entry |
| Save | Saves the PO record to the database |
| Save and Print | Saves the PO and immediately opens the print dialog |
| Exports the Purchase Order as a PDF for sending to the supplier | |
| Search | Search for existing POs by date, PO number, or supplier |
| List View | Displays all Purchase Orders in a tabular list |
| View History | Shows 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.
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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 |
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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.
| Column | Description & Instructions | Required |
|---|---|---|
| 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.
| Field | Description |
|---|---|
| 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
Click New in the toolbar. A blank PO form opens with Location pre-filled as Axpert.
Click the 🔍 search button next to Supplier and select the supplier. Contact Email auto-fills from the supplier master.
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.
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.
Click the 🔍 search icon on the Item column and select the material. Unit auto-fills. Current Stock is displayed for reference.
Enter the quantity to be ordered and the agreed Rate per unit. Select Discount Type and enter a discount value if applicable.
Press Enter or Tab to add new rows. Repeat steps 4–6 for each material line.
Verify the Total Gross Amount, Total Discount, Tax Amount, and Net Amount in the footer before saving.
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.
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.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank PO Short Close form for entry |
| Save | Saves the short close record and permanently closes the specified quantities |
| Search | Search for existing PO Short Close records by date, Doc ID, supplier, or PO number |
| List View | Displays all PO Short Close records in a tabular list |
| View History | Shows 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.
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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.
- Select the Location, Supplier, and PO No in the header
- Right-click anywhere inside the Item Particulars grid
- From the context menu, hover over FillGrid
- Click Fill PO Details from the submenu
- All item lines from the selected PO are loaded automatically with Item, Unit, and Balance Qty filled
| Column | Description & Instructions | Required |
|---|---|---|
| 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
| Field | Description |
|---|---|
| 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
Click New in the toolbar. A blank PO Short Close form opens with Location pre-filled as Axpert.
Choose the supplier from the Supplier dropdown. Only suppliers with open POs will appear in the list.
Choose the Purchase Order from the PO No dropdown. The item lines from that PO are loaded automatically into the Item Particulars grid.
Confirm or select the Date of the short close using the calendar. Leave Doc Id. blank — it is assigned on save.
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.
Check the Balance Qty for each item line. This is the remaining undelivered quantity. Verify it matches your expectation before entering the 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.
Fill the Notes field in the footer with the reason for short close. This is important for audit and reporting purposes.
Click Save. The system assigns a Doc Id and permanently closes the specified quantities. The PO balance is updated immediately.
- 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
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.
- 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
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Local GRN form for entry |
| Save | Saves the GRN, updates stock, and posts the supplier payable entry |
| Save and Print | Saves the GRN and opens the print dialog immediately |
| Exports the GRN document as a PDF | |
| Search | Search for existing GRNs by date, GRN number, PO number, or supplier |
| List View | Displays all GRN records in a tabular list |
| View History | Shows the modification history of this GRN record |
| Voucher Details | Displays 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.
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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 |
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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.
| Column | Description & Instructions | Required |
|---|---|---|
| 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
| Field | Description |
|---|---|
| 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
Click New in the toolbar. A blank GRN form opens with GRN Location pre-filled as Axpert.
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.
Select the GRN Date — the actual date goods were physically received at the store.
Enter the Supplier. Inv. No and Supplier Inv. Date exactly as printed on the physical invoice received from the supplier.
If the items need batch and expiry date tracking (e.g., pharma products), check the Location Batch Flag checkbox before entering item quantities.
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.
Check that the Rate, Taxcode, and Tax % match the supplier's invoice. Edit the Rate if the invoiced rate differs from the PO rate.
Verify Gross Amount, Tax Amount, and Net Amount in the footer match the supplier invoice total before saving.
Click Voucher Details in the toolbar to preview the accounting journal entries that will be posted on saving.
Click Save. The system assigns a GRN No, updates the stock quantity, and posts the supplier payable accounting entry automatically.
- Dr Stock / Inventory A/c Cr Supplier Payable A/c
- Dr Input Tax A/c Cr Supplier Payable A/c
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.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Direct Purchase form for entry |
| Save | Saves the record, updates stock, and posts the supplier payable entry |
| Save and Print | Saves and immediately opens the print dialog |
| Exports the Direct Purchase document as a PDF | |
| Search | Search for existing Direct Purchase records by date, Doc No, or supplier |
| List View | Displays all Direct Purchase records in a tabular list |
| View History | Shows the modification history of this record |
| Voucher Details | Displays 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.
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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 |
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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.
| Column | Description & Instructions | Required |
|---|---|---|
| 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
| Field | Description |
|---|---|
| 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
Click New in the toolbar. A blank Direct Purchase form opens with Location pre-filled as Axpert.
Click the 🔍 search button next to Supplier and select the supplier from the search popup.
Select the Currency. Enter Exchange Rate (to Base) if Base Currency is selected. Always fill Exchange Rate (to Local).
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.
Check the Location Batch Flag if items require batch and expiry date tracking.
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.
Press Enter or Tab to move to the next row. Repeat step 6 for each item on the invoice.
Click the Free Item Details tab to enter any bonus or free items received separately.
Verify Gross Amount, Tax Amount, and Net Amount match the supplier invoice total.
Click Save. The system assigns a Doc No, updates stock, and posts the accounting entries automatically.
- Dr Stock / Inventory A/c Cr Supplier Payable A/c
- Dr Input Tax A/c Cr Supplier Payable A/c
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.
- 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
Toolbar Buttons
| Button | Description |
|---|---|
| New | Opens a blank Purchase Return form for entry |
| Save | Saves the return, reduces stock, and reverses the supplier payable entry |
| Save and Print | Saves and opens the print dialog immediately |
| Exports the Purchase Return document as a PDF | |
| Search | Search for existing Purchase Return records by date, Doc ID, or supplier |
| List View | Displays all Purchase Return records in a tabular list |
| View History | Shows the modification history of this record |
| Voucher Details | Displays 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.
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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 |
| Field Name | Description & Instructions | Required |
|---|---|---|
| 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.
| Column | Description & Instructions | Required |
|---|---|---|
| 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
| Field | Description |
|---|---|
| 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
Click New in the toolbar. A blank Purchase Return form opens with Location pre-filled as Axpert.
Click the 🔍 search button next to Supplier. Select the supplier to whom goods are being returned.
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.
Confirm the Date of the return. Fill Exchange Rate (to Local) — always required. Fill Exchange Rate (to Base) if Base Currency is selected.
In the Item Particulars grid, click the 🔍 search icon on the Item column and select the material being returned.
Select the Batch No. from the dropdown. The Balance Qty and Rate are auto-filled from the original receipt for that batch.
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.
Press Enter or Tab to add a new row. Repeat steps 5–7 to return multiple items or multiple batches of the same item.
Fill the Notes field in the footer with the reason for return. This is important for audit trail and supplier communication.
Click Save. The system assigns a Doc Id, reduces stock for the returned batch, and reverses the supplier payable accounting entries automatically.
- Dr Supplier Payable A/c Cr Stock / Inventory A/c
- Dr Supplier Payable A/c Cr Input Tax A/c
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.
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.
| Parameter | Description & Instructions | Default |
|---|---|---|
| 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 |
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.
Report Toolbar
| Button | Description |
|---|---|
| Sends the report directly to the printer | |
| Preview | Shows a print preview of the report before printing |
| Page Setup | Configure paper size, orientation, and margins for printing |
| View | Refreshes or toggles the report display |
| Find | Search for a specific value within the report (e.g., supplier name, item, transaction number) |
| Tasks | Additional 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.
| Column | Description |
|---|---|
| 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. |
How to Run the Report
Navigate to Local Purchase → Reports → Local Purchase Register. The Parameters dialog opens automatically.
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.
Click OK. The report is generated and displayed showing all matching transactions grouped by Transaction Number.
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.
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.
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.
| Parameter | Description & Instructions | Default |
|---|---|---|
| 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 |
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.
Report Toolbar
| Button | Description |
|---|---|
| Parameters | Re-opens the Parameters dialog to change filters and regenerate the report without closing and reopening |
| View | Refreshes 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
| Column | Description |
|---|---|
| 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. |
How to Run the Report
Navigate to Local Purchase → Reports → PO Register. The Parameters dialog opens automatically.
Select Locationname, Vendor, and Item as required. Set Fromdate and Todate to define the reporting period. Leave all as ALL for a complete report.
Click OK. The report is generated showing all POs matching the selected filters, grouped by PO No.
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.
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.
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.
| Parameter | Description & Instructions | Default |
|---|---|---|
| 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 |
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.
Report Toolbar
| Button | Description |
|---|---|
| View | Refreshes or toggles the report display |
| Preview | Shows a print preview of the report before printing |
| Page Setup | Configure paper size, orientation, and margins for printing |
| Sends the report to the printer | |
| Find | Search for a specific value within the report (e.g., item name, PR number) |
| Tasks | Additional 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.
| Column | Description |
|---|---|
| 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). |
How to Run the Report
Navigate to Local Purchase → Reports → Purchase Request Register. The Parameters dialog opens automatically.
Select the Locationname (or leave as ALL). Set the Fromdate and Todate to define the reporting period.
Click the OK button. The report is generated and displayed showing all Purchase Requests matching the selected filters.
Use Find to search within the report. Use Preview to check layout before printing. Click Print to print or use Tasks to export.
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.
Navigation Path
Screen Overview
Filter Parameters
Set the required filters before clicking any report button. All filters default to ALL. Fields marked with * are mandatory.
| Field | Description & Instructions | Required |
|---|---|---|
| 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.
| Button | Report 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. |
How to Generate a Report
Navigate to Local Purchase → Reports → Purchase Reports. The filter screen opens directly — no separate Parameters dialog.
Click the calendar icons to set the report period. These are mandatory fields.
Select the transaction type — ALL, Direct Purchase, or GRN. This is a mandatory field.
Set Branch, Location, Supplier Category, Supplier, Item Group, and Item as required to narrow the report scope.
Click Supplier List, Itemwise Purchase, or Supplierwise Purchase to generate the required report. The report opens in a new window or panel.