Report Transformation

Report transformations provide a powerful way to customize standard reports by applying filters, grouping data, and reorganizing information to meet specific business requirements.

Each transformation you create can be saved and reused, making it easy to generate consistent reports for different departments, time periods, or analysis needs.

Key Features

You can filter reports by date ranges, specific employees, or custom field values on suppliers.

Reports can be organized into multiple columns (up to six) with custom mappings to reporting categories for flexible data presentation.

Advanced users can add JavaScript code to perform custom calculations or data manipulations, and include detailed instructions for other users.

Learn more about reporting categories: Reporting Categories

Name

Enter a name for this report transformation.

From

The starting date for the report period.

To

The ending date for the report period.

Employee

Select a specific employee to filter the report, or leave blank to include all employees.

Columns

Select the number of columns to display in the report.

Items2

Define the report items and map them to reporting categories for each column.

Accounting method

Check to enable accounting method selection for this report.

AccountingMethodOption

Select whether to use accrual or cash basis accounting for this report.

Suppliers

Check to enable grouping the report by suppliers.

SupplierCustomField

Select a supplier custom field to filter by.

SupplierCustomFieldValue

Enter the custom field value to filter suppliers by.

ForEachSupplier

Define report items to show for each supplier.

Employees

Check to enable grouping the report by employees.

ForEachEmployee

Define report items to show for each employee.

Script

Check to enable custom script processing for this report.

CustomScript

Enter custom JavaScript code to transform the report data.

Instructions

Check to add custom instructions to the report.

InstructionLines

Add step-by-step instructions that will appear on the report.

Published

Check to make this report transformation available to other users.