Create billing schedules

On the Billing schedule page, you can create, delete, or edit billing schedules. You can also review the list of billing schedules. When you create a billing schedule, the default values for it are determined by the billing group that is associated with it. Additional information is set up on the Recurring contract billing parameters page.

Create a billing schedule

To create a billing schedule, follow these steps.

  1. On the Billing schedule page, select New.
  2. In the Create billing schedule dialog box, in the Billing schedule group field, select a billing schedule group.
  3. In the Customer account field, select a customer account.
  4. In the Start date field, select the start date, and then, in the Number of periods field, enter the number of periods. The End date field is updated based on the number of periods that you enter. If you update the Billing end date field, the Number of periods field is updated to 0 (zero).
  5. Select OK.
  6. On the Billing schedule page, in the General tab, in the Description field, enter a description of the billing schedule.
  7. In the Milestone template field, select a milestone template for Milestone billing.

Fields such as Invoice account and Currency code are updated with information from the customer.

The Billing frequency and Billing interval fields are automatically set, based on the selected billing schedule group.

  1. To create separate invoices, set the Invoice separately option to Yes.
  2. To automatically renew a billing schedule after the final billing period, set the Renew Automatically option to Yes, and then set the Lines to add per renewal field.

The Parameters fields are automatically set, based on the values on the Recurring contract billing parameters page.

  1. To prorate the amount of a billing schedule, set the Prorate partial periods option to Yes.
  2. To align the billing schedule detail lines with the end of a month, set the Align to month option to Yes.
  3. In the Contract start date and Contract end date fields, enter the start and end dates of the contract. These dates are for information only.

The Payment field shows the customer payment information from the customer. When a line item is on hold or terminated, the payment information can't be changed.

Note

When you consolidate invoices by item, the value of the Payment terms, Method, and Billing schedule fields must match. Otherwise, the invoices can't be consolidated.

  1. On the Address tab, you can review and update the Delivery address and Bill to address fields.
  2. On the Contact information tab, you can associate an end user account with the billing schedule.
  3. In the Contact info fields, you can enter a contact, email address, and internet address.
  4. To track partner commission information, set the Partner account and Partner commission rate fields. These fields are for information only.
  5. On the Total tab, you can view the various totals that have been calculated for the billing schedule.
  6. On the Hold tab, you can view audit information about when the billing schedule was put on hold when the hold was removed.
  7. On the Termination tab, you can view a history of the terminations that were applied to or removed from the billing schedule.
  8. Select Save.
  9. On the Billing schedule lines FastTab, select Add line.
  10. In the Item number field, select the item number. If the item that is added is a parent item in a revenue split, the lines are automatically updated with the child items. You can edit only the parent item in a revenue split. All child items are then updated accordingly.
  11. In the Item type field, select the item type.
  12. Update the start and end dates.
  13. Before the invoices are created, you can change the billing frequency by updating the Billing frequency field. After the first invoice for the billing schedule is created, the billing frequency can't be changed.
  14. In the Unit field, select the unit of measure for the item.
  15. In the Pricing method field, select the pricing method for the item.

The Unit price field is automatically set from inventory. However, you can update it if you change the pricing method to Flat.

Remove a line item

To remove an item from a billing schedule, follow these steps.

  1. On the Billing schedule page, in the Schedule number field, select the number of the billing schedule to edit.
  2. On the Billing schedule lines FastTab, select the line to delete, and then select Remove.
  3. Select Save.

Generate a quotation from a billing schedule

To generate a quotation document from a billing schedule, follow these steps.

  1. On the Billing schedule page, select the number of the billing schedule to edit.
  2. On the Billing schedule header Action pane, select Generate quotation.
  3. Fill in options on the Sales quotation page, such as From date and To date.
  4. Click Create.

The rest of this article describes the actions and details that are available for lines on the Billing schedule lines FastTab.

Billing schedule line actions

The buttons on the Billing schedule lines FastTab let you apply actions to individual lines.

