Specifies the columns for your analysis report - both the visible columns that will appear in the report and the intermediary columns that are used for calculation only. An analysis report consists of a column template and several columns. You can set up several column templates in the Analysis Column Template table.
In the Analysis Report window, you can view analysis reports using the various templates that you have set up for the lines and columns.
List of Fields in the Table
The following table lists the fields in this table.
| Analysis Type Code Field, Analysis Column Table |
Inventory |
| Ledger Entry Type Field, Analysis Column Table |
Inventory |
| Show Field, Analysis Column Table |
Inventory |
| Item Ledger Entry Type Filter Field, Analysis Column Table |
Inventory |
| Column No. Field, Analysis Column Table |
Inventory |
| Show Opposite Sign Field, Analysis Column Table |
Inventory |
| Keep Comparison Period Scope Field, Analysis Column Table |
United Kingdom Local Functionality |
| Invoiced Field, Analysis Column Table |
Inventory |
| Column Type Field, Analysis Column Table |
Inventory |
| Rounding Factor Field, Analysis Column Table |
Inventory |
| Analysis Column Template Field, Analysis Column Table |
Inventory |
| Analysis Area Field, Analysis Column Table |
Inventory |
| Column Header Field, Analysis Column Table |
Inventory |
| Comparison Period Formula Field, Analysis Column Table |
Inventory |
| Comparison Date Formula Field, Analysis Column Table |
Inventory |
| Value Type Field, Analysis Column Table |
Inventory |
| Value Entry Type Filter Field, Analysis Column Table |
Inventory |
| Formula Field, Analysis Column Table |
Inventory |
| Line No. Field, Analysis Column Table |
Inventory |
| Analysis Type Code Field, Analysis Column Table |
Inventory |
| Ledger Entry Type Field, Analysis Column Table |
Inventory |
| Column Type Field, Analysis Column Table |
Inventory |
| Show Field, Analysis Column Table |
Inventory |
| Item Ledger Entry Type Filter Field, Analysis Column Table |
Inventory |
| Column No. Field, Analysis Column Table |
Inventory |
| Show Opposite Sign Field, Analysis Column Table |
Inventory |
| Invoiced Field, Analysis Column Table |
Inventory |
| Rounding Factor Field, Analysis Column Table |
Inventory |
| Analysis Column Template Field, Analysis Column Table |
Inventory |
| Analysis Area Field, Analysis Column Table |
Inventory |
| Column Header Field, Analysis Column Table |
Inventory |
| Comparison Period Formula Field, Analysis Column Table |
Inventory |
| Comparison Date Formula Field, Analysis Column Table |
Inventory |
| Value Type Field, Analysis Column Table |
Inventory |
| Value Entry Type Filter Field, Analysis Column Table |
Inventory |
| Formula Field, Analysis Column Table |
Inventory |
| Line No. Field, Analysis Column Table |
Inventory |
| Keep Comparison Period Scope Field, Analysis Column Table |
United Kingdom Local Functionality |
See Also
Reference
Analysis Columns
Analysis Column Template
Other Resources
Analysis Report
How to: Set Up Analysis Column Templates