Purpose

If a vendor is also a customer, from the perspective of making vendor payment, it is possible to offset the outgoing payment amount from the existing amount owed to the customer when running the F110 – Automatic Payment Run.

Prerequisite settings in vendor/customer master

Vendor Master

1 Input Customer Information in Vendor Master

  1. The customer number is used by the payment and dunning programs for clearing open items. For line item display, the link to the customer line items is established using this number.

screen1.JPG

     If you require clearing between the customer and vendor, the following requirements must be met:

     –  The customer number must have been entered in the corresponding vendor master record.

     –  The vendor number must have been entered in the corresponding customer master record which we will do in the next step.

     –  The fields “Clrg with vend.” or “Clrg with cust.” must have been selected in both master records.


     2. For clearing with customer setting, the screen is as shown below. As for clearing with vendor setting will cover in next step.


When you try to activate the ‘Clrg with cust.’ Indicator, SAP displays the follow message where the ‘clearing account 10201734’ is the customer number.



Customer master

2 Input Vendor Information in Customer Master

    1. Specifies an alphanumeric key that uniquely identifies the vendor or creditor in the SAP system.



     2. Then turn on the ‘Clearing with vendor’ indicator in order to complete the settings in respective master in order to allow clearing with customer during

          automatic payment process.


Clearing between vendor and customer via F110

1 Analyse Vendor and Customer Balance

  1. Analyse the open item balance for vendor, that the total amount outstanding on vendor side must be greater than the balance outstanding on customer side. This is required in order for clearing with customer to work.

         Vendor Open item


Please take note, the item with debit balance where the document number is 620004610 as shown above, should be excluded from automatic payment in the parameter set up (shown in next step) as SAP throws out error during payment run.



     2. Check the outstanding balance on the customer side where the amount is 2,200 very much less than the vendor outstanding amount.

          Customer Open Item


     3. Together with the settings both in vendor and customer master we discussed previously being fulfilled then we can proceed to next step for payment           settlement between the vendor and customer.


2 Automatic Payment Settings and Payment Run

      1. In the F110 (Automatic Outgoing Payment) parameter settings as shown below, both vendor and customer must be input in order to do offsetting payment           between a vendor and customer. Both vendor and customer numbers must be entered besides other settings.


     2. The result of payment proposal list shows the amount details of all open items from vendor and corresponding customer highlighted in red colour box.


     3. Display payment proposal job log


     4. Display payment job log

     5. Actual document posted



To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Bohdan Petrushchak

    Hello Kee Seng,

    Thanks for an interesting guide on offsetting between vendor and customer accounts.

    I would like to note that you should also add the following small remark concerning the business scenario described above.

    As far as I understood, you use APP in order to post payments (not to generate payment orders). In this case, document type specified in configuration of payment method (“Document type for payment” in “Payment methods for Country”) should allow postings to both customer and vendor accounts. Otherwise, you’ll encounter errors during APP run.

    On the other hand, if somebody would like to use this scenario for generation of payment orders, the document type specified in settings of the posting rule for outgoing payments (“Global Settings for Electronic Bank Statement -> Define Posting Rules“) should also allow postings to both account types – vendors and customers.

    Best regards,

    The Wirtschaftsmann

    (0) 

Leave a Reply