Integration Transactions are Not Posted to Finance

rdheeraj · #1 1st May 2002, 12:26

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

tombaan · #2 1st May 2002, 15:53

did you try changing the batch status in the tables

MariaC · #3 2nd May 2002, 08:38

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.

Neal Matthews · #4 3rd May 2002, 11:09

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

MariaC · #5 3rd May 2002, 12:02

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

Neal Matthews · #6 3rd May 2002, 12:42

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

Neal Matthews · #7 7th May 2002, 09:40

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