Apps & Add-Ons
Business Solutions
Services
Contact Us
Acute Data Systems
Tel: 800.761.3037
Fax: 800.801.8573
solutions@acutedata.com
Fast Units of Measure Tool
The TaiRox Fast Units of Measure Tool (“Fast UOM”) is a SQL Server specific tool used to diagnose and, where possible, fix issues that arise in Sage 300 Inventory Control when UOM codes are used with “different case variations” (upper and lower case letters are used inconsistently). For example, “Each” and “EACH” may both be used when the intention was that these codes meant the same thing. Problems can arise when two codes differ only in case and when these codes are used as keys to various tables.
Sage 300 databases are set up with either “case sensitive” or “case insensitive” collation sequences. Fast UOM performs differently after detecting which of these two setups is used.
Benefits
- Operates in a few seconds, even on large databases
- Detects units of measure that are not in the ICUCOD table
- Detects units of measure with case variations in ICUNIT and ICUCOD table
- Will report case variations in all I/C, O/E and P/O tables
- Will fix units of measure variations in case insensitive databases in preparation for a migration
How to Read Fast UOM Logs
Duplicates in the ICUNIT Table
A Clean Log
A clean log file will report no warnings or errors and list all tables that it is checking against
A Clean Log
A clean log file will report no warnings or errors and list all tables that it is checking against