Distribution - Inventory Keys

Setup Options > Keys > Distribution - Inventory

Alpha keys result in the left-alignment of all data, with trailing blanks. Numeric keys result in the right-alignment of all data, with preceding zeros. Only the digits 0 to 9 are allowed.

If you need to change a key type:

  • Ensure that all entries/transactions are complete (including journals, distribution reports, postings, month ends, etc).

  • Before making the change, copy the current/live company to a new company (i.e. a History/Backup company) and then change the key type for the old/live company. This will enable you to still review the history against the old key types (in the History/Backup company) while using the new key type for transactions in the live company.

Similarly, changing the case of a key field could result in loss of access to data (e.g. if you previously defined a stock code using lowercase characters and then change to uppercase, you will not be able to access the lowercase stock code key).

This allows for both alphabetic and numeric characters. Data is left-aligned with trailing blanks.

This only allows the entry of numeric characters (i.e. 0-9). Data is right-aligned with preceding zeros.

This automatically converts alphabetic characters in the key to uppercase.

This automatically converts any alphabetic characters in the key to lowercase.

This caters for both upper and lowercase characters (i.e. no conversion is performed). This conversion capability is supported in all forms, toolbars and data grids and applies to alphanumeric key types.

This suppresses the display of zeros that appear before the numeric key.

This restricts the number of characters that can be entered or displayed in a key field.

If you have selected a key type that can be prefixed, then this indicates the length of the prefix required. If the prefix is zero, then the prefix length is dynamic and is determined by the number of characters you define in the prefix.

This lets you assign a unique GIT Reference number whenever you process an inter-warehouse or supply chain transfer of goods.

This allocates the next GIT Reference number automatically.

This allocates the next GIT Reference number according to the numbering method defined against the source warehouse.

This allocates the next GIT Reference according to the numbering method defined against the source warehouse, together with a two character prefix.

This is the next number that will be used when you process an inter-warehouse or supply chain transfer of goods and automatic numbering is defined.

This is the number that will be assigned to the next document printed to record the receipt into stock of an item using the Inventory Movements program. This number is assigned only if the option to generate the next document number is enabled for your Stock receipts document format.

This is the number that will be assigned to the next document printed to record the issue of items for miscellaneous purposes using the Inventory Movements program. This number is assigned only if the option to generate the next document number is enabled for your Issue document format.

This is the number that will be used for the next inspection document to be printed. This number is automatically updated by the system each time you print a new inspection document using the Purchase Order Inspection program.

This is the number that will be used for the next rejection note document to be printed. This number is automatically updated by the system each time you print a new rejection note document using the Purchase Order Inspection program.

This is the number that will be used for the next scrap note document to be printed. This number is automatically updated by the system each time you print a new scrap note document using the Purchase Order Inspection program.

This allows for both alphabetic and numeric characters. Data is left-aligned with trailing blanks.

This only allows the entry of numeric characters (i.e. 0-9). Data is right-aligned with preceding zeros.

This automatically converts alphabetic characters in the key to uppercase.

This automatically converts any alphabetic characters in the key to lowercase.

This caters for both upper and lowercase characters (i.e. no conversion is performed). This conversion capability is supported in all forms, toolbars and data grids and applies to alphanumeric key types.

This suppresses the display of zeros that appear before the numeric key.

This restricts the number of characters that can be entered or displayed in a key field.

This lets you assign a unique lot number.

This allocates the next lot number automatically (if the key type is numeric). The automatic option is not applicable if you enable the Lot is equal to job option and you won't be able to reserve lots for parent parts.

This is the next number that will be used if automatic numbering is defined.

This sets the lot number to be the same as the job number when processing transactions in the Job Receipts program. Both your lot and job number key types must be the same (i.e. either both must be numeric, or both must be alphanumeric). This option is only applied to co-products if the Use same lot on multiple stock codes option is enabled.

This allows for both alphabetic and numeric characters. Data is left-aligned with trailing blanks.

This only allows the entry of numeric characters (i.e. 0-9). Data is right-aligned with preceding zeros.

This automatically converts alphabetic characters in the key to uppercase.

This automatically converts any alphabetic characters in the key to lowercase.

This caters for both upper and lowercase characters (i.e. no conversion is performed). This conversion capability is supported in all forms, toolbars and data grids and applies to alphanumeric key types.

This suppresses the display of zeros that appear before the numeric key.

This restricts the number of characters that can be entered or displayed in a key field.

This lets you create ranges of manual serial numbers that are sequential within the company - created according to the prefix and suffix defined against the company (the combined prefix and suffix cannot exceed 20 characters).

This lets you track the last serial number range created for a specific stock code (you define the prefix and next suffix against each individual stock item).

This is the character(s) that must form the start of the serial number when you add a range of manual serial numbers within this company.

This number is appended to the prefix and together they form the serial number. The system automatically increments the next suffix for each new serial number created in the range, providing the number was created using the prefix. The number of numeric characters entered for the suffix must cater for the total quantity of serial numbers you want to add using the defined prefix.

For example:

A suffix of 1 character will allow 9 serials to be added for the prefix you defined.

This allows for both alphabetic and numeric characters. Data is left-aligned with trailing blanks.

This only allows the entry of numeric characters (i.e. 0-9). Data is right-aligned with preceding zeros.

This automatically converts alphabetic characters in the key to uppercase.

This automatically converts any alphabetic characters in the key to lowercase.

This caters for both upper and lowercase characters (i.e. no conversion is performed). This conversion capability is supported in all forms, toolbars and data grids and applies to alphanumeric key types.

This suppresses the display of zeros that appear before the numeric key.

This restricts the number of characters that can be entered or displayed in a key field.

This lets you assign a unique code to identify a new stock item added.

This allocates the next code automatically when you add a new stock code (for numeric key types only).

This assigns the next code automatically when you add a new stock item, based on a user-defined script (i.e. you can use the VBScript Editor to build a unique code for each new stock item added).

This is the next number that will be used if automatic numbering is defined.