Setup Invoices/Quotes numbering

SuiteCRM Forum - English Language Developer Collaboration
#1

Hello,

I have a problem with the numbering of new quotes :frowning: Someone has entered a high number (201700105) and now the new quotes are numbered from this number, and I need to return the numbering to the end of the original series (105) but I did not find it in the setup.

Can you advise? Thank you.

Radim

#2

If you have not created too many, perhaps you could manually change the numbers in the database?

Then the system will just add 1 to the highest number it finds?

#3

Maybe you can use this code

UPDATE 
  dbo.aos_quotes
SET
  number = 105 -- > Number you like 
WHERE
  dbo.aos_quotes.number > 201700000 -- > Large Number of quotattions 201700105

and then you need go to Admin -> AOS Settings
And change the vaue of "Initial Quote Number " for the value you wish

:wink: