Enable
The invoice calculation matrix functionality is enabled automatically when the respective Modules & Functions for Fixed Invoicing and Service Packages are enabled.
There is also an additional setting called Invoice Calculation Matrix Profiles that restricts access to assigning a specific matrix profile to a customer record.
Once enabled, the Invoice Calculation Matrix Profiles Module & Function can be enabled or disabled at the user and profile levels; again, this is through the support team.
Profile
Click Settings, then click Other.
Click Profile & Users, then click Modules & Functions.
Select the relevant record, then from the QuickLinks click Modules.
Click Bill Payer, then select the Invoice Calculation Matrix Profile checkbox.
Users
Click Settings, then click Other.
Click Profile & Users, then click Users.
Select the relevant record.
From the QuickLinks click Modules & Functions.
Click Bill Payer, then select the Invoice Calculation Matrix Profile checkbox.
Configure
Once the Module & Functions have been enabled, the invoice calculation matrix feature can be configured.
To configure the invoice calculation matrix, follow these steps.
Click Settings, then click Finance,
Click Invoice, then click Calculation Matrix.
On the Calculation Matrix screen, there are several options to choose from that apply to Daily, Weekly, Monthly, and Annual calculations.
The available options within each calculation drop-down are as follows:
Daily
Tab | Field | Option |
Daily | Weekly Calculation | (Daily x 365) / 52 |
Daily | Weekly Calculation | Daily x 7 |
Daily | Monthly Calculation | (Daily x 365) / 12 |
Daily | Annually Calculation | Daily x 365 |
Weekly
Tab | Field | Option |
Weekly | Daily Calculation | (Weekly x 52) / 365 |
Weekly | Daily Calculation | Weekly / 7 |
Weekly | Monthly Calculation | (Weekly x 52) / 12 |
Weekly | Annually Calculation | Weekly x 52 |
Weekly | Annually Calculation | (Weekly / 7) x 365 |
Monthly
Tab | Field | Option |
Monthly | Daily Calculation | (Monthly x 12) / 365 |
Monthly | Weekly Calculation | (Monthly x 12) / 52 |
Monthly | Weekly Calculation | (Monthly x 12) / Weeks per Year Override |
Monthly | Annually Calculation | Monthly x 12 |
Annually
Tab | Field | Option |
Annually | Daily Calculation | Annually / 365 |
Annually | Daily Calculation | Annually / 365.25 |
Annually | Weekly Calculation | Annually / 52 |
Annually | Weekly Calculation | Annually / Weeks per Year Override |
Annually | Monthly Calculation | Annually / 12 |
The Weeks per Year field allows the number of weeks per year to be overridden based on the required calculation. This field is shared across all tabs and is referenced in the / Weeks per Year Override options for the Weekly Calculation on the Monthly and Annually tabs.
If no value is entered in the Weeks per year field, the default value of 52.143 weeks are used.
The Weeks per Year field has validation, which means the value entered cannot be less than 52 or greater than 53.
