TAG /

Selecting details of Optional Items from QuoteWerks database

Jan 11, 2019

The below T-SQL statement provides a template for selecting details of Optional Items from the QuoteWerks SQL Server database. If you have any questions or if you’d like an equivalent for an Access backend, then please email development@hilltopsit.co.uk. SELECT OH.SetName AS PrimaryProductCode, PP.[Description] AS PrimaryProductDescription , OI.PartNumber AS OptionalProductCode, PO.[Description] AS OptionalProductDescription FROM QuoteWerks.dbo.OptionsHeaders AS […]

READ MORE

Querying the QuoteWerks Database for selected Line Items

Jan 11, 2019

In our years of working with QuoteWerks and providing integration solutions, it’s been a fairly common requirement to query the QuoteWerks database for Line Items on a Document which are either non-optional or optional and selected. How to do this relies on understanding the bitwise logic around the Document Items table LineAttributes field. More information […]

READ MORE

Modifying the QuoteWerks Document Open screen grid columns (pre v5.2)

Apr 29, 2015

This can be achieved by modifying your User.ini file settings in the OpenWindowGridSettings section. Firstly, identify the name of your User.ini file by opening the Tools menu | My Preferences screen; you will find the ini file name at the bottom left: Next, CLOSE QUOTEWERKS and locate the INI file which will be in the […]

READ MORE