Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
reset the invoice number counter
07-10-2017, 11:32 PM
Post: #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
Find all posts by this user
Quote this message in a reply
07-11-2017, 01:50 AM (This post was last modified: 07-11-2017 04:18 AM by falkoner.)
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
07-11-2017, 01:56 AM
Post: #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
Find all posts by this user
Quote this message in a reply
07-11-2017, 11:16 AM
Post: #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
Find all posts by this user
Quote this message in a reply
08-18-2017, 06:52 PM
Post: #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

http://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
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)