P and L to not include closing entries.

jknauft

I have a client that needs to run a P & L across fiscal years. They closed their fiscal year on 6/30/07 and now want to run the P & L from 07/01/06..10/16/07. What happens is the "C" closing entries are included in the amounts. I've tried unchecking the "include closing entries" checkbox in the column layout but it isn't making any difference. Any ideas?

Jon

Alex_Chow

You have to set the filter to be:

7/1/06..6/30/07|7/1/07..10/16/07

ssingla

You have to set the filter to be:

7/1/06..6/30/07|7/1/07..10/16/07

Filters like this are not needed.

If you are using "account schedule" and "analysis by dimension" check that the analysis view includes the entry for the period 07/01/06 - 06/30/07.
Include Closing entry will negate the balance in the P&L so dont use it.

jknauft

Alex/Sandeep,

I had already tried using the filter like you suggested and it wouldn't take it. For some reason, unchecking the Include Closing Entries doesn't make any difference either. The closing entries are still showing.

Jon

jknauft

Just realized that I hadn't mentioned that this was in account schedules! :shock:

ssingla

I have tested and every thing is working fine. Didn't marked the "Include Closing Entry" and it shows data for the last year. Check for the analysis view data. Does that include the data for the last year.

Alex_Chow

jknauft wrote:

I have a client that needs to run a P & L across fiscal years. They closed their fiscal year on 6/30/07 and now want to run the P & L from 07/01/06..10/16/07. What happens is the "C" closing entries are included in the amounts. I've tried unchecking the "include closing entries" checkbox in the column layout but it isn't making any difference. Any ideas?

Jon

What version are you using? I remember that this was a problem with the 3.x releases.

jknauft

4.0 SP3. I'm using the account schedule and when I put in a range of 070106..101707 where the closing entries were made on 06/30/07 it doesn't seem to make a difference whether I have the include closing entries checked or not.

I checked the code behind the Account Schedule and it looks like the checking of the Include Closing Entries affects the ending date. It doesn't look like it will filter out the closing entries if they are in the middle of the range.

Jon

Alex_Chow

Yep, I checked codeunit 8, and it looks like it doesn't differentiate if you have a closing date in between the date ranges if you're using Net Change...

ssingla

Analysis by Dimension works fine but Account Schedule :oops:

When I faced the similar situation couple of years back I used 2 compariosn formula couloums and 1 formula coulum with the comparison formula column as Show "Never".

sjrowe3

Please advise.