How to generate invoice number

[copy_writes (chethan)]

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

Read_Cell.xaml (13.4 KB)

I hope I will get the solution.

Thanks
Chethan P

[NIVED_NAMBIAR (NIVED N)]

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

[copy_writes (chethan)]

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

[Yoichi]

Hi,

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

Previous_Invoice_number = Invoice_number

Regards,

[copy_writes (chethan)]

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

[Yoichi]

Hi,

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

Regards,

[copy_writes (chethan)]

Sure
Invoice_Number.xlsx (8.3 KB)

[Yoichi]

Hi,

Thank you for sharing.

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

Read_Cell.xaml (14.0 KB)

Regards,

[copy_writes (chethan)]

Thank you very much it was working

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