Set up dynamic allocations

Completed

The dynamic allocation method is based on changeable values. For example, the number of employees in a cost center or the items sold of a cost object in a specific time period. There are nine pre-defined allocation bases and twelve dynamic date ranges. You can set different filters based on the allocation base.

The following table shows which filters are possible for different allocation bases and which values are valid in the No. Filter and Group Filter fields. Press F1 in the Date Filter Code field to read detailed descriptions.

Base No. Filter Date Filter Code Cost Center Filter Cost Object Filter Group Filter
G/L Entries G/L Account Yes Yes Yes N/A
G/L Budget Entries G/L Account Yes Yes Yes G/L Budget Name
Cost Type Entries Cost Type Yes Yes Yes N/A
Cost Budget Entries Cost Type Yes Yes Yes Budget Name
No of Employees N/A Yes Yes Yes N/A
Items Sold (Qty) Item No. Yes Yes Yes Inventory Posting Group
Items Purchased (Qty) Item No. Yes Yes Yes Inventory Posting Group
Items Sold (Amount) Item No. Yes Yes Yes Inventory Posting Group
Items Purchased (Amount) Item No. Yes Yes Yes Inventory Posting Group

Most dynamic allocation bases depend on a net change in 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.

The Date Filter Code field for the calculation of dynamic allocation bases lets users 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 date filter codes are predefined:

  • Empty

  • Week

  • Last Week

  • Month

  • Last Month

  • Month of Last Year

  • Year

  • Last Year

  • Period

  • Last Period

  • Period of Last Year

  • Fiscal Year

  • Last Fiscal Year

Set up dynamic allocations

Watch the following video for a quick demonstration of a dynamic allocation.