Hi all,

Due to some unknown reason, one anticipated payment got stuck while reconciling (tfcmg2103s000) and unable to change the stutus again. I could not find where to correct in tables to re-activate this.

Can anybody help to solve this issue.

Thanks in advance.
Kumarksa
:confused:

tfcmg110, tfcmg111, tfcmg112 (second form) ?
somewhere there perhaps?

Hi there,

I am also stuck in the same problem. not able to change to status of Paymant documents status. it seems that is locked for some reason. not able to find out where problem lies in table?

please help?

Regards,
Mitesh

Hi,

For check to get reconciled in tfcmg112 anticipated payment status to be open and clearing year,period,batch,transaction type,doc,line no,clearing date,reconciliation currency,rate,ratefactor,rate.date,rate.type,reconciliation amount to be zero . Reconciliation status to be free. and previous status open. in tfcmg110 the clearing year,period,batch,transaction type,doc,line no,clearing date to be blank / 0.Payment document status = open

Regards,
Chaitanya

Hi Chaitanya,

I have checked each and very field in tfcmg112 and tfcmg110. everything is either zero / blank. but still i am not able to change the status from Open to Rejected...

What is the other around?

Regards,
Mitesh

Hi,
Can u attach the screenshot of the tables tfcmg100,110,112 of this document.

Regards,
Chaitanya

Hope yours is Baan IV.

Try with this correction programmes mentioned below.
I am not sure which one is applicable for you. Try in the simulation mode first and see the result and then proceed.

1.Otfcor0111 Reset a Payment Batch Upto Status Paid in Automatic Procedure
2.Otfcor0270 Check Anticipated Tables(tfcmg110\tfcmg111\tfcmg112)
3.Otfcor0272 Reverse Anticipated Document

Srinivas.CH