Map UoM - UQC

Unit Quantity Code (UQC) is a uniform measuring unit used by the department for measuring quantity in the returns filed. UQCs are used to maintain consistency and prevent variations in quantities in the returns filed by different businesses. This requires the businesses to measure the quantities of items using the UQC from the list given by the department.

Using Tally.ERP 9, you can map your unit of measurement to the UQC given by the department, and file the returns. This can be done in the UoM master as well as in the Map UoM-UQC report, which allows you to map all the UoMs at once. In case an item has more than one UoM, and thus linked to multiple UQCs, you will have to select the reporting UQC for such items to report in GST returns.

To map UoM to UQC

1.    Go to Gateway of Tally > Display > Statutory Reports > GST > Map UoM - UQC.

2.    Select the UoM that has to be mapped to its UQC, and click S: Map to UQC.

3.    Select the right UQC from the predefined list.

4.    Press Enter to map. Similarly, you can map each UoM to the right UQC.

The list of Unit Quantity Code provided by the department does not have the representative code for brass, carats, litres, running foot, and so on. Based on your business requirement, map the unit to the related UQC. For example, you can map litres to KLR-KILOLITRE. Before filing, change the quantity in the hsn worksheet of the template, or CSV file. Examples of mapping units to the related UQCs with the conversion factors are given below:

Unit of Measure

Nearest UQC

Conversion of Quantity in Template

Litres

KLR-KILOLITRE

Multiply by 0.001

MLT-MILILITRE

Multiply by 1000

Carat

KGS-KILOGRAMS

Multiply by 0.0002

GMS-GRAMMES

Multiply by 0.2

Brass

SQF-SQUARE FEET

Multiply by 100

CBM-CUBIC METERS

Multiply by 2.835

Running foot

MTR-METERS

Multiply by 0.3048

Cubic inches

MLT-MILILITRE

Multiply by 16.3871

Hanks

YDS-YARDS

For cotton, multiply by 840

For woolen, multiply by 560

Inches

MTR-METERS

Multiply by 0.0254

CMS-CENTIMETERS

Multiply by 2.54

Pounds

TON-TONNES

Multiply by 0.000453592

KGS-KILOGRAMS

Multiply by 0.453592

GMS-GRAMMES

Multiply by 453.592

Lots

TON-TONNES

Multiply by 0.0000128

KGS-KILOGRAMS

Multiply by 0.0128

GMS-GRAMMES

Multiply by 12.8

Milligrams

GMS-GRAMMES

Multiply by 0.001

Decameter square

SQY-SQUARE YARDS

Multiply by 119.599

SQF-SQUARE FEET

Multiply by 1076.39

Square inches

SQM-SQUARE METERS

Multiply by 0.00064516

SQY-SQUARE YARDS

Multiply by 0.000771605

SQF-SQUARE FEET

Multiply by 0.00694444

Tola

GMS-GRAMMES

Multiply by 11.6638125

 

Reporting UQC

Selecting the report UQC for an item, in case it has mulitple UQC's linked, is also made easy in Tally.ERP 9.

To select the reporting UQC for an item

1.    In the Map UoM - UQC report, click U: Update RUQC.

2.    Select an item and click A: Map to RUQC.

3.    Select the reporting UQC (RUQC) from the list.

4.    Press Enter to map the stock item to its RUQC.

The quantities of the selected stock item will be reported using the RUQC chosen in the GST returns.

Buttons

F1: Detailed - Use this button to view the information in the report in the detailed mode.

F5: Show All/ Show Unmapped: Use this button to toggle between unmapped UoM or all UoMs in the report.

 

Setting UQC after Upgrade

When you are upgrading from an earlier version of Tally.ERP 9 to Release 6.1, a message is displayed to inform you about the need to map your UoMs to the UQC. You can directly go to the Map UoM - UQC report to start mapping by pressing Enter.