Settings of the Invoice Revenue By Group report
For correct operation of the Invoice Revenue By Group report, it is important to know the function of its settings and filters.
The Format section shows the available file formats that you can use to save the report:
The Base Options section shows the primary settings of the report:
This table gives the function of each setting:
| Setting | Function |
|---|---|
| Dates(Inclusive) | Use to select the date range of the report. |
| Group By | Use to select the primary group that ezyVet uses as a filter to show report data. For example:
Note: To calculate the data:
If you do not set the Sub Group By value, ezyVet only uses the Group By value to show the report data. |
| Include Zero Results | If you set this to ON, the report shows one row for each record. It is not necessary for the record to have invoice revenue data. Important: The report can have a very large quantity of rows that do not show revenue data. If you set this to OFF, the report only shows records that have invoice revenue data. |
| Sub Group By | Use to select the secondary group that ezyVet uses as a filter to show report data. To calculate the report data to show, ezyVet: For example, if you set Group By to Breed and Sub Group By to Date (Month), the report shows monthly invoice revenue of each breed.
Note: If you do not set the Sub Group By value, ezyVet only uses the Group By value to show the report data |
| Include Tax | If you set this to ON, the report shows tax data. If you set this to OFF, the report does not show tax data. OFF is the default value. |
| Include Earned/Commission | Use to show more commission data in the report. If you set this to ON, the report shows these columns:
|
| Count By 1 | Shows the total number of a type of item related to the Group By value and the Sub Group By value. Note: For example:
Result: The report shows an Invoice Count column. The column shows the total number of invoices of each primary product group. |
| Count By 2 | Shows the total number of one more type of item related to the Group By value and the Sub Group By value. This setting has the same function as the Count By 1 setting. |
Dedicated filters of the Invoice Revenue By Group report
The Invoice Revenue By Group report has many other filters that show dedicated types of invoice revenue information. For example, you can show invoice revenue that is related to one department only or one staff member only.