SMART Data Template
SMART Data Template defines without code which data other apps take from a Business Central record and how it is calculated. A data template combines tables as variables, named mapping codes and expressions with filters, aggregates and output formatting, and SMART apps such as SMART Generic Excel Report and SMART EDI use it for document export, integration and reporting.
At a glance
- Publisher: SMART business
- Installation: installed automatically with the solutions that use it: SMART Generic Excel Report
- Interface languages: English, Polish, Ukrainian
- Licensing: Licensing Policy
Capabilities
- One template can read data from several related tables: the record the calling app hands in, the records linked to it (for example the customer of a document), fixed records such as a company bank account, and document lines one by one.
- Each named value is calculated by a formula that combines constants, fields, other values and totals such as sums, counts and joined lists, and a transformation rule can convert it.
- Values come out already formatted, for example as a decimal with a set number of digits or a date in a given format, so the calling app gets text it can use as is.
- A formula reads as one line and the structure of a template is drawn as a tree, so a template can be understood without opening every setting.
- A check of the whole template lists errors and warnings before it is used, without changing anything.
- Templates move to another company, environment or test database as one JSON file and can be copied under a new code.
Get started
- SMART Data Template — how a template works, then create it with its tables, filters, mapping codes and expressions, and validate it.
- SMART Generic Excel Report — for example, build an Excel report on a data template with SMART Generic Excel Report.