How to get a consecutive number

Create the following Global variables;

• DocID       – Type Integer
• oldDocID  – Type Integer
• oldRN       – Type Integer
• Client        – Type Text 

1. Create a new Assign data activity with the following assignments;
   
   Workflow global variable = DocID = Index entry of the document = Doc ID
   Workflow global variable = Client = Index entry of the document = Company
   
    
2. Next, create another Assign Data activity with the following assignments;
   
   Workflow global variable = OldDocID = File cabinet = Doc ID = DW_Company = CV_Client AND DW_DocID < > GV_DocID
   
   
   
    
3. Create a new ‘Assign Data’-step (here: Get old RN)
4. Fill the variable ‘oldRN’ using a value from the file cabinet
   Here Document Number is used as Invoice Number
   
   
   DW_DocID = GC_OldDocID
    
5. Create a new ‘Assign Data’-step (here: Get new RN)
6. Fill the Index data (here: Document Number) using an arithmetic expression 
   
   
   GV_oldRN + 1

 
The condition

1. Add a new ‘Condition’-Step (here: Condition_Client 1)
2. Set it up as follows:
   
   Note: If the value of the company is always written in the same way (uppercase, lowercase, etc.) you will not need the UCASE()
    
3. Add 2 new ‘Assign Data’ - Steps
4. Assign additional information to the invoice number
   Example:
   

Result
In the end it all should look like follows: