How to Use Alternate Units of Measure in TallyPrime: Complete Guide
How to Use Alternate Units of Measure in TallyPrime: Complete Guide
Learn how to configure alternate units of measure (UoM) in TallyPrime. Step-by-step guide to dual unit conversion rules, inventory setups, decimal settings, and invoicing.
Who is this for: Step-by-Step Tutorial
Many trading businesses deal with products that are purchased in bulk (e.g. Boxes, Crates) but sold in smaller units (e.g. Pieces, Packets). TallyPrime's Alternate Units of Measure feature allows you to record these transactions without maintaining separate stock items.
Maintaining inventory accuracy becomes difficult when purchase and sales channels measure stock differently. For instance, a wholesale distributor might buy soft drinks in cartons containing 24 cans but sell them to local retail shops in individual cans. If the accountant creates two separate stock items—'Cartons' and 'Cans'—reconciling stock valuations, tracking batch numbers, and generating profit summaries becomes an administrative nightmare. TallyPrime solves this through a dual-unit system known as **Alternate Units of Measure**.
Understanding the Core Inventory Units in TallyPrime
Before setting up alternate units, it is essential to understand the different unit configurations TallyPrime supports. Choosing the wrong unit type can lock your database or require complex conversions later.
- Simple Units: These are standalone measurement terms. Examples include
Nos(Numbers),Kgs(Kilograms),Pcs(Pieces), andBox. They represent direct integers or decimals. - Compound Units: A compound unit is a permanent combination of two simple units with a fixed conversion value. For example,
Box of 12 Pcs. Here, one box will always equal 12 pieces, with no flexibility. - Alternate Units: This configuration assigns two different units to a single stock item. You define a standard relation (e.g.,
1 Box = 24 Pcs), but you can override this ratio on individual sales or purchase bills (for example, if a supplier issues a damaged box containing only 22 pieces).
The Critical Importance of Decimal Place Settings
One of the most common pitfalls when creating units of measure in TallyPrime is ignoring the **Number of Decimal Places** setting in the Unit Master creation. For instance, if you measure sugar in Kilograms as the primary unit and Bags as the alternate unit, you will often deal with fractional values (e.g., 1.5 bags or 75.5 Kgs).
If you leave the decimal places setting for Kilograms at 0, TallyPrime will round off all fractions to the nearest whole integer. A sale of 75.5 Kgs will be recorded as 76 Kgs, resulting in stock discrepancies and tax mismatch errors in GSTR-1.
To configure decimal places correctly:
- Go to Gateway of Tally > Create > Unit.
- Select or type the symbol (e.g.,
KGS). - In the Number of Decimal Places field, enter
3(highly recommended for weight metrics) or2(for general fractional measurements). - For alternate unit symbols like
BOX, setting the decimal places to0or1is usually sufficient.
Step-by-Step Alternate Unit Configuration
To configure alternate units, you must first enable the feature in the stock item creation configuration menu. Follow these steps to map your inventory rules:
Enable Alternate Units in Tally Settings
Go to Gateway of Tally > Create > Stock Item. Once on the stock item creation screen, press F12 (Configure). Scroll to the inventory section, locate the option Use Alternate Units, change it to Yes, and press Ctrl+A to save.
Assign Primary and Alternate Units
In the stock item creation screen, name your product (e.g., Mineral Water 1L). In the Unit field, select your primary tracking unit (e.g., BOX). Below this, a new field named Alternate Unit will appear. Select your secondary unit (e.g., PCS).
Define the Conversion Factor
In the Where relation fields, input the mathematical relationship. For example, enter 12 PCS = 1 BOX. This tells TallyPrime that every box contains exactly 12 individual bottles. Save the stock item master.
Real-World Examples of Dual Unit Applications
Different trade industries use alternate units to manage their specific supply chain workflows. Below are some of the most common configuration pairings:
| Industry Sector | Primary Unit | Alternate Unit | Conversion Example |
|---|---|---|---|
| Beverages & Food Retail | CASE (Carton) | CAN (Pieces) | 24 CAN = 1 CASE |
| Steel & Construction Metal | MT (Metric Ton) | PCS (Rods) | 200 PCS = 1 MT |
| Cement & Infrastructure | BAG | KGS | 50 KGS = 1 BAG |
| Pharma & Chemistry Supplies | BOX (Strip) | TAB (Tablets) | 10 TAB = 1 BOX |
Recording Transactions with Alternate Units
Once set up, entering transaction vouchers in TallyPrime becomes extremely flexible. When you create a sales or purchase invoice:
- Select the customer/supplier and the stock item.
- In the **Quantity** field, you can type the amount in either unit. If you type
5 Box, Tally will automatically display5-00 BOXand calculate60 PCSin the background. - If you want to sell individual units, you can type
15 Pcs. TallyPrime will convert this and show1-03 BOX(meaning 1 Box and 3 Pieces) based on your conversion rate. - This ensures your stock summary reports display both the total box count and loose piece counts accurately, eliminating manual calculations.
Troubleshooting Alternate Unit Valuation Anomalies
Sometimes, businesses notice that their **Stock Summary** values display incorrect rates or unexpected fractional balances. This is almost always caused by a transaction where the alternate unit override was entered incorrectly. For example, if an operator accidentally types 10 PCS but overrides the conversion to read 10 BOX, the inventory database valuation will suffer from a severe rate inflation.
To clean up and audit these errors:
- Open the Stock Summary report.
- Press Alt+F12 to open the Range Filter menu.
- Set the query to filter for transactions where the calculated rate differs significantly from standard cost profiles.
- Audit the vouchers and ensure the primary-to-alternate ratios match standard parameters.
How Automation Saves You Time on Multi-Unit Accounting
While configuring alternate units makes your records accurate, manually entering multi-unit details on purchase bills remains time-consuming. Accounts teams must verify the primary counts, conversion ratios, tax rates, and line items for every invoice.
Using TrulyInvoice simplifies this entire workflow. By leveraging AI-driven data extraction, TrulyInvoice reads supplier invoices, extracts quantity metrics, and maps them to your existing Tally inventory items. TallyPrime's built-in alternate unit conversion rules then calculate secondary unit quantities automatically. This keeps your records precise, reduces compliance errors, and saves hours of manual entry.
Chartered Accountant & Accounting Automation Specialist