Business Central Account Schedule Column Layout

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.

Calendar Comparison

The date formula can contain a maximum of 32 characters (signs, numbers, and letters). Below are the following letters and the meaning:

• C: Current (end of)
• D: Day
• W: Week
• WD: Week Day (not work day). Week Day 1 is Monday.
• M: Month
• Q: Quarter
• Y: Year

Let’s take a look at some examples on what you can do with it.

Date	Date Formula	Result	Meaning
20 Apr 2022	CM	31 Apr 2022	End of Month
20 Apr 2022	-CM	1 Apr 2022	Beginning of Month
20 Apr 2022	1M	20 May 2022	Plus 1 Month
20 Apr 2022	1M+CM	5 May 2022	End of Next Month
20 Apr 2022	CM+D25	25 May 2022	Day 25th of the following month
20 Apr 2022	CM+45D	14 Jun 2022	45 Days after End of Month
20 Apr 2022	7D	27 Apr 2022	Plus 7 Days
20 Apr 2022	D7	7 May 2022	The next Day 7th
20 Apr 2022	D25	25 Apr 2022	The next Day 25th
20 Apr 2022	-D10	10 Apr 2022	The previous Day 10th
20 Apr 2022 (Wed)	WD1	25 Apr 2022	The next Week Day 1: Monday
20 Apr 2022 (Wed)	WD6	23 Apr 2022	The next Week Day 6 : Saturday
20 Apr 2022	1Q+1M+CM	31 Aug 2022	Plus 1 Quarter and 1 Month, End of Month
20 Apr 2022	1Y-CY	1 Jan 2023	Beginning of Next Year
20 Apr 2022	CY+1D	1 Jan 2023	Beginning of Next Year
20 Apr 2022 (Wed)	CW	24 Apr 2023	End of this week (Sunday)
30 Jan 2022	1M	28 Feb 2022	Next month (February 2022 only has 28 days)

 

 

Keywords: Column Layouts, Acct Schedules, NAV