tairox-logo.png
Products |Customization |Services |Videos |Partners |About |Contact |TCP Dispatch
TaiRox Software |Partners |About |Contact |Communications
Products |Videos |Customization |Services |TCP Dispatch
Downloads
User Guide
Product Distribution File
Release Notes
Application Suite
Automate G/L Consolidation
Automate Recurring Entries
Download Rates
Productivity Tools
SOX Check Approval
SOX Second Sight
SOX User Management
TaiRox Collections
TaiRox CRM and Collections
Data Management Suite
Copy Company
Create Company
Fast Clear History
Fast Data Integrity
Fast DBTools
Fast Duplicates Check
Fast Units of Measure Tool
Optional Field Manager
SOX Backup Enterprise
SOX Backup Express
Free Diagnostic Software
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 2022.
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 300 2012 to 2022: A single executable program works with these platforms.