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:

first(documentheaders->docno,3)+”C”+last(documentheaders->docno,(len(documentheaders->docno)-4))

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

first(documentheaders->docno,4)+”C”+last(documentheaders->docno,(len(documentheaders->docno)-5))

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

🚀 Unlocking the Power of QuoteWerks Web API & AI Assistant: A Hands-On Video Series

Jul 02, 2025

At Hilltops IT, we’re always exploring new ways to help businesses streamline their quoting processes and integrate smarter tools into their workflows. That’s why we’re excited to share our latest YouTube playlist, where we dive into the capabilities of the QuoteWerks Web API and the built-in AI Assistant. This 3-part video series is a practical walkthrough of how to connect […]

READ MORE

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