F110: Is it possible to create a proposal based on vendor’s total?

[Former Member]

Dear experts,

F110 -> Free selection -> BSEG-WRBTR allows to create proposal

that will include invoices that meet the specified criteria.

For example, invoices that are greater than 500.00 and less than 999.00.

I’m trying to figure out how to do the same filtering based on the total amount per vendor.

For example, a vendor has 2 invoices: $ 300 and $ 800 => the total is $ 1,100 (REGUH-RWBTR).

In case the criteria is (500.00,999.00) -> the vendor should not be picked up.

Thank you,

Vita

[former_member190652]

Do you want to have this criteria of 500 to 999 for all vendors of that particular payment method and company code ?  If so, then you can put the minimum and maximum amount settings in transaction FBZP at company code and payment method level.  Don't select the single payment for marked item check box and also don't select the check box individual payment in vendor master data.

Sridhar

[former_member194797]

Hi,

I think it is possible if

1) the same lower and higher limit are applicable to all supppliers using the same payment method

2) you are grouping all documents of one supplier in a single payment.

In this case, it is possible to put a minimum amount and a maximum amount in the payment method in company code. You should also choose "as many as required" for "Note to payeelines on the form".

[Former Member]

Hi Zara,

Using F110 you can create the proposal as

1) Total invoice payment (For all invoices one check payment/one payment)

2) Individual check payment for Individual invoice (one check for one invoice)

your requirement is not possible through F110.  But using F-53 or F-58 you can make the payment as per your wish,  Picking the invoices manually.  Thanks.

Regards,

Inthiyaz

[Former Member]

Hello,

I don't think it is possible to do that only with customizing or settings in the payment program.

In customizing (FBZP), you can define a minimum payment amount for the paying company code. For this setting, you can choose $500. It will not make a payment for less than $500.

I don't think it is possible to setup automatically with config a maximum payment amount per account. However, you can adjust in FBZP the available amount for house bank/account/currency.

If those solution are not fitting your requirements, then you need to use "BTE 00001840 - Payment Program: Balance Check" to implement the exact rules you need.

Regards