Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 3rd September 2003, 12:14
Erik Konrath Erik Konrath is offline
Member
 
Join Date: Nov 2001
Location: Cork (Ireland
Posts: 32
Erik Konrath is on a distinguished road
Baan: BaaNIVc4 -
Unhappy Year close

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
Reply With Quote
  #2  
Old 3rd September 2003, 12:37
Jaap Roos Jaap Roos is offline
Member
 
Join Date: Jun 2002
Posts: 36
Jaap Roos is on a distinguished road
Some Help

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
Reply With Quote
  #3  
Old 3rd September 2003, 12:59
Erik Konrath Erik Konrath is offline
Member
 
Join Date: Nov 2001
Location: Cork (Ireland
Posts: 32
Erik Konrath is on a distinguished road
Baan: BaaNIVc4 -
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
Reply With Quote
  #4  
Old 3rd September 2003, 13:18
Jaap Roos Jaap Roos is offline
Member
 
Join Date: Jun 2002
Posts: 36
Jaap Roos is on a distinguished road
Some other help

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
Reply With Quote
Sponsored Links
  #5  
Old 3rd September 2003, 16:28
Erik Konrath Erik Konrath is offline
Member
 
Join Date: Nov 2001
Location: Cork (Ireland
Posts: 32
Erik Konrath is on a distinguished road
Baan: BaaNIVc4 -
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
Reply With Quote
  #6  
Old 3rd September 2003, 16:33
Jaap Roos Jaap Roos is offline
Member
 
Join Date: Jun 2002
Posts: 36
Jaap Roos is on a distinguished road
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
Reply With Quote
  #7  
Old 3rd September 2003, 16:38
Erik Konrath Erik Konrath is offline
Member
 
Join Date: Nov 2001
Location: Cork (Ireland
Posts: 32
Erik Konrath is on a distinguished road
Baan: BaaNIVc4 -
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
Reply With Quote
  #8  
Old 5th September 2003, 09:59
Jaap Roos Jaap Roos is offline
Member
 
Join Date: Jun 2002
Posts: 36
Jaap Roos is on a distinguished road
Hi Erik,

Are there any results?

With Regards,
Jaap
Reply With Quote
  #9  
Old 5th September 2003, 11:31
Erik Konrath Erik Konrath is offline
Member
 
Join Date: Nov 2001
Location: Cork (Ireland
Posts: 32
Erik Konrath is on a distinguished road
Baan: BaaNIVc4 -
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
Reply With Quote
  #10  
Old 5th September 2003, 11:36
Jaap Roos Jaap Roos is offline
Member
 
Join Date: Jun 2002
Posts: 36
Jaap Roos is on a distinguished road
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
Reply With Quote
  #11  
Old 11th September 2003, 18:59
Erik Konrath Erik Konrath is offline
Member
 
Join Date: Nov 2001
Location: Cork (Ireland
Posts: 32
Erik Konrath is on a distinguished road
Baan: BaaNIVc4 -
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
Reply With Quote
  #12  
Old 11th September 2003, 20:45
Jaap Roos Jaap Roos is offline
Member
 
Join Date: Jun 2002
Posts: 36
Jaap Roos is on a distinguished road
Hi Erik,

Nice your problem is solved.

Have success.

With Regards,
Jaap Roos
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Close Year Provisional - Opening Balances in P&L Accounts Scott2001 Finance, Invoicing and Integration 2 30th October 2004 06:34
Year End Close Scott2001 Finance, Invoicing and Integration 0 5th December 2003 21:57
Close Year mid-year, 2 in one year ? BaanTech Finance, Invoicing and Integration 1 24th September 2002 21:48
close year tombaan Finance, Invoicing and Integration 1 1st May 2002 17:11
close year Julian Hsu Finance, Invoicing and Integration 3 19th December 2001 10:26


All times are GMT +2. The time now is 04:55.


©2001-2017 - Baanboard.com - Baanforums.com