What is Fast Unit of Measure?
Fast Units of Measure Tool is a program 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.
Why use Fast Unit of Measure?
- Operates in a few seconds, even on larger 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 IC, OE, and PO tables
- Will fix units of measure variations in case-sensitive databases in preparation for a migration
Sample Log One
Duplicates in the ICUNIT Table
The log will report multiple variations in the ICUNIT table. Further tests will not be performed before this issuesis resolved for all of the items with variations.
Sample Log Two
