Goal: Generate custom MS Excel-based reports from a calculation logic
Use case example: Download a customer-specific price list from multiple sources (Price Lists, Price Records etc)
- Pricefx API method that executes the logic and creates an Excel output.
- Use the
formulamanager.executeformula method and append the output type and the name of the template:
For more details, see the API documentation.
Generic Excel Output
Corresponding Excel output example:
Logic elements of the matrix format type will be rendered in a separate sheet. The tab's name reflects the matrix element name.
Similarly as for Quotes and Price Lists, we can enhance the generic output and save it as an Excel template. Such a template can be assigned to any generic logic.
Please refer to Publishing Templates for more details.