The Rates and Rules Custom Bill Formula functionality allows you to create and maintain two types of formulas: Bill Rate Formulas & Rate Matrix Formulas.
Bill Rate Formulas calculate invoice bill amounts using customized logic instead of default system-defined margin.
Rate matrix formulas calculate alternative gross profit values displayed in the rates matrix of a job order. These formulas do not impact bill calculations.
Custom formulas let you replace system-defined calculations with business-specific rules using pay rates, quantities, oncosts, fixed values, and other custom formulas.
📌 Note:
User would need permission to apply custom bill rate formulas. Administrator will have to go to Maintenance, Hierarchy, Middle Back Office Country Setting, then Standard Rate Bill Types.
For more information, see Bill Type Settings.You can also apply custom bill rate formulas to items in a Standard Rates Matrix on job orders and standard rate templates.
Create a Custom Bill Formula
Build the Formula
Go to Rates and Rules, then Maintenance, then Custom Bill Formulas, then Bill Formula Maintenance.
Click Add (+) to open the Bill Formula Entry screen.
Change Country if the formula applies to a different country.
Enter the formula name
Select Formula Type: Bill Rate Formula or Rate Matrix Formula & add Description.
In the Formula Builder field, click Add (+) to insert a new row.
Select a Type and the required Component.
Enter a Value or Test Value, depending on the component.
Repeat step 7-8 as needed until the full formula is built.
Test and Save
Click Evaluate Formula to test your calculation.
If the formula is valid, the Test Formula pane displays the result of your formula.
If your formula is invalid, an informative error message is displayed, and you will need to refer to the error message to correct the formula
Click Save once the formula evaluates successfully.
💡 Best Practices
Create separate formulas for testing before rolling changes out to production.
Use fixed values and standard components consistently to maintain reliable calculations.
Review active hierarchy assignments regularly to ensure formulas appear correctly on job orders.
Test formulas across several job orders to verify the displayed results.