Hi,

Could someone give me any hints on how to solve the inbalance preventing the year close?

Case history:

1) When trying to close the year I got the following error message:

"Total profit and loss balance is not yet zero; debits = 2901287287.692600, credits = 2901287287.682800"

-> DR > CR by 0.0098

2) I ran a "home made" query which indicates in which period there is an inbalance:

Period 1: CR > DR by 0.0002

Period 4: DR > CR by 0.01

3) I corrected the inbalances by:

- running correction program otfcor9996, which rouns off amounts to the second decimal (Period 1)

- via GTM increasing the CR of the inbalanced document (which I identified by running session tfgld3410m000 "Print Debit and Credit Amounts by Document"

4) I ran Session tfgld3203m000 "Rebuild Opening Balances/History from Transactions" for all periods.

5) When trying to close the year I get the same error message, but with different amounts:

"Total profit and loss balance is not yet zero; debits = 116355698.070000, credits 116355698.080000"

-> Problem 1: CR and DR amounts are completely different from the ones in the first error message.

-> Problem 2: This time it is the CR which is higher than the DR

(Note that the 0.0002 inbalance has been fixed)

Any help would be greatly appreciated!

Erik
:confused:

Hi Erik Konrath,

Your first step must be to run the session tfgld3203m000 "Rebuild Opening Balances/History from Transactions".

With this rebuild you becomes completely sure about the real difference.

Solution one:
If the difference still exists search for the period.
If you know the period search for the document.
By GTM (tfgld106 and maybe VAT and ACR and ACP tables too) you can change the document (be sure the document becomes not out of balance)
Rebuild again the totals and try to close the year again.
Is it not possible for you to find the wrong period and/or document, than you can create a query which is making totals by document. Be sure that the amounts are printed with 4 or more digits behind the dot. Import this in excel and search for the not balanced documents. If you find them modify them by GTM and rebuild your totals again.


Solution two (If nothing helps):
By using GTM you can change a total table (tfgld200 series) for only 0, 01.
You must do it for the ledger totals but of the ledger and dimension totals too.
After this actions try to close the year again.

With Regards,
Jaap Roos
0031 6 51 13 65 99

Hi Jaap,

Thank you for your answer. Unfortunately I think that I tried everything you suggested:

Suggestion 1: If the difference still exists search for the period.
If you know the period search for the document.
By GTM (tfgld106 and maybe VAT and ACR and ACP tables too) you can change the document (be sure the document becomes not out of balance)
Rebuild again the totals and try to close the year again.
Is it not possible for you to find the wrong period and/or document, than you can create a query which is making totals by document. Be sure that the amounts are printed with 4 or more digits behind the dot. Import this in excel and search for the not balanced documents. If you find them modify them by GTM and rebuild your totals again.

Answer 1: I did retrieve the documents which are not balanced, included one with a digit after the 4th decimal.
Through the correction program otfcor996 I could correct the unbalanced document with the digit after the 4th decimal and I corrected another document with an inbalance of 0.01 via GTM in table tfgld106, by increasing the Credit to 0.01. I then rebuilt all periods. Then, when I ran the session tfgld3410m000 and our "home made" query, no unbalanced documents was found.


Suggestion 2: By using GTM you can change a total table (tfgld200 series) for only 0, 01.
You must do it for the ledger totals but of the ledger and dimension totals too.
After this actions try to close the year again.

Answer 2: I tried that way as well.

Any other ideas?

Thanks for your help.

Erik

Hi Erik,

If you modify a tfgld200 serie table this must effect the message while closing the year. If not you modified the wrong table and you must search for another tfgld201/2/3/4 table.

If you found the correct one than have a look at the difference in the error message. Based on this difference you can calculate what the exact correction must be.

Another possibility is too that the software is not up to date and isn't calculating correct. If this is the case than you need a software fix.

yes, year closing isn't in all case easy.

With Regards,
Jaap Roos

Hello again Jaap,

I hope I have found the solution, but I would like your opinion on this:

In table tfgld201 Credit and Debit for the top parent account are balanced, however in table tfgld203 there is an opening balance of -0.01. (ledger A/C = Debit).

I think that the initial inbalances are actually fixed, but that the system, after checking the balance of CR and DR of finalized transactions, adds the opening balance to the balance of finalized transactions occurring during the year.

At present when trying to close the year the system tells me that DR < CR by 0.01. So what if I change the opening balance of -0.01 to 0?

My guess is that it would solve the problem, but hopefully it won't screw up the system elsewhere.

What do you think of this?

Cheers,

Erik

Hi Erik,

You can always test this and see what happens.

If the error message is changing you know that you are working at the correct table.

Is this balance for the year to be closed or for the next year?

Regards,
Jaap

It is the balance of the year to be closed. note that the opening balance of the next year is also out by 0.01.

I'm going to try it and I'll let you know.


Erik

Hi Erik,

Are there any results?

With Regards,
Jaap

Hi Jaap,

Unfortunately my last attempt to solve the problem failed miserably again...frustration is rising...

I am quite sure that the problem lies with the opening balance, but I still have to find a way of fixing it...

Cheers,

Erik

Hi Erik,

Bad answer!

I do not have another idée how to solve the problem.

A suggestion can be that I have a closer look into the system and based on that analyses maybe I can advise a corrective action.

Thats my latest suggestion.


Regards,
Jaap Roos

Hi Jaap,

Problem is solved!

Basically I hadn't read the error messages properly...

The firts message was "Total debit/credit not in balance...."

After I had made the corrections in tfgld106 to the unbalanced document, the second message was:

"Total profit and loss balance is not yet zero..."

What happened is that by solving the balance problem I created another problem in the P&L, because instead of increasing a Balance sheet ledger account by 0.01, I increased a P&L ledger account!

Thanks anyway for your time.

Bedankt,

Erik

Hi Erik,

Nice your problem is solved.

Have success.

With Regards,
Jaap Roos