Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
20%
Total votes: 35

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 1st May 2002, 13:26
rdheeraj rdheeraj is offline
Member
 
Join Date: Jan 2002
Posts: 31
rdheeraj is on a distinguished road
Integration Transactions are Not Posted to Finance

Hello Everybody,

When we try to post integration transactions from productio(SFC) to Receipt(Finance), baan does not post the entry and on Seeing Integration error log it report " Batch being used try again" and " cannot open batch for posting to finance". We tried to repost these entries for 5-6 times but the entries are not posted and are recorded in error log. Can anybody pls explain the rectifcation.

Waiting for Earliest Reply

Dheeraj
Reply With Quote
  #2  
Old 1st May 2002, 16:53
tombaan's Avatar
tombaan tombaan is offline
Junior Member
 
Join Date: Mar 2002
Location: texas
Posts: 7
tombaan is on a distinguished road
Baan: 4c3 - DB: sql - OS: windows
did you try changing the batch status in the tables
__________________
tombaan
Reply With Quote
  #3  
Old 2nd May 2002, 09:38
MariaC's Avatar
MariaC MariaC is offline
Guru
 
Join Date: Sep 2001
Location: South Africa
Posts: 386
MariaC is on a distinguished road
Baan: BaanIV, BaanV, BaanERPLN - DB: SQL, Oracle - OS: Unix, Windows
Yes, I have come across this problem recently.

This happens because there is a finance integration batch somewhere in your system which is in use. In my case this happened in a multi site environment.

To solve:

Find the original company num, transaction origin, financial transaction, date and transaction type of the transaction.

Look on tfgld430 for the batch info for that original company

Find the batch and check it's status. If it is in use change to free and rerun integration. It should post now.
__________________
Regards
Maria
Reply With Quote
  #4  
Old 3rd May 2002, 12:09
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Guru
 
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
Hello,

I currently have an identical problem with an integration batch in our system.

Error log contains the message "Batch being used; try again", "Cannot open batch for posting to finance".

The transaction status is being shown as errorneous in Display Integration transactions. I have checked out the associated batch by looking at tfgld410 but the batch in question is fully finalised apart from this one transaction. See screen dump.

Any assistance appreciated.

Regards
Neal Matthews
Intier Automotive - IT Support Analyst
Reply With Quote
  #5  
Old 3rd May 2002, 13:02
MariaC's Avatar
MariaC MariaC is offline
Guru
 
Join Date: Sep 2001
Location: South Africa
Posts: 386
MariaC is on a distinguished road
Baan: BaanIV, BaanV, BaanERPLN - DB: SQL, Oracle - OS: Unix, Windows
Hi Neal,

You need to check in tfgld430 for the date on which the integration transaction occured. There is probably a batch on that date which doesn't have the correct status
__________________
Regards
Maria
Reply With Quote
Sponsored Links
  #6  
Old 3rd May 2002, 13:42
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Guru
 
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
Hi Maria,

Our tfgld430 shows two dates;

Posting date : 02-05-2002 Batch : 2390
Posting date : 03-05-2002 Batch : 2389

All records in tfgld100 and tfgld101 for these batches have a status of Ready.

Am I missing something ?

Cheers
Neal
Reply With Quote
  #7  
Old 7th May 2002, 10:40
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Guru
 
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
Sol from support. Transactions already posted. Status field in tfgld418 incorrect.

"The transactions for production order 922059 have already been present in tfgld106. There was also no record in the tfgld416. Hence it was only necessary to change the the status of the transation in the table tfgld418 to "posted". The error log has been deleted as well."

Cheers
Neal
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
Integration Transactions faditimo Finance, Invoicing and Integration 1 18th February 2004 14:33
Purchase Integration with Finance in Baan ERP 5.0b baaniac Finance, Invoicing and Integration 3 25th June 2003 13:15
Audit trail from Finance to distribution Nazeem Finance, Invoicing and Integration 14 11th October 2002 05:18
Large No. of Integration Transactions despite Compression turned on baaniac Finance, Invoicing and Integration 5 16th January 2002 04:20
Project-Finance Integration sajitkrishnan Finance, Invoicing and Integration 14 9th November 2001 15:08


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


©2001-2018 - Baanboard.com - Baanforums.com