Excluding vendor invoces from payment proposal

[Former Member]

How do we exclude vendor invoice/invoices to be paid that exceed for example $20,000 in F110? We want to exclude any vendor payments from payment run that exceed $20,000 and pay only those invoices for particular vendor that total up to less than $20,000. Blocking invoices will not work. How can we restrict them to show up in proposal?

[Former Member]

Hi Sheena

Can you check in FBZP - > Bank determination -> Available amount, what will be the result if you limit the amount value to $20,000 for the house bank, account id you want.

Unless this change doesnt effect your other FBZP reuirements, this should ideally work.

As this node checks whether the House bank from which you are paying has sufficient balance or not.

Thanks

Nikhil

[Former Member]

Nikhil,

What are saying is only good for invoices less than 20,000. But how to pay invoices over 20,000. We also want to print checks for invoices over 20,000 with same payment method.

[Former Member]

Hi,

Best Suggection would be while entering the Parameters for F110 , In Free selection tab , Select Document in tht from the list Select amount Field (BSEG-WRBTR) and in Values enter put <= 20000 and Tick the check box -exclude Values. by this system will exculde all the line items which amount as greater or equal to 20000 .

the above process ,Users also can follow as its very simple process

Thanks

Goutam

[Former Member]

Sheena, a more robust control here would be to setup 2 payment methods and on then in the IMG "Set Up Payment Methods per Company Code for Payment Transactions" you can limit the value a payment can be made for. So in this instance, you can have say 2 payment methods for Bank Transfer, B1 and B2, You let B1 run for all items up to $20,000 and then don't need to worry about that, for B2, you run the payment run and then can review each payment item. Note both payment methods need to appear in your vendor record.

Hope this helps?

[sanilbhandari]

Hi

Setting up two payment methods for the same puprose may confuse the end user. You can write your validation in FEDI0004 where invoices with $20000 will be shown as error or will be blocked by the system

Regards

Sanil

[Former Member]

Hi Sheena,

in F110, in Free selection Tab,

Option:1

Select Document. and then select Field "Amount BSEG-WRBTR" and in Values put (1.00,20000.00) (with brackets). Now it will not pick the all amount between 1 and 20000. Don't forget to select "Exclude values"

Option:2

in FBZP go to Payment Method in company Code, and select your payment method and give Minimum Amount as 20000 now you can not pay any amount less than 20000 both Vendor and Customers through this payment method.

Satish

Edited by: Satish Kumar on Jun 14, 2011 2:33 PM

Edited by: Satish Kumar on Jun 14, 2011 3:12 PM

[Former Member]

But this would restrict the amount only. The restriction of the amount should be at vendor level not document level. For example, a Vendor ABC has two invoices that add upto 22000 ( 11,000 each invoice) and the other vendor XYZ has three invoices that add upto 18,999 (5000, 10,000 and 3999). The vendor XYZ invoices should be picked to be paid , not vendor ABC's invoices.

[Former Member]

Hi sheena,

Goto free selection tab, select free selection-field name - Amount in LC & select exclude values. In values put < 20000.

Regards

Milind Sonalkar

[atif_farooq]

Dear:

Go to F110..free selection tab...select documents... also check exclude values.. document numbers whose value exceeds 20000 Rs in values .This will do the needful for you.

Regards