Grouping Vendors for F110

[Former Member]

Hi,

We have requirement to group vendors for payment run i.e.

1) Vendors to be paid once in a month

2) Vendors to be paid twice in a month

3) Vendors to be paid weekly

4) Vendors to be paid twice in a week

5) Vendors to be paid daily.

How can we group all vendors as per above and create a single payment run?

Thanks and Regards,

Anurag

[Former Member · Accepted solution]

Hi Anurag,

As per the vendor selection in parameter tab of the payment proposal, the payment will initiate and happen, now as per your daily weekly and monthly requirements you can give specific vendors, apart from that i feel there is no other option.

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Number of vendors are in thousands, we do not want manual ranges for selection. If new vendor is been created, this may lead to wrong selection.

Is there any option that we group vendors through characteristics/parameters entered in vendor master data. If yes then this would be one time activity.

Thanks and Regards,

Anurag

[Former Member · Accepted solution]

Dear Anurag,

For meeting your requirement, you may use field "Corporate Group" (LFA1-KONZS) under Control screen of vendor master. This field is freely definable. You can maintain your groups in the vendor master. For e.g.

1) Vendors to be paid once in a month - 1000

2) Vendors to be paid twice in a month - 2000

3) Vendors to be paid weekly                 - 3000

4) Vendors to be paid twice in a week  - 4000

5) Vendors to be paid daily.                     - 5000

Once your master data is updated, in F110 you may enter all the vendors under Parameters and then go to Free selection. There you need to select "Corporate Group" under Field Name and enter the values for e.g. 1000 for monthly payment.

This will create proposal only for those vendors where you have maintained Corporate Group - 1000 under vendor master.

But this will require an accurate vendor master data, as proposal will get generated based on the corporate group maintained in the vendor master.

Hope this helps you.

Regards,

Kiran

[Former Member · Accepted solution]

HI Kiran,

F110>Free selection>>Field Name>>>Vendor Master data - I did not found any field as 'Corporate group'

Thanks and Regards,

Anurag

[Former Member · Accepted solution]

Dear Anurag,

Go to F110>Free selection>>Field Name>>>Vendor Master dataF110>Free selection>>Field Name>>>Vendor Master data and try to find with field name KONZS.

The description for this field show as "Group Key" there.

Regards,

Kiran

[Former Member · Accepted solution]

Hi Kiran,

I have created a new group key and assigned to vendor master. Now I am trying to create proposal on the basis of it but it is not working,

In edit proposal system is not getting any items though hundreds of line items are open and overdue.

Thanks and Regards,

Anurag

[ajaycwa1981]

Hi Anurag

Either Corp Group Field or Using a BTE in FIBF are the choices

Press F4 in the Event Field in FIBF > Settings > Process Modules > of a Customer.. You can easily identify the relevant BTE

Ajay M

[Former Member]

Hi Ajay sir,

Corporate group and group key is same, right ? I have created one but getting error in 'Edit Proposal' that

Company codes 1000/1000 do not appear in proposal 19.07.2016 1; correct

No other proposal exist for selected vendors.

All Vendors have overdue open items.

How can we use BTE to group vendors? Please elaborate.

Thanks and Regards,

Anurag

[ajaycwa1981]

Hi Anurag

This is a very common error. you can search it in the forum

For BTE - You need to write the Code in its Function Module.. Each BTE has a sample FM which needs to be copied and code is written in that

Ajay M