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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th May 2004, 14:41
mihaelagr's Avatar
mihaelagr mihaelagr is offline
Member
 
Join Date: Jun 2002
Location: Romania,Cluj-Napoca
Posts: 41
mihaelagr is on a distinguished road
Baan: Baan IV c4,sp18 - DB: Sql server 2000 - OS: Windows Server 2003
Angry finally close period 12

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
Reply With Quote
  #2  
Old 13th May 2004, 16:01
Andreas's Avatar
Andreas Andreas is offline
Senior Member
 
Join Date: Nov 2001
Location: Hannover
Posts: 263
Andreas is on a distinguished road
Baan: ERP LN FP5 - DB: Oracle 10g - OS: AIX, SLES
Print debit/credit amounts by document

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
__________________
Jazz is not dead, it just smells funny!
F.Z.
Reply With Quote
  #3  
Old 14th May 2004, 07:19
mihaelagr's Avatar
mihaelagr mihaelagr is offline
Member
 
Join Date: Jun 2002
Location: Romania,Cluj-Napoca
Posts: 41
mihaelagr is on a distinguished road
Baan: Baan IV c4,sp18 - DB: Sql server 2000 - OS: Windows Server 2003
Thank's

Hi Andreas,

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

Mihaela
Reply With Quote
Sponsored Links
  #4  
Old 14th May 2004, 07:52
onnoboer's Avatar
onnoboer onnoboer is offline
Member
 
Join Date: Jul 2002
Location: Veenendaal, The Netherlands
Posts: 43
onnoboer is on a distinguished road
Baan: BaanIV_c, BaanV_c - DB: Oracle, Tbase - OS: NT, Unix
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??)
__________________
Onno Boer

Nulla tenaci invia est via
Reply With Quote
  #5  
Old 14th May 2004, 08:18
mihaelagr's Avatar
mihaelagr mihaelagr is offline
Member
 
Join Date: Jun 2002
Location: Romania,Cluj-Napoca
Posts: 41
mihaelagr is on a distinguished road
Baan: Baan IV c4,sp18 - DB: Sql server 2000 - OS: Windows Server 2003
hi

Hi Onno,

Yes I've changed dimensions from optional to mandatory for some P&L accounts.
Reply With Quote
  #6  
Old 14th May 2004, 09:18
onnoboer's Avatar
onnoboer onnoboer is offline
Member
 
Join Date: Jul 2002
Location: Veenendaal, The Netherlands
Posts: 43
onnoboer is on a distinguished road
Baan: BaanIV_c, BaanV_c - DB: Oracle, Tbase - OS: NT, Unix
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.
__________________
Onno Boer

Nulla tenaci invia est via
Reply With Quote
  #7  
Old 18th May 2004, 12:05
Moshe Almog's Avatar
Moshe Almog Moshe Almog is offline
Member
 
Join Date: Sep 2002
Location: Israel
Posts: 64
Moshe Almog is on a distinguished road
Baan: B4c ; B50 - DB: Oracle - OS: Unix
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
Reply With Quote
  #8  
Old 18th May 2004, 13:37
mihaelagr's Avatar
mihaelagr mihaelagr is offline
Member
 
Join Date: Jun 2002
Location: Romania,Cluj-Napoca
Posts: 41
mihaelagr is on a distinguished road
Baan: Baan IV c4,sp18 - DB: Sql server 2000 - OS: Windows Server 2003
Hi

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
Reply With Quote
  #9  
Old 18th May 2004, 14:43
Moshe Almog's Avatar
Moshe Almog Moshe Almog is offline
Member
 
Join Date: Sep 2002
Location: Israel
Posts: 64
Moshe Almog is on a distinguished road
Baan: B4c ; B50 - DB: Oracle - OS: Unix
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
Reply With Quote
  #10  
Old 18th May 2004, 15:01
onnoboer's Avatar
onnoboer onnoboer is offline
Member
 
Join Date: Jul 2002
Location: Veenendaal, The Netherlands
Posts: 43
onnoboer is on a distinguished road
Baan: BaanIV_c, BaanV_c - DB: Oracle, Tbase - OS: NT, Unix
Create a file with a query on the gld table.
Then execute the query in the file using qptool6.1 -c <companynumber> -f <filename>
__________________
Onno Boer

Nulla tenaci invia est via
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
Period Status Integration Jochen Finance, Invoicing and Integration 2 15th March 2004 15:22
Financial fiscal period 13 of year 2002 ? Lucy Jih Finance, Invoicing and Integration 4 30th January 2003 11:32


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


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