Netting customer and vendor balances

[former_member502729]

I am testing this process.

I have made master data changes:

1) Vendor master for VENDA: in the customer field, entered CUSTA and in the screen Payment Transactions Accounting, ticked Clrg with cust.

2) Customer master for CUSTA: in the vendor field, entered VENDA and in the Payment Transaction tab of Company Code data, ticked Clearing with vendor.

Transactions:

1) Entered a PO for €50 for VENDA, GR'ed ite and created a vendor invoice using MIRO (for €50)

2) Entered a customer invoice (document type DA) using FB01 for CUSTA for €50

Transaction F-44 (Clear Vendor)

Both amounts appear as open items. The vendor invoice appears as +50 BUT the customer invoice is +50 also. So SAP is saying that the total open items is +100.

I cannot clear one against the other. WHY?

[Former Member · Accepted solution]

Hi,

I doubt this will work with manual clearing. Could you please run F110 and see if the payment program is picking up any amount  for the vendor.

Thanks,

RK

[former_member502729 · Accepted solution]

Thanks RK for yoyr reply.

Using F110 has not worked for me. I have tried a direct debit run for the customer and an EFT run for the vendor. In both tests, SAP proposed €100 - this is the sum of the customer open items and the vendor open items.

I was expecting SAP to propose €0

[Former Member · Accepted solution]

Yes you should be able to clear via F-44 and the total of AR and AP open items should be 0 as expected.

Check your double entry posted. Vednor balance should be credit and customer debit. You may have used incorrect posting keys in FB01.

NW

[former_member502729 · Accepted solution]

NW - That's me sorted. Thanks!

Wrong posting key.