Changing the QuoteWerks Document Number Prefix

Further to the post back in February about changing the three character prefix on a QuoteWerks Layout, a client has just asked about changing just the Q/O/I letter – specifically the “I” Invoice for a “C” Credit Note.

Here’s the formula we gave them for the QuoteWerks master installation Layout:


For a remote QuoteWerks user’s Layout, it would be:


The formulae use two key functions – ‘first’ and ‘last’ which both take two parameters:

  • string – the piece of text that we want to take part of
  • num – the number of characters that we want to take from string

Using these functions in this way, we are able to take the parts of the Document Number that we want to retain (the prefix and the number itself) and replace the Document Type Q/O/I with another letter.

Hope this helps!

The Hilltops IT QuoteWerks Support Team.

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 […]


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 […]


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. […]