Is it possible to block the creation of a sales invoice if customer has an overdue invoice? If so, how?

[iteerstech]

Hellow Szufisher.
I appreciate your reference but I had got some thing from those scripts.

But it disable the create the “create button” like below,

How do reference to this buttons.I need to enable restrictions for the “Return/Credit note”

[kennethsequeira]

@iteerstech

This is awesome, how would one restrict the issue on Credit note/sale Return to "Account Manager " role only ?

Try this in client script for sales invoice:

frappe.ui.form.on('Sales Invoice', { 
    onload_post_render : function(frm){
        var bt = 'Return / Credit Note'
        if (! (frappe.user.has_role('Account Manager')))
        {
            frm.page.remove_inner_button(bt, 'Create')
            }
        }
    }
);

Note that this will hide the button if the user doesn’t have said role.

You can play around and use frappe.throw to create the error message and block return creation as well.

EDIT: added not operator

[iteerstech]

@kennethsequeira

frappe.ui.form.on(‘Sales Invoice’, { onload_post_render : function(frm){ var bt = ‘Return / Credit Note’ if (frappe.user.has_role(‘Account Manager’)) { frm.page.remove_inner_button(bt, ‘Create’) } } } );

Hey Ken,
Letmi try its and give you a feedback.
Regards.

[iteerstech]

Hi Ken,
This hides the button from all roles including the "Account Manager’

[kennethsequeira]

Check the updated code. Just have to add a not (!) in front of the if condition.

It will then check if the user has the Account Manager role. If not, then it’ll remove the button.

[iteerstech]

Thanks alot .
It worked as expected

[akash22]

@mujeerhashmi

filters = {'docstatus': 1, 'customer': doc.customer, 'status': ('In', 'Unpaid,Overdue')}
total_unpaid = frappe.get_all("Sales Invoice", filters=filters)
if (total_unpaid):
    frappe.throw(_('Customer has an outstanding balance'))

Please write complete script so that we can just paste & save as custom script … it will be very helpful to those who dont know coding.

.