Advanced Multi-UOM

From AutoCount Resource Center
Jump to navigation Jump to search

Advanced Multi UOM

This module allows stock items with multiple unit of measurement, UOM auto conversion, and multiple UOM reports.

Go to Tools > Program Control > Module Setting

Check the checkbox of Advanced Multi-UOM to enable it.


Repost Sales/Purchase/Stock Transactions

Compared to Basic Multi-UOM (which produces stock reports only in smallest UOM), Advanced-Multi UOM produces stock reports in multiple UOM.

If you have been using Basic Multi UOM before purchasing Advanced Multi UOM module, your stock balance (transacted earlier) is reported in smallest UOM. To re-categorise these 'old' stock according to their UOM respectively (as provided by Advanced Multi UOM module), you need to run a Repost.


To run Repost,

Go to Start > All Programs > AutoCount Accounting > AutoCount Accounting Management Studio

Go to Data Consistency > Repost Sales/Purchase/Stock Transactions


AMU1.png


Select relevant items,

Click on Start Repost.


AMU2.png


Stock Card Report before Repost

Though there were stock balances for both UOM (PCS and BOX), the report will either show smallest UOM (PCS), OR

show the default Report UOM (one UOM at one time, according to the setting of default Report UOM at Stock Item Maintenance).


AMU3.png


Stock Card Report After Repost

The report will show each of UOM separately (BOX, PCS...) and their transaction respectively. (also see More Options below}


AMU4.png


Click on More Options and You may choose from 3 UOM options.

1. Show Multi UOM (by default this is selected)

2. Show Default Report UOM

3. Show Smallest UOM


AMU5.png


Multiple UOM with same UOM rate


AMU6.png

Base UOM means 'Smallest UOM' in Stock reports (More Options > UOM Option > Show Smallest UOM ) ... the Base UOM is important only when you have multiple UOM with UOM Rate equal to 1 (smallest rate), and you wish to view stock reports in a specific smallest UOM, then you must specify the desired UOM to be the Base UOM.


AMU7.png

Most commonly, the 'Show Multi-UOM' option is selected, where each of the UOMs will be displayed accordingly. However, 'Show Multi-UOM' is applicable only when the module of Advanced Multi-UOM is enabled.


Purchase Item with Multi UOM

Go to Purchase > Purchase Invoice

Click on Create a New Purchase Invoice,

Under UOM column, you may select different UOM...


AMU8.png


UOM Conversion

If you are purchasing items in bigger UOM and selling them at smaller UOM, you may convert the larger UOM to smaller UOM or vice versa.

Go to Stock > Stock UOM Conversion,

Click on Create a New Stock UOM Conversion,


AMU9.png

Key in the description of this conversion,

Click on '+' sign to add an item conversion; you may choose to convert upwards or downwards.

Click on Save.


AMU10.png


Take a look at Stock Card Report again


AMU11.png

Note: Doc.Type UC means Unit Conversion.


Auto UOM Conversion

From current Stock Card Report, balance quantity of item B0001 is: 9 CTN, 7 BOX, -3 PCS.

Issue an Invoice of 2 PCS, and the system will prompt a message saying there is insufficient quantity for PCS, and suggesting to convert one BOX into PCS.


Go to Stock > Stock Item Maintenance,

Retrieve item with multi UOM,

Make sure that the checkbox of Auto UOM Conversion is checked,


AMU12.png


Create a New Invoice,

Select item N91, and quantity 2 PCS,


AMU13.png


Click on Save,


AMU14.png


Click on Yes, will prompt the screen of Stock UOM Conversion..

(If click on No, will prompt the screen of Confirmation for Negative Quantity Stock Items..)


AMU15.png

Note: the system will automatically suggest to convert from nearest UOM. You may amend it or/and click Save.


View the Stock Card Report again,

AMU16.png


Set Automatic UOM Conversion

Go to Tools > Options >Invoicing > Document Control 2

Check the checkbox of Automatic UOM Conversion

This setting will automatically perform UOM conversion (when needed) without prompting message screen for confirmation.


AMU17.png

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations