SAP Knowledge Base Article - Public

2841450 - Customer and Vendor - Open items clear together

Symptom

Where Customer is maintained as Supplier and vice/versa, apps Clear Incoming Payments (app ID F0773) or Clear Outgoing Payments (app ID F1367) do not allow to select customer and supplier line items together.

You wish the open items to be cleared against each other automatically.

"Image/data in this document is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

S/4 HANA Cloud

Reproducing the Issue

  1. Customer is maintained as Supplier and vice/versa the following is configured:
    In app Maintain Business Partner (app ID BP)
    Example: 

    Supplier 10300002:
    Customer 10100002 is maintained in Supplier Master 10300002

    Customer :10100002
    Supplier 10300002 is maintained in Customer Master.

    BP Role: Supplier (Fin.Accounting) (defined) tab Vendor: General Data Customer maintained

    customer.png

  2. BP Role: Supplier (Fin.Accounting) (Defined),tab Vendor: Payment Transactions, Clearing w.customer ticked

    10300002.png






  3. BP Role: Customer (Fin.Accounting) (Defined), tab: Customer:General Data field "Supplier"  enter the corresponding supplier ID.

    supplierfield.png

  4. BP Role: Customer(Fin.Accounting) (Defined),tab Customer: Payment Transactions, Clearing w.vendor ticked

    clearingwithVendor.png
  5. Customer/Supplier Invoices created for Business Partners above.

  6. Apps Post Incoming Payments or Post Outgoing Payments, option is usually singular usage i.e for posting outgoing supplier line items shown. In app Post Incoming Payments customer items shown. Likewise this functionality is not supported in apps Clear Incoming Payments or Clear Outgoing Payments. 

 

Cause

This feature is currently not supported in the Fiori apps.

Resolution

  • Use Manage Automatic Payment (App ID F0770)

    Manage Automatic Payment - Netting of AR/AP Items

    See Netting of AR/AP Items in  Accounts Payable (‏J60‏)

    1. In APP: Manage Supplier Master Data (App ID F1053A), for Supplier, select Company Code -> tab Finance -> section "Automatic Payment Transactions" include both incoming and outgoing payments concerned.

    2. In APP: Manage Customer Master Data (App ID F0850A) for Customer, select Company Code -> tab Finance -> section "Automatic Payment Transactions" include both incoming and outgoing payments concerned.

    3. If payment methods exists in Supplier Journal Entry, in app Manage Supplier line items (App ID F1053A) select Supplier invoice, Edit line item, remove Payment Method and click on OK

    4. If payment methods exists in Customer Journal Entry in app Manage Customer Line Items (App ID F0711) select Customer invoice, Edit line item, remove Payment Method and click on OK

    5. APP: Manage Automatic Payments (App ID F0770)

    5.1 Example: Customer and Supplier Master records set up with Payment Methods E and T  
    E is incoming payments
    T is outgoing payments

    5.2 Case 1 Supplier and Customer have the same number.


    In app Manage Automatic Payments Parameters you can include both the incoming and outgoing payment methods. 



    Schedule payment proposal/run for netting payment document 



    Balance of netting Incoming, payment method E is choosen.

  • 5.3 Case 2 Supplier and Customer have the different numbers.

    5.3.1  Example Balance of netting is incoming: Incoming and Outgoing Payment methods included in Automatic Payment Parameters 




    Schedule payment proposal/run for netting payment document 




    Balance of netting Outgoing, payment method T is choosen. 




  • 5.3.2 Example balance of the netting is Incoming. Incoming and Outgoing Payment methods included in Automatic Payment Parameters 






    Schedule payment proposal/run for netting payment document.