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.