Invoice number sequence validation

[Mahadevaswamyb]

Dear Team,

Could some one help me with the below scenario.

As per the below table Data is the invoice numbers and Result is what I want a workflow to drive. in each case we wanted to validate Invoice numbers are generated in the continuous sequence.

Data                   Result
2000000344
2000000345      Yes
2000000346      Yes
2600000271      No
2810017325      No
2810017326      Yes
2810017327       Yes

Regards

Mahadev

[JosephSerpis · Accepted solution]

Hi @Mahadevaswamyb you can do this with a Multi-Row Formula.

 

[RolandSchubert · Accepted solution]

Hi Mahadev,

MultiRowFormula Tool  is a practical solution for that. Find a sample workflow attached.

Best regards

Roland

[Mahadevaswamyb]

Thank you, this works perfectly..!!

[Srini_Advik]

This should give the final result.

[mahadevaswab]

Dear all,

Need one more hep.

Co code Invoice #

2810   2810001

2810   2810002

2810   2810003

2500   2500001

2500   2500002

From the above we wanted to validate the Sequence number based on the co code and then followed by Invoice number sequence.

Rgards

Mahadev