2841450 - Customer and Vendor - Open items clear together

How to clear supplier open items and customer open items against each other automatically or manually.

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

SAP S/4HANA Cloud Public Edition

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
   
   

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

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

4. BP Role: Customer(Fin.Accounting) (Defined),tab Customer: Payment Transactions, Clearing w.vendor ticked
   
   
5. Customer/Supplier Invoices created for Business Partners above.

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 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. 



Balance of netting Incoming payment method E is choosen. 

Manual Clearing:

Manual workaround Depending on Use Case: (In these case scenarios maintenance of customer/vendor number in BP master data is not the pre-requisite)

Customer and Supplier Open Items Cross Clearing

AR Accountants or AP Accountants can clear customer open items with supplier open items using either the Clear Incoming Payments or Clear Outgoing Payments applications. Additionally:

Document Type ZV is used in this scenario

By using the Select More button, when selecting open items, choose whether to clear open items from customers, suppliers, or both.

Example 1.1 Clear Incoming Payment app – Select Suppliers

1. Open the Clear Incoming Payments app and click Clear Open Items button



2. Input Company Code and Customer

3. Select Journal Entry Type "ZV"

4. Select a Supplier to clear

5. Select More popup supports Customer & Supplier selection

6. Select some items for Customers and Suppliers



7. Customer was renamed to Account and Account Type can be seen.

8. Click Simulate and post button



Document could be posted correctly and posting key correctly used such as 15&28 or 35&08 depends on Debit/Credit’s difference.

Example 1.2 Clear Outgoing Payments app – Select Customers

1. Open the Clear Outgoing Payments app and click Clear Open Items button



2. Input Company code and Supplier  

3. Select Journal Entry Type "ZV"

4. Select a Customer to clear

4. "Select More" popup supports Customer & Supplier selection

5. Select some items for customers and Suppliers

Support Transfer Posting with Clearing

2586464 - Error ID(Description): 001(No pymt possible because Items with a debit bal.still exist; see job log)

FZ011, reallocation, Enter a payment method for incoming payments, Enter a payment method for outgoing payments, FZ010, NET, NETTING, supplier, customer, receivables, payables, glt2201, balancing field  , KBA , FI-FIO-AP-PAY-2CL , Payment Apps (Public Cloud) , FI-AP-AP-A-2CL , Posting/Clearing/Special General Ledger (Public Cloud) , FI-FIO-AR-TRA-2CL , Transaction Apps: Public Cloud , FI-AR-AR-A-2CL , Posting/Clearing/Special General Ledger (Public Cloud) , FI-FIO-AP-TRA-2CL , Transaction Apps: Public Cloud , FI-FIO-AP-2CL , Fiori UI for Accounts Payable (Public Cloud) , Problem