SBS ARCB Billing Schedule Setup

Use this page to set up the default values for creating a billing schedule in Advanced Recurring Contract Billing (ARCB). All billing schedules that you create begin with these default values, but you can change the values for each billing schedule as needed.

Billing schedules are created on the SBS ARCB Billing Schedule Card page.

General

Use this FastTab for determining the default settings for new billing schedules. This FastTab contains the following fields: 

Field Description
Billing Schedule Status

Select the default status for a new billing schedule: Active or Pending Approval.

If you select Pending Approval as the status for new billing schedules, use the Activate Schedule action on the SBS ARCB Billing Schedule Card to change the status to Active so that invoices can be processed for the billing schedule.

Billing Schedule Group

Select the default billing schedule group when new billing schedules are created. Billing schedule groups are created on the SBS ARCB Billing Schedule Group page.

Notice Given Days Specify the default number of days notice that is given before a billing schedule is due for renewal.
Renew Days in Advance Specify the default number of days in advance that a billing schedule can be renewed.
Prorate Partial Period

Select whether to prorate the partial billing periods: 

  • On: Calculates partial amounts for first or last periods that are not full billing periods. The amounts for partial billing periods is a fraction of the full billing period amount.
  • Off: Does not calculate partial amounts when the first or last periods are not full billing periods. Partial billing periods are charged the same amount as full billing periods.
Align to Month

Select whether to align the billing schedule detail lines to the end of a month when a billing schedule is created or updated:

  • On: Aligns the billing schedule detail lines to the end of a month.
  • For a billing cycle that starts on April 15, the end of the first billing cycle is April 30. Each subsequent billing cycle then starts on the 1st of the month and ends on the last day of the month.

  • Off: Prevents the billing schedule detail lines from aligning with the end of a month.
  • For example, this option is selected and the billing frequency is monthly. For a billing cycle that starts on April 15, the end of the billing cycle is May 14. Each subsequent billing cycle starts on the 15th of the month and ends on the 14th of the month.

Termination Type

Select the default termination type: 

  • Bill Remaining: Adds any remaining amounts in the billing schedule to the termination period, changes the status of the schedule to Last Billing, and updates the deferral end date for an associated deferral schedule.
  • Adjust Schedule: Cuts off the billing schedule at the termination date, changes the status of the schedule to Last Billing, and adjusts the associated deferral schedule by reversing the amount that no longer must be recognized.
Unique Schedule Type

Select the schedule type:

  • None: No restrictions on creating billing schedules for customers.
  • Customer: Only one billing schedule can be created for each customer.
  • End user: Only one billing schedule can be created for each customer-end user combination.
Allow Multiple Customer Per End User

Indicates whether an end user can have relationships with more than one customer.

  • On: An end user can have relationship with multiple different customers.
  • On the SBS ARCB Customer and End User Relationship page, all customer records that have the End User option turned on are available to be selected as end users for the current customer record, regardless if the record has an existing customer-end user relationship.

  • Off: An end user can have a relationship with only one customer. Default.
  • On the SBS ARCB Customer and End User Relationship page, only customer records that have the End User option turned on and do not already have an existing customer-end user relationship are available to be selected as an end user.

For more information about customer-end user relationships, see General Scenario.

Sales Document Type (Service Item) Select the default type of sales document that is generated when the invoice for service items is created from a billing schedule: Sales Invoice or Sales Order.
Sales Document Type (Inventory Item) Select the default type of sales document that is generated when the invoice for inventory items is created from a billing schedule: Sales Invoice or Sales Order.
Use Posted Shipment Date Use the posted shipment date to calculate the Billing Start Date from the sales order. Please refer to the following table.

Posted Shipment Date Table

 

Back to top ▲

Sales Order/Invoice Creation

Use this FastTab to specify the default options used for creating sales orders and invoices on the SBS ARCB Billing Schedule Order/Invoice Creator. This FastTab contains the following options: 

Field Description
Consolidate by Customer

