F110: override FBZP House Bank with Vendor Master data

[Former Member]

Hello to all,

I am new in FICO so I apologize in advance if this has been answered elsewhere. However, the previous days I did a lot of research and found that none of the suggested solutions applied to my case.

I use F110 and I want the payment program to use Vendor's bank (already set in Vendor's Master data) instead of FBZP proposed Bank (derived from Bank Determination). No matter what I tried, the bank account used in my proposal matches that of FBZP.

How can I override FBZP settings and used the Bank set in Vendor's master data?

Thanks,

Christos.

[Former Member · Accepted solution]

Hi,

Pls check whether u have checked the " Bank details" field in the payment method/country tab in FBZP for the coressponding payment method.

[Former Member · Accepted solution]

Hi Vinoth and thanks for the reply,

In "payment method/country" I only see Country name in accosiation with payment methods and their descriptions. It is not clear to me where is the "Bank Details" field.

[Former Member · Accepted solution]

Hi Chrish,

Double click on the payment method.There u can find the field in the " Required master record specification " tab.

Thanks

[Former Member · Accepted solution]

Found it, thanks!

No, it is not checked. Could you please describe what is the effect of that?

[Former Member · Accepted solution]

If you set this indicator, you specify that the payment method can
be used if bank details have been maintained in the customer/ vendo
master record.

Conversely, the customer/vendor bank details are only selected and
entered into the payment dataset if this indicator is set.

[Former Member · Accepted solution]

What happens if this "Bank details" is checked and there are no bank details in Vendor's master? Will FBZP bank determination take over or will the payment fail?

[Former Member · Accepted solution]

I tried your solution check "Bank Details" and updated Vendor's master data with a specific bank. I recreated the proposal, but it still gets the bank determined by FBZP.

[former_member197737 · Accepted solution]

Hi Chris,

Try populating field house bank (LFB1-HBKID) at vendor master data, company level. Bank details is for vendor's bank (receiving account), and not for company code house bank (payment account). That field should overwrite house bank determined by FBZP.

Best Regards!

[Former Member · Accepted solution]

Thanks a lot mgitur! That did the trick!

[Former Member · Accepted solution]

Mgitur hello again,

Looks like the change didn't work in my Production environment. I produced the proposal, but all lines are now marked red, except one that includes a vendor with house bank (LFB1-HBKID).blank.

[former_member197737 · Accepted solution]

Hi Chris,

You should take a look to payment log to detect which is the error. If you checked the flag "bank details" in payment method mentioned by Vinoth, then all vendors should have bank details in its own master data. Analyze payment log to detect the error.

Best regards! 

[Former Member · Accepted solution]

I didn't change the flag "bank details" but it worked with this field blank both in Development and Test. It fails only in Production

That's the log:

Information re. vendor XXXXXXXXXX / customer  / paying company code XXXX ...      FZ           304          S     

Payment with currency EUR, payment method 0: No valid payment procedure           FZ           390          S     

Information re. vendor XXXXXXXXXX / paying company code XXXX ...                  FZ           305          S     

... payment not possible because of reported error                                FZ           311          S     

[former_member197737 · Accepted solution]

Chris,

Are you telling me that if you leave the house bank blank in production for one vendor it works, but if you populate the house bank for that same vendor, it does not work? Then you should check bank determination (FBZP) because it seems that house bank populated in vendor's master data is not determined in FBZP (You should have house bank in ranking order). Also check currencies and available amounts (FBZP) for house bank populated in master data.

Bear in mind that original issue was solved and now you have a new issue. Maybe you should be opening a new thread.

Best regards!

PS: Please, also mark as answered or helpful.

[Former Member · Accepted solution]

Hi mgitur,

You were right, FBZP settings were different in Production. I made the necessary changes and everything works perfectly.

Thanks a lot!

[Former Member]

Crystal clear, thanks a lot Marssel!

[Marssel700]

Hi,

you can't override FBZP - Bank Determination - in F110 by Vendor assignment. To to that you must enter manual clearing: F-51, F-28 or F-53.

regards

[Former Member]

Hi Marssel and thanks for your feedback,

Actually FBZP Bank determination can be overriden, Please have a look at the solution proposed by mgitur.

Thanks.

[Marssel700]

Actualy you didn't override FBZP. You have selected FBZP account determination in F110 by Home Bank assignment in Vendor. You can also do that at document level.

[Former Member]

You are correct. Would you please briefly describe how this is done at document level? Thanks!

[Marssel700]

Chris,

enter chane document: Additionl data.

If you have no authorization to change field go to OB32 - Account type K.

regards