Client Script to calculate Invoice Count

1

i need Client Script to calculate Invoice Count for the current sales invoice customer if it possible

2

@Osk

frappe.ui.form.on('Sales Invoice', {
    refresh: function(frm) {
        // Add a button to fetch and display the invoice count
        frm.add_custom_button(__('Show Invoice Count'), function() {
            frappe.call({
                method: 'frappe.client.get_value',
                args: {
                    doctype: 'Sales Invoice',
                    filters: {
                        'customer': frm.doc.customer
                    },
                    fieldname: 'count(name)'
                },
                callback: function(response) {
                    var count = response.message['count(name)'];
                    frappe.msgprint(__('Number of Invoices for this Customer: ') + count);
                }
            });
        });
    }
});

Try this.

3

thank you for the help

could you please give me more support to my issue

i dont want add new button to get total count

i want display total invoice count in custom field (invoice_count), this even must be work depend on customer in the current sales in voice m keep in mind that i add new tab break on the sales invoice include invoice_count field

4

@Osk Try this.

frappe.ui.form.on('Sales Invoice', {
    customer: function(frm) {
        if (frm.doc.customer) {
            // Fetch and update the total invoice count for the selected customer
            frappe.call({
                method: 'frappe.client.get_value',
                args: {
                    doctype: 'Sales Invoice',
                    filters: {
                        'customer': frm.doc.customer
                    },
                    fieldname: 'count(name)'
                },
                callback: function(response) {
                    var count = response.message['count(name)'];
                    frm.set_value('invoice_count', count);
                }
            });
        }
    }
});
5

there is no data in the invoice_count field when i enable Clint script

6

when i use first client script … bring me invoice count without any problem but i don’t want use button i need direct display count in the field

7

hii , try this one :

frappe.ui.form.on('Sales Invoice', {
    customer: function(frm) {
        // fetch the total count of invoices for the customer
        frappe.call({
            method: 'frappe.client.get_list',
            args: {
                doctype: 'Sales Invoice',
                fields: ['name'],
                filters: {
                    'customer': frm.doc.customer
                }
            },
            callback: function(r) {
                if (r.message) {
                    // Update the invoice_count field in the Sales Invoice form
                    frm.set_value('invoice_count', r.message.length);
                }
            }
        });
    }
});
8

how can i added a new event handler for the tab_break instead of button that mean
i want when choose tab break (custom_sales_survey) display invoice count in the

invoice_count field

9

image
image1332×209 22.8 KB

did try this one?

10

i dont want use report

now this code is work and i got invoice count but i dont want use button event

i just want when i choose tab break (custom_tab_brake) bring to me data

frappe.ui.form.on('Sales Invoice', {
    refresh: function(frm) {
        // Add a button to fetch and display the invoice count
        frm.add_custom_button(__('Show Invoice Count'), function() {
            frappe.call({
                method: 'frappe.client.get_value',
                args: {
                    doctype: 'Sales Invoice',
                    filters: {
                        'customer': frm.doc.customer
                    },
                    fieldname: 'count(name)'
                },
                callback: function(response) {
                    var count = response.message['count(name)'];
                    frappe.msgprint(__('Number of Invoices for this Customer: ') + count);
                }
            });
        });
    }
});
11

@Osk Try this.

frappe.ui.form.on('Sales Invoice', {
    custom_tab_brake: function(frm) {
        // Fetch and display the invoice count when the custom_tab_brake tab is selected
        frappe.call({
            method: 'frappe.client.get_value',
            args: {
                doctype: 'Sales Invoice',
                filters: {
                    'customer': frm.doc.customer
                },
                fieldname: 'count(name)'
            },
            callback: function(response) {
                var count = response.message['count(name)'];
                frappe.msgprint(__('Number of Invoices for this Customer: ') + count);
            }
        });
    }
});
12

thank you for the help i solved the issue