Why is a leading 0 (zero) deleted in the inventory number. The field is 16 digit alphanumeric ? Is there a method to get around this? It is causing problems.

Thanks

Hi Bill,
When faced with this situation, what we normally use is a 2 segment number with 15 digits in the first segment and a space before the last single digit. This workaround will solve the issue of leading zeroes, although displays on the screen as 15 space 1.

However, you can report on forms without the space, so OE invoices, confirmations, and picking slips will look fine in OE, and similarly for PO documents in Purchase Orders. Adagio stores the item code without formatting in the database.

You need to be aware of using XLS as any import file into Adagio Inventory for pricelists or Inventory Counts, instead of CSV formats. CSV will drop the leading "0"'s and will make your imports, a nightmare.

You can correct your configuration on the fly with GV - Read Write, and will need to adjust the IC company profile and PO company profile, if you have already moved your configuration of dataset to production.

Best,
Brian

If the item number is a single segment, then leading zeros are trimmed and the field is right justified in the length of the key (to conform with all other Adagio key fields). If the item number is made up of two or more segments, then it remains left justified and leading zeros are allowed. The item format is set when the database is first defined.

Dakota's Toolkit for Adagio can be used to change both the format and size of a item number.