mpchheda
20th December 2008, 11:38
While changing the status of Period from Open to Close through sesion "Maintain Period Status" tfgld0107m000 system is giving me error (attached) "Not all intergration transaction (Sales Invoice) are posted for the year 2007 period 10".
Also tried to close the period through session "tfgld1206m000" Close period - One by one . It has closed for ACP but stuck in ACR.

There is not pending batch to finalise. No ocuments seen. All errors are deleted. No cle in tfgld416. An urgent support is needed.
I am on BaanIVc4- SQL7 on Window NT.

After Running correction program, i ahve got a output which shows me lots of record. Like
Comp. No. | Transaction Origin| Fin Transaction| Date| Time with remark -- Unposted to gld410 & gld418.

So what i need to do further.....

Regards,

Manish

Regards,
Manish

yantopwo
22nd December 2008, 08:21
Are you have Print Integration Transaction?
If Not yet, print integration transaction with fiscal period, transaction Origin "Sales" and Financial Transaction "Sales Invoice" for transaction status is"unposted" or "Erroneous".

You are should be check in "Display Integration Transaction Log (tfgld4532m000), may be you have error when post integration transaction to Finance Trans. If have an error, clear the error first.

sushil
23rd December 2008, 12:21
hello,

As above said .Try Session -

tfgld4432m000
tfgld4532m000

and then get the appropriate error line and description by using the session -tfgld4510m000.

Then try resolving by Posting on same log date and transaction date.


Regards,
Sushil Kumar Mudaliar

mpchheda
13th January 2009, 07:59
Dear Mr. Sushil,

Please throw some light on this thread...

http://www.baanboard.com/baanboard/showthread.php?t=54681

Kind regards,

Manish

Rajhyd
22nd January 2009, 14:20
Please run the correction program otfcor0615. It will show you the records that didnt get posted. HAve a look at that report and finish the month closing.

Regards
Rajasekhar

mpchheda
23rd January 2009, 06:12
Dear Rajasekhar,
In my Question, i have written that i have Run the correction program, and the report is also attached for reference. After that what i need to do, that was my question.

Where else I need to give the GL code, as i have already maitain in tfgld6102m000 and still it is not defualting?

Regards,

Manish

Rajhyd
23rd January 2009, 10:53
Manish,

Can you check in tfgld410 for these transactions where the field batch number on the last form. if this has a number. CAn you check in tfgld100 the batch status. And also check in tfgld106 if the document number is present. If yes, then please change the status in tfgld418 to posted and delete them from tfgld416

Rajasekhar

mpchheda
24th January 2009, 07:57
Rajasekhar,

I want to knoe the reason for GL code not defaulting through thr automatic process.
It can be manually changed / inserted through table which i have already done. But i want to know the rootcause of this error.

BR
Manish

Rajhyd
25th January 2009, 18:53
I guess you need to check with Infor support and the standard answer would be - it is technical reason as to why it didnt get updated. The automatic process takes care of all ledger accounts to be picked for posting during integrations. However it is possible (very rare occasions) that the ledgers and dimensions got posted but the status in certain tables didnt get updated. It is possible that while such updation was on the connection with the server got lost or whatever.

I hope this is a clear reason for you. Coming back to your comment that every thing can be changed through GTM - well this is possible only if the person knows about the complications in the tables and all the updations that happen.

And for integrations if not posted, it is not needed to put the ledgers into it, there are different ways of doing it. Maybe you can check with support. If not then please mail me.

Rajasekhar
mail:rajasekhar.gabbita@empover.com

mpchheda
7th February 2009, 06:32
Hi,

I ahve checked as instructed by you.
Out of so many records, most of them are not present in tfgld410. Few of them are present in tfgld410. But the batch is 0 (null) for these in last form.
Also the Document status for these transaction is "Reserved" and they are not present if tfgls416. Kindly guide me further....

BR,
Manish

Rajhyd
12th February 2009, 07:12
This means that you other related issue of the non postings because of the integration errors is preventing you from month closing. Unless that is solved, this wont work please.

mpchheda
14th March 2009, 06:55
Try to give some solution , as the problem is already highlighted by me.

BR/

Rajhyd
17th March 2009, 09:14
Unless your other open issue of Integrations posting isnt resolved, you cannot try closing the period. First resolve it and then try to close the month and update if there are any more errors.

Regards
Rajasekhar

mpchheda
17th March 2009, 11:03
Thanks for your reply