Hello,
I am trying to run a financial statement for our fiscal month on Nov. 2010. I have specified the “From Date” and the “To Date” in the columns for each department. However, when I run the report is always shows year to date numbers up to “To Date” setting. It acts like the 'From date" is not there. Anyone else have this same issue? Please help.
Thanks…
Dave
Check the date intervals which you have specified in your financial statement.
Hi
We struggled with this problem too.
Apparently if you click “include opening” (transaction tab) on the column, BUT the ledger account does not have an opening transaction, for some reason it goes and summarize up all transactions in the fiscal year.
I would say it is a MS bug, or this is how they designed it (in case they made a mistake :)). We have not fixed it yet, so I cannot tell you where the bug exactly is (in terms of code) only left the “include opening” unchecked except for January an YTD columns. This is OK for now.
Hope it helped.
David
David,
Thanks for the response. This is exactly what the issue was. A counsultant of ours found and commented out the piece of code where is looks back to the first available “openening period”. Now all of our financial statements work correctly. I cannot tell you where this code was located as well.
Hello
Ok, glad you found it. Now it will be pretty easy for us to fix it too.
David
feel very happy that you fixed this issue. We are also getting the same issue. Can you pls help us to resolve the problem.