baan999
13th August 2009, 17:14
i AM TRYING TO DELETE THE RECORD IN tfcmg2100s000 session
error " assigment found record cannnot be deleted "
And when i try to link the supplier payment with bank - by stating as : automatic, the amount is not reducing and when i set to :NO than amount is increasing in Remaining Amount field.
How to resolve , please advice
Rajhyd
17th August 2009, 07:46
Hi,
Can you please go into this batch and for this document, firstly unassign or unlink whatever documents have accidentally got linked to it.
Then delete this record.
For this supplier, try executing recalculate Supplier balances and then proceed further.
If you still get the same message, then advise you to use GTM. Check in table tfacp200 for this document and check what invoice got linked to it. This would help you in processing it without any further errors.
Regards
Raj
baan999
18th August 2009, 12:32
RajHyd,
Thanks for the reply. I already tried unassign/unlink
Now at this point we are not able to change / remove the allocation, remove the transaction or revise the allocation
please advice.
Rajhyd
18th August 2009, 12:53
Hi,
Use GTM to remove this in total.
Note the document numbers and delete them from:
tfgld102, tfacp200 (this document and also the linking that happened to the invoice for this doc), tfgld018(status to change to deleted)
Recalculate the supplier balances for this supplier.
This should work.
Regards,
Rajasekhar
baan999
19th August 2009, 08:20
Rajhyd,
Use GTM to remove this in total ...
e.g. I booked on sup trans and finalised(001tran type)
and maintained the bank trans (077 trn typ) this details are only available in non finalised to finalise.
while trying to link the payment for 077(bank trn) for 001(sup.trn) with setting status = automatic & the remaining amoun column is not reducing, infact it is increasing.
if there any solutions to remove bank trns or reverse the entry.
Rajhyd
19th August 2009, 10:19
Is it possible for me to do a remote login and check the same. I can do it through Team Viewer. In case you have something different then do let me know.
I assume that you havent done the changes as suggested. The remaining amount will go on increasing and this happens. If this has been set as automatic then it is possible that this linking has wrongly happened to many more invoices too.
Raj