Keys
This uses as the invoice number either the next available auto voucher number, or the supplier's delivery note number, or the Goods received note number, or the purchase order number. If the delivery note, GRN or purchase order is defined with a presentation length that is more than 15 characters, then that numbering method is disabled.
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 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 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 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 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 generates invoice, credit and debit note numbers at company level and the branch associated with the transaction has no bearing on the document number.
This generates invoice, credit and debit note numbers from the AR branch associated with the transaction. If the AR Invoice number key type is set to alphanumeric, then you can assign a single character as a prefix to the document numbers generated by each branch. This enables you to identify the branch that generated the document.
This is the next invoice number that will be used if automatic numbering is defined. Numbers are allocated up front and incremented during processing. Note: Cancelling or rolling back a transaction does not de-allocate this number and will result in gaps in the numbering sequence as the allocated number is not re-used.
This is the next credit note number that will be used if automatic numbering is defined. Numbers are allocated up front and incremented during processing. Note: Cancelling or rolling back a transaction does not de-allocate this number and will result in gaps in the numbering sequence as the allocated number is not re-used.
This is the next debit note number that will be used if automatic numbering is defined. Numbers are allocated up front and incremented during processing.
Cancelling or rolling back a transaction does not de-allocate this number and will result in gaps in the numbering sequence as the allocated number is not re-used.
This allocates the order number as the invoice number for the first invoice generated for the order. Subsequent invoices for the order assigns the next invoice number based on the invoice numbering method defined. You can't select this if the Auto invoice numbering - order release option is set to Use delivery note. Don't select this if you intend to part-ship goods (where more than one invoice will be produced for one sales order) as this may result in missing invoice numbers.
This lets you use the same invoice number for different customers within a SYSPRO company when processing invoices, regardless of your order or invoice numbering methods.
If you chose the Same invoice for different customers option, then this lets you delete the invoice cross reference table and rebuild it.
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 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 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 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 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 allocates the next customer code automatically when you add a new customer.
This lets you assign a unique code to identify a new customer added.
This assigns the next code automatically when you add a new customer, based on a user-defined script (i.e. you can use the VBScript Editor to build a unique code for each new customer added).
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 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 allocates the next supplier code automatically when you add a new supplier.
This lets you assign a unique code to identify a new supplier added.
This assigns the next code automatically when you add a new supplier, based on a user-defined script (i.e. you can use the VBScript Editor to build a unique code for each new supplier added).
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 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 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 generates delivery note numbers using the entry made at the Next delivery note field.
This generates delivery note numbers based on the numbering defined for the branch associated with the sale.
This generates delivery note numbers based on the numbering defined for the branch, together with a prefix that can assist in identifying the branch that generated the document.
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 is a 15-digit number incremented with each new pick.
This is a 5-digit number incremented with each new pick and prefixed by the original sales order from which it originated.
This is a 5-digit number incremented with each new pick and prefixed by the date (in CCYYMMDD format) the pick was created.
This is a 5-digit number incremented with each new pick and prefixed by the warehouse of the first picking line and the date (in YYMMDD format) when the pick was created.
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 an RMA number whenever merchandise is returned from a customer.
This allocates the next RMA number automatically according to your entry at the Next RMA number field when merchandise is returned from a customer.
This allocates the next RMA number held against the branch when merchandise is returned from a customer.
This allocates the next RMA number and prefix from the branch when merchandise is returned from a customer.
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 number when you add an order.
This allocates the next number automatically when you add an order.
This allocates the next order number automatically using the numbering against the branch linked to the sale. If your order key type is alphanumeric, then you can assign a single character as a prefix to the document numbers generated by each branch. This helps you identify the branch that generated the document.
This is the next sales order number that the system will use if order numbers are being generated at company level.
This is the next credit note number that the system will use if order numbers are generated at company level. The number must be in the range 800000 to 899999. The number of characters will depend on the presentation length selected.
This is the next debit note number that the system will use if order numbers are generated at company level. The number must be in the range 900000 to 999999. The number of characters will depend on the presentation length selected.
This assigns the next order number to a supply chain transfer order according to the numbering method of the branch assigned to the source warehouse. Otherwise the numbering method of the branch assigned to the target warehouse determines the next order number assigned to a supply chain transfer order.
This assigns an invoice number automatically when you release an order. The number allocated to the first invoice generated for the order is the order number providing you enabled the Sales order moved to invoice setup option. Otherwise it is the next invoice number by branch or by company based on the AR invoice numbering method 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.
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 indicates how you want to allocate GRN numbers for purchase order receipts (i.e. automatic, manual, by warehouse, by warehouse with prefix, by branch and by branch with prefix).
This generates a new GRN number for each stock item receipted using the Purchase Order Receipts program. If any item on the purchase order requires inspection or is traceable, then a new GRN number is assigned to each line, regardless of whether this option has been enabled.
This produces a GRN number per line when using the Receipt All function in the Purchase Order Receipts program. Otherwise the Receipt All function generates a single GRN number for all lines. If any item on the purchase order requires inspection or is traceable, then a new GRN number is assigned to each line, regardless of whether this option has been enabled.
Select this to assign a GRN number to each new shipment received into stock using the Landed Cost Tracking system.
This forces GRN numbers to be unique, regardless of the supplier. You will need to create a GRN master file using the Reindex Files program to ensure that duplicate GRN numbers are not created.
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 indicates how you want to allocate numbers when capturing purchase orders (i.e. automatic, manual, by warehouse, by warehouse with prefix, by branch and by branch with prefix).
If by Warehouse or Branch ensure that you assign a unique range of numbers for each warehouse (or branch) to avoid duplicating purchase order numbers.
If by Prefixed warehouse or Prefixed branch ensure that the prefix is unique in order to avoid duplicate keys, which would prevent SYSPRO from allocating the next number.
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 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.
Manual lets you assign a unique number for each RFQ. Automatic allocates the next RFQ number automatically.
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 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 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 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 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 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 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 lets you automatically increment the last release of an item when you go back a revision when updating the revision/release of an item.
Your selection here is ignored when stock control is not at release level and release numbering is not automatic. This is also dependent on the option Allow non-sequential entries.
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 lets you apply a revision/release that is smaller than the one when you apply a new revision/release through an ECO. This option only applies to the revision and not the tracked release when the Track release option is enabled. Typically, you would set up the revision to refer to a specific location or status and the release to be incremental. It would then be necessary in each design change for an ECC-controlled item to enter a revision that does not occur after the previous revision.
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 code to identify a new job added.
This allocates the next job number automatically when you add a job.
This numbers your jobs automatically according to the classification assigned at the time of capturing the job.
This assigns the next job number automatically when you add a new job (Job Entry program only) based on a user-defined script (i.e. you can use the VBScript Editor to build a unique code for each new job number added).
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 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 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 WIP inspection number at the time of receiving items into inspection.
This allocates the next available WIP inspection number automatically.
This numbers WIP inspections by job class.