Resolution:
These instructions assume that pools are set to calculate on a Year-To-Date (YTD) basis.
Billing:
- Go to Projects > Cost and Revenue Processing > Cost Pool Setup > Cost Pools.
- Query the Cost Pools for the prior Fiscal Year.
- Using the Pool Rates subtask, input the YTD Provisional in the last period of the year.
- Go to Projects > Billing > Calculate Billings > Calculate Retroactive Billings.
- Select Indirect Costs and correct FY. In the Select Period for Rates box, enter the period that hold the new rates that were entered in step 1.
- Calculate the retroactive bill.
- This function compares what was previously billed to what should be billed with the modified YTD rates and creates a bill for the variance.
- Post the billing in the current year. Basically, this is a current year billing for cost from a prior year.
Revenue and PSR's: This has two options:
Option #1: Correct the revenue ITD for the projects but leaves the Indirect Costs as previously recorded:
- Go to Projects > Cost and Revenue Processing > Cost Pool Setup > Cost Pools.
- Query the Cost Pools for the prior Fiscal Year.
- Using the Pool Rates subtask, input the new rate in the YTD Target and > or YTD Actual rates.
- Manually calculate the impact of the rate change (the amount of the Retroactive Bill could possibly be used).
- Go to Projects > Project Setup > Revenue Setup > Basic Revenue Info and enter a revenue adjustment in the current year.
- Compute and post revenue in the current year > period.
Option #2: Correct the revenue ITD for the projects and change the Indirect Costs previously recorded:
- Go to Projects > Cost and Revenue Processing > Cost Pool Setup > Cost Pools.
- Query the Cost Pools for the prior Fiscal Year.
- Using the Pool Rates subtask, input the new rate in the YTD Target and/or YTD Actual rates.
- Compute Burden for the last period of prior Fiscal Year for all projects.
- Compute Revenue in the final period of the FY - Do not post.
- Determine the amount of additional Revenue to be posted by either previewing the Revenue Posting Journal or Updating the PSR's.
- Enter a Revenue Adjustment in the Basic Revenue Screen to reverse this additional Revenue amount.
- Compute Revenue in the final period of the FY.
- Validate there is no revenue to post when zero revenue amounts are included.
- Update PSR's and Create Project Report Tables.
- Review reports to ensure the reported Revenue agrees to what was posted to the General Ledger in the prior FY.
- Run Update Prior Year History.
- Enter a Revenue Adjustment in the current FY to offset what was entered previously.
- Compute and Post Revenue in the current FY.
Knowledge Base Reference Number: KBA #60825