Modifying a Sequence Series

Your PrismCore system has a group of default sequence series parameters for 'Selected Store Locations' (i.e. All Locations) and for each store location you add to the system (for details on sequence series parameters, see About Sequence Series).

The parameters define the format of each system-assigned number sequence type. They also determine the number of digits for the numerical part of the number and the first and last number you want assigned for each sequence type. You can modify these parameters in the Sequence Series module.

NOTE: The 'All Locations' / 'Selected Store Locations' sequence series will always display first for each type of sequence series you wish to modify. To access a store location's sequence series, you will need to press the Next Record (F8) button until you reach the desired location.

Be aware that each number in each sequence series must be unique, so you need to have different templates or different ranges of start and end numbers for different sequence series to prevent the system from trying to create duplicate numbers.

To modify a sequence series:
1. Access the Sequence Series module.
2. From the Store Location toolbar, select 'Selected Store Locations' or the individual store location for which you want to modify the sequence series.
3. From the 'Select Sequence Type' combo box, select the sequence type you want to modify (e.g., Discrepancies, Purchase Orders, Returns).
4. The parameters for the sequence type display in the frame below the
'Select Sequence Type' combo box. Most of sequence types have only four fields enabled. Change the data in these, as desired. Note that when the system uses the parameters to create a number for a sequence series the numbers in the first three fields will be left-padded with zeros to match the number of numerical characters defined in the Template field (e.g., '1' might become '000001' in the final document number.

Field               Input

Start Number

Enter the number to be used for the first number in the sequence series.

Next Number

Enter the number to be used for the next number in the sequence series. This is the number that will appear on the next record you create for the sequence type.

End Number

Enter the number to be used for the last number in the sequence series. When this number is reached, the sequence starts again from the Start Number. The end number is typically all 9's and is the number of digits indicated in the series template (e.g., if the template is PO######, the end number is 999999).

Template

Enter the template to define the form of the number in the sequence series. At a minimum, the template consists of a series of # signs. Each

  1. sign represents a numerical character, and you can put alpha/numeric characters before or after the # signs in order to be able to distinguish one sequence series from another. For example, the template for discrepancies could be DSR-######, while the template for Tradebook POs could be PO-######TR.


 NOTE: Click the button if you want PrismCore to set the Next Number for you by calculating the next available number not already used in the sequence series.


5. For some special sequence types there are other fields and check boxes that you can define (for details on these sequence series parameters, see Sequence Series Options). The special sequence types are purchase orders, returns, merchandise requests, mail order numbers, and merchandise transfers. If you are modifying one of these sequence types, you need to be sure to make applicable changes to the following parameters:

Field                                                  Input

Description


Enter a description for the sequence series. This description allows you to select this sequence series in some modules in PrismCore.

Apply shared sequence to Text, Trade and GM

This check box is enabled only on the 'Shared' default sequence series. If you want to use only one sequence series for all three subsystems, check the checkbox. This causes PrismCore to use the parameters from the 'Shared' record, instead of the separate sequence series records for each subsystem.


Use this series for autogenerated tasks

This checkbox is checked on the default sequence series for all three subsystems. It can be checked on only one series per subsystem. If
you add a new sequence series for a subsystem, you can check this box
on the new series. If you check the box on the new series, it is checked and grayed out on the new series and it becomes unchecked and available to be checked on the original series record.

Subsystem

From the combo box, select the subsystem for which the series should be used (e.g., Textbook, Trade Book, or General Merchandise). You can have more than one sequence series per subsystem (e.g., one for autogenerated textbook POs and another for manually created textbook POs.)


6. When you are done modifying the record, click the Save Record button.