Quotation lines from an Excel template
Since release 20261112 you can download an Excel template for a quotation’s items, fill one row per line with the answers to each configurator question, and upload it: each row is configured and priced exactly as Configure would, then added to the quotation.
CRM › Order to Cash › Selling › Quotations › New quotation, or a draft quotation › Lines tab.
Download the template
- Press Download template.
- Pick the items. The quotation’s items are listed to start with.
- Press Download template (Excel).
- There is one sheet per configurable item, with the columns Line no, Item no, one column per question of the item’s configurator model, Quantity and Unit price.
- Row 2 says what each column accepts.
- Standard items share one sheet.
Fill it in
- One row per line.
- Pick answers from each cell’s drop-down.
- Type a “Define” value as a number, for example a rod or stem length such as 225.
- Separate several answers with “;”, for example for Options.
Upload it
- Save the file and press Upload lines from file. Each row is configured and priced exactly as the line’s Configure would.
- Check the preview: each row’s configuration and price. 360° shows its bill of material, process and cost.
- Refused rows list the reason per column. Download the refused rows, correct them and upload again.
- Choose Append to the lines or Replace the lines, then press Add lines.
- Nothing is saved until the quotation is saved. On a draft quotation each line is added as Add line would.
- Configurations that are not used are cancelled.
Who can
Add or change on Quotations. Configurable items also need permission to create configurations.