Button Description
Add line Add a line to the billing schedule.
Add from items list Add multiple items to a billing schedule by selecting them in a list.
Remove

Remove the selected line from the billing schedule.

For items that are part of a revenue split, you can remove only the parent item. All associated child items are then automatically removed.

View billing detail View the billing details.
Terminate

Terminate the selected lines. This button is available only when the selected lines have a status of Active.

For items that are part of a revenue split, you can terminate only the parent item.

Remove termination

Remove the termination from the selected lines. This button is available only when the selected lines have a status of Terminated.

For items that are part of a revenue split, you can remove the termination only from the parent item.

Place hold

Select the details for putting the selected line on hold.

For items that are part of a revenue split, you can put only the parent item on hold.

Remove hold

Remove the hold from the selected line.

For items that are part of a revenue split, you can remove the hold only from the parent item.

Escalation and discount This button isn't available for items that are part of a revenue split, except parent items where the revenue split uses the Zero amount allocation method.
Deferrals

Enter deferral options for the selected line.

This button isn't available for parent items in a revenue split.

Milestone allocation

Review and update the milestone allocation information for the selected line.

This button is available only when the billing schedule line item is a milestone item.

Support and renewal

Review and update the support and renewal information for the selected line.

This button is available only when the billing schedule line item is a support or renewal item.

Display dimensions Show or hide the dimension columns that appear in the Billing schedule lines grid.
Calculate unit price

Calculate the unit price of the item, so that the customer can pay the contract amount in installments (for example, daily, monthly, quarterly, semiannually, or annually). You can select the contract price and price frequency.

You can view an audit trail of the changes: the old contract price and frequency, the new contract price and frequency, the user who made the change, and the date and time of the change.

Alignment date

Specify the alignment date for renewal items.

If you select an item group in the Item group field, all items use the alignment date of the first item in the item group in the billing schedule. If the Item group field is blank, you can specify an alignment date to use for all items.

This button is available only when the Billing frequency field is set to Annual.

Unbilled revenue

Set the item to use the unbilled revenue feature. You can then specify the unbilled revenue and unbilled discount accounts for the item.

This button is available only for items where the Item type field is set to Standard. It isn't available for existing billing schedules or for billing schedule lines where the invoice has already been created.

Add revenue split child

Select a child item to add to the sales order.

This button is available only for parent items in a revenue split.

Advanced pricing options Edit the pricing options for an item.

Billing schedule line details

When you select a line in the Billing schedule lines FastTab, you can view specific details for that line. Those details are divided among different tabs.

General tab

The following information is available on the General tab.

Field or section Description
Usage

This section provides information about usage items. It contains the following fields:

  • Usage identifier – The identifier of the meter or usage item.
  • Reading option – The usage reading option: Reading or Consumption.
  • Estimated consumption – Specify the estimated consumption for a usage item that has periods where the invoice hasn't been created. On the Billing detail page, you can review the billing detail lines for the estimated consumption.
External references* This section contains the External and Line number fields, where you can specify external reference information.
Milestone

This section provides information about milestone items. It contains the Estimated completion date field, which shows the item completion date.

Text A comment for the line. The text is translated to the default language of the customer or legal entity.
Item group The item group for the line item.
Alignment date The alignment date for the billing schedule.

* When you consolidate invoices by item on the Generate invoice page, the External reference fields must match. If even one character is different, the items won't be consolidated on the invoice. No validation checks are done on either field in the External reference section, and the value in the Line number field must be a positive integer.

Address tab

The following information is available on the Address tab.

Field Description
Delivery address

Select the delivery address for the line item. The default delivery address is the primary delivery address from the Address FastTab.

When you change the address, you can select the following address options:

  • Addresses – Select an address for the current customer.
  • In use – Select an address that is currently used for the current customer.
  • Other address – Select an address for any customer record.

For items that use revenue splitting, only the address for the parent item can be edited. The address for the child items matches the address for the parent and can't be edited separately.

Bill to address

