Recalculate a billing schedule

Axel Martel, Cloud Kicks' sales assistant, has generated a billing schedule and would like to make some changes to the Opportunity. He will have to generate a new invoicing schedule in order to obtain invoices in line with the new amount of the Opportunity to be invoiced.

Add an Opportunity Product or Quotation Line Item

José informs Axel that the customer has used an additional service when delivering his order. Axel needs to add a complementary Opportunity Product and generate a new billing schedule to bill in line with his Opportunity.

1. From his Opportunity, Axel adds a Opportunity Product

2. Then clicks on the "Recalculate" button on the LWC component.

The Recalculate button is used to generate a new billing schedule, taking into account the modifications made to the Opportunity.
 

IMPORTANT : you must click on "Recalculate" after each modification made to an Opportunity Product.
This  icon reminds you to click on "Recalculate".

After a "Success" message, Axel notes: 

• The 3 previous invoices have been modified (and not replaced), taking into account the amount of the Opportunity Product added and broken down according to the % milestones of the invoicing schedule: 

• The LWC component displays the following values:

    

The Opportunity billing plan is 100%:

Note : from the LWC component, you have shortcuts to directly open the invoice in reference.

IMPORTANT : you must click on "Recalculate" after each modification made to an Opportunity Product.

What happens if an invoice has already been issued? 

The first Down Payment invoice has been issued and paid by the customer.

You need to add an Opportunity Product.

1. Add the Opportunity Product

2. Then click on the "Recalculate" button on the LWC component.

Only draft invoices are modified. The amount remaining to be invoiced is distributed over the draft invoices, according to the schedule model.

What happened? 

• In accordance with regulations, the invoice issued cannot be modified, as it has not been updated. The invoice includes a single invoice line: Shorts.

• Draft invoices include 2 invoice lines: Shorts + T-Shirts

• T-Shirts are billed at 100% on the 2 remaining draft invoices (i.e. 35%+65%), while shorts continue to be billed on the initial milestones.

The Percentage billed is visible in the sofactoapp__Percentage_billed__c field on the Invoice Line Item.
A new Pick list field sofactoapp__ItemStatus__c allows to detect whether the Opportunity Product/Quotation Line Item are used during recalculation, whose pick list values are as follows:  

• "is New" when adding an Opportunity Product/Quotation Line Item

• "Has Changed" upon modification of this Opportunity Product/Quotation Line Item

Not using Opportunities? You can follow exactly the same procedure after adding a Quotation Line Item.

Delete an Opportunity Product or Quotation Line Item

José informs Axel that a customer has decided to withdraw a service from his quotation and contract it at a later date.
Axel needs to delete an Opportunity Product from the Opportunity and generate a new billing schedule.

We'll see that the procedure is identical to that for adding an Opportunity Product.

1. From the Opportunity in question, Axel deletes a Opportunity Product.

   

2. Then clicks on the "Recalculate" button on the LWC component.

The Recalculate button button generates a new billing schedule, taking into account any modifications made to the Opportunity.

After a "Success" message, Axel notes: 

• The 3 previous invoices have been modified (and not replaced), taking into account the amount of Opportunity Product withdrawn and distributed according to the % milestones of the invoicing schedule. 

• The LWC component displays the new amounts. 

• The Opportunity billing plan is 100% 

IMPORTANT : you must click on "Recalculate" after each modification made to an Opportunity Product.

What happens if an invoice has already been issued? 

The first Down Payment invoice has been issued and paid by the customer.

You need to withdraw an Opportunity Product, which is present on the Down Payment Invoice. 

1. Remove Opportunity product

2. Then click on the "Recalculate" button on the LWC component.

Only draft invoices are modified. Draft invoices now include only one invoice line: Shorts.

In accordance with regulations, the invoice issued cannot be modified, as it has not been updated.

Not using Opportunities? You can follow exactly the same procedure after deleting an Offer Item.

Modify the invoiced unit price

José informs Axel that the unit price of an item offered to his customer will be reduced. Axel needs to modify the unit price of his Opportunity product, Club Junior Tee shirts, and generate a new invoicing schedule to invoice in line with his Opportunity.

1. Axel opens the Opportunity product question 

2. Modifies the  sales price of its Opportunity Product 

3. Then clicks on the"Recalculate" button on the LWC component.

The Recalculate button is used to generate a new billing schedule, taking into account the modifications made to the Opportunity.

After a "Success" message, Axel notes: 

• The 3 previous invoices have been modified (and not replaced), taking into account the new Sales Price of the modified Opportunity Product and distributed according to the % milestones of the invoicing schedule 

• The LWC component displays the new amounts 

• The Opportunity billing plan is 100% 

Note : from the LWC component, you have shortcuts to directly open the invoice in reference.

IMPORTANT : you must click on "Recalculate" after each modification made to an Opportunity Product.

What happens if an invoice has already been issued? 

The first Down Payment invoice has been issued and paid by the customer.

You need to change the selling price of an Opportunity Product.

1. Change the selling price of Opportunity product

2. Then click on the "Recalculate" button on the LWC component.

Only draft invoices are modified. The amount remaining to be invoiced is distributed over the draft invoices, according to the schedule model. In accordance with regulations, the invoice issued cannot be modified, as it has not been updated.

Not using Opportunities? You can follow exactly the same procedure from the  Sales Price of an Quotation Line Item.

Modify Billing Quantity

José informs Axel that the customer has ordered 5 additional sports items. Axel needs to modify the quantity of his Opportunity Product and generate a new billing schedule to invoice in line with his Opportunity.

1. Axel opens the Opportunity product question 

2. Modifies the quantity of its Opportunity Product 

3. Then clicks on the "Recalculate" button on the LWC component.

The Recalculate button is used to generate a new billing schedule, taking into account the modifications made to the Opportunity.

After a "Success" message, Axel notes: 

• The 3 previous invoices have been modified (and not replaced), taking into account the new quantity of the modified Opportunity Product and distributed according to the % milestones of the invoicing schedule 

• The LWC component displays the new amounts 

• The Opportunity billing plan is 100% 

Note : from the LWC component, you have shortcuts to directly open the invoice in reference.

IMPORTANT : you must click on "Recalculate" after each modification made to an Opportunity Product.

What happens if an invoice has already been issued? 

The first Down Payment invoice has been issued and paid by the customer.

You need to modify the quantity of an Opportunity Product.

1. Modify the quantity of  an Opportunity product

2. Then click on the "Recalculate" button on the LWC component.

Only draft invoices are modified. The amount remaining to be invoiced is distributed over the draft invoices, according to the schedule model. In accordance with regulations, the invoice issued cannot be modified, as it has not been updated.

Not using Opportunities? You can follow exactly the same procedure from the quantity of an Quotation line item.

Directions for use

Limit of use: the discount

The addition, modification or withdrawal of a discount on the Opportunity Product or Quotation Line Item is not taken into account when recalculating the billing schedule.
It is advisable to apply the discount directly to the generated invoice.

Tip: recalculate one modification at a time

The modifications are applicable one after the other. You must click on "Recalculate" after each modification made to an Opportunity Product or Quotation Line Item.

Example: Axel wants to change the quantity of Opportunity Product A and add Opportunity Product B to his Opportunity. Here are the steps to follow: 

1. open Opportunity Product A, modify quantity, save

2. click on "Recalculate

3. then add Opportunity Product B to Opportunity

4. click on "Recalculate

It is not advisable to modify the quantity of Product A and add Opportunity Product B, then click on "Recalculate". The risk is that you will be billed the wrong amount for the Opportunity.