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

Clearing between customer and vendor invoice with F110 transaction

Hello,

I have an issue related to the functionalities of the transaction F110.

I'd like to clear the vendor invoice with the custome invoice.

Customer and vendor records are linked properly and the flag 'Clrg with Cust.' is set on vendor and 'Clearing with Vendor' is set on customer.

Both the invoice are in USD and the amount in document currency of the vendor invoice is > of the amount in document currency of the customer invoice.

I entered in both the invoice the same payment method (outgoing payment method).

The error that I can see in the proposal log is related to the customer invoice and is:

Payment method selection for items due now to the amount of USD 500,00

Due items with currency USD, pmnt method - items total is > 0

..none of the payment methods defined can be used for these items

information re. vendor xxxxxxxx / customer yyyyyyy / paying company code TS01 ...

.. payment not possible because of reported error

According to the log of the proposal the vendor invoice can be paid.

If I click on display proposal and double click on the customer invoice (with red light) I can read the note:

No pymt possible because items with a debit

Following the settings of the payment method used:

Payment method in the country

- Payment method for outgoing payment selected

- Bank transf. selected

- allowed for personal payment flagged

- Bank details flagged

- Document type for payment XX

- clearing document type XX

- Use classic payment medium program selected

Currency allowed: This table is empty (will mean that all currencies are permitted)

Payment method in company code

Minimum amount: 0,01

Maximum amount: 9.999.999.999,99

Distribution amnt: 0,00

Single paymentfor marked item selected

Foreign business partner allowed selected

foreign currency allowed selected

Cust/vend bank abroad allowed? selected

Bank selection control "No optimization" selected

Can you please help me to understand the error?

I'm afraid it is a problem with the bank but I don't understand why the payment of the vendor invoice is allowed and the customer invoice not.

Thank you very much in advance

Kind R

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Apr 11, 2011 at 05:52 PM

    Hi,

    you must use a incoming payment melthod.

    Check if the balance between vendor and customer is incoming (<0) or outgoing payments (>0). I recommend to define both Payment Methods definitions mentioned above since F110 allow it in parameters entries. Check Customer and Vendors Master Data Account Control to have payment with clearing.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Sure!

      1 - Enter FBZP. Select "Payment Method/Country".

      2 - Create a new entry as copy as some outgoing payment method. Chose PM model accordig your process in f110.

      3 - Change to income payment.

      4 - In Payment Method Classification hit "debit memo".

      5 - Keep the Program for the Form Printout (RFFO*).

      6 - Enter FBZP. Select "Payment Method in Company code".

      7 - Create a new entry as copy as same payment method copied before and assign new PM key.

      8 - Enter Bank Determination

      9 - Define the new PM for all left folders as copy as old PM.

      Let me if Is that clear for you? Anyway you may use some FBZP documentation to support your test.

      regards

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2011 at 05:13 PM

    Hello,

    I have an issue related to the functionalities of the transaction F110.

    I'd like to clear the vendor invoice with the custome invoice.

    Customer and vendor records are linked properly and the flag 'Clrg with Cust.' is set on vendor and 'Clearing with Vendor' is set on customer.

    Both the invoice are in USD and the amount in document currency of the vendor invoice is > of the amount in document currency of the customer invoice.

    I entered in both the invoices the same payment method (outgoing payment method).

    The error that I can see in the proposal log is related to the customer invoice and is:

    Payment method selection for items due now to the amount of USD 500,00

    Due items with currency USD, pmnt method - items total is > 0

    ..none of the payment methods defined can be used for these items

    information re. vendor xxxxxxxx / customer yyyyyyy / paying company code TS01 ...

    .. payment not possible because of reported error

    According to the log of the proposal the vendor invoice can be paid.

    If I click on display proposal and double click on the customer invoice (with red light) I can read the note:

    No pymt possible because items with a debit bal.still exist; see job log

    Following the settings of the payment method used:

    Payment method in the country

    - Payment method for outgoing payment selected

    - Bank transf. selected

    - allowed for personal payment flagged

    - Bank details flagged

    - Document type for payment XX

    - clearing document type XX

    - Use classic payment medium program selected

    Currency allowed: This table is empty (will mean that all currencies are permitted)

    Payment method in company codeMinimum amount: 0,01

    Maximum amount: 9.999.999.999,99

    Distribution amnt: 0,00

    Single paymentfor marked item selected

    Foreign business partner allowed selected

    foreign currency allowed selected

    Cust/vend bank abroad allowed? selected

    Bank selection control "No optimization" selected

    Can you please help me to understand the error?

    I'm afraid it is a problem with the bank but I don't understand why the payment of the vendor invoice is allowed and the customer invoice not.

    Thank you very much in advance

    Kind Regards

    Emanuela

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 12, 2011 at 01:45 PM

    Hi,

    I think you have a problem for grouping the documents. There are a lot of conditions for grouping the documents; they are described in OSS note 305414 - F110: Unintelligible grouping of documents.

    For example, all documents should have either the same payment method either empty payment method.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.