|
Fast Units of Measure Tool
|
|
Available for $995 + $250 per year, 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. Consult the
User Guide
for more detailed descriptions and examples.
|
|
|
*New* Support is added for Sage 300 2024.
|
|
*New* Support is added for Sage 300 2023.2 and 2023.3.
|
|
*New* When logging into a SQL Server instance, a checkbox allows users to remember SQL Server passwords.
The remembered passwords are encrypted.
Picture.
|
|
|
Fast Units of Measure Tool
|
|
|
|
Sample Log #1
|
|
|
|
Sample Log #2
|
|
|
|
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 2024: A single executable program works with these platforms. |
| • | .NET Framework 4.6.2 or higher is required. |
| • |
Detailed Platform Requirements |
|
