Un Apply Transaction Payment Reconciliation

[Former Member]

Hi,

We done a incoming payment with 10 invoices. Out of 10 invoices, 3 invoice were wrongly selected.  Customer don't want to cancel the payment. Instead of that, They want to Un apply the wrong invoices with correct invoices. Is any one faced this Un Apply Transaction requirement or Any work around to achieve this.

We are using SAP 9.1 PL 06 ( US Localization )

[jitin_chawla]

Hi,

What you have created for 10 Invoices is a Document based payment. Document Based payment closes the status and values of the Invoices/documents involved in the Payment. There would be no possibility to un-apply.

Creating a Payment based on Invoices have closes and created entries in respective tables. OJDT, JDT1, OITR, ITR1, OINV and associated tables, ORCT and its associated tables. Un applying is not possible as these entries which have taken place needs to be reversed and this reversal is only possible by cancelling and re-doing the complete payment.

It is the standard working of the system.

Regards,

Jitin

SAP Business One Forum Team

[K_Pauquet]

Hi sudhir b,

if you selected the 10 invoices in the incoming payment window, you can simply cancel the incoming payment in your system & create a new one with the correct invoices selected. the cancellation will undo the system reconciliation & re-open all documents.

If you created a payment on account for the customer & then manually reconciled it with the invoices, you can cancel the reconciliation. That will reopen the invoices & the payment. You can then reconcile the payment with the correct invoices.

All the best,

Kerstin

[Former Member]

Hi,

As said earlier the customer don't want to cancel the payment and don't want to rework again. .They simply want a mapping. That's the problem. Thanks for your reply.

[K_Pauquet]

Hi sudhir b,

you cannot manually undo a system reconciliation in SAP Business One, you need to cancel the payment to properly reverse the original transaction completely.

All the best,

Kerstin