This content has been marked as final. Show 3 replies
What is the 'view' in your reports? Have you run the consolidation at November?What are the accounts for which you see these numbers?
It is common that opening balances are calculated based on the previous month closing balances. There could be some accounts which lookup the previous year values.
Thanks for your response.
The view in our reports in 'Periodic'. Yes we have run the consolidation at November too, but the issue goes on with December now, the next period. Too hide those values in December we are placing Conditional Format option to make the values view as 0.
The ghosted data you see in November when viewing reports on a "periodic" basis is expected. Your scenario is setup as YTD for the default data view. When data exists in October on a YTD view and the next month is 0, when looking at the Periodic view the November data will be the negative YTD October amount. This is commonly referred to as "ghosted" data. Technically there is no real data in November since none has been loaded, however the system still assumes that the November YTD 0 amount should also be calculated periodically.
To get around this you can build all your Income Statement reports in Smartview as YTD and then hide\group those columns. Then do caluclations for each month minusing February from January as an example. That will be your February periodic column. Do this for all months. This is a common way to approach it.
Edited by: user9929569 on Nov 20, 2012 12:35 PM