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

QuoteWerks – More Than Just a Quoting Solution

Jun 19, 2025

When most people think of QuoteWerks, they immediately associate it with fast, accurate, and professional quoting. And while that’s certainly its core strength, QuoteWerks is far more than just a quoting tool. It’s a powerful business enablement platform that streamlines operations, enhances customer relationships, and integrates seamlessly with your existing systems. In this article, we’ll […]

READ MORE

Enhancing Customer Interaction with QuoteWerks QuoteValet and Tawk.to

Apr 28, 2025

At Hilltops IT, we pride ourselves on providing top-notch consultancy, support, training, and development services for QuoteWerks. As a dedicated reseller, we are always looking for innovative ways to enhance the functionality and improve User experience of QuoteWerks for our clients.   Introducing Real-Time Customer Engagement We are excited to announce a new customization that […]

READ MORE

Case Study: Revolutionizing Service Contract Quotations with Contract Calculator Integration

Feb 05, 2025

Discover how Tescan transformed their sales process with a cutting-edge Contract Calculator, seamlessly integrating SugarCRM and QuoteWerks to deliver faster, more accurate customer quotations.   Project Goals Tescan aimed to:   Key Actions   Overcoming Challenges   Results   Customer Testimonial “The new Contract Calculator has transformed our Service Sales process. We can now generate […]

READ MORE