Support
Support

000307 : ConnectIt-Sage50 Document Item Field Macros (&QWDI_)

Created: 11 Nov 2014
Last Updated: 11 Nov 2014
Below is a list of all of the fields that are supported by the ConnectIt Document Item field &QWDI_ macros. In order to use these macros within the ConnectIt Configuration, the macro should be entered with the &QWDI_ prefix followed by the database field name. For example, to use the value from the CustomText01 field, then the macro should be entered as &QWDI_CustomText01.

The full list of field names available is as follows:
LineAttributes, LineNumber, LineType, QtyBase, QtyMultiplier1, QtyMultiplier2, QtyMultiplier3, QtyMultiplier4, QtyTotal, QtyGroupMultiplier, Description, Notes, Comment, ItemType, VendorPartNumber, Vendor, ManufacturerPartNumber, Manufacturer, PONumber, SONumber, OrderDate, SerialNumber, CloseProbability, PriceProfile, TaxCode, UnitCost, CostModifier, UnitPrice, PriceModifier, UnitList, ExtendedCost, ExtendedPrice, ExtendedList, SalesTax, ShippingAmount, TaxRate, AlternateUnitCost, AlternateUnitPrice, AlternateUnitList, AlternateExtendedCost, AlternateExtendedPrice, AlternateExtendedList, AlternateSalesTax, AlternateShippingAmount, ExtendedWeight, UnitOfMeasureFactor, UnitOfMeasure, UnitOfPricingFactor, UnitOfPricing, UnitWeight, CustomText01, CustomText02, CustomText03, CustomText04, CustomText05, CustomText06, CustomText07, CustomText08, CustomText09, CustomText10, CustomText11, CustomText12, CustomText13, CustomText14, CustomText15, CustomText16, CustomText17, CustomText18, CustomText19, CustomText20, CustomNumber01, CustomNumber02, CustomNumber03, CustomNumber04, CustomNumber05, CustomDate01, CustomDate02, CustomMemo01, CustomMemo02, ItemURL, VendorSourcing, PictureFile, RecurringStartDate, RecurringEndDate, SpecSheetFile

Search Again

See Also...

ID Article TitleLast Updated
000001 ConnectIt-Sage50 Step-by-Step Guide to Installation 10 Oct 2018
000003 ConnectIt-Sage50 Step-by-Step Guide to Configuration 10 Oct 2018

l: 0844 357 7360 | i: +44(0)1273 013695 | e: enquiries@hilltopsit.co.uk
© Hilltops IT Consultancy Services Ltd 2005-2025

Time saving solutions from Hilltops IT