Skip to Content
author's profile photo Former Member
Former Member

Multiple queries on YTD and Balance Sheet accounts

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 06, 2012 at 03:16 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

            Add a comment
            10|10000 characters needed characters exceeded

          Before answering

          You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
          You must be Logged in to submit an answer.

          Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.