Date Filter Code Field, Cost Allocation Target Table
Specifies a filter to filter the calculation of the dynamic allocation base by dates.
Most dynamic allocation bases are dependent on a net change within a specific time period. It would not be practical, if this time period were set up with a typical date filter, because the date range would have to be newly defined before each allocation.
You use the Date Filter Code field to define a dynamic date range without using a static date. If the allocation bases are updated, the date filter is automatically updated by using the current work date. The current date is the default value for the work date. The following table shows predefined date filter codes in the first column and the date filter that would be calculated if the work date is Saturday, November 24, 2012 in the second column.
| Date filter code | Date filter on 22.11.2012 |
|---|---|
<Blank> |
No filter |
Week |
19.11.2012 - 25.11.2012 (Monday - Sunday) |
Last week |
12.11.2012 - 18.11.2012 |
Month |
01.11.2012 - 30.11.2012 |
Last Month |
01.10.2012 - 31.10.2012 |
Month of Last Year |
01.11.2011 - 30.11.2011 |
Year |
01.01.2012 - 31.12.2012 |
Last Year |
01.01.2011 - 31.12.2011 |
Period, Last Period, Period of Last Year, Fiscal Year, Last Fiscal Year |
According to accounting periods |
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 |
|---|---|
| Cost Allocation Target Table | General Ledger |
| Cost Allocation Target Table | General Ledger |
See Also
Reference
Other Resources
How to: Define Dynamic Allocations
Setting Filters for Dynamic Allocation Bases