Select whether sales documents are consolidated by the sell-to customer:

  • On: Consolidates sales documents based on the following order of fields from the SBS ARCB Billing Schedule Card. Consolidation occurs when these values are the same: 
    • Sell to Customer Number (header)
    • Currency Code (header)
    • End User (line)
    • Bill-To Option (header)
    • Ship-to Option (header)
    • Payment Term (line)
    • Payment Method Code (line)
    • Direct Debit Mandate ID (line)
    • Shortcut Dimension 1 (header)
    • Shortcut Dimension 2 (header)
    • Dimension Set Id (header)
    • External Document Number (header)
    • Transaction Type (line)
  • Off: Does not consolidate sales documents by the sell-to customer.
Consolidate by Item

Select whether sales documents are consolidated by item:

  • On: Consolidates sales documents based on the following order of fields from the SBS ARCB Billing Schedule Card. Consolidation occurs when these values are the same:
  • When the unit price and discount amount are rounded, the rounded amounts must be the same for consolidation to occur. ClosedMore.

    For item consolidation to occur, the following rounded amounts for all lines that have the same item must match: 

    When the lines for the item are consolidated, the amount after consolidation is the sum of the rounded amount for all lines. The unit price is the average of the unrounded unit prices of the consolidated lines.

    Invoice rounding is a standard feature in Microsoft Dynamics 365 Business Central. For more information, see the Microsoft Dynamics 365 Business Central documentation: Set Up Invoice Rounding.

  • Off: Does not consolidate sales documents by item.
Consolidate by Item Excluding Start and End Date

Available when Consolidate by Item is selected for use.

  • On: When consolidating sales documents by item, the billing start and end dates are not considered when items are consolidated for a sales invoice or order. After items are consolidated based on the item consolidation criteria, the items are consolidated to a single line regardless of the start and ends dates for an item.
  • Off: When consolidating sales documents by item, the billing start and end dates are considered when items are consolidated for a sales invoice or order. After items are consolidated based on the item consolidation criteria, the items are consolidated to a single line only when the start or end dates for the item matches.

This option does not apply to deferral items.

Consolidate by Bill-To Customer

Select whether sales documents are consolidated by the bill-to customer:

  • On: Consolidates sales documents based on the following order of parameters from the SBS ARCB Billing Schedule Card
    • Bill-to customer number (shipping and billing)
    • Sell-to customer number (header)
    • Contact, email, and Internet address (header)
    • Currency (header)
    • End user (line)
    • Bill to option (header)
    • Ship-to option (header)
    • Payment terms (line)
    • Payment method code (line)
    • Direct debit mandate ID (line)
    • Dimensions (header)
  • Off: Does not consolidate sales documents by the bill-to customer.
Consolidate by Different End User

Select whether the end user values of the billing schedule lines are used when sales documents are consolidated:

  • On: Consolidates sales documents for the same customer regardless of the end user values for the billing schedule lines.
  • Off: Consolidates sales documents for the same customer only when the end user values for the billing schedule lines are the same. 

Support and Renewal

Use this FastTab to specify the default options for support and renewal items. This FastTab contains the following fields: 

Field Description
Support and Renewal Quantity

Select one of the following options: 

  • 1: Adds one support item at the transaction level for the sales order.
  • Invoice Qty: The quantity of the support item and the renewal item is the same as the original line item. The unit price and extended price are calculated accordingly.
Include Discount Indicates whether to include the discount in the billing schedule.
Support Level

Select the default support level to use for support items.

Support and renewal levels are created on the SBS ARCB Billing Support and Renewal Levelspage.

Tip: If you do not see the support level you need, select New to create a support level. Also, you can select Advanced to edit the values of an existing support level.

Support Frequency

Select the default support frequency for a billing schedule: Daily, One Time, Weekly, Monthly, Quarterly, Semiannually, or Annually.

Renewal Frequency

Select the default renewal frequency for a billing schedule: Daily, One Time, Weekly, Monthly, Quarterly, Semiannually, or Annually.

Renewal Schedule Group

Select the default billing schedule group to use for billing schedules that are renewed.

The groups are created on the SBS ARCB Billing Schedule Group page

Unbilled Revenue

Use this FastTab for specifying the default options for items that use the unbilled revenue feature. This FastTab contains the following fields: 

Field Description
Auto Post General Journal

