Incorrect Allocation of Expense from the Dynamic Expense Allocation Schedule

There was a change in the 2020.2 version on the calculation of the allocation of expenses using Dynamic Allocation. Previously, the unapproved Statistical Journal Entries were included in the computation of the Allocation Schedule. Starting 2020.2, only the approved Statistical Journal Entries will be considered in the allocation of the expenses using Dynamic Allocation. Since there were unapproved Statistical Journal Entries in the previous period, those were excluded in the current run of the Allocation Schedule.

In order to resolve this, the user has the following options:

1. Approve all the pending  Statistical Journal Entries; or
2. Create Statistical Journal Entry manually to account for the change in the headcount as catch-up adjustment

If user does not want to re-open the accounting period, user can choose the second option and perform below steps:

A.  Get the balance of Statistical Account used in the Dynamic Allocation as basis as of the period

1. Go to Transactions > Financial > Statistical Schedule > List
2. View Headcount
3. Click the Saved Search link to load the Saved Search
4. Click  Return to Criteria
5. Criteria tab: Add the following filters:
• Date Created = on or before the date
• Subsidiary if using OneWorld
6. Click Submit
7. Export the search result

B. Create a Saved Search for the list of approved Statistical Journal Entries to get the current balance per Department

1. Navigate to Reports > Saved Search > All Saved Searches > New
2. Select Transaction
3. Criteria tab: Add the following filters:
• Account = Statistical Account
• Status = Journal: Approved for Positing
• Date = on or before the date
• Subsidiary
4. Result tab: Add the following fields:
• Department
• Summary type : Group
• Amount
• Summary type : Sum
5. Search Title: Enter desired name
6. Click Save & Run

C. Create manual Statistical Journal Entries

1.  Navigate to Transactions > Financial > Make Statistical Journal Entries
2. Enter values on below fields:
• Date
• Posting Period
• Unit of Measure 
• Account
3. Click Save
4. Approve the  Statistical Journal Entries

D. Generate the Allocation Journal Entry

1. Go to  Transactions > Financial > Allocation Schedule > List
2. View the Allocation Schedule
3. Click History tab
4. Click Journal Entry link generated from previous run which is incorrect
5. Edit Journal Entry
6. Hover on Actions
7. Click Delete
8. Edit the Allocation Schedule
9. Set the Next Date to the previous period that needs to be re-run
10. Click Save
11. Click Create Journal Entry