Hi,

I am running the close year procedure for year 2003.I've done automatic balancing P&L and now I am trying to finally close last period with tfgld1206m000.I receive the next message:total debit/credit not in balance :debits=0.0000 credits=31153025.0.I've close 2 years before and this never happened.The difference in both years was at decimals.Trial balance for last period has column closing balance=0.0000.I have done rebuilding for all periods.I don't know what to do any more.Please help!

Thank you,
Mihaela

Hi Mihaela,
we had a similar problem a few years ago.
Sounds like there's a problem in tfgld106.
I'm on Vc but you should have a similar session like 'Print debit/credit amounts by document' (it's tfgld3410m000 in Vc).
Try it with checked option 'only differences'.
maybe it gives a hint on an unbalanced document.

Hope this helps

Hi Andreas,

Thank's for the hint.I try to run that session see if anything shows up.

Mihaela

There can also be a problem with the total of the dimension per ledger account in case a dimension is mandatory for that ledger account. Did you change parameters regarding dimensions per ledger account in the tables (e.g. from optional to mandatory??)

Hi Onno,

Yes I've changed dimensions from optional to mandatory for some P&L accounts.

The system is checking for the mandatory ones if all dimensions are filled. Create an (easy)sql query and find the ones with an empty dimension and fill them manually (ttaad4100) or with an update query. After that run the yearend once more.

Hi Mihaela,

1. If you are using Multicurrency please check for unbalanced documents in all home currencies. (This checks the transactions table tfgld106)

2. The error that you get comes from checking the balances tables tfgld201 / tfgld203.
so maybe you have to rebuild balances from transactions.

Regards,
Moshe

Hi Moshe,

I know that baan checks tfgld201/203 tables in session tfgld1206m000(close periods) but also this tables are used when the trial balance is printed(tfgld3402m000) and the closing balance is 0.00000(for 0 level accounts and also for highest level accounts),so where can be the problem?

Regards,
Mihaela

Hi Mihaela,

Another possibility is that there is a very small difference like 0.0001, that for the trial balance report is Zero but for the error check in tfgld1206 is more then the allowed tolerance in the compare check.

I found such problems while running the program in Debug Mode and then sometimes have to fix using GTM (ttaad4100).
I do not know if you can do it yourselves in your system?

If not BaaN support can do it.

Regards,
Moshe

Create a file with a query on the gld table.
Then execute the query in the file using qptool6.1 -c <companynumber> -f <filename>