reset the invoice number counter

reset the invoice number counter - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: How To ? (http://www.weberp.org/forum/forumdisplay.php?fid=6)
+--- Thread: reset the invoice number counter (/showthread.php?tid=4369)

reset the invoice number counter - swaminathan - 07-10-2017

I need to reset the invoice number counter at the beginning of every fiscal year please help

RE: reset the invoice number counter - TimSchofield - 07-11-2017

The invoice number needs to be unique in the database so you can't just set it back to 1 at the start of the year. A way round it is to start the invoice number with the year number. To do this you need to change the systypes table in the database. So to set the next sales invoice number to be 201700001 you would run the sql:

UPDATE systypes SET typeno='201700001' WHERE typeid='10';

Thanks
Tim

RE: reset the invoice number counter - R2-G - 07-11-2017

(07-10-2017, 11:32 PM)swaminathan Wrote: I need to reset the invoice number counter at the beginning of every fiscal year please help

Invoice No is controled by a counter (typeid 10) in the systypes table

so below mysq via phpmyadmin will set it to what you want (xxx)l

update systypes set typeno=xxx where typeid='10';

I hope that helps

R2-g

RE: reset the invoice number counter - swaminathan - 07-11-2017

(07-11-2017, 01:56 AM)R2-G Wrote:
(07-10-2017, 11:32 PM)swaminathan Wrote: I need to reset the invoice number counter at the beginning of every fiscal year please help

Invoice No is controled by a counter (typeid 10) in the systypes table

so below mysq via phpmyadmin will set it to what you want (xxx)l

update systypes set typeno=xxx where typeid='10';

I hope that helps

R2-g

Thank you Tim and R2 g,
I appreciate the members to spare time and answer every query on this forum.

RE: reset the invoice number counter - Chandrasekaran - 08-18-2017

Dear Swaminathan,

We are WebERP Implementation services company.we have more than 6+ years of experience in WebERP Implementation and customization.

Emaginationz Technologies is our company and link for it is listed below

www.emaginationz.net

You will definitely have lot of customization requirement in WebERP.You can reach us anytime through this mail ID "neewgowtham2014@gmail.com"

We can help you anytime.

Best Regards,
Gowtham