Analysis inquiry and reporting

You can use Ledger Inquiry and Account Allocation to inquire on transaction analysis. You can see all the transactions for an account, or only those transactions within a specified range. You can use the overlay facility to display and report on all the analysis associated with your transactions.

Financial Analysis reports allow you to sort analysis codes on three levels. You can also define up to five selection options, which can be based on analysis dimension. So you might, for example report monthly sales by salesman, within country, within region.

Financial Statements and Financial Tables allow up to two levels of sorting, while Aged Analysis Listing allows up to five levels for sorting and selection.

If you are reporting across more than one database, the analysis structure in each database must be the same if reports produced by analysis dimensions are to contain meaningful data.

Hierarchical Analysis

It is possible to develop a hierarchical reporting structure using analysis subdimensions. Analysis codes can contain up to fifteen characters, each of which can represent a level in the hierarchy. By selecting subdimensions for reporting, you can effectively produce hierarchical reports. You can use one report structure to present your data in a variety of ways by using subdimensions.