Service invoices count
Calculates all closed invoices which have service added to them.
Validate in Zenoti
Zenoti > Reports NEW (v2 report) > Financial Reports > Sales - Accrual report > Select all values in Item Type, Sale Type, and Payment Type dropdown > Select centers as displayed in the ezPulse app.
Unhide the Invoice Closed Date and Status column.
Export the report in Excel, open the file remove the top 5 rows and the last row.
Select the table and Go to Insert Tab > Pivot table
Add Item Type in Filters, select Service.
Add Item Status in Filters, select Closed.
Add Invoice No in Rows and count the number of invoices shown.