Max Months Rates Still Charging Projects

Please see this ticket for the issue, Ticket: https://support.swinerton.com/support/tickets/332115

(below is Wynne's solution article)

Max Cap Billing

Test in a Test Environment initially, to ensure the Max Cap Billing works as expected when configured.

Max cap billing is a feature that allows the system to recognise when to reduce or stop billing against items when they hit a particular threshold. This could be due to commercial decisions or business practice. An example may be that as an internal rental business, you may only want to recover the purchase cost through invoicing your internal project and once that value has been recovered, the item remains on rent but at zero cost. Another example may be that you wish to recover 120% of the assets purchase value and allow a 20% administrative fee to cover cost as well as the value. There may also be contractual agreements in place, which could benefit from this feature. 

Configuration for max months charging.  

Set up an item transaction which has the "Complete invoices only" flag checked

Set up a charging calculation template with the monthly rate set as slot 1 

Check the "Allow maximum charge" flag (1) and set the "Maximum months slot" field (2) to 2 

Create or update an item to use the configured charging calculation. 

Check the "Maximum charge" flag for the item. 

Add a rental rate for the charging calculation

Select an AR account to use and set the "Maximum charge type" field to "Standard maximum months charge". 

Test 1.  

Create a rental contract for the configured account. 

Add 2 lines using the configured item for both. 

Set the monthly rental rate of the first line to be 2000 and the max months to be 4. 

Set the monthly rental rate of the second line to be 0 and the max months to be 4. 

Save the contract and then dispatch it. 

Run continuation billing for the first month’s rental and confirm that the first line is invoiced. 

Run continuation billing for the next 3 months and confirm that the first line is invoiced. 

Run continuation billing for the 5 month and confirm that no invoice is generated. 

Test 2.  

Repeat the above test but add a 3rd line. 

Set the monthly rental rate of the 3rd line to be 4000 and the max months to be 2. 

Confirm that the 3rd line is only billed on the first 2 continuation billing runs. 

Configuration for max percentage charging.  

Set up a charging template like the configuration for "Max months" above, but in the "Maximum charge" tab set the "Maximum % slot" to 2 and leave the "Maximum months slot" inactive. 

Set up an item to use this charging calculation with the "Maximum charge" flag checked and a price set up against it. 

Test 3.  

Change the AR account configuration so that the "Maximum charge type" field is now set to "Standard maximum % charge". 

Change the item configuration so the "Replacement cost" field is set to 7,500. 

Create a rental contract for the configured account. 

Add 2 lines using the configured item for both. 

Set the monthly rate of the first line to be 250 and the percentage rate to be 10. 

Set the monthly rate of the second line to be 0 and the percentage rate to be 10. 

Run continuation billing for the first month and confirm that only the first line is billed. 

Run continuation billing for the next 2 months confirming that only the first line is billed on both. 

Run continuation billing for the next month and confirm that no bill is produced as the total amount billed is 750 which is 10% of the replacement cost. 

Regression testing: Issue 116224  

Configure a new charging calculation template with the following settings. 

Set up the Daily (1), Weekly (2) and Monthly (3) slots.[Text Wrapping Break] 

Set up the "Maximum months slot" (1) and the "Monthly maintenance fee slot" (2). 

Add the charging calculation to an item and then follow the rest of the configuration for the max months charging. 

Test 4  

Create a contract for the configured account. 

Add 3 lines using the configured item for all 3. 

On the first line set the following details: 

• Daily rate = 6 
• Weekly rate = 8 
• Monthly rate = 10 
• Max Months = 3 
• Maintenance Fee = 1.75 

On the second line set the following details. 

• Daily rate = 6 
• Weekly rate = 10 
• Monthly rate = 25 
• Max Months = 4 
• Maintenance Fee = 0 

On the third line set the following details. 

• Daily rate = 0 
• Weekly rate = 0 
• Monthly rate = 0 
• Max Months = 3 
• Maintenance Fee = 1.75 

Dispatch the contract. 

Run continuation billing 10 days after the dispatch date. 

At this point the first line will hit the best rate i.e. it will try to the charge the monthly rate, however the second line would not hit the best rate as it would try to charge for 2 weeks. 

As both lines do not hit the best rate available, no bill will be produced. 

Run continuation billing 18 days after the dispatch date. 

At this point both lines will hit the best rate. 

Confirm that a bill for the first 2 lines is generated. 

Run continuation billing for 2 more months and confirm that a bill for the first 2 lines is produced. 

[Text Wrapping Break] 

Run continuation billing for the 4th month. 

Confirm that a bill is produced for the first 2 lines and that the amount charged for the first line is the maintenance fee and that the second line amount is for the monthly rate. 

Run continuation billing for the 5th month. 

Confirm that a bill is produced and that it only has the maintenance charge for the first line.