This alert will let you know about active contracts that are not billing overages. (This alert does not take into account expire by copies contracts.)
You can either run this alert to see only past due overage billings or to see overage billings a specific number of days into the future (this will also include ALL past due overage billings).
If you want to see only past due overage billings you need a negative number in VariableW for how many days past due you want to include.
VariableW - List contracts where overagenextbilling date < Today + VarW Days (use a negative number here if you only want to see past due.....use a positive number if you want to include future billings due), defaults to -10
VariableX - CustomerTypes to exclude from reporting (separate by comma or blank for ALL), defaults to blank for ALL
VariableY - Contract Bill Codes to exclude from reporting (separate by comma or blank for ALL), defaults to blank for ALL
VariableZ - ContractTypes to exclude from reporting (separate by comma or blank for ALL), defaults to blank for ALL
Line 1 in Figure 1 shown above shows overage billing as 189 days past due.
If you're using this to see the contracts that need overage billing up to the next VariableW days in the future then list VariableW as a positive number.
Line 1 in Sample shown above shows -6 in Days Past Due. This means this overage is set to bill in six days from the day this alert output was created.
**This alert will also list active contracts that need their overage billing period enabled. This alert sorts by days past due except for the ones that need their billing period enabled. Those will show at the top. Once you fix the billing period then they sort within the days past due where they are supposed to.
This alert will also help you identify contracts that are still active but should be terminated.
See link on best practices for terminating contracts. https://ceojuice.zendesk.com/entries/22932536-best-practices-for-terminating-contracts
Also see link for termination codes on contracts. https://ceojuice.zendesk.com/entries/22973116-termination-codes-on-contracts