Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
reset the invoice number counter
07-10-2017, 11:32 PM,
#1
reset the invoice number counter
I need to reset the invoice number counter at the beginning of every fiscal year please help
Thanks
Swaminathan
Reply
07-11-2017, 01:50 AM, (This post was last modified: 07-11-2017, 04:18 AM by TimSchofield.)
#2
RE: reset the invoice number counter
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

Reply
07-11-2017, 01:56 AM,
#3
RE: reset the invoice number counter
(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
Reply
07-11-2017, 11:16 AM,
#4
RE: reset the invoice number counter
(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.

Thanks
Swaminathan
Reply
08-18-2017, 06:52 PM,
#5
RE: reset the invoice number counter
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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)