TRANXACT.AI Aide

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

  1. Press Download template.
  2. Pick the items. The quotation’s items are listed to start with.
  3. 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

  1. Save the file and press Upload lines from file. Each row is configured and priced exactly as the line’s Configure would.
  2. Check the preview: each row’s configuration and price. 360° shows its bill of material, process and cost.
  3. Refused rows list the reason per column. Download the refused rows, correct them and upload again.
  4. 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.