How to stop a user from adding an ap invoice that is higher than the customers balance in sap b1

[wale_adegbola]

Hello,

I write to know How to stop a user from adding an AR invoice that is higher than the customers balance in sap b1.

[Stef5 · Accepted solution]

Hey, 
I think credit limits could be your solution, this can help you for this purpose for sales. 
General Settings: BP Tab | SAP Help Portal
Defining Credit Limits | SAP Help Portal

Just to ask, in the topic you mentioned AP-Invoice and in the details it is the AR invoice mentioned.
You mean AR Invoices (Sales), right? 

[wale_adegbola · Accepted solution]

Thanks so much for your response but they don't want to use credit limit because the customer is not entitled to any credit limit. What happens is that the customer pays like $5,000,000 first before delivery and invoicing the customer so after they receive the payment they want to deliver and then invoice but they want the system to avoid them invoicing the customer a product that is not more than $5,000,000 so how can it be setup in the system? Is there a query to be added into the transaction notification.

[Stef5 · Accepted solution]

yes, the other possibility is to write a sql query with an error code in the transaction notification.

[wale_adegbola · Accepted solution]

Please i don't mind if i can get the query to be added to the transaction Notification?