Views:

The Column Layout page contains the fields that are shown in the following table.

Field
Description
Column No. Identifies the line for the column. The column numbers are optional and the same column number can be used on more than one line. The columns with the same number are then treated as a group. For example, if the column number is included in a formula, it will represent the sum of all the lines that share the column number.
Column Header The text in this field is printed on reports that include the column.
Column Type Determines how the amounts in the column are calculated. The amounts are calculated for the period defined in the Date Filter field on the report or page as follows:
  • Formula: The column displays amounts calculated from amounts in other columns in the account schedule. Enter the formula in the Formula field.
  • Net Change: The column displays the net change in the account balances during the period.
  • Balance at Date: The column displays the account balances at the end of the period.
  • Beginning Balance: The column displays the account balances at the beginning of the period.
  • Year to Date: The column displays the net change in the account balances from the start of the fiscal year to the end of the period.
  • Rest of Fiscal Year: The column displays the net change in the account balances from the end of the period to the end of the fiscal year in which the period ends.
  • Entire Fiscal Year: The column displays the net change in the account balances for the fiscal year in which the period ends.
Ledger Entry Type Determines the type of ledger entries that are included in the amounts in the account schedule column. The options are as follows:
  • Entries: The total is calculated from entries.
  • Budget Entries: The total is calculated from budget entries.
The type of ledger entry is based on the Totaling Type field on the account schedule line. The following options are used:
Totaling Type Entry Type
Posting Accounts General Ledger Entries/General Ledger Budget Entries
Total Accounts General Ledger Entries/General Ledger Budget Entries
Cost Type Cost Entries
Cost Type Total Cost Entries
Cash Flow Entry Accounts Cash Flow Ledger Entries/Cash Flow Forecast Entries
Cash Flow Total Accounts Cash Flow Ledger Entries/Cash Flow Forecast Entries
   
Amount Type
  • Determines the type of entries that are included in the amounts in the account schedule column. The options are as follows:
  • Net Amount: The amount includes both credit and debit entries.
  • Debit Amount: The amount includes debit entries only.
  • Credit Amount: The amount includes credit entries only.
Formula If Formula is selected as the Column Type, enter a formula for the line. The result of the formula is displayed in the column when the account schedule is printed.
Use this field to perform calculations on other columns. Other columns are referenced through their column number. The calculation symbols are the same as those used in the row formulas.
For example, to calculate the difference in percentage of the G/L entries and the budget entries, enter the following formula: 100*(Column No. of the G/L entry column/ Column No. of the G/L Budget entry column -1)
Show Opposite Sign If selected, debits in this column are shown in reports as negative amounts (that is, with a minus sign) and credits are shown as positive amounts.
Comparison Date Formula Date formula that specifies which dates must be used to calculate the amount in this column. Microsoft Dynamics NAV uses this formula to calculate the amount from the comparison period in relation to the period represented by the date filter on the report request.
Use the standard time periods of W(eek), M(onth), Y(ear), or Q(uarter) to create the formulas. For example, -1Y is the same period one year earlier.
Show
  • If selected, the amounts in the column are shown in reports. No more than five columns in an account schedule layout can be shown in the printed report. The options are as follows:
  • Always: All amounts in the column are always shown. This is the default value.
  • Never: The column does not appear on reports. It is used only for calculations.
  • When Positive: Only positive amounts (amounts that are positive before Show Opposite Sign is applied) are shown in the column.
  • When Negative: Only negative amounts (amounts that are negative before Show Opposite Sign is applied) are shown in the column.
Rounding Factor Rounding factor for amounts in the column. The default value is None, no rounding. Be aware that amounts on printed reports are rounded. For example, if 1000 is selected, all amounts are shown in thousands.
Amounts in the Acc. Schedule Overview Matrix page are not rounded.

Column Layout Options

The following table shows the additional columns that users can add to the Column Layout page by using the Choose Columns function.
Field
Description
Comparison Period Formula Specifies which accounting periods to use when users are calculating the amount in this column. An accounting period does not have to match the calendar. But each fiscal year must have the same number of accounting periods, even though each period can be different in length.
Microsoft Dynamics NAV uses the period formula to calculate the amount from the comparison period in relation to the period represented by the date filter on the report request.
The abbreviations for period specifications are as follows:
  • P = Period.
  • LP = Last period of a fiscal year, half-year, or quarter.
  • CP = Current period of a fiscal year, half-year, or quarter.
  • FY = Fiscal year.
For examples of formulas, press F1 to access Help for this field.
Business Unit, Global Dimensions, and Dimensions 3 and 4 Totaling fields used to create column layouts that show global dimension information across columns.
  • When the column layout is not linked to an analysis view, the global dimensions are available in the Column Layout page.
  • When the column layout is linked to an analysis view, the dimensions specified in the analysis view are displayed in the Column Layout page.
Analysis views are linked to column layouts in the Column Layout Names page, in the Analysis View Name field.

 

Keywords: Column Layouts, Acct Schedules, NAV,