Updated: March 12, 2024 11:05am

Document Sequences

Setting up document numbering sequences is a two-step process:

  1. Set the desired sequence level: Subsidiary, Store, or Workstation. Set this in Preferences & Settings > Node Preferences > Sequences.
  2. Based on the selected level, go into each Subsidiary, Store, or Workstation record and define the starting sequence number for each document type used by your business.

Set the Sequence Level

  1. In the Admin Console, select Preferences & Settings > Sequencing.    
  2. Select the desired sequence level for each document type.    
  3. Save the changes.   

sequencing preferences

Set the Starting Sequence Number

  1. Navigate to the desired Subsidiary, Store, or Workstation record. Click the pencil icon.    
  2. Click the Sequences tab. Enter the desired starting sequence number for each document type that your business uses.     
  3. Save the changes.    

sequencing settings
Sequences Defined in Prism
Sale No,  Return No,  Customer ID No,  Send Sale No, EFT Invoice No, Disbursement No, Purchase Order No,     Next Voucher No,  ASN No,  Transfer No,  Z-Out No, Order No,  Adjustment Memo No, UPC, ALU, Transfer Order No 

Single Sequence for all Orders, Single Sequence for all Sales
You have the option of using a single sequence for all orders (customer, special, layaway), and sales (sales, returns)

Avoid Duplicate Sequence Numbers in RP Prism, RIL
If you will be creating documents in BOTH RP Prism and Retail Pro Integration Layer (RIL), be sure to set up separate document numbering sequences for each system. For example, if you use the default document numbering sequences for a document type for both RIL and Prism, and then create POs and Vouchers in each system, you will get "Duplicate Document Number" error messages.

Maximum Sequence Number Length

1) TO = 8
2) PO = 20
3) Voucher = 10
4) ASN = 10
5) Adjustment = 10
6) Sale No = 10
7) Return No = 10
8) Sales Order No = 10
9) Send Sale No = 10
10) EFT Invoice No = 10
11) Disbursement No = 10
12) Z-Out No = 19
13) UPC = 18