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.