Inventory Module
User Help Manual — Item Masters · Transfers · Stock Management
Masters
Unit of Measurement
Define units like PCS, KG, LTR.
Category
Item category with inventory ledger.
Item Group
Group items for reporting.
Item Sub Group
Sub-classification within a group.
Item Brand
Register item brands.
Loyalty Category
Loyalty point earning categories.
Taxes
Tax codes with input/output ledgers.
Item Master
Full item setup with batch, units, barcodes.
Reason Master
Reasons for stock movements.
HS Code
Tariff codes with duty percentages.
Transactions
Item Transfer Request
Request stock from another location.
Transfer Booking
Book a transfer between locations.
Transfer Expense
Record transfer-related costs.
Item Transfer Issue
Issue stock out for transfer.
Item Transfer Receipt
Receive transferred stock.
Direct Stock Transfer
Transfer stock without request/booking.
Stock Receipt
Receive stock from non-purchase sources.
Stock Issue
Issue stock for consumption or write-off.
Item Fabrication
Convert raw materials to finished goods.
Reports
Unit of Measurement
Unit of Measurement defines all units used for stocking, selling, and purchasing items — such as PCS, KG, LTR, BOX, etc. Every item in the Item Master must be assigned a Stock Unit and Sale Unit from this master.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves the record |
| 🔍 Search | Search for existing records |
| List View | Displays all records in a list |
| View History | Shows modification history |
| Field | Description | Required |
|---|---|---|
| Unit Name* | Full name of the unit (e.g., Pieces, Kilograms, Litres, Box). This appears in item and transaction screens. | Yes |
| Unit Code* | Short code for the unit (e.g., PCS, KG, LTR, BOX). Used in grids and reports. | Yes |
| Inactive | Check to deactivate this unit without deleting it. | Optional |
Step-by-Step Guide
Open a blank Unit of Measurement form.
Type the full unit name (e.g., Pieces).
Type the short code (e.g., PCS).
Click Save. The unit is now available in the Item Master and all transaction grids.
Category
Item Category is the top-level classification of items. Each category has its own Inventory Ledger — meaning items in different categories post stock values to different GL accounts. The category also controls the item number prefix and whether the category is applicable for sales.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves the record |
| 🔍 Search | Search for existing records |
| List View | Displays all records in a list |
| View History | Shows modification history |
| Field | Description | Required |
|---|---|---|
| Category Name* | The full name of the item category (e.g., Pharmaceutical, FMCG, Cosmetics, Medical Devices). | Yes |
| Item Code Prefix* | A short prefix used to auto-generate item numbers for items in this category (e.g., PH for Pharmaceutical). All item codes in this category will start with this prefix. | Yes |
| Inventory Ledger* | The GL account to which the inventory value of items in this category is posted. Click 🔍 to select from the chart of accounts. This is mandatory for stock accounting. | Yes |
| Sales Applicable?* | Check if items in this category can be sold. Uncheck for internal-use-only items. | Optional |
| Inactive? | Check to deactivate this category. | Optional |
Step-by-Step Guide
Open a blank Category form.
Type a meaningful category name.
Enter a short 2-4 character prefix for auto-generated item codes.
Click 🔍 and select the GL account for inventory posting for this category.
Check if items of this category can be sold in sales transactions.
Click Save. The category is now available in the Item Master.
Item Group
Item Group provides a secondary classification of items within a category — for example, Antibiotics, Analgesics, and Vitamins within a Pharmaceutical category. Item Groups are used for sales reporting, filtering, and performance analysis.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves the record |
| 🔍 Search | Search for existing records |
| List View | Displays all records in a list |
| View History | Shows modification history |
| Field | Description | Required |
|---|---|---|
| Group Name* | The name of the item group (e.g., Antibiotics, FMCG-Food, Cosmetics-Skin). | Yes |
| Group Code* | A short code for the group (e.g., ANT, FCG, CSK). | Yes |
| Inactive? | Check to deactivate this group. | Optional |
Step-by-Step Guide
Open a blank Item Group form.
Type the group name and its short code.
Click Save. The group is available in the Item Master Group field.
Item Sub Group
Item Sub Group is a third-level classification beneath Item Group, allowing even finer categorisation of items. For example, within Antibiotics (Group), sub-groups could be Oral Antibiotics and Injectable Antibiotics.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves the record |
| 🔍 Search | Search for existing records |
| List View | Displays all records in a list |
| View History | Shows modification history |
| Field | Description | Required |
|---|---|---|
| Sub Group Name* | The name of the sub group (e.g., Oral Antibiotics, Injectable, Tablet Form). | Yes |
| Sub Group Code* | A short code for the sub group. | Yes |
| Inactive? | Check to deactivate. | Optional |
Step-by-Step Guide
Open a blank Item Sub Group form.
Type the sub group name and code.
Click Save. Available in the Item Master Subgroup field.
Item Brand
Item Brand records the brand or manufacturer of each item. Brand is a mandatory field in the Item Master. Brands are used for brand-wise sales and stock analysis reports.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves the record |
| 🔍 Search | Search for existing records |
| List View | Displays all records in a list |
| View History | Shows modification history |
| Field | Description | Required |
|---|---|---|
| Brand Name* | The full brand or manufacturer name (e.g., GlaxoSmithKline, Pfizer, Unilever, Private Label). | Yes |
| Brand Code* | A short code for the brand. | Yes |
| Inactive? | Check to deactivate. | Optional |
Step-by-Step Guide
Open a blank Item Brand form.
Type the brand name and short code.
Click Save. The brand is now available in the Item Master Brand field.
Loyalty Category
Loyalty Category defines the categories of customers eligible for loyalty points. Each loyalty category has a different earning rate configured in the Loyalty Card master. The Loyalty Category is assigned to each item in the Item Master, controlling which loyalty earning rules apply when that item is sold.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves the record |
| 🔍 Search | Search for existing records |
| List View | Displays all records in a list |
| View History | Shows modification history |
| Field | Description | Required |
|---|---|---|
| Loyalty Category* | The name of the loyalty category (e.g., Gold, Silver, Standard, Non-Loyalty). This name is used when setting up point earning rules in the Loyalty Card master. | Yes |
Step-by-Step Guide
Open a blank Loyalty Category form.
Type the category name.
Click Save. The category is now available in the Item Master and the Loyalty Card master setup.
Taxes
The Taxes master defines all tax codes used in purchase and sales transactions. Each tax code has a percentage rate and separate GL accounts for input tax (on purchases) and output tax (on sales). Tax codes are applied to items via the Item Master and used in invoice calculations.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves the record |
| 🔍 Search | Search for existing records |
| List View | Displays all records in a list |
| View History | Shows modification history |
| Field | Description | Required |
|---|---|---|
| Tax Code* | Unique code for this tax (e.g., VAT16, ZERO, EXEMPT). This code appears in item master and transaction dropdowns. | Yes |
| Tax % | The tax percentage rate (e.g., 16 for 16% VAT, 0 for zero-rated, blank for exempt). e.g., enter 16 for 16% VAT | Optional |
| Tax Ledger (Input) | GL account for input tax on purchases — used when this tax applies to a purchase invoice or GRN. Click 🔍 to select. | Optional |
| Tax Ledger (Output) | GL account for output tax on sales — used when this tax applies to a sales invoice. Click 🔍 to select. | Optional |
| Inactive?* | Check to deactivate this tax code. | Optional |
Step-by-Step Guide
Open a blank Taxes form.
Enter a unique, meaningful code (e.g., VAT16, ZERO, EXEMPT).
Enter the tax rate percentage. Leave blank for exempt items.
Click 🔍 and select the input tax GL account for purchases.
Click 🔍 and select the output tax GL account for sales.
Click Save. The tax code is now available in the Item Master Tax Code field.
Item Master
The Item Master is the central repository for all product information. Every item sold, purchased, transferred, or stocked must be registered here. It links together category, group, brand, tax code, loyalty category, HS code, units of measure, barcodes, and supplier details into one comprehensive item record.
Navigation Path
Screen Overview — Header & Barcode Details Tab
Screen Overview — Unit Details Tab
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank Item Master form |
| 💾 Save | Saves the item record |
| 🔍 Search | Search for existing items |
| List View | Displays all items in a list |
| View History | Modification history |
| CSV Import | Import multiple items from a CSV file |
| Field | Description | Required |
|---|---|---|
| Category* | Item category — select from Category master dropdown. Determines the inventory ledger and item code prefix. | Yes |
| Group* | Item group — select from Item Group master. | Yes |
| Subgroup* | Item sub group — select from Item Sub Group master. | Yes |
| Brand* | Item brand or manufacturer — select from Item Brand master. | Yes |
| Item Number | System-generated item code based on category prefix. Use … to search existing. | Auto |
| Item Name* | Full descriptive name of the item. | Yes |
| Stock Unit* | The base unit for stocking and inventory tracking. Select from UOM master. | Yes |
| Sale Unit* | The unit used in sales transactions. May differ from Stock Unit (e.g., stock in KG, sell in 500g packs). Select from UOM master. | Yes |
| Dutycode* | HS Code / Customs duty code. Select from HS Code master. Defaults to NA. | Yes |
| Field | Description | Required |
|---|---|---|
| Tax Code* | Tax code applicable to this item. Select from Taxes master. Determines tax % and ledgers. | Yes |
| Tax (%) | Tax percentage — auto-filled from Tax Code. Read-only. | Auto |
| Inventory Ledger* | GL inventory account — auto-filled from Category. Read-only. | Auto |
| Loyalty Category* | Loyalty earning category for this item. Select from Loyalty Category master. | Yes |
| Origin | Country or region of origin for this item. Select from dropdown. | Optional |
| Composition Name | Active ingredient or product composition (important for pharmaceuticals). | Optional |
| Item Type* | Type of item — e.g., Finished Goods, Raw Material, Service. Select from dropdown. | Yes |
| Batch Required? | Check if this item must be tracked by batch number in all transactions. Recommended for pharmaceutical and perishable items | Optional |
| All Location Batch Required?* | Check if batch tracking is required at every location where this item is stored. | Optional |
| Inactive?* | Check to deactivate this item. Inactive items cannot be used in transactions. | Optional |
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Barcode | The barcode number for this item (EAN13, EAN8, QR, etc.). Enter or scan. | Yes |
| Mainbarcode?* | Check if this is the primary barcode for the item. One barcode must be set as main. | Yes |
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Unit* | An alternate unit of measure for this item (e.g., if stocked in KG but also sold in 500g packs, add 500g as a unit here). | Yes |
| Conversion Factor (To Stock Unit)* | How many Stock Units = 1 of this unit (e.g., 0.5 if 500g = 0.5 KG). Used for auto-conversion in transactions. | Yes |
| Grossweight (in Kgs) | Gross weight per unit in kilograms. | Optional |
| Netweight (In Kgs) | Net weight per unit. | Optional |
| CBM | Volume per unit in cubic metres — used for shipping calculations. | Optional |
Supplier Details Tab — Link one or more suppliers who supply this item, with their supplier item code and lead time. Attachment Tab — Attach product images, spec sheets, or certificates. Footer Tab — Additional notes and custom fields.
Step-by-Step Guide
Open a blank Item Master form.
Choose from the respective masters. Item Number auto-generates from category prefix.
Type the full product name.
Select units from UOM master. If Stock Unit = Sale Unit, enter the same in both.
Choose the applicable tax code and HS code.
Select item type and the loyalty earning category.
Check Batch Required? for pharmaceuticals, food items, or any product requiring expiry/batch tracking.
In the Barcode Details tab, enter the item barcode and mark one as Main barcode.
In the Unit Details tab, add alternate units with conversion factors if applicable.
In the Supplier Details tab, link the primary supplier(s) for this item.
Click Save. The item is now available across all purchase, sales, and inventory transactions.
Reason Master
The Reason Master defines the reasons used to categorise stock movements in Stock Receipt, Stock Issue, and Sales Return transactions. Each reason is linked to specific GL debit and credit accounts, controlling how the accounting entry is posted for that type of movement.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves the record |
| 🔍 Search | Search for existing records |
| List View | Displays all records in a list |
| View History | Shows modification history |
| Field | Description | Required |
|---|---|---|
| Reason* | The reason name for this stock movement type (e.g., Damaged Goods, Sample Issue, Expired Stock Write-off, Free Issue). | Yes |
| Credit Ledger | The GL account to be credited for movements under this reason. Click 🔍 to select. Used in Stock Receipt transactions. | Optional |
| Debit Ledger | The GL account to be debited for movements under this reason. Click 🔍 to select. Used in Stock Issue transactions. | Optional |
| Sales Promotion? | Check if this reason is used for sales promotion-related stock movements (free goods given under promotion schemes). | Optional |
| Inactive? | Check to deactivate this reason. | Optional |
Step-by-Step Guide
Open a blank Reason Master form.
Type a clear, descriptive reason name.
For Stock Receipt reasons, select the GL account to credit.
For Stock Issue reasons, select the GL account to debit.
Check if this reason is linked to promotional free goods.
Click Save. This reason is now available in Stock Receipt and Stock Issue transactions.
HS Code
The HS Code (Harmonized System Code) master stores international tariff classification codes along with their customs duty percentages. HS Codes are assigned to items in the Item Master (Dutycode field) and are used in Import Purchase transactions for customs declarations.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves the record |
| 🔍 Search | Search for existing records |
| List View | Displays all records in a list |
| View History | Shows modification history |
| Field | Description | Required |
|---|---|---|
| HS Code | The 6-10 digit Harmonized System tariff code (e.g., 3004.20.10 for antibiotics). Leave blank if not yet assigned. | Optional |
| HS Description | The official tariff description corresponding to this HS code. | Optional |
| Effective From | The date from which this HS code is effective. Click the calendar icon to set. | Optional |
| Duty (%) | The customs import duty percentage applicable to items under this HS code. e.g., 25 for 25% import duty | Optional |
| Inactive | Check to deactivate this HS code entry. | Optional |
Step-by-Step Guide
Open a blank HS Code form.
Enter the official tariff code and its description.
Enter the date from which this code is effective.
Enter the applicable customs duty percentage.
Click Save. The HS code is now available in the Item Master Dutycode field and in Import PO/Licence screens.
Item Transfer Request
The Item Transfer Request is raised when one location needs stock from another location. It records the items required, quantities, and the source and destination locations. The request is fulfilled through an Item Transfer Issue followed by an Item Transfer Receipt.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank ITR form |
| 💾 Save | Saves the request |
| 💾 Save and Print | Saves and prints |
| 🔍 Search | Search existing requests |
| List View | List all requests |
| View Histor | Modification history |
| Re-Print | Re-prints the request |
| Cancel | Cancels the request |
| Field | Description | Required |
|---|---|---|
| Request From* | The location requesting the stock. Select from dropdown. | Yes |
| Request Date | Date the request is being made. Defaults to today. | Yes |
| Request No* | System-generated request number. Use … to search existing. | Auto |
| Request To* | The location from which stock is being requested. Select from dropdown. | Yes |
| Remarks | General remarks for this request. | Optional |
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Item Name* | Item being requested. Click 🔍 to search and select. | Yes |
| Unit* | Unit of measure — auto-filled from Item Master. | Auto |
| Packsize | Pack size — auto-filled. | Optional |
| Available Stock | Available stock at the Request To location — auto-filled for reference. | Auto |
| Required Quantity* | Quantity being requested. | Yes |
Step-by-Step Guide
Open a blank Item Transfer Request form.
Choose the location that needs the stock.
Choose the location that has the stock.
In the grid, click 🔍 to select each item and enter the Required Quantity.
Click Save. The request is raised and can be actioned by the source location via Item Transfer Issue.
Transfer Booking
Transfer Booking is used to pre-book a stock transfer between two locations — scheduling when the transfer will happen and which route/vehicle will be used. It is referenced in Item Transfer Issue and Transfer Expense transactions to link costs to specific transfers.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank Transfer Booking form |
| 💾 Save | Saves the booking |
| 🔍 Search | Search existing bookings |
| List View | List all bookings |
| View History | Modification history |
| Field | Description | Required |
|---|---|---|
| From Location* | The source location dispatching the stock. Select from dropdown. | Yes |
| To Location* | The destination location receiving the stock. Select from dropdown. | Yes |
| Booking Date* | Date of the transfer booking. Select from calendar. | Yes |
| Booking Number | System-generated booking number. Use … to search existing. | Auto |
| Notes | Any notes about this booking (e.g., vehicle details, route information). | Optional |
| Closed? | Check to mark this booking as closed once the transfer is complete. | Optional |
Step-by-Step Guide
Open a blank Transfer Booking form.
Choose the source and destination locations.
Enter the planned transfer date.
Add any relevant transfer notes.
Click Save. The booking number can now be referenced in Item Transfer Issue and Transfer Expense.
Transfer Expense
Transfer Expense records the costs associated with a stock transfer — freight charges, vehicle hire, handling fees, etc. It is linked to a Transfer Booking and records the expense as either a bill payable to a vendor or a direct cash/bank payment.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank Transfer Expense form |
| 💾 Save | Saves the expense |
| 🔍 Search | Search existing expenses |
| List View | List all expenses |
| View History | Modification history |
| Cancel | Cancels the entry |
| Voucher Details | Displays accounting entries |
| Field | Description | Required |
|---|---|---|
| Booking No* | The Transfer Booking number this expense belongs to. Select from dropdown — From Location, To Location, and Booking Date auto-fill. | Yes |
| Document Date* | Date of the expense document. | Yes |
| Document No | System-generated document number. | Auto |
| Expense Booked to* | The location to which this expense is charged. Select from dropdown. | Yes |
| Trans Type* | Transaction type — Bill or Payment. | Yes |
| Type* | Vendor, Cash, or Bank. | Yes |
| Supplier / Cash / Bank* | Select the vendor or payment account. Click 🔍 to search. | Yes |
| Currency | Transaction currency — auto-filled. | Auto |
| Exchange Rate (to USD)* | Exchange rate. | Yes |
| Notes | Remarks for this expense. | Optional |
| From Location | Auto-filled from Booking. | Auto |
| To Location | Auto-filled from Booking. | Auto |
| Booking Date | Auto-filled from Booking. | Auto |
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Charge Name | Type of expense. Select from dropdown. | Yes |
| Charge Basedon* | How the charge is applied — Fixed, Per KG, Per CBM, etc. | Yes |
| Bill/Payment Amount* | Amount of this charge. | Yes |
| Bill/Payment Amount (USD) | USD equivalent — auto-calculated. | Auto |
Step-by-Step Guide
Open a blank Transfer Expense form.
Choose the Transfer Booking. Header details auto-fill.
Choose Bill or Payment and select the vendor.
In the Expense Details tab, add each charge with its amount.
Click Save. Use Voucher Details to verify accounting entries before posting.
Item Transfer Issue
Item Transfer Issue records the actual dispatch of stock from one location to another. It is linked to an Item Transfer Request (Request No) and/or a Transfer Booking (Booking No). Saving an Issue deducts stock from the From Location. The receiving location then confirms receipt via Item Transfer Receipt.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank Issue form |
| 💾 Save | Saves and deducts stock |
| 💾 Save and Print | Saves and prints |
| 🔍 Search | Search existing issues |
| List View | List all issues |
| View History | Modification history |
| Voucher Details | Displays accounting entries |
| Print Invoice | Prints transfer invoice |
| Print Delivery | Prints delivery note |
| Field | Description | Required |
|---|---|---|
| From Location* | Location dispatching the stock. Defaults to current location. | Yes |
| Receipt Location* | Destination location receiving the stock. Select from dropdown. | Yes |
| Document Date | Date of issue. Defaults to today. | Yes |
| Document No | System-generated document number. | Auto |
| Trans Type* | Type of transfer transaction. Select from dropdown. | Yes |
| Request No* | Linked Item Transfer Request number. Select from dropdown. | Yes |
| Request Date | Date of linked request — auto-filled. | Auto |
| Booking No* | Linked Transfer Booking number. Select from dropdown. | Optional |
| Driver Name | Name of the delivery driver. | Optional |
| Vehicle No. | Vehicle registration number for tracking. | Optional |
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Item* | Item being transferred. Click 🔍 to search. | Yes |
| Unit* | Unit of measure. | Auto |
| Pack Size | Pack size. | Auto |
| Reserved Stock | Stock reserved for this location. | Auto |
| Current Stock | Available stock before issue. | Auto |
| Batch* | Select batch from dropdown — mandatory for batch-tracked items. | Yes |
| Stock | Stock in selected batch. | Auto |
| Balance Qty | Balance from linked request. | Auto |
| Quantity* | Quantity being issued. | Yes |
| Cost Rate | Cost rate per unit. | Auto |
| Item Gross Weight* | Total gross weight for this line. | Optional |
| Item CBM* | Total CBM for this line. | Optional |
| Last Sales Price (Intr) | Last internal sales price — reference. | Auto |
Step-by-Step Guide
Open a blank Item Transfer Issue form.
Choose source and destination.
Link to the originating Transfer Request.
If a booking was made, link it here.
In the grid, select items, choose batch, and enter quantity.
Click Save. Stock is deducted from From Location. The receiving location can now raise an Item Transfer Receipt.
Item Transfer Receipt
Item Transfer Receipt is raised by the receiving location to confirm that stock dispatched via an Item Transfer Issue has been physically received. It is linked to the Transfer Issue via the Transfer No field. Saving a Receipt adds the stock to the Receipt Location.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank Receipt form |
| 💾 Save | Saves and adds stock to receipt location |
| 💾 Save and Print | Saves and prints |
| 🔍 Search | Search existing receipts |
| List View | List all receipts |
| View History | Modification history |
| Voucher Details | Displays accounting entries |
| Re-Print | Re-prints the receipt document |
| Field | Description | Required |
|---|---|---|
| Transfer No* | The Item Transfer Issue number to be receipted. Select from dropdown — Receipt Location, Issue Location, Trans Type, and Transfer Booking No auto-fill. | Yes |
| Trans Type* | Transaction type — auto-filled from linked Issue. | Auto |
| Receipt Location | Receiving location — auto-filled. | Auto |
| Issue Location | Dispatching location — auto-filled. | Auto |
| Receipt Date* | Date goods are physically received. Enter or select from calendar. | Yes |
| Receipt No | System-generated receipt number. | Auto |
| Transfer Booking No | Linked booking — auto-filled. | Auto |
| Location Batch Flag | Enable location-level batch tracking for received goods. | Optional |
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Item Name | Item — auto-filled from linked Issue. | Auto |
| Unit | Unit — auto-filled. | Auto |
| Pack Size | Pack size. | Auto |
| Balance Qty | Quantity expected from the Issue — auto-filled. | Auto |
| Batch | Batch number — auto-filled from Issue. | Auto |
| Manufacturing Date | Mfg date — auto-filled. | Auto |
| Expiry Date | Expiry date — auto-filled. | Auto |
| Quantity* | Quantity actually received. May differ from Balance Qty if partial receipt. | Yes |
| Price | Unit price — auto-filled. | Auto |
| Amount | Total amount — auto-calculated. | Auto |
| Expense Amount | Transfer expense allocated to this item — auto-calculated. | Auto |
Step-by-Step Guide
Open a blank Item Transfer Receipt form.
Choose the Issue number. All details auto-fill.
Enter the actual date goods were received.
Check received quantities in the grid. Adjust if partial receipt.
Click Save. Stock is added to the Receipt Location.
Direct Stock Transfer
Direct Stock Transfer moves stock between two locations without a prior Transfer Request or Transfer Booking. It is used for immediate or ad-hoc transfers where the normal request-booking-issue-receipt workflow is not required. Both the stock deduction and the receipt happen in a single transaction.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank DST form |
| 💾 Save | Saves and moves stock between locations |
| 💾 Save and Print | Saves and prints |
| 🔍 Search | Search existing DSTs |
| List View | List all DSTs |
| View Histor | Modification history |
| Voucherdetails | Displays accounting entries |
| Draft | Saves as draft |
| Field | Description | Required |
|---|---|---|
| Location* | The source location dispatching the stock. Select from dropdown. | Yes |
| To Location* | The destination location receiving the stock. Select from dropdown. | Yes |
| Trans Type* | Transfer transaction type. Select from dropdown. | Yes |
| Transfer Date* | Date of the stock transfer. Select from calendar. | Yes |
| Transfer No | System-generated transfer number. | Auto |
| To Location Batch Flag | Enable location batch tracking at the destination. | Optional |
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Item Name* | Item to be transferred. Click 🔍 to search. | Yes |
| Unit* | Unit of measure — auto-filled. | Auto |
| Pack Size | Pack size. | Auto |
| Reserved Stock | Reserved stock at source location. | Auto |
| Current Stock | Available stock at source — reference. | Auto |
| Batch No | Batch number — select for batch-tracked items. | Cond |
| Expiry Date | Expiry date of selected batch. | Auto |
| To Batch No | New batch number at destination if re-batching. | Optional |
| To Expiry Date | Expiry date at destination. | Optional |
Step-by-Step Guide
Open a blank Direct Stock Transfer form.
Choose From and To locations.
Set the transfer type and date.
In the grid, select items, batch, and quantity to transfer.
Click Save. Stock is moved from source to destination in one step.
Stock Receipt
Stock Receipt is used to bring stock into a location from non-purchase sources — such as corrections for opening stock, sample receipts, returned goods from market, or stock adjustments after physical counting. The GL entry is driven by the Reason selected.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves and adds stock |
| 💾 Save and Print | Saves and prints |
| 🔍 Search | Search existing receipts |
| List View | List all receipts |
| View History | Modification history |
| Voucher Details | Displays accounting entries |
| Re-Print | Re-prints |
| Draft | Saves as draft |
| Field | Description | Required |
|---|---|---|
| Location* | Location receiving the stock. Defaults to current location. | Yes |
| Stock Receipt | Date of stock receipt. Select from calendar. | Yes |
| Stock Receipt No | System-generated receipt number. Use … to search existing. | Auto |
| Reason* | Select the reason for this stock receipt from the Reason Master dropdown. Drives the GL credit entry. | Yes |
| Credit Ledger | GL account to be credited — auto-filled from selected Reason. | Auto |
| Location Batch Flag | Enable location batch tracking. | Optional |
| Notes | Remarks for this stock receipt. | Optional |
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Item* | Item to be received. Click 🔍 to search. | Yes |
| Unit* | Unit of measure — auto-filled. | Auto |
| Pack Size | Pack size. | Optional |
| Batch No* | Batch number — mandatory for batch-tracked items. | Yes |
| Supplier Batchno* | Supplier's batch reference. | Yes |
| Suppliername* | Supplier name for this batch. Select from dropdown. | Yes |
| Manufacturing Date* | Manufacturing date of this batch. | Yes |
| Expiry Date* | Expiry date of this batch. | Yes |
| Qty* | Quantity being received. | Yes |
| Rate (In Base)* | Cost rate in base currency. | Yes |
| Amount | Total value — auto-calculated. | Auto |
Step-by-Step Guide
Open a blank Stock Receipt form.
Set the location and receipt date.
Choose the reason — the Credit Ledger auto-fills.
Enter item, batch details (including supplier, manufacturing date, expiry), quantity, and rate.
Click Save. Stock and inventory value are added to the location.
Stock Issue
Stock Issue is used to remove stock from a location for reasons other than sales — such as samples given to customers, damaged or expired stock write-offs, items consumed internally, or corrections after physical count. The GL debit entry is driven by the selected Reason.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank form |
| 💾 Save | Saves and deducts stock |
| 💾 Save and Print | Saves and prints |
| 🔍 Search | Search existing issues |
| List View | List all issues |
| View History | Modification history |
| Voucher Details | Displays accounting entries |
| Re-Print | Re-prints |
| Draft | Saves as draft |
| Field | Description | Required |
|---|---|---|
| Location* | Location from which stock is issued. Defaults to current location. | Yes |
| Stock Issue Date | Date of issue. Select from calendar. | Yes |
| Stock Issue No | System-generated issue number. Use … to search. | Auto |
| Reason* | Select the reason for this stock issue. Drives the GL debit entry. | Yes |
| Debit Ledger | GL account to be debited — auto-filled from selected Reason. | Auto |
| Notes | Remarks for this issue. | Optional |
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Item* | Item to be issued. Click 🔍 to search. | Yes |
| Unit* | Unit of measure — auto-filled. | Auto |
| Pack Size | Pack size. | Optional |
| Reserved Stock | Reserved stock at location. | Auto |
| Current Stock | Available stock — reference. | Auto |
| Batch* | Select batch for batch-tracked items. | Cond |
| Available Stock | Stock available in selected batch. | Auto |
| Qty* | Quantity being issued. | Yes |
Step-by-Step Guide
Open a blank Stock Issue form.
Debit Ledger auto-fills from the selected Reason.
Select items, batch if applicable, and quantity to issue.
Click Save. Stock is deducted from the location.
Item Fabrication
Item Fabrication records the conversion of raw material items (Minus items) into finished or semi-finished goods (Plus items). It simultaneously deducts the raw material stock and adds the finished product stock — enabling production or repackaging workflows within the inventory system.
Navigation Path
Screen Overview
Toolbar Buttons
| Button | Description |
|---|---|
| ▣ New | Opens a blank Fabrication form |
| 💾 Save | Saves the fabrication and moves stock |
| 💾 Save and Print | Saves and prints |
| 🔍 Search | Search existing fabrications |
| List View | List all records |
| View Histor | Modification history |
| Re-Print | Re-prints the fabrication document |
| Field | Description | Required |
|---|---|---|
| Location* | Location where fabrication is taking place. Defaults to current location. | Yes |
| Fabrication Date | Date of fabrication. Select from calendar. | Yes |
| Fabrication No | System-generated fabrication number. Use … to search. | Auto |
| Location batch Flag | Enable location-level batch tracking. | Optional |
| Notes | Remarks about this fabrication. | Optional |
| Field | Description | Required |
|---|---|---|
| S No | Auto-incremented. | Auto |
| Item Name (Minus)* | Raw material or source item to be consumed. Click 🔍 to search. | Yes |
| Unit (Minus)* | Unit of measure — auto-filled. | Auto |
| Pack Size (Minus) | Pack size. | Optional |
| Reserved Stock | Reserved stock at location. | Auto |
| Current Stock | Available stock before fabrication. | Auto |
| Batch (Minus)* | Select batch for batch-tracked raw material items. | Cond |
| Batch Stock | Stock in selected batch. | Auto |
| Qty (Minus)* | Quantity of raw material being consumed. | Yes |
| Amount | Value of consumed raw material — auto-calculated. | Auto |
The To Item Details tab works identically, but records the finished or output items being produced — enter the output item, its batch details, quantity produced, and value.
| Field | Description | Required |
|---|---|---|
| Total Minus Qty | Total quantity of raw materials consumed. | Auto |
| Total Minus Value | Total value of raw materials consumed. | Auto |
| Total Plus Qty | Total quantity of finished goods produced. | Auto |
| Total Plus Value | Total value of finished goods produced. | Auto |
Step-by-Step Guide
Open a blank Item Fabrication form.
Fill the header.
Select each raw material item, batch, and quantity consumed.
Select each output item, assign batch and expiry, and enter quantity produced.
Verify Minus and Plus quantities and values in the footer.
Click Save. Raw material stock is deducted and finished goods stock is added.
Stock Statement
Period-based summary of every item showing Opening, Receipts, Issues, and Closing stock with values.
Navigation Path
Parameters
| Parameter | Description | Default |
|---|---|---|
| Company | Filter by company | ALL |
| Branch | Filter by branch | ALL |
| Location | Filter by location | ALL |
| Segment | Filter by segment | ALL |
| Group Name | Filter by item group | ALL |
| Brand | Filter by brand | ALL |
| Item Name | Select specific item via 🔍 | ALL |
| Unit Type | STD UNIT or alternate unit | STD UNIT |
| From Date | Period start date | Today |
| To Date | Period end date | Today |
Report Output
Columns
| Column | Description |
|---|---|
| Item Number | Item code — click hyperlink to drill to Stock Ledger |
| Item Name | Full item name |
| Std Unit | Standard unit of measure |
| Brand Name | Item brand |
| Opening | Opening quantity at start of period |
| Opening Value | Opening inventory value |
| Receipt | Total received (GRN, Stock Receipt, Transfer Receipt) |
| Receipt Value | Value of receipts |
| Issue | Total issued (Sales, Stock Issue, Transfer Issue) |
| Issue Value | Value of issues |
| Closing | Closing quantity = Opening + Receipt − Issue |
| Closing Value | Closing inventory value |
| Rate | Average cost rate per unit |
Stock Ledger
Transaction-level audit trail showing every stock movement for a selected item in chronological order with Opening and Closing balances.
Navigation Path
Parameters
| Parameter | Description | Default |
|---|---|---|
| Company | Filter by company | ALL |
| Branch | Filter by branch | ALL |
| Location | Filter by location | ALL |
| Supplier | Filter by supplier | ALL |
| Item Name | Select a specific item — recommended for meaningful output | ALL |
| Type | Filter by transaction type | ALL |
| Fromdate | Period start date | Today |
| Todate | Period end date | Today |
Report Output
Columns
| Column | Description |
|---|---|
| Transaction Number | Document number — click hyperlink to open original document |
| Transaction Date | Date of the transaction |
| Batch | Batch number affected |
| Type | Movement type — GRN, Sales Invoice, Stock Issue, Transfer Issue, etc. Opening/Closing rows shown in red |
| Std Unit | Unit of measure |
| Received | Quantity received (inward) |
| Issued | Quantity issued (outward) |
| Rate | Unit cost rate |
| Amount | Transaction value |
| Username | System user who processed the transaction |
| Customername | Customer name for sales movements |
Stock Aging
Groups current stock into user-defined age brackets (slabs) to identify slow-moving, overstocked, or near-expiry inventory.
Navigation Path
Parameters
| Parameter | Description | Default |
|---|---|---|
| As on Date | Date as of which aging is calculated | Today |
| Company | Filter by company | ALL |
| Branch | Filter by branch | ALL |
| Location | Filter by location | ALL |
| Group Name | Filter by item group | ALL |
| Segment Name | Filter by segment | ALL |
| Item Name | Select specific item via 🔍 | ALL |
| slab1 | Upper limit of 1st bracket in days | 30 |
| slab2 | Upper limit of 2nd bracket | 60 |
| slab3 | Upper limit of 3rd bracket | 90 |
| slab4 | Upper limit of 4th bracket — stock older than this appears in >slab4 | 120 |
Report Output
Columns
| Column | Description |
|---|---|
| Item | Item name |
| <= 30 Qty / Amount | Stock in the first slab — most recently received |
| <= 60 Qty / Amount | Stock aged slab1+1 to slab2 days |
| <= 90 Qty / Amount | Stock aged slab2+1 to slab3 days |
| <= 120 Qty / Amount | Stock aged slab3+1 to slab4 days |
| > 120 Qty / Amount | Oldest stock — slow-moving or overstocked |
| Total Stock | Total quantity across all brackets |
| Total Amount | Total inventory value |
Transit Stock Statement
Shows all stock issued via Item Transfer Issue that has not yet been received via Item Transfer Receipt — preventing in-transit stock from being overlooked.
Navigation Path
Parameters
| Parameter | Description | Default |
|---|---|---|
| Location | Filter by destination location, or ALL | ALL |
| Item | Filter by specific item via 🔍, or ALL | ALL |
Report Output
Columns
| Column | Description |
|---|---|
| Item Name | Item in transit — grouped by destination location. Click hyperlinks for transfer details. |
| Unit | Unit of measure |
| Transit Qty | Quantity issued but not yet received at destination |
| Transit Amt | Inventory value of in-transit stock |
| Total per location | Subtotal for each destination location |
Item Expiry Details
Lists all stock batches expiring within a specified number of days, or already expired (negative Days To Expiry). Critical for pharmaceutical and perishable products.
Navigation Path
Parameters
| Parameter | Description | Default |
|---|---|---|
| Branch | Filter by branch | ALL |
| Locationname | Filter by location | ALL |
| Group Name | Filter by item group | ALL |
| Segment Name | Filter by segment | ALL |
| Brand | Filter by brand | ALL |
| Itemname | Filter by specific item via 🔍 | ALL |
| Days | Items expiring within this many days are included. Expired items always shown. | 90 |
Report Output
Columns
| Column | Description |
|---|---|
| Location | Warehouse/shop storing this batch — grouped by location |
| Item Name | Name of the item |
| Group Name | Item group |
| Segment Name | Item segment |
| Batch No | Internal batch number |
| Supplier Batch No | Supplier original batch reference on packaging |
| Batch Date | Manufacturing date of this batch |
| Expiry Date | Expiry date of this batch |
| Stock | Current quantity in this batch |
| Days To Expiry | Days until expiry. Negative = already expired — immediate action required. |