Order sequence start from PI100667

Question

hi all, I&rsquo;m new to sage x3 and need some help. we are moving from sage accpac and would like to continue our sequence of orders from our previous system. we are currently at 100666 and would like to start sage x3 at 100667. Our system now starts from PI100000. 
 
 Is there a way to enter when the sequence should start ?

Julien Patureau · Answer

Hi George Cheung 
 First you need to identify which sequence counter is used for the orders (purchase or sales?). You can use the function GESTCA to check the sequence counter used depending on your company and document type: 
 Sales order sequence counter can be managed at the order type level, in that case you need to check the function GESSTO: 
 Then you can use the function MODCPT to force the starting number: 
 
 Be sure the sequence number is large enough to handle all orders numbers you will ever need to create. This is why I usually suggest to have a reset at some point such as per year but then you need to have the year number being part of the sequence number. 
 At worst you can change the format if you run short of number but then the sorting per alphanumeric in any order selection and left list can get messy.

Sage X3

Order sequence start from PI100667

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING