Skip to Content
author's profile photo Former Member
Former Member

Clearing Customer & Vendor with Automatic Payment Program

Hi,

I'm facing a problem in Clearing Vendor with Customer through Automatic Payment Program. I created payment methods for Customer (D-Incoming payment method) & Vendor (C-Outgoing Payment method) individually and I also selected "Clearing" check box in master data. I raised invoices for customer & vendor in which vendor invoice value is greater than customer's.

I tried to clear vendor & customer using F110. It's displaying the vendor & customer invoice line items & showing the balance amount after deducting customer's invoice amount with vendor's invoice amount. But after clicking "Reallocate" for both line items, it's not netting the amount and the check is getting printed for the actual vendor invoice amount but not for net amount.

Can anyone please suggest. I maintained the parameters of customer & vendor in F110. Everything is perfect, but I don't know why it's not getting resolved.

Thanks,

Pavan

Add comment
10|10000 characters needed characters exceeded

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 29, 2011 at 07:11 AM

    Hi All,

    I maintained the House Banks, Payment methods in both Customer & Vendor accounts. I also maintained Customer number in Vendor master data & vice versa in Control Tab. As said by Murali, we can't maintain the same payment method to Vendor & Customer because if we try to create a same payment method in FBZP "Payment Methods in Country" it gives an error as "An entry exists with the same key". I also enabled the option "Customer" "Vendor" in both DR & KR Document types in OBA7 and also in the payment document types.

    So I created Payment methods "C" for Outgoing Payments & "D" for Incoming Payments.

    In F110 it's displaying the net amount (difference between Vendor & Customer invoice) and after clicking it's showing 2 line items 1. Customer Invoice 2. Vendor Invoice and after clicking it I'm clicking Reallocate button & input the payment method, House bank details.

    It's generating a cheque with full vendor invoice amount & not displaying the net amount. In FBL1N & FBL5N it's showing both vendor & Customer line items as cleared with full amounts.

    I request you all to clearly understand this config and give me a remedy.

    Thanks,

    Pavan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I'm very thankful to you. Your solution gave me the 100% apt output which I desired. I'm really happy. I was waiting for this reply since many days.

      Thank you very much once again.

      Thanks,

      Pavan

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2011 at 02:20 AM

    Hi,

    Have you ensured that the related document types ( Customer and Vendor Payment document types ) allow both customer and vendor account types?

    Have you configured details like payment method and house bank correctly in APP ?

    Regards,

    Gamidii

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2011 at 01:43 PM

    Hi pavan ,

    I also selected "Clearing" check box in master data,

    i have a small issue

    where will the "clearing check box" in master data.

    can u please give detail information.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2011 at 06:32 AM

    Hi,

    Have u maintained Vendor account number in ur customer master under the "Control Tab"

    Regards,

    Amit Shinde

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 15, 2011 at 05:04 AM

    Hi Friends,

    Till date no body answered to my thread. Hope anyone of you got the solution for this thread. If so, please post the solution.

    Thanks,

    Pavan

    Add comment
    10|10000 characters needed characters exceeded