Products |Customizations |Services |Videos |Partners |About |Contact |TCP Dispatch
TaiRox Software |Partners |About |Contact
Products |TCP Dispatch |Services |Videos
User Guide
Product Distribution File
Release Notes
Application Suite
Automate G/L Consolidation
Download Rates
Productivity Tools
Productivity Tools cloud
SOX Check Approval
SOX User Management
TaiRox CRM
Data Management Suite
Copy Company
Create Company
Fast Clear History
Fast Data Integrity
Fast DB Tools
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 $595 + $120 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.
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 or 6.0 or Sage 300 2012, 2014, 2016, 2017, 2018 or 2019
• A single executable program works with all platforms
• Microsoft SQL Server is required