Hello,

when closing December it throughs following message:

"Not all integration transactions are posted for year 2006 perid 12"

Error in tfgld416
Transaction origin: Purchase
Financial Transaction: Result

I checked tfgld416 but there is no record for this period for Purchase result
I check also tfgld418 and there is no unposted transaction for Purchase result.

What's the problem? Any idea?

thanks,
Immanuel

Strange, you get the message that there are records and there is no record with dates in december 2006 in tfgld416. I would suggest rebuilding period 12 with tfgld3203m000

Hi Immanuel,
The error could only be due to unposted integration transactions. Now this could be an integration batch which got stuck while posting and so i recommend you to check the tfgld109 or tfgld100 table or going through session Select Batches for Finalization {tfgld1110m000}. I guess one of the run numbers might show "In Use" in tfgld109 or one of the batches not Finalized in table tfgld100..

A passing look at Display Integration Transaction Log {tfgld4532m000} wouldnt hurt..

sk

Hello,

thanks for you posts.

I checked the tables tfgld100, 101 (finalized), 102 (empty), 109 (no inuse) and I can't find any problem.

--I also ran the rebuild as suggested, and it didn't help either.

There are integration transaction (SFC etc) but they are not intgerated.
The system says that it is Purchase result and there are for sure no purchase result pending, could it be that it gives a wrong message?

According to the message and the review you have done I think you have transactions with dates in 2007 affecting 12 2006 period, you can check that in session tfgld4410m000 asking for transactions not posted of 12 2006 period.
Please check table tfgld415 too.

Paola

According to the message and the review you have done I think you have transactions with dates in 2007 affecting 12 2006 period, you can check that in session tfgld4410m000 asking for transactions not posted of 12 2006 period.
Please check table tfgld415 too.

Paola

Hello Paola,

that's was the reason, I had transactions in 2007 for 2006. I posted them and the problem was solved.

Thanks!

Immanuel

For future reference, you can also run session otfcor0615 to get a list of unposted transactions for a period.

Roy

Roy,

what is the session name for otfcor0615?

Here a screen image of the session.

Roy

I don't have this session for some reason (BaanIVc2 or c4)

You can only activate the session by "Run Program" and type in otfcor0615.