Products |Customizations |Services |Videos |Partners |About |Contact |TCP Dispatch
TaiRox Software |Partners |About |Contact |Recent News
Products |Videos |Customizations |Services |TCP Dispatch
User Guide
Product Distribution File
Release Notes
Application Suite
Automate G/L Consolidation
Download Rates
Productivity Tools
SOX Check Approval
SOX User Management
TaiRox Collections
TaiRox CRM and Collections
Data Management Suite
Copy Company
Create Company
Fast Clear History
Fast Data Integrity
Fast DBTools
Optional Field Manager
SOX Backup Enterprise
SOX Backup Express
Specialized Programs
Automate Recurring Entries
Fast Duplicates Check
SOX Second Sight
Tax Converter
For Dealers Only
Fast Units of Measure Tool
G/L Account Repair
Restore G/L History
Install Check
Fast Units of Measure Tool
Available for $995 + $250 per year, 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. Unlike codes used elsewhere in Sage 300, these UOM codes are not forced to be in upper case. 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. Consult the User Guide for more detailed descriptions and examples.
*New* support has been added for Sage 300 2021.
Fast Units of Measure Tool
fast-uom-main.png fast-uom-main.png
Sample Log #1
fast-uom-icunit-dupes.png fast-uom-icunit-dupes.png
Sample Log #2
fast-uom-clean-log.png fast-uom-clean-log.png
Features and 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 tables.
• 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.
Platform Requirements
• Sage ERP Accpac version 5.6 to 6.0 or Sage 300 2012 to 2021
• A single executable program works with all platforms
• Microsoft SQL Server is required