Reviewing and Recalculating Process for Overhead Amounts
You use the Review and Recalculate Overhead program (P09J100) to review the overhead amount that was created as a result of Overhead Calculation (R09J408).
Using the P09J100 program, you can drill down and review the overhead information set up for a joint venture or a business unit.
For example, you can review and drill down the following:
Joint venture or business unit operational status that was used while calculating the overhead amount using fixed amount, fixed amount with escalation, and day rate methods.
Account group information that was used while calculating the overhead amount using fixed percent and fixed percent with sliding scale methods.
Escalation index information that was used while calculating the overhead amount using the fixed amount with escalation method.
Joint venture master and overhead rule information that was used while calculating the overhead amount using all the five methods.
General ledger transactions to understand how the system has calculated the overhead amount using the general ledger transaction for fixed percent and fixed percent with sliding scale methods.
Data selection date (Service/Tax Date or G/L Date) used to select transactions (Release 9.2 Update).
The Date Option header field in the Review General Ledger form provides information on whether the transactions are selected based on the G/L Date or the Service/Tax Date (Release 9.2 Update).
After you review existing overhead information, if the overhead calculation is incorrect, then you can recalculate the overhead after changing the method setup or operational status. In order to do so, you must first mark that specific overhead record to recalculate through the Row menu. Then, after updating the records in the respective setup programs, you can recalculate the overhead record through the Form menu. During recalculation, the system considers these applications: Escalation Index, Account Group, Overhead Methods, Joint Venture and Business Unit Operational Statuses, and General Ledger transactions. All the records marked for recalculation is re-evaluated, and updated calculation is displayed in P09J100 program.
You can delete a calculated record only when there are no journal entries associated with an overhead record.
Eligibility Criteria for Recalculation
Before you mark the overhead record for recalculation, you must take into account the following eligibility for recalculating overhead records:
If a journal entry is created for an overhead calculation and it is posted, then you will not be able to mark that record for recalculation even if the journal entry is voided.
If a journal entry is created for an overhead calculation and it is not posted, you must first delete the journal entry in order to mark the overhead record for recalculation.
If overhead is calculated using the fixed percent method or fixed percent with sliding scale method, where the basis is month, then the overhead record for any month using this method can be marked for recalculation. However, if the basis is year-to-month or inception-to-month, then only the latest overhead calculation record can be marked for recalculation.
If the records for a month in the P09J100 program are marked for recalculation, the system unlocks and enables you to change the operational status of a joint venture or business unit for that month.
The system also enables you to change the escalation index for future months and also for the month for which the record is marked for recalculation.
In the overhead rule assignment setup, an overhead rule assignment can always be inactivated.
If overhead is calculated using the fixed amount escalation index, the system unlocks and enables you to change only the future month index.
If all the overhead records that are using the account group are marked for recalculation, then the system allows you to change the account group setup.