Skip to Content
0
Former Member
Oct 10, 2006 at 04:11 PM

Account not appearing in the query

18 Views

Hi All,

I am running a PCA report. After executing the query, I was not able to see one of the accounts. This account currently has budget amounts in it. It does not have any actuals in it as of now. Like for example if I am running the query just for accounts and amounts for fiscal period 001/2006 to 012/ 2007, I am able to see the first 12 cells empty and the next ones filled up with the budget amounts. But when I am running the same query for period 001/2006 to 012/2006, I am unable to see the account. I even tried by unchecking the suppress zero rows/columns. The user wants to see that account in the report even though it has got no data in it. I was just wondering if the account does not have actual values in it, will it not show up in the query for that particular period? Is there any setting that I can change to see this account also?