Select whether the general journal entries for unbilled revenue amounts are automatically posted: 

  • On: Automatically posts the general journal entries for the unbilled revenue amounts.
  • Off: Does not post the journal entries for unbilled revenue amounts. You must manually post the journal entries.

Progressive Milestone

Use this FastTab for specifying the default options for using the progressive milestone billing feature. This FastTab contains the following fields: 

Field Description
Skip Credit Memo

Indicates whether the credit memo for a milestone item that uses the progressive milestone billing feature is created.

  • On: Does not create the credit memo for billing period, and adjusts the billing amount accordingly for the next billing period.
  • Off: Creates the credit memo for the billing period.
Auto Terminate

Indicates whether the billing schedule lines that are 100% completed are automatically terminated after the final invoice is created.

  • On: After the invoice for a line that is 100% completed is created, the billing schedule line is automatically terminated.
  • Off: After the invoice for a line that is 100% completed is created, a dialog appears asking you to confirm whether the billing schedule line is to be terminated. If you select not to terminate the line, you can manually terminate it at a later time. When several lines are 100% complete, a dialog appears for every line that can be terminated.

User-Defined Fields Header and Lines

Use this FastTab for creating user-defined fields for saving additional information. For each user-defined field you want to add, specify the name of the field box. These field boxes appear in the header and lines section when you add a billing or deferral schedule.

The user-defined fields for billing schedules are independent and unrelated to the user-defined fields for deferral schedules.

This FastTab contains the following fields: 

Field Description
User Defined Fields Header
User Defined Field

If you require user-defined field boxes for saving additional information, specify the name of the field box that you want to add. These field boxes appear in the header section when you add a billing or a deferral schedule. The available formats for the user-defined field boxes are as follows: 

  • Text field boxes 1 to 5 and 9 to 13
  • Date field boxes 6 and 14 to 17
  • Integer field boxes 7 and 18
  • Boolean field  boxes 8 and 19

The user-defined fields for billing schedules are independent and unrelated to the user-defined fields for deferral schedules.

User Defined Fields Lines
User Defined Field

If you require user-defined field boxes for saving additional information, specify the name of the field box that you want to add. These field boxes appear in the lines section when you add a billing or deferral schedule. The available formats for the user-defined field boxes are as follows: 

  • Text field  boxes 1 to 5 and 9 to 13
  • Date field boxes 6 and 14 to 17
  • Integer field boxes 7 and 18
  • Boolean field boxes 8 and 19

The user-defined fields for billing schedules are independent and unrelated to the user-defined fields for deferral schedules.

If you specified the names for any user-defined fields, only the user-defined fields that are specified appear in the header or lines section on the following page

Note icon. Note: If a customer has multiple billing schedules and the invoice is created using a consolidation option, information from the user-defined fields of only the first billing schedule appears on the consolidated invoice. The information for the user-defined fields of the other billing schedules does not appear on the invoice.

Performance

 

 

Audit Entries

Use this FastTab to select the field boxes for which you want to track changes. Turn on the audit option to track the changes for any of the following field boxes:

  • Price
  • Quantity
  • Start Date
  • End Date
  • Frequency
  • Deferral
  • New Billing Line
  • Delete Billing Line
  • Auto Renewal
  • Interval
  • Standalone Prices

When a change is made to the selected field boxes for a billing schedule, the SBS Audit Comment page will open, where reason for the change can be entered in the comment box.

 

Sales Documents No. Series

This FastTab contains the following fields: 

Field Description
Sales Invoice No. Series Select the number series that you want to apply to Sales Invoice that are associated with this group.
Sales Order No. Series Select the number series that you want to apply to Sales Order that are associated with this group.
Sales Credit Memo No. Series Select the number series that you want to apply to Sales Credit Memo that are associated with this group.
Posted Sales Invoice No. Series Select the number series that you want to apply to Posted Sales Invoice that are associated with this group.
Posted Sales Credit Memo No. Series Select the number series that you want to apply to Posted Sales Credit Memo that are associated with this group.

Action

This page contains the following action: 

Action Description
Navigate tab
Process

Select an action you want: 

Back to top ▲