Comparison Period Formula Field, Column Layout Table

Contains a period formula that specifies which accounting periods should be used to calculate 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 comparison period is based on the period of the start date of the date filter. The abbreviations for period specifications are:

Abbreviation	Description
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 example, FY[1..3] denotes first quarter of the current fiscal year

Examples of formulas:

Formula	Description
<Blank>	Current period
-1P	Previous period
-1FY[1..LP]	Entire previous fiscal year
-1FY	Current period in previous fiscal year
-1FY[1..3]	First quarter of previous fiscal year
-1FY[1..CP]	From the beginning of previous fiscal year to current period in previous fiscal year, inclusive
-1FY[CP..LP]	From current period in previous fiscal year to last period of previous fiscal year, inclusive

If you want to calculate by regular time periods, you must enter a formula in the Comparison Date Formula field.

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table	Location
Column Layout Table	General Ledger
Column Layout Table	General Ledger

See Also

Reference

Column Layout
Accounting Periods

Other Resources

Create and Set Up Account Schedules