Change QuoteWerks Document Number Prefix on a Layout

To change the QuoteWerks document number prefix on a Layout requires the ‘last’ formula to extract the actual number part of the reference.

The ‘last’ formula takes 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

So how many characters do we want to take? By default, QuoteWerks document numbering starts at 1000, so that’s 4 characters that we would need. But what happens when we get to 9999? When we hit 10000, we’ll need 5 characters.

We know that the prefix will always be 3 characters (or 4 characters on remote installations), plus the 1 character for the “Q”, “O” or “I”, so we need to take the length of our QuoteWerks document number and subtract 4 (or 5 characters for remote installations).

So, we are left with the following formula:

last(documentheaders->docno,(len(documentheaders->docno)-4))

For remote QuoteWerks installation Layouts, use:

last(documentheaders->docno,(len(documentheaders->docno)-5))

A different prefix can be applied by concatenating a different string to the formula:

"NEW"+last(documentheaders->docno,(len(documentheaders->docno)-4))

If you want to keep the “Q”, “O” or “I” document type part of the QuoteWerks document number prefix, then subtract 3 instead of 4:

"NEW"+last(documentheaders->docno,(len(documentheaders->docno)-3))

For more QuoteWerks Layout authoring and formula tip and tricks, please search our blog or contact development@hilltopsit.co.uk

Related Stories

See all

Case Study: Hilltops IT create Innovative Contract Calculator which Transforms Tescan’s Sales Process

Feb 05, 2025

Hilltops IT Consultancy Services Ltd. is excited to announce the successful implementation and expansion of a groundbreaking Contract Calculator for Tescan, a leading provider of scientific instrumentation. This innovative solution, developed by our dedicated team, seamlessly integrates SugarCRM and QuoteWerks systems, significantly enhancing the accuracy and efficiency of generating customer quotations. Read the full press […]

READ MORE

Hilltops IT Launches ConnectIt-SageOne Integration for QuoteWerks and Sage One Business Cloud

Feb 05, 2025

Hilltops IT Consultancy Services Ltd is excited to announce the launch of ConnectIt-SageOne, a powerful integration solution designed to seamlessly connect QuoteWerks with Sage One Business Cloud. This innovative product aims to enhance business efficiency, accuracy, and productivity by automating data transfer and synchronization between the two platforms. Read the full press release here! Get […]

READ MORE

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