on 02-06-2012 2:21 AM
I needed bit more clarity on these YTD and Balance Sheet accounts. Hope some expert out there could chime in.
1) I have my application as PERIODIC
2) My Input Schedule page key is set to PERIODIC
3) If my row expansion has BALANCE SHEET accounts and col expansion has 24 month periods
Q1) Now when user enters 500 for Jan and 750 for Jun does system treat this as periodic data or YTD
Q2) If I have to report Year/Qtr balance for these accounts how should i structure my report. Does my page key should have YTD or PERIODIC.
Q3) For above input data, when i run a report with col expansion as YR.TOTAL what should i expect 750 or 1250. Assume my report has page key as PERIODIC. What difference should it make if i have the page key as YTD in the report.
I am not seeing consistent results and i expected 1250 but I am actually getting 0.
-S
Edited by: ShilpaK on Feb 6, 2012 3:22 AM
Hi,
Q1) Now when user enters 500 for Jan and 750 for Jun does system treat this as periodic data or YTD
Since you are sending values for balance sheet accounts system will treat this as YTD (YTD of Jun - 750)
Q2) If I have to report Year/Qtr balance for these accounts how should i structure my report. Does my page key should have YTD or PERIODIC.
If you enter values only up to Feb and design report by Qtr, syste will not show any thing irrespective of measure.
(Assumption Qtr1 - Jan to Mar). You can see Qtrly report only after values entered for all periods in each Qtr.
Same way for Year also. If you want to see Yearly report then you should choose time as YR.DEC.
Q3) For above input data, when i run a report with col expansion as YR.TOTAL what should i expect 750 or 1250. Assume my report has page key as PERIODIC. What difference should it make if i have the page key as YTD in the report.
***You will see only 0 because the values are not filled till DEC. To see YTD values for given data you should choose YR.DEC.
--> To see 750 as YTD value you should select time as Yr.DEC.
--> Along with above data if you send data for Dec as 1000 then you can see 1000 for Yr.TOTAL. Until you filled up DEC values system will return 0 for Yr.TOTAL.
Hope it helps...
regards,
Raju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.