gl_balance_F and Gl_other_F are not joined together for drill down????
DannyNov 16 2011 — edited Oct 23 2012Hi ,
Isnt it a standard practice in organizations to see the summary/ balance sheet and wanting to drill down to the next level as to see the journal lines? I am not interested in knwing how to drill through/down from Journal lines till subledgers as we dont hv them here. Trying to find the source for the details though.
So my main requirement is when the client checks the balance sheet, he sees the summary dollar amounts in the report. If he clicks on any one amount, he should be able to see how that amount was arrived to i.e. the details/journal line entries. IS that not delivered by default in OOTB Financial Analytics or am I missing something here? Are GL_BALANCE_F and GL_OTHER_F not joined internally?
IF the above is the case, how do I achieve what the client requires? Just a valid real time idea required. I dont need step by step instructions.
Just in case its not clear, an ATM transaction is the best example I can think of. If I see my balance increase/reduce from prev month, I take a mini transaction which shows where all I spent my money.
Ahsan, any feedback on this?
Thanks,
Dan