Balance sheet and P&L as per two different accounting pe

amankakar

Hi

One of my cliemt has its reporting to US for which the balance sheet and P & l has to be sent yearly and half yearly in June (as the accounting year in US is from Jan to Dec).Now as per Indian requirment he would be closing his books on 31st march (accounting year from apr-march).Now would he able to generate P&L and balance sheet from Jan-June and then for whole year Jan to Dec after closing the year in March.

Any suggestions would be really helpful

/regds

Alex_Chow

Umm.... It sounds like your problems can be solved by using Date Filter when you're running your reports.

Can you explain a little bit more about what you're looking for?

amankakar

actually I am using account schedules but in that u cannot define a custom date filter..like 0101..0203|0203..1003.you cannot use an OR sign and if i dont use that closing entries are included in the total

Alex_Chow

Unfortunately, the account schedule report will exclude the closing entries by default.

An alternative soliution without programming would be to export the account schedules in different months into Excel (from the account schedule overview screen), then do a copy and paste job.

amankakar

Well U have written it excludes by default,it actually includes it by default.That is infact the problem,i dont want closing entries to be included

Alex_Chow

amankakar wrote:

Well U have written it excludes by default,it actually includes it by default.That is infact the problem,i dont want closing entries to be included

Sorry, typo. What I meant to say was that it will NOT exclude by default.

Alex_Chow

On the same note, has anyone ever programmed something where you can exclude closing entries when printing account schedules?

song

Actually, it, by default does not include the Closing Date. To include the Closing Date, you need to set it up in the Column Layout by providing a check mark in the "Include Closing Date" field.

Alex_Chow

song wrote:

Actually, it, by default does not include the Closing Date. To include the Closing Date, you need to set it up in the Column Layout by providing a check mark in the "Include Closing Date" field.

What country is your database from?

In the US version, there is no such field in the account schedule column layout...

song

It is under Version AP 4.0 SP1, its in Table 334 field no. 13

ssingla

Indian Database also have the same field and aman can use the same to exclude the closing entries

Alex_Chow

song wrote:

It is under Version AP 4.0 SP1, its in Table 334 field no. 13

Dang it, you're brilliant!

How did I miss that field?! :-k

LibertyMountain

I am NAV2009 (no service packs) NA version. We have table 334 (Column Layout), but no field 13. Why would this be removed? I have the same issue where I want a column to exclude closing entries. I don't think it is possible in my version; but I'd like someone to prove me wrong.

sheilasalanguit

This is also my problem my India DB.
Financial Yr is Jan-Dec but my Tax yr is Apr-March.
Then the Account Schedule - column layout, the "include Closing Date" is not available in Nav2009.

Any fix available? :oops:

ssingla

I don't know why they removed the field in NAV IN/W1 version. The possible solution can be following :

a) Customize a report using Line Layout and custom column layout.
b) Customize Exclude Closing entry feature.
c) Use comparision date formula to get the transaction of 2 periods (not including closing date) and then use formula to sum them.