User login
|
|
Frontpage Sponsor
|
|
Google search
|
|
Poll
|
For ERP LN feature pack upgrade, what method of install are you using? Installation Wizard into existing VRC 38% Installation Wizard into new VRC 38% Manual into existing VRC 5% Manual into new VRC 19% Total votes: 42 |
Baanboard at LinkedIn
|

|
|
|
 |

1st May 2002, 12:26
|
Member
|
|
Join Date: Jan 2002
Posts: 31
|
|
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
|

1st May 2002, 15:53
|
 |
Junior Member
|
|
Join Date: Mar 2002
Location: texas
Posts: 7
|
|
Baan: 4c3 -
DB: sql -
OS: windows
|
did you try changing the batch status in the tables
__________________
tombaan
|

2nd May 2002, 08:38
|
 |
Guru
|
|
Join Date: Sep 2001
Location: South Africa
Posts: 386
|
|
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
|

3rd May 2002, 11:09
|
 |
Guru
|
|
Join Date: Sep 2001
Location: Nottingham
Posts: 483
|
|
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
|

3rd May 2002, 12:02
|
 |
Guru
|
|
Join Date: Sep 2001
Location: South Africa
Posts: 386
|
|
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
|

3rd May 2002, 12:42
|
 |
Guru
|
|
Join Date: Sep 2001
Location: Nottingham
Posts: 483
|
|
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
|

7th May 2002, 09:40
|
 |
Guru
|
|
Join Date: Sep 2001
Location: Nottingham
Posts: 483
|
|
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
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|