About / Blog

Change QuoteWerks Next Document Number

QuoteWerks Document Numbering

The QuoteWerks next Document number can be changed by editing the QuoteWerks DocumentNumbering table.

For QuoteWerks Standard or Professional editions, the DocumentNumbering table is in the docs.mdb Access database; for QuoteWerks Corporate edition which has been re-hosted to SQL Server, the DocumentNumbering table is in the QuoteWerks SQL Server database.

Updating QuoteWerks Document Numbering

NOTE: please ask all users to exit QuoteWerks, take a full backup of QuoteWerks and the database before continuing!!!

NOTE: when changing the QuoteWerks Document numbering, please ensure that the numbers are changed to a value which is greater than the current values or you may get duplicate Document numbers and unexpected results from QuoteWerks and reporting.

Using Access or SQL Server tools

If you are familiar with Access or SQL Server Enterprise Manager tools, then the QuoteWerks next Document number for QUOTE, ORDER and INVOICE Documents, plus the next Project ID and Template numbers can be changed by updating the values in the DocumentNumbering NextQuoteNumber, NextOrderNumber, NextInvoiceNumber, NextProjectIDNumber and NextTemplateNumber fields.

Using QuoteWerks Medic Utility

If you are not familiar with Access or SQL Server Enterprise Manager tools, then the QuoteWerks Medic Utility provides an interface to update the required numbers:

  1. Open the QuoteWerks Medic Utility (see Windows Start menu | All Programs | QuoteWerks | Tools & Information | Medic Utility option.
  2. Select the Utilities menu | Data Manager for QuoteWerks Databases option.
  3. Enter the Administrator password when prompted and click OK.
  4. Click the Advanced Queries tab
  5. Select the System Database:docs (Access backend only).
  6. Copy / paste one of the following SQL statements into the SQL Command Text window and press the Start button:

UPDATE DocumentNumbering set NextQuoteNumber = 9999
UPDATE DocumentNumbering set NextOrderNumber = 9999
UPDATE DocumentNumbering set NextInvoiceNumber = 9999
UPDATE DocumentNumbering set NextProjectIDNumber = 9999
UPDATE DocumentNumbering set NextTemplateNumber = 9999

NOTE: the QuoteWerks database field name is slightly confusing in that the value in the field is not the ‘Next’ Document number – the next document number is gets 1 (one) added to it. So, in the example above, the actual next Document number in QuoteWerks would be AAAQ10000, AAAO10000, AAAI10000.

More information

We hope that you found this tip for QuoteWerks sales quoting solution useful. For more QuoteWerks tips and assistance, please get in touch!

Related Stories

See all

Copying the QuoteWerks QuoteValet URL to the Windows clipboard

Jan 31, 2019

The script below provides a way to quickly and easily copy the QuoteValet document URL for the current open document in QuoteWerks to the Windows clipboard. This can then be pasted into an email or other document to send to your customer. To implement the script, we suggest copy/pasting the below code into a text […]

READ MORE

User is already logged into QuoteWerks message

Jun 18, 2015

This is a fairly rare issue when working with newer versions of QuoteWerks, but it can be very frustrating when it does occur! The issue may occur if a User’s system crashed or they switched off their PC without first logging out of QuoteWerks and requires you to manually delete the “.lck” file associated with […]

READ MORE

QuoteWerks F2 lookup and double click does not work

May 19, 2015

This is another reasonable common query that our clients have which is usually due to the particular User’s Preference settings that is logged in on a particular workstation. Furthermore it will usually affect the User on any workstation that they try and if they log in as a.n.other User then QuoteWerks will probably behave as expected. Ref. […]

READ MORE