Payment wizard limits outgoing payments to balance in G/L bank account

[Former Member]

SAP B1 2005A Banking, Payment Wizard, Recommendation Report limits recommended invoices for payment to the balance in the G/L bank account. Is there a way to get around this limitation?

It would be much better for our company if the Recommendation Report listed ALL invoices that meet the parameters we specified (Vendor # range, Vendor Group, Due Date, etc) then allow us to de-select individual invoices until the total of payments is below the G/L bank account balance.

[Former Member · Accepted solution]

Hi Lorna,

I think the Non-Included button in that step can be used to achieve your goal.

Thanks,

Gordon

[Former Member · Accepted solution]

Thank you for answering. We tried that. It gives us a report of invoices that were not included in the recommendation. But we cannot figure out how to select anything from the report. We even tried to deselect invoices from the recommendation report to ensure that the bank balance limitation was not affecting our inability to select from the non-included invoices report. Are we doing something wrong?

[Former Member · Accepted solution]

Sorry for the hurry answer without check. The message on the screen clear says: Non-Included trans. displays rows for which a payment cannot be generated.

This is system behavior. I don't think there are any existing options other than try SDK.

Thanks,

Gordon

[former_member583013 · Accepted solution]

Hi Lorna,

You could try this...In Step 5 (Payment Method - Selection Criteria)...Change the Max. Outgoing Amt to a higher number so that all transaction will be listed in Step 6 (Recommendation Report)

Suda

[Former Member · Accepted solution]

This resolves our issue. Thanks!!!

[keith_taylor2]

You can over-ride the bank available balance when you are executing the payment wizard - perhaps you make a mental note of the amount and then over-ride it then SAP will allow you to cut checks totalling any amount you want