Select the bill-to address for the line item. The default delivery address is the primary delivery address from the Address FastTab. You can change the address as you require, based on the purpose of the available addresses:

  • If none of the addresses have a purpose of Invoice, the default bill-to address is the primary address for the customer, regardless of the purpose.
  • If one or more of the addresses have a purpose of Invoice, the default bill-to address is the address that was most recently entered.
  • If one or more of the addresses have a purpose of Invoice, and one of the invoice addresses is set as the primary address, the default bill-to address is the address that has a purpose of Invoice and is set as the primary address.
  • For items that use revenue splitting, only the address for the parent item can be edited. The address for the child items matches the address for the parent and can't be edited separately.

Product tab

The following information is available on the Product tab.

Field or section Description
Storage dimensions

This section shows the storage information for the item. It contains the Serial number field, which shows the serial number of the item.

The serial number is copied from the initial sales order during the support and renewal process. For items that use revenue splitting, the serial number of the parent item is copied to all child items. The serial number is copied when the Copy serial number option is set to Yes on the Recurring contract billing parameters page.

Product dimensions The product details for the item and the values are automatically updated, based on the Variant number value that is selected for the billing schedule line.

Account tab

The following information is available on the Account tab.

Field Description
Main account The main account that is created on the sales line. The default value is from the sales order. This field can be blank.
Item financial dimensions

The default financial dimension values, based on the customer and item record.

For items that use revenue splitting, the child items use the financial dimension values of the customer and item records, as described earlier. If you must update the financial dimension values of child items, you can import the data entity.

Renewals tab

The following information is available on the Renewals tab.

Field Description
Renew automatically

A value that indicates whether the billing schedule line is automatically renewed for the next billing period:

  • Yes – The billing schedule line is automatically renewed for the next billing period when you create an invoice.
  • No – The billing schedule line isn't automatically renewed. You must manually renew the billing schedule.
Lines to add per renewal The number of lines to add to a billing schedule renewal.

Additionally, the following buttons are available on the Renewals tab.

Button Description
Unbilled revenue journal entry audit View all changes for items that use the unbilled revenue feature.
Add renewal term Add a renewal term for the item. The start date of the new renewal term is the next date after the end date of the previous term. The Renewal end date, Deferral start date, Deferral end date, Item quantity, and Unit price fields can be updated.
Modify renewal term

Modify a renewal term. For the initial term, you can change the deferral start and end dates before the initial journal entry is created. For subsequent terms, the start date can't be changed. It's always the next date after the end of the previous term.

If a renewal term exists after the term that you're modifying, the dates of the term can't be changed. In this case, only the Quantity and Unit price fields for the renewal item can be updated.

For example, three terms exist.

  • The first term can't be changed because it has already started.
  • For the second term, only the quantity and unit price can be changed.
  • For the third term, all values except the start date can be changed. Additionally, the Schedule from template option lets you create a deferral schedule that is based on the template for the unbilled revenue item. When this option is set to Yes, select the deferral template in the Template field, and change the deferral start and end dates as you require. Subsequent renewal terms use the same deferral template. However, the deferral template can be changed.

Termination tab

The following information is available on the Termination tab.

Field Description
Termination date The date when the billing schedule line is terminated. The default value is from the Termination date field on the header. You can change the value as you require.
Termination type The termination type. The default value is from the Termination type field on the header.

Hold tab

If revenue and expense deferrals are used, the Hold tab shows the deferral date.

Escalation and discount tab

The following information is available on the Escalation and discount tab.

Field Description
Escalation

Select whether escalations are allowed for the billing schedule line. Any escalation line from the header is applied when the billing schedule line is created.

  • Yes – Escalations can be applied to the line. When this option is selected, you can set up the escalations for the billing schedule lines on the Escalation and discount page.
  • No – Escalations can't be applied to the line.

The default setting is based on the Billing schedule group selected.

Price changes tab

For lines that are changed from Standard price to Flat price, the grid on Price changes tab includes the following columns:

  • Change date
  • Changed by user
  • Standard price
  • Flat price
  • Price update