Comparison Date Formula Field, Column Layout Table
Contains a date formula that specifies which dates should 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.
For example, if the field is set to -1Y, Microsoft Dynamics NAV compares to the same period 1 year earlier.
If you want to calculate by accounting periods, you must enter a formula in the Comparison Period 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
Other Resources
Create and Set Up Account Schedules
How to: Enter Dates and Times