ConnectIt Advanced Macros are available for the values settings in the ConnectIt Configuration Email tab | Send tab, Documents tab | Purchase Document tab | Overrides tab and Documents tab | Sales Document tab | Overrides tab. They support &Conc_, &Calc_ and &Date_ type macros for Document Header, Product/Service and Group Header Line Types only - other Line Types support the existing &QW.._ macros only.
&Conc_ macros allow various values to be concatenated together, for example using the Sage field NOTES_3 and value "&Conc_This is the Document Number: &QWDH_DocNo; and Name: &QWDH_DocName;" would write the sentence "This is the Document Number: AAAI1000 and Name: Monthly service charges" to the Sage document Notes 3 field. This may also be used at Line Item level; please note the use of the standard &QWDH_ macro with a semi-colon (";") at the end of the field name in this example which should also be used for other &QW.._ macros.
&Calc_ macros allow a calculation to be done between two (or more) fields, for example using the Sage field NOTES_3 and value "&Calc_(&QWDH_ProfitAmount; / &QWDH_SubTotal;) * 100" would write the percentage profit to the Sage document Notes 3 field. This may also be used at Line Item level, so for example using the Sage field UNIT_PRICE and value "&Calc_(&QWDI_CustomNumber01; / &QWDI_QtyTotal;)" would Override the Unit Price written by ConnectIt and replace it with your own calculated Unit Price. Please note that if you were to Override the Sage UNIT_PRICE field, then you would also want to Override the Sage NET_AMOUNT field in order to ensure consistency and that the values ‘add up’. Please also note that the use of the standard &QWDH_ macro with a semi-colon (";") at the end of the field name in this example which should also be used for other &QW.._ macros.
&Date_ macros allow certain dates to be specified, for example "&Date_FirstDayOfMonth" will return the first day of the current month. Other &Date_ macro suffixes available are: Today, LastDayOfMonth, FirstDayOfLastMonth, LastDayOfLastMonth, FirstDayOfNextMonth and LastDayOfNextMonth.
|
