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

See Also