Views:
Question:
I need a consecutive number for my documents. How can I get this?
 
Answer:

The variables

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

Fill the variables as follows:

  1. Create a new ‘Assign Data’-step (here: Get Values)
  2. Fill variable ‘DocID’ and ‘Client’ with the corresponding indexvalues


     
  3. Create a new ‘Assign Data’-step (here: Get Old DocID)
  4. Fill the variable ‘oldDocID’ with a value from a file cabinet




    DW_Company = CV_Client AND DW_DocID < > GV_DocID

     
  5. Create a new ‘Assign Data’-step (here: Get old RN)
  6. Fill the variable ‘oldRN’ using a value from the file cabinet
    Here Document Number is used as Invoice Number


    DW_DocID = GC_OldDocID

     
  7. Create a new ‘Assign Data’-step (here: Get new RN)
  8. 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:

Comments (0)