Troubleshooting Project reporting

If your actual and budget amount balances are zero on the project variance and project obligations list, verify these settings:

  1. Verify whether the cube is running and when the cube was last updated. Top list balances come from the cube.
  2. Verify that a budget is set up. The budget scenario must be in a Ready state. Open the scenario and verify that Project and Account are dimensions. Verify that there is data on the data list. Note the reporting basis that is associated with the budget.
  3. Verify that the chart of accounts structure selected in the budget reporting basis is the same structure selected for your summary account.
  4. Check project reporting settings. Amounts from the cube are determined by project reporting settings. We recommend using the same parameters as your reporting basis that is assigned to the budget.
  5. Verify that the costs you posted transactions to and the budgets created use a posting account that rolls up to the summary account. If the project budget was set up using the project dimension but no account, then the project ledger reports will retrieve balance budget amounts. However, the drill to the budget scenario details will not retrieve any budget records. The drill displaying the GeneralLedgerTotal will not have an account to display. A blank chart account is not a valid account. The most common issue is the selection of the summary account. Select the correct summary expense account from the chart of accounts. Your actual and budget expense accounts must rollup into that summary account. You must have the correct chart key field that is selected or the key value will be zeroes.
  6. Verify the reporting period selected. If you select LTD or YTD, you must select a summary or rollup period balance. A summary or rollup period balance has calendar periods with a _LTD or _YTD suffix. A summary or rollup period balance must be selected for the amounts to be displayed on the reports.
    Note: The rollup amounts are retrieved from the cube. The posting amounts are retrieved from the GeneralLedgerTotal business class.
  7. Check that there are actual balances. Use the Searches menu and the Total tab to search for project totals for the period and check whether there are posted amounts. Only amounts that have been posted will be displayed in the totals for actual amounts. Verify the entries have been journalized.
  8. Project managers must have user context for project reporting settings.
  9. LTD balances do not reflect prior year balances. To update balances for YTD and LTD, a Global Ledger role is required. Sign in as Controller and select Processing > Reporting Basis > Reporting Basis. Select the reporting basis used for the project reporting settings. Select Actions > Update Next Year Balance for the prior year. Then try the report again for the current year.
    See the Global Ledger User Guide.