Quote/Order Items

Some notes on Accelerator mail merge with quotes/orders.

The item table must not have rows with multiple other rows.

EG
image.png 51.9 KB View full-size Download

The item table must be isolated from any totals
EG
image.png 113 KB View full-size Download


If you just merge using view vlineitems data will not be formatted.
EG
image.png 23.9 KB View full-size Download


You need to create your own view to get the data
EG
image.png 195 KB View full-size Download
CREATE VIEW vCustomQuoteItems
AS
select QuIt_LineItemID, prod_code, quit_productid,quit_description,
quit_linenumber, prod_name,quit_orderquoteid,
FORMAT(quit_quantity,'N2')as quit_quantity,
uom_description as quit_uomid,
FORMAT(quit_quotedprice,'N2') as quit_quotedprice,
FORMAT(quit_quotedpricetotal,'N2') as quit_quotedpricetotal,
uom_description
from vLineItemsQuote
left join vUOM on UOM_UOMID=quit_uomid

In the Accelerator web.config change the setting from
image.png 9.69 KB View full-size Download

To

image.png 9.27 KB View full-size Download

Now when we merge we see
image.png 28 KB View full-size Download

Please note that your columns may be different and this view is just an example. You may need to customise this some more.