Hi
I am trying to create colums layout of Accounts Schedule Report.
What i want to achieve is that that if i run a report from 01/04/2012…31/07/2012, then i want to setup a colum called LastYearToDate which which should show the result of netchange in GLEntries for 01/04/2011…31/07/2011. I have tried to use -1Y but it only works for one calander month, or quater or half yearly, but it does not work for a specific date range which is outside the norms.
Any help would be grately appreciated
Best Regards
Ajay Sharma
Look at these report for guidence
Report No 7
Report No 37
Thanks Amol
Thank you for your quick response, but where do i Find Reports 7 and 37.
Best Regards/Ajay Sharma
Go to Financial Management–>General Ledger–> Reports–>Financial Statement–>
Report no 7 → Trial Balance /Previous Year
Report 37 → Balance Comp-Prev Year
Thanks Again.
That looks good. However what i am trying to achieve is the similar formula in one of my own report Profit and Loss Report Created in General Ledger>>Analysis & Reporting>>Account Schedules. In this profit and loss account report, i want to add one more field with heading “LastYeartoDate”. in the Date Comparison formula field, i have entered as -1Y. This shoould calculate the net change in gl entries for the same period last year. It works, for a month, quater, week or year, but it does not work for a specifici period. For Example in Date range if i put show me Profit and Loss account for 01/04/2012…31/07/2012, then “LastYeartoDAte” colum does not show the result for last year same period.
Best Regards/Ajay Sharma
With Comparison Formula it really doesn’t matter what exact date you put in DateFilter – while date is in year’s range, and you set CF = -1Y, you will get previous year’s 31/Dec. (depending of what you have in Column Type & Amount Typre).
If your Acc.Periods = Calendar months, you can use FY[1] for Jan, FY[2] for Feb etc, (FY{1…3] for Q1) in Comp.Period formula.