How to generate invoice number

how to generate the auto invoice
For example, I have data in the excel invoice number 100 if we run the excel means we have to increment one-102 next time we have to run the data means next time means 103
like this
@NIVED_NAMBIAR @Yoichi can you please help me
I try this I increment using assign activity to increment and it’s working I have a problem in if we have 2 or 3 invoice number is not add like an empty column on that time it’s not working :expressionless:


Read_Cell.xaml (13.4 KB)

I hope I will get the solution.

Thanks
Chethan P

Hi @copy_writes

U mean if u process invoice number 100 today then u need to process 101 Tommorow

Is that what u mean ? @copy_writes

yes but hear the problem is if we have 2 invoice if we generate 2 invoice means its writing the same value example 3 and 3 only

Thanks
Chethan P

Hi,

Probably you need to add the Assign activity as the following.

Previous_Invoice_number = Invoice_number

img20210301-3

Regards,

if we have two row is empty on that time how its work i get the same invoice number for both row

Hi,

Can you share your excel file, if possible? It’s no problem if dummy data.

Regards,

1 Like

Sure :slightly_smiling_face:
Invoice_Number.xlsx (8.3 KB)

Hi,

Thank you for sharing.

It seems no problem with the above code. If I have any misunderstanding your requirement, please point it.

img20210301-5

Read_Cell.xaml (14.0 KB)

Regards,

1 Like

Thank you very much it was working :beer: :beer: :beer:

Thank you, I was a little confused about that. thank you very much
i forgot to add the value to the previous invoice number thanks yar you help me a lot

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.