Mass updating Document Statuses using QuoteWerks Medic Utility

We’ve had several enquiries over the years from QuoteWerks users wanting to update old Quote documents en-masse to archive them off with a “Closed” Status.

The QuoteWerks Medic Utility offers several pre-defined mass update options, but there’s no specific update to change a Document Status, so you’ll need to use the ‘Advanced Queries’ option within the QuoteWerks Medic Utility Database Manager screen.

The exact syntax for the query will depend on both the edition of QuoteWerks (Standard, Professional or Corporate) and exactly what you want to do, but as an example:

With Corporate re-hosted to SQL, the query will look something like:

UPDATE DocumentHeaders
SET DocStatus = ‘Closed’
WHERE (DocDate < ‘2011-01-01’)
AND (DocType = ‘QUOTE’)
AND (DocStatus <> ‘Lost’)
AND (DocStatus <> ‘Won’)
AND (DocStatus <> ‘Another Status Not To Be Changed’)

For Standard, Professional or Corporate not re-hosted to SQL, try:

UPDATE DocumentHeaders
SET DocStatus = DocStatus
WHERE (DocDate < #2011-01-01#)
AND (DocType = “QUOTE”)
AND (DocStatus <> “Lost”)
AND (DocStatus <> “Won”)
AND (DocStatus <> “Another Status Not To Be Changed”)

PLEASE NOTE that you should backup your QuoteWerks Document database BEFORE running any of these example queries! By their nature these queries may update many Dcouments in your database and the changes cannot be undone without restoring the database from a backup.

We hope that you find this tip useful. If there are other scenarios that you’d like to explore or tips for updating QuoteWerks Documents, then please comment below and one of the team will be pleased to help you out.

Thanks,

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

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