The following macros are examples of the fields that can be used in the cover page, literature documents, and/or MS Word templates to pull the related information from QuoteWerks into the documents. This is not a complete list, full table information of the fields available can be found at DocumentHeaders Tables & Fields and DocumentItems Tables & Fields
Note: When the macros are placed in RTF cover pages, they must be double-underlined. You can double-underline text when specifying the font for the text. For Word documents, they need to have open and closed angle brackets (e.g. <<&DH_DocNo>>). |
&DH_AlternateCommissionAmount &DH_&AlternateCurrencyIdentifier &DH_&AlternateCurrencySymbol &DH_AlternateDepositAmount &DI_AlternateExtendedPrice &DH_AlternateGrandTotal &DH_AlternateGSTTax &DH_AlternateLocalTax &DH_AlternateProfitAmount &DH_AlternateShippingAmount &DH_AlternateSubTotal &DH_&AlternateTotalCost &DH_&AlternateTotalList &DH_AlternateTotalTax &DH_SoldToCompany &DH_SoldToContact &DH_&SoldToFirstName &DH_&SoldToLastName &DH_SoldToTitle &DH_SoldToAddress1 &DH_SoldToAddress2 &DH_SoldToAddress3 &DH_SoldToCity &DH_SoldToState &DH_SoldToPostalCode &DH_SoldToCountry &DH_&SoldToAddress &DH_&SoldToFullAddress &DH_&SoldToInLineAddress &DH_SoldToMobile &DH_SoldToPhoneExt &DH_SoldToPhone &DH_SoldToFaxExt &DH_SoldToFax &DH_SoldToEMail &DH_SoldToPONumber
&DH_ShipToCompany &DH_ShipToContact &DH_&ShipToFirstName &DH_&ShipToLastName &DH_ShipToMobile &DH_ShipToTitle &DH_ShipToAddress1 &DH_ShipToAddress2 &DH_ShipToAddress3 &DH_ShipToCity &DH_ShipToState &DH_ShipToPostalCode &DH_ShipToCountry &DH_&ShipToAddress &DH_&ShipToFullAddress &DH_&ShipToInLineAddress &DH_ShipToPhoneExt &DH_ShipToPhone &DH_ShipToFaxExt &DH_ShipToFax &DH_ShipToEMail
&DH_BillToCompany &DH_BillToContact &DH_&BillToFirstName &DH_&BillToLastName &DH_BillToTitle &DH_BillToAddress1 &DH_BillToAddress2 &DH_BillToAddress3 &DH_BillToCity &DH_BillToState &DH_BillToPostalCode &DH_BillToCountry &DH_&BillToAddress &DH_&BillToFullAddress &DH_&BillToInlineAddress &DH_BillToMobile &DH_BillToPhoneExt &DH_BillToPhone &DH_BillToFaxExt &DH_BillToFax &DH_BillToEMail
&DH_IntroductionNotes &DH_ClosingNotes &DH_InternalNotes &DH_PurchasingNotes
&DH_&SalesRepFullName &DH_&SalesRepAddress &DH_&SalesRepFullAddress &DH_&SalesRepFullAddressA &DH_&SalesRepAddress1 &DH_&SalesRepAddress2 &DH_&SalesRepAddress3 &DH_&SalesRepCity &DH_&SalesRepMobilePhone &DH_&SalesRepState &DH_&SalesRepPostalCode &DH_&SalesRepCountry &DH_&SalesRepPhone &DH_&SalesRepPhoneExt &DH_&SalesRepFax |
&DH_FOB &DH_ShipVia &DH_Terms
&DH_ContractStartDate &DH_ContractEndDate &DH_CustomText01 &DH_CustomText02 &DH_CustomText03 &DH_CustomText04 &DH_CustomText05 &DH_CustomText06 &DH_CustomText07 &DH_CustomText08 &DH_CustomText09 &DH_CustomText10 &DH_CustomText11 &DH_CustomText12 &DH_CustomText13 &DH_CustomText14 &DH_CustomText15 &DH_CustomText16 &DH_CustomText17 &DH_CustomText18 &DH_CustomText19 &DH_CustomText20 &DH_CustomDate01 &DH_CustomDate02 &DH_CustomNumber01 &DH_CustomNumber02
&DH_&SalesRepFaxExt &DH_&SalesRepTitle &DH_&SalesRepEmail &DH_&SalesRepFullNameOrUserName &DH_&SalesRepInlineAddress &DH_&SalesRepMobilePhone &DH_SalesRep &DH_&SalesRepFullName &DH_DocNo &DH_ProjectNo &DH_DocName &DH_DocType &DH_DocStatus &DH_DocDate &DH_DocDueDate &DH_ExpirationDate &DH_GrandTotal &DH_&TotalCost &DH_&TotalList &DH_SubTotal &DH_TotalTax &DH_LocalTax &DH_LocalTaxRate &DH_GSTTax &DH_ShippingAmount &DH_CommissionAmount &DH_&PaymentOptions &DH_&PaymentOptions_IndicateSelected &DH_ProfitAmount &DH_&ProfitPercent &DH_&PreparedByAddress &DH_&PreparedByAddress1 &DH_&PreparedByAddress2 &DH_&PreparedByAddress3 &DH_&PreparedByCity &DH_&PreparedByCountry &DH_&PreparedByEmail &DH_&PreparedByFax &DH_&PreparedByFaxA &DH_&PreparedByFaxExt &DH_&PreparedByFullAddress &DH_&PreparedByFullAddressA &DH_&PreparedByInlineAddress &DH_&PreparedByFullNameOrUserName &DH_&PreparedByFullName &DH_&PreparedByPhone &DH_&PreparedByPhoneExt &DH_&PreparedByPhoneWithExt &DH_&PreparedByPhoneWithExtA &DH_&PreparedByMobilePhone &DH_&PreparedByPostalCode &DH_&PreparedByByState &DH_&PreparedByTitle &DH_&PreparedByPicture &DH_&PreparedByElectronicSignature &DH_&PreparedByAddress &DH_&QuoteValetTotalPaymentsMade &DH_&LastName &DH_LastModified_Date &DH_LastModified_Time &DH_&QuoteValetCustomerFacingURL &DH_&QuoteValetPeerReviewURL &DH_&QuoteValetApprovalURL &DH_&URLToOpenDocument
&DI_&Line1ManufacturerPartNumber &DI_&Line1VendorPartNumber &DI_&Line1Description &DI_&LineItemCount
|
&SYS_InstallPath &SYS_ExecPath &SYS_DataPath &SYS_AppVersion, &SYS_AppBuildNumber &SYS_AppEdition &SYS_BackendDBType &SYS_InstallUniqueID &SYS_NowA &SYS_NowB
&APP_CustomMessage1 &APP_CustomMessage2
&APP_LicenseeCompany &APP_LicenseeContact &APP_LicenseeAddress1 &APP_LicenseeAddress2 &APP_LicenseeAddress3 &APP_LicenseePhone &APP_LicenseePhoneExt &APP_LicenseeFax &APP_LicenseeFaxExt &APP_LicenseeEmail &APP_&LicenseeInlineAddress &APP_&LoggedInUserAddress &APP_&LoggedInUserFullAddress &APP_&LoggedInUserFullAddressA &APP_LoggedInUserAddress1 &APP_LoggedInUserAddress2 &APP_LoggedInUserAddress3 &APP_LoggedInUserCustomText01 &APP_LoggedInUserCustomText02 &APP_LoggedInUserCity &APP_LoggedInUserState &APP_LoggedInUserPostalCode &APP_LoggedInUserCountry &APP_LoggedInUserName &APP_LoggedInUserFullName &APP_&LoggedInUserFullNameOrUserName &APP_&LoggedInUserInlineAddress &APP_LoggedInUserTitle &APP_LoggedInUserPhone &APP_LoggedInUserPhoneExt &APP_&LoggedInUserPhoneWithExt &APP_&LoggedInUserPhoneWithExtA &APP_LoggedInUserFax &APP_LoggedInUserFaxA &APP_LoggedInUserFaxExt &APP_LoggedInUserEmail &APP_LoggedInUserMobilePhone
&APP_OurLocationCompany &APP_OurLocationContact &APP_&OurLocationAddress &APP_&OurLocationFullAddress &APP_OurLocationAddress1 &APP_OurLocationAddress2 &APP_OurLocationAddress3 &APP_OurLocationCity &APP_OurLocationState &APP_OurLocationPostalCode &APP_OurLocationCountry &APP_OurLocationPhoneNumber &APP_OurLocationPhoneExt &APP_OurLocationFaxNumber &APP_OurLocationFaxExt &APP_OurLocationEmail &APP_&LoggedInUserFullNameOrUserName &APP_&LicenseeWebsite
&COVER_RE &COVER_Message &SYS_NowA &SYS_NowB &SYS_TodaysDate &SYS_TodaysDateA &SYS_TodaysDateForSQL &SYS_FirstDayOfThisWeekForSQL &SYS_FirstDayOfLastWeekForSQL &SYS_FirstDayofCurrentMonthForSQL &SYS_FirstDayofNextMonthForSQL &SYS_FirstDayofLastMonthForSQL &SYS_YesterdaysDateForSQL &SYS_30DaysAgoForSQL &SYS_45DaysAgoForSQL &SYS_60DaysAgoForSQL &SYS_90DaysAgoForSQL |
Macros for Only Microsoft Word Templates
These macros are only used in Microsoft Word Documents and will not work in RTF Cover Pages, Literature, or Spec Sheet :
Document Headers: Document Items:
|
&DI_&QtyGroupMemberTotal_Actual &DI_&QTYTOTAL_ACTUAL &DI_&QTYGROUPMULTIPLIER_ACTUAL &DI_&ProfitAmount &DI_&RecurringRevenueAnnual &DI_&RecurringRevenueAnnualWithTax &DI_&RecurringRevenueMonthly &DI_&RecurringRevenueMonthlyWithTax &DI_&RecurringRevenueQuarterly &DI_&RecurringRevenueQuarterlyWithTax &DI_&RecurringRevenueWeekly &DI_&RecurringRevenueWeeklyWithTax &DI_&RecurringRevenueWithTax &DI_RecurringRevenueWithTax
|
Macros NOT supported for Microsoft Word Templates
This list displays the macros that are not yet available for the Microsoft Word Templates.
|
|
Word merging also supports the DocumentItems CustomText01-CustomText14 Sections. This is similar to the ItemType Sections already supported in the Word Merging Feature. This enables you to separate out products using different classifications on your Microsoft Word based Quote or Proposal. For instance, if you use CustomText01 to hold the values of either Onsite or Remote assistance, you could have all Onsite assistance labor items on page 5 of a Word document by encasing it in "<<Begin.CustomText01.Onsite>>" and ending it with "<<End.CustomText01.Onsite>>". The Description field for each line could be printed in between these tags with "<<CustomText01.Onsite.&DI_Description>>". You could do the same for Remote by replacing Onsite in the macros.
QuoteValet Macros
Visit the QuoteValet Macros topic to see a list of all macros supported in QuoteValet.