Actuals amount in GL Cube does not match Account Inquiry or YTD Budget Report - Cube filtered by Account Status





Description of Issue

Actuals amount in the Revenues and Expense Cube (General Ledger Cube) does not match the amount showing in Account Inquiry or the YTD Budget Report for a set of accounts.

Cube Report is being filtered by Account status and only Active accounts were selected.



Context
  • Revenue and Expense Cube

  • General Ledger Cube

  • Account Inquiry

  • YTD Budget Report



Cause

Cube is being filtered by Account Status and only Active accounts are selected.



Resolution

When filtering by Account Status, make sure Active, Inactive and Closed is selected to ensure all accounts in the find set are included.

Additional Information

Please review the Master Article - Cubes Reporting with Excel for all Cubes related topics.