Hello,

I am attempting to close year 2000 via session tfgld6203m000 - Close Year and I am receiving the message tfglds0364 "Total debit / credit not in balance".

Can anybody with the source tell me which figures in which tables are causing this problem.

I have closed the year provisionally tfgld6201m000 and I have also ran the session tfgld6202m000 to Balance Profit and Loss Accounts.

All periods in 2000 are also finally closed expect the last period.

I am running on Baan IV c3.

Regards
Neal Matthews
Intier Automotive - Project Leader

Hi Neal,

The for each ledger account the system the values from tfgld203 and the transactions from tfgld201. It creates a debit and credit balance for each account and adds these together. If the total is not = 0 then you get the error message. Did you run a rebuild on your ledger before trying to run the close?

Hi Maria,

I haven't run a rebuild as yet but I suspect this may be the best way to correct the inbalance in tables 201 and 203.

Can I run a rebuild on periods which are finally closed or do I need to speak to support ?

Cheers
Neal

Hi Neal,

I'm not 100% sure on that point but I doubt that anything will stop you from running the rebuild for finally closed periods.

We are still having problems closing year 2000 in company 002 but I believe that we may have a problem with our multicompany structure as our system has been set up with the following tables shared;

tfgld004 - Financial Companies
tfgld007 - Periods

Company 005 also required their opening balances for 2002 and here we managed to follow the year end process with a little more success and we actually managed to close year 2000 for company 005. This had the effect of closing all the periods and moving on the fiscal year for company 002 and now the current
fiscal year for the whole system is 2001 despite 2000 not being closed for all the companies apart from company 5.

I would suspect that the above tables shouldn't be shared.

Does anybody have any procedures closing year end in a multicompany setup.

Thanks
Neal Matthews
Intier Automotive - IT Support Analyst

Neal,
you are correct... tfgld007 Period Status and tfgld004 Financial Comapnies should not be shared. In our multi-company environ. the tfgld005 Periods table is shared but, not the two you mention. The typical set up for multi-finance/ multi-company is to share only key financial tables and no more. For a set of companies that have the same Chart of accounts / fiscal year-period structure These are:
tfgld002 Dimension descriptions
tfgld005 periods
tfgld006 end dates by year
tfgld008 Chart of Accounts
tfgld009 Demension ranges by ledger
tfgld010 Demensions
and tfgld450 Inetgration paramenters.
The rest of the finance tables are resident for EACH company. It is part of standard procedure to run the rebuild dimension/ledger history before you close a year. This is a session to correct any problems that may have occurred in the ledger over the year. Sometimes this is not apparent to your Finance community so.... Run the session for all periods in the year before closing. This can not be done once a period is finally closed! Which means if your periods are finally closed, you ought to call support and see if they have a workaround.
Once you get to that point, run a provisional close to see what the opening balances would be provisionally, do the rebuilds, run the provisional again and check to see if some Opening bals are different (ie, corrected). Run the autobalancing of P/L. The autobalance creates a batch that you must finalize. See if the batch exits, is balanced, and finalize it. THEN, run the close year session. This also creates a batch that you need to finalize. Always have someone in finance looking over the batch totals and balances if you are not intimately aquainted with the books and where the $$$ should be.
Hope this helps.
BB

Thanks for that BB,

One small question on the batches that are created by the P/L balance and the close year.

I would presume that the P/L balance batch is generated in the current fiscal year (the year you are closing), finalised and then the close year procedure creates another batch in the next fiscal year (the one you are moving into).

I will certainly be talking to support on this issue and also reviewing the logical table setup.

Regards
Neal Matthews
Intier Automotive

Yes, you are correct. the autobalance batch is for the closing year, the closing batch is for the new year.
cheers,
bb