Invoice Number Generate

[JAMIR]

Hello,
I want to generate IV Number automatically. Issue Voucher items no limit. In following table there is Cust. ID Code given in [Issue To] colomn. I want to generate IV Number by formula. Issue Voucher Number should be Generate with Cust. ID & Date. Also for 02 & 03 Cust ID he should not generate IV Number. When its found it should be blank. If 05 code with the date of 1/1/2014 it should generate IV Number only for the date 1/1/2014, if 05 code with the date 1/2/2014 it should be generate next IV Number with that date. It is possible with formula?

 

[Somendra Misra]

Hi Jamir,

Please see the attached file. Is this what you want?

Regards!

 

[JAMIR]

Hi Somendra,
I am sorry for not mentioned IV Number which is start from 102500. This IV Number start for the Cust ID with date mentioned infront.

Regards!

Zameer Shaikh

 

[sgmpatnaik]

@Somendra Misra

I tried another method for the Invoice No. with Helper Column

in the Helper Column i use the formula as

=IF($A3="02",0,IF($A3="03",0,IFERROR($A3/$A3,0)))

and in Iv No.

=IF($A3="02","",IF($A3="03","",(SUM(H$3:$H3)&" / "&$A3&"-"&TEXT($B3,"dd-mm-yyyy"))))

for the continue Invoice No. you can check formula in G and H Column

note H Column to be hide

 

[sgmpatnaik]

@JAMIR

Please check my uploaded file may be it will helpful to you

please change the formula as give below in the Column G and Drag Down

=IF($A3="02","",IF($A3="03","",(SUM(H$3:$H3)+10249&" / "&$A3&"-"&TEXT($B3,"dd-mm-yyyy"))))

other wise please inform

Thanks

 

[Somendra Misra]

@sgmpatnaik
Nice approach by you. But consider OP requirement. I think he had change his requirment.

@JAMIR
While posting question you should clear all the points, it will save a lot of time. And secondly, if you upload any file do give in some dummy output what you require. You were short on both the points. Please upload the file with desired output.

Regards!

 

[sgmpatnaik]

@Somendra

Thanks for your kind words, as per OP requirement the formula was changed let see what the OP requirement the invoice to be continue or stand alone

Regards

 

[JAMIR]

@JAMIR

Please check my uploaded file may be it will helpful to you

please change the formula as give below in the Column G and Drag Down

=IF($A3="02","",IF($A3="03","",(SUM(H$3:$H3)+10249&" / "&$A3&"-"&TEXT($B3,"dd-mm-yyyy"))))

other wise please inform

Thanks

Hi sgmpatnaik,
I am very glad to see your reply and taking effords for my problem. I just want to generate Issue Voucher Number 152500 in the IV Number Colomn.

Kindly trace the attached file.

Thanks & Regards,

Zameer