Invoice number sequence validation

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

Expression

Data Investigation

Accepted answers

JosephSerpis

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

Multi_Row_Formula_240919.yxmd

RolandSchubert

Hi Mahadev,

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

Best regards

Roland

CheckInvoiceNumbers.yxmd

All comments

JosephSerpis

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

Multi_Row_Formula_240919.yxmd

RolandSchubert

Hi Mahadev,

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

Best regards

Roland

CheckInvoiceNumbers.yxmd

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703