AP Invoice and AR Invoice Manual Reconciliation for Business Partners

[talha_hilal]

Dear Experts,

We have a scenario in which we have a vendor which is a customer as well.We have opened same business partner as vendor and a customer.

Now what we have to do is we have to reconcile AP Invoice and AR Invoice for party.
Both Invoice have same Withholding Tax Rate and Withhold Tax Codes.

I am using reconciliation in Business Partner Module in order to knock of the payable with the receivables from the party by using Multiple Business Partner Check. I have selected my vendor and customer invoice and reconciled the amount to 0 (zero).

Now pressing reconcile button.

reconciled.jpg Once it is posted and reconciled.

manualrecon.jpg Sometimes it is passing an error with different invoices.

* Note: both time we have the same conditions.
(Item based AP) (Service based AR) (Same Wt hold Tax)

I am working on SAP HANA 9.2 PL04.

Will be looking forward for your expert advice.

[talha_hilal]

Dear Expert,

I am sharing the detailed info and screenshots for the following error.
Please find the attached link.
https://www.dropbox.com/s/lja4dfwry9jovym/AP%20Invoice%20and%20AR%20Invoice%20Manual%20Reconciliatio...

Thanks in Advance.

[talha_hilal]

Dear Experts,

Your response is still awaited.

Thanks.

[Former Member]

Hi Talha, in order for you to reconcile AP against AR, make sure on AR Invoice it has no WTax involved. If it has, (assuming your wtax on AR is recognized upon payment) delete it first and reconcile it

Regards,

Mahj

[talha_hilal]

Hi Mahj,

First of all thank you for your response.
If Wtax removed from AR invoice it is showing the same error as the AP invoice is made with the withholding tax.
so in that scenario i am using same Wtax for vendor and customer invoices to reconcile.

Thanks,

[talha_hilal]

anyone who could help me out?