Reporting (57)
Reporting enables you to get any piece of data out of the system in any shape you like. Our tools allow you to work with that data, transform it, or export it to 3rd party systems.
Dataset View
The Dataset view enables you to view and edit the basic information about an overall Dataset. Datasets are used to easily query any information within the entire LemonEdge platform and return those results in a format you want. Each Dataset create a SQL Wrapper [see here] for retrieving the data and interacting with it throughout the LemonEdge platform.
Datasets
Datasets provide the ability to query every single field in the system, combine them into any shape of data you require, and even build up a library of useful queries that can be re-queryed by the dataset tool again.
GetGLRollup SQL Wrapper
This is a standard system SQL Wrapper [more info] provided by the platform and automatically upgraded on every new release. Do not change this SQL…
Enterprise Tools - Reporting
Reporting is our suite of tools aimed towards being able to retrieve all of your data from the system in any shape you want. You…
GL Rollup Classifications View
The GL Rollup Classifications view displays the data you want to aggregate from the period end data and rollup into this header. This view is always displayed in conjunction with the GL Rollup Headers Tree View. This provides an easy and consistent mechanism of editing the data associated with your hierarchical tree structure.
GL Rollup Header View
The GL Rollup Header View displays the basic information for a GL Rollup Header and is always used in conjunction with the GL Rollup Headers Tree View. This provides an easy and consistent mechanism of editing the data associated with your hierarchical tree structure.
GL Rollup Headers View
The GL Rollup Headers View contains a hierarchical tree structure allowing you to configure precisely the structure of your gl report and how account balances are rolled up.
GL Rollup View
GL Rollups enable you to create hierarchical GL specific reports that rollup account balances according to your reporting requirements. This enables you to easily create standard, and advanced reports, such as trial balance/p&l/capital account statements/etc.