In this article

SBS ARCB Billing Schedule Card

Use this page to create, delete, or edit billing schedules. You can also review a list of all billing schedules.

When you select to view a billing schedule, a separate page showing the details of the billing schedule.

When you create a billing schedule, the default values for the billing schedule are determined by the billing group associated with the billing schedule. Also, other default values are set up on the SBS ARCB Billing Schedule Setup form. You can change any of the default values as needed.

Revenue Split

When you add an item that is a part of a revenue split, keep the following information in mind: 

  • The Parent amount cannot be deferred.
  • The start date, end date, quantity, unit, site, auto-renewal and warehouse values for child items are based on the parent item.
    You cannot change these values for the child items. Any changes must be made for the parent item.
  • The Pricing method is Flat and cannot be changed.
  • Child items can be added or removed.
  • Child items can have one of the following:
    • Same Billing frequency and Billing intervals as the parent item.
    • The Billing frequency set to One-time, which automatically sets the Billing intervals to 1.
  • The sum of the net amount of the child items is equal to the Parent amount.
  • If the MEA type for the sales order is single, the corresponding MERA transaction line is created when the parent and child lines are added.
  • When the allocation method for a revenue split is Equal amounts and the Parent amount is changed, the amounts for all child lines are recalculated.
  • For a revenue split that has the Allocation method set to Variable amount:
    • The net amount of the parent item appears in the Parent amount column.
      This value can be edited. However, the unit price, net amount, and discount cannot be edited and show a zero (0) amount.
    • The unit price for child items shows a zero (0) value.
      You can edit the unit price or net amount. When you edit one value, the other value is automatically updated.
  • For a revenue split that has the Allocation method set to Percentage:
    • The net amount of the parent item appears in the Parent amount column.
      This value can be edited. However, the unit price, net amount, and discount cannot be edited and show a zero (0) amount.
    • The net amount for child items is calculated as follows: Percentage * Parent amount.
  • For a revenue split that has the Allocation method set to Equal amount:
    • The net amount of the parent item appears in the Parent amount column.
      This value can be edited. However, the unit price, net amount, and discount cannot be edited and show a zero (0) amount.
    • The net amount of the child items is calculated by dividing the Parent amount equally among all child items.
    • When child items are removed or added, the net amount and unit prices are recalculated so that all child lines have equal amounts.
    • If the Parent amount cannot be divided perfectly equal, the net amount and unit price of the last child item may be slighter more or less than the other child items.

Add a Billing Schedule

To add a billing schedule, follow these steps:

  1. From the SBS ARCB Billing Schedule List, select New, the Billing Schedule Group List appears.
  2. Select a billing schedule group, and select OK.

    3. The SBS ARCB Billing Schedule Card page appears with some options already updated based on the settings from the billing schedule group. If needed, you can edit any option.

  3. In the Schedule FastTab, update the following as needed:
    1. If automatic numbering is setup, the billing schedule No. is automatically updated. If the billing schedule group does not use automatic numbering, specify the number.
    2. Select the Sell-to Customer No..
      The Customer Name and Sell-to address and contact information updates with the information from customer record. If needed, edit the address information.
    3. If needed, select the End User No. and the Billing Start Date.
    4. The Billing End Date is automatically updated based on the Frequency and Number of Periods specified.
    5. As needed, specify values for other options.
  4. In the Schedule Lines FastTab, add line items to the billing schedule.
  5. In the Schedule Details FastTab, specify the line details for a specific line item, such as currency code, payment terms and method, and other options.
  6. In the Shipping and Billing FastTab, select the shipping and billing information.

    7. If the billing schedule you create has a Pending Approval status, you must use the Activate Schedule action to change the status to Active so that you can process invoices.

Delete a Billing Schedule

To delete a billing schedule, follow these steps: 

  1. Select one or more lines that you want to delete, and select Delete.
  2. When you are asked to confirm the action, select Yes.

You can delete only one billing schedule at a time.

The following actions can be performed on a billing schedule or a billing schedule line.

Copy a Billing Schedule

To create a copy of a billing schedule, follow these steps: 

  1. On the SBS ARCB Billing Schedule Card page, select Actions tab > Copy > Copy Schedule.

    2. On the SBS ARCB Billing Copy Schedule page, the Source Schedule FastTab is automatically updated with the information of the billing schedule you want to copy.

  2. In the New Schedule FastTab, do the following: 
    • Specify a Description and select a Customer.
    • Specify the start and end dates for the billing schedule.
    • If need, change the Billing Frequency and Number of Periods.
  3. In the lines section, you can add or remove lines as needed.
    When you add a line, specify the values for the line.
  4. For existing lines, you can change only the Pricing Method, Unit Price, or Quantity as needed.
  5. Select Copy Process.
  6. Select whether you want to all items to use the same start and end dates.

After the copy process finishes, the newly created billing schedule appears in the SBS ARCB Billing Schedule Card page. If the billing schedule being copied is a terminated, the newly created billing schedule is the exact same except the status of the billing schedule and all lines are active and the termination date is cleared.

Terminating a Billing Schedule

To terminate several billing schedules, use the SBS ARCB Billing Batch Termination Process.

To terminate a billing schedule, follow these steps: 

  1. From the SBS ARCB Billing Schedule List, select a line. Or from the SBS ARCB Billing Schedule Card edit a record.
  2. Select Actions > Termination > Terminate Schedule, which opens the SBS ARCB Billing Schedule Termination page.
  3. In the General FastTab, do the following:
    1. specify the Termination Date.
    2. Select the Reason Code and Reason Code Value.
    3. Specify a Termination Note.
  4. Select Actions > Termination > Terminate.
  5. When you are asked to confirm the action, select Yes.

To terminate a billing schedule and create a credit memo, follow these steps: 

  1. From the SBS ARCB Billing Schedule List, select a line. Or from the SBS ARCB Billing Schedule Card edit a record.
  2. Select Actions > Termination > Terminate Schedule.
  3. In the SBS ARCB Billing Schedule Termination page, specify the Termination Date and set Termination Type to Adjust Schedule.
  4. Select the Reason Code and Reason Code Value.
  5. Specify a Termination Note.
  6. Select Issue credit, and then do the following: 
    1. If you want to prorate the amount of the final invoice, select Prorate Daily.
    2. Select the Invoice Date.
    3. If the billing schedule has an associated deferral schedule, select the Deferral Adjustment Method.
  7. Select Actions > Credit Memo(s), and select Create Credit Memo(s), Post Credit Memo(s), or Post & Send.
  8. Select Actions > Termination > Terminate.
  9. When you are asked to confirm the action, select Yes.

To terminate a billing schedule and bill the remaining amount, follow these steps: 

  1. From the SBS ARCB Billing Schedule List, select a line. Or from the SBS ARCB Billing Schedule Card edit a record.
  2. Select Actions > Termination > Terminate Schedule.
  3. In the SBS ARCB Billing Schedule Termination page, specify the Termination Date and set Termination Type to Bill Remaining.
  4. Select the Reason Code and Reason Code Value.
  5. Specify a Termination Note.
  6. Select Actions > Termination > Terminate.
  7. When you are asked to confirm the action, select Yes.

Terminating a Schedule Line

To terminate a billing schedule line, follow these steps: 

  1. On the SBS ARCB Billing Schedule Card page, select one or more lines in the Schedule Lines.
  2. Select Termination > Terminate, which opens the SBS ARCB Billing Schedule Termination page.
  3. Specify the Termination Date, and set Termination Type to Bill Remaining.
  4. Select the Reason Code and Reason Code Value.
  5. Specify a Termination Note.
  6. Select Actions > Termination > Terminate.
  7. When you are asked to confirm the action, select Yes.

Terminate a billing schedule line and create a credit memo: 

  1. On the SBS ARCB Billing Schedule Card page, select one or more lines in the Schedule Lines.
  2. Select Termination > Terminate, which opens the SBS ARCB Billing Schedule Termination page
  3. Specify the Termination Date and set Termination Type to Adjust Schedule.
  4. Select the Reason Code and Reason Code Value.
  5. Specify a Termination Note.
  6. Select Issue credit, and then do the following: 
    1. If you want to prorate the amount of the final invoice, select Prorate Daily. .
    2. Select the Invoice Date.
  7. In the Actions tab, select Create Credit Memo(s), Post Credit Memo(s), or Post & Send.
  8. When you are asked to confirm the action, select Yes.

Remove a Termination

Remove a termination from a billing schedule : 

  1. On the SBS ARCB Billing Schedule Card page, select Actions > Termination > Remove Termination.
  2. When you are asked to confirm the action, select Yes.

Remove a termination from a billing schedule line: 

  1. On the SBS ARCB Billing Schedule Card page, select one or more lines in the Schedule Lines that has been terminated.
  2. Select Termination > Remove Termination.
  3. When you are asked to confirm the action, select Yes.

View the Termination History

View the termination history for a billing schedule

  1. On the SBS ARCB Billing Schedule Card page, select Actions > Termination > Schedule Termination History.
  2. On the SBS ARCB Billing Schedule Termination History, review the termination changes to the billing schedule.
  3. When you are finished, select Close.

View the termination history for a billing schedule line: 

  1. On the SBS ARCB Billing Schedule Card page, select a line in the Schedule Lines.
  2. Select Termination > Termination History, which opens the SBS ARCB Billing Schedule Termination History.
  3. When you are finished, select Close.

Put a Hold on a Billing Schedule

To put a hold on several billing schedules, use the SBS ARCB Billing Batch Hold Process.

To put a hold on a billing schedule, follow these steps: 

  1. From the SBS ARCB Billing Schedule List, select a line. Or from the SBS ARCB Billing Schedule Card edit a record.
  2. Select Actions > Hold Functions > Hold Schedule.
  3. On the SBS ARCB Billing Schedule Hold page, select the Reason Code and Reason Code Value.
  4. If needed, select Create Adjustment and in Enter Hold Date, specify the hold date.
  5. Select Actions > Process > Hold.
  6. When you are asked to confirm the action, select Yes.

To put a hold on a billing schedule line, follow these steps: 

  1. On the SBS ARCB Billing Schedule Card page, select one or more lines in the Schedule Lines FastTab.
  2. Select Hold > Hold .
  3. On the SBS ARCB Billing Schedule Hold page, select the Reason Code and Reason Code Value.
  4. If needed, select Create Adjustment and in Enter Hold Date, specify the hold date.
  5. Select Actions > Process > Hold.
  6. When you are asked to confirm the action, select Yes.

Remove a Hold

To remove a hold from a billing schedule, follow these steps: 

  1. On the SBS ARCB Billing Schedule Card page, select Actions > Hold > Remove Hold.
  2. When you are asked to confirm the action, select Yes.

Remove a hold from a billing schedule line:

  1. On the SBS ARCB Billing Schedule Card page, select one or more lines in the Schedule Lines that is put on hold.
  2. Select Hold > Remove Hold.
  3. When you are asked to confirm the action, select Yes.

View the Hold History

View the hold history for a billing schedule : 

  1. On the SBS ARCB Billing Schedule Card page, select Actions > Hold Functions > Schedule Hold History, which opens the SBS ARCB Billing Schedule Hold History page.
  2. When you are finished, select Close.

View the hold history for a billing schedule line: 

  1. On the SBS ARCB Billing Schedule Card page, select a line in the Schedule Lines.
  2. Select Hold > Hold History, which opens the SBS ARCB Billing Schedule Hold History page.
  3. When you are finished, select Close.

Back to top ▲

Apply a Price Adjustment

To apply a price adjustment or a discount to a billing schedule line, follow these steps: 

  1. On the SBS ARCB Billing Schedule Card page, select one or more lines in the Schedule Lines area.

    2. The item number is automatically updated with the item of the line.

  2. Select Price Adjustment > Price Adjustment, which opens the SBS ARCB Billing Price Adjustment page.
  3. Specify the Price Index Calculation.
  4. In the lines do the following: 
    1. If the price change is a discount, select Discount.
    2. Specify the Start Date, Frequency, Percentage or Amount, select the Price Index Schedule, and specify the End Date.
  5. In the Actions tab, select Adjust the Price.
  6. When you are asked to confirm the action, select Yes.

View the Price Adjustment History

View the price adjustment history for a billing schedule:

  1. On the SBS ARCB Billing Schedule Card page, select Actions tab > Price Adjustment Functions > Schedule Price Adjustment History, which opens the SBS ARCB Billing Price Adjustment History page.
  2. When you are finished, select Close.

View the price adjustment history for a billing schedule line:

  1. On the SBS ARCB Billing Schedule Card page, select a line in the Schedule Lines area.
  2. Select Price Adjustment > Price Adjustment History, which opens the SBS ARCB Billing Price Adjustment History page.
  3. When you are finished, select Close.

Apply the Price Index History

View the Price Index history for a billing schedule:

  1. On the SBS ARCB Billing Schedule Card page, select Actions tab > Price Adjustment Functions > Price Index History, which opens the SBS ARCB Billing Price Index History page.
  2. When you are finished, select Close.

View the Price Index history for a billing schedule line:

  1. On the SBS ARCB Billing Schedule Card page, select a line in the Schedule Lines area.
  2. Select Price Adjustment > Price Index History, which opens the SBS ARCB Billing Price Index History page.
  3. When you are finished, select Close.

View the Discount History

View the discount history for a billing schedule: 

  1. On the SBS ARCB Billing Schedule Card, select Actions tab > Price Adjustment Functions > Discount History, which opens the SBS ARCB Billing Discount History.
  2. When you are finished, select Close.

View the discount history for a billing schedule line: 

  1. On the SBS ARCB Billing Schedule Card, select a line in the Schedule Lines area.
  2. Select Price Adjustment > Discount History, which opens the SBS ARCB Billing Discount History.
  3. When you are finished, select Close.

Back to top ▲

Archive a Billing Schedule

Archive a billing schedule: 

  1. On the SBS ARCB Billing Schedule Card page, select Actions tab > Archive Function > Archived.
  2. On the SBS ARCB Billing Batch Archive Process page, select the billing schedule lines that you want to archive.
  3. Select Archived.
  4. When you are asked to confirm the action, select Yes.

Caution: Archiving a billing schedule is a permanent action and cannot be reversed.

Tip: To archive multiple billing schedules, use the SBS ARCB Billing Batch Archive Process page.

Stubbing a Billing Schedule

Stub a billing schedule: 

  1. On the SBS ARCB Billing Schedule Card page, select Actions tab > Stubbing Function > Apply Stubbing.
  2. On opens the SBS ARCB Billing Schedule Card page, specify the Stubbing Date.
  3. In the Actions tab, select Stub.
  4. When you are asked to confirm the action, select Yes.

Stub a billing schedule line: 

  1. On the SBS ARCB Billing Schedule Card page, select one or more lines in the Schedule Lines area.
  2. Select Stubbing > Apply Stubbing , which opens the SBS ARCB Billing Schedule Card page.
  3. Specify the Stubbing Date.
  4. In the Actions tab, select Stub.
  5. When you are asked to confirm the action, select Yes.

Reverse the Stubbing

Reverse the stubbing on a billing schedule: 

  1. On the SBS ARCB Billing Schedule Card page, select Actions tab > Stubbing Function > Reverse Stubbing.
  2. When you are asked to confirm the action, select Yes.

Reverse the stubbing on a billing schedule line: 

  1. On the SBS ARCB Billing Schedule Card page , select one or more lines in the Schedule Lines FastTab.
  2. Select Stubbing > Reverse Stubbing.
  3. When you are asked to confirm the action, select Yes.

Use Multiple Customer Posting Groups

You can set up multiple posting groups which you can use as alternative posting groups when you are posting sales and purchase documents and journals.

Note icon. Note: If you are using Business Central 22.0 and SBS ARCB 40.7 or earlier, then you must go to the Feature Management page and turn on these features manually. It is automatically turned on if you are using Business Central 23.0 or later.

Turn on:

  • Feature Update: Allow using of multiple posting groups for customer or vendor
  • Feature Update: Enable use of new extensible exchange rate adjustment, including posting review

To set up multiple posting groups, do the following:

  1. Go to the Sales & Receivable Setup and the Customer Card pages and turn on Allow Multiple Posting Groups.

  2. Go to the Customer Posting Groups page.

  3. Create new posting groups if there are no posting groups. For example, create two posting groups: 

    1. Domestic Posting Group

    2. Alternative Domestic Posting Group

  4. Assign accounts to the posting groups. For example, assign different Receivables Accounts to different posting groups.

  5. Select the posting group to which you want to assign alternative posting groups.

  6. On the Customer Posting Groups Action tab, go to Related > Posting Group > Alternative Groups. For more information about setting up posting groups, see Set Up Posting Groups.

  7. On the Alternative Customer Posting Group table, add customer posting groups which you can use as alternative posting groups. For example, assign Alternative Domestic Posting Group as an alternative for the Domestic Posting Group.

After you have set up multiple posting groups and added alternative posting groups, you can then use alternative posting groups when you are working with billing schedules. For example, if you create a billing schedule for customer 10000, the default customer posting group is Domestic Posting Group. Because you have set up Alternative Domestic Posting Group as an alternative posting group, you can use that posting group instead of the default one.

Add Items with Extended Text to Billing Schedule

To add extended text to your billing schedule line, do the following.

  1. Make sure that you have added extended text to the item or items you want to add to the schedule line. For more information about adding extended text to items, see Set up Extended Text for an Item.

  2. Add the item or items to the Schedule Lines.

  3. On the Schedule Lines Action tab, select Line > Functions > Insert Ext. Texts.

  4. The extended text associated with the item is added to the schedule lines, underneath the item. The extended text appear as lines with the Comment type.

When you invoice the billing schedule, the extended text lines appear on the invoice.

Create a Sales Order or Invoice

A sales order or invoice is created for a line depending on the Sales Document Type selected for the billing schedule line.

To create a sales order or invoice for a billing schedule, follow these steps: 

  1. On the SBS ARCB Billing Schedule Card page, select Actions tab > Invoice Function > Create Order/Invoice.
  2. In the SBS ARCB Billing Schedule Order/Invoice Creator page, specify the As of Date.
  3. If needed, select how you want to consolidate the sales orders or invoices, by customer or items.
  4. Specify the sales order or invoice date.
  5. In the list, select the billing schedules for which you want to create sales orders or invoices.
  6. Select the Actions tab and select the actions that you want to perform.
    • If you select Create Order(s)/Invoice(s), sales orders or invoices are created for all selected billing schedules. After the sales orders or invoices are created, you can review the log report.
    • If you select Post Order(s)/Invoice(s), sales orders or invoices are created and then posted for all selected billing schedules. After the sales orders or invoices are created, you can review the log report.
    • If you select Post & Send, sales orders or invoices are created and then posted for all selected billing schedules.
      1. You can then send the sales orders or invoices to customers who have an sales orders or invoice. Before the sales orders or invoices are sent through the email program, you can edit the message.
      2. After the sales orders or invoices are sent, you can review the log report.

    7. If the sales invoice amount is negative, a sales credit memo is created.

Preview an Invoice

Review the invoice for a billing schedule:

  1. On the SBS ARCB Billing Schedule Card page, select Actions tab > Invoice Function > Invoice Preview.
  2. In the SBS ARCB Invoice Preview page, select the As of date.
  3. Select whether to Include Invoiced Periods.
  4. In the Billing Schedule Detail area, add any other filters that you want.
  5. Select how you want to view the generated report: 
    • Select Preview to view the report on your screen.
    • Select Print to select the destination for the report.

Process Milestone Items

To update the end date on milestone items, follow these steps:

  1. On the SBS ARCB Billing Schedule Card page, select Actions tab > Milestone > Milestone.
  2. On the SBS ARCB Billing Batch Milestone Processing page, specify the End Date.
  3. Select the billing schedule lines that you want to process.
  4. Select Milestone Process > Process.
  5. When you are asked to confirm the action, select Yes.

To edit the details for a milestone item, follow these steps:

  1. On the SBS ARCB Billing Schedule Card page, select a line in the Schedule Lines FastTab.
  2. Select Milestone > Milestone Details, which opens the SBS ARCB Milestone Details page.
  3. Review the values in the Header Fields, and make any changes as needed.
  4. Review the Lines FastTab, and make any changes as needed.
    When adding a line, do the following: 
    1. Select the Type and Item No.
    2. Depending on the allocation method selected, specify the Percentage or Amount.
    3. Select the Frequency.
    4. Specify a Milestone ID.
  5. Select Actions > Process > Process.

Specify Revenue Allocation

To specify the revenue allocation for a billing schedule, follow these steps: 

  1. In the list of all billing schedules, select the Schedule Number of the billing schedule.
  2. In the In the Actions tab, select Revenue Allocation, which opens the SBS MERA Revenue Allocation (ARCB) page.
  3. Select the MEA Type.
  4. Specify the MEA Number and the Deferred Contract Revenue Account.
    • If the MEA type is Single, the same MEA Number and Deferred Contract Revenue Account applies to each line.
    • If the MEA type is Multiple, you can apply a different MEA number and Deferred contract revenue account to each line.
  5. In the Actions tab, select Enter Percent Line, which opens the SBS MERA Transaction Percent Line page.
  6. For the item, specify the Percent, and select OK.
  7. In the SBS MERA Revenue Allocation (ARCB) page, select OK.

Review MEA Percent History

To review the MEA percent history, follow these steps:

  1. In the list of all billing schedules, select the Schedule Number of the billing schedule.
  2. In the In the Actions tab, select Revenue Allocation, which opens the SBS MERA Revenue Allocation (ARCB) page.
  3. In the Actions tab, select History.
  4. In the page that opens review the history, and select Close when you are finished.

Back to top ▲

Perform Actions on Line Items

In the Schedule Lines FastTab you can perform the following additional actions on a single billing schedule line.

To add a line to a billing schedule, follow these steps: 

  1. Select Manage > New Line.
  2. For each item line you want to add, do the following:
    1. Set Type to Item.
    2. Select the Item No., and specify the Billing Type.
      • For Billing Type set to Standard, complete any other information as needed.  
      • For Billing Type set to Usage, complete other information and ensure to specify the Usage Option. This value determines how you enter the consumption values on the SBS ARCB Billing Detail List.
      • For Billing Type set to Milestone, complete other information and ensure to specify a milestone template and edit the milestone details for the line. For more information, see Milestone Billing Workflow.
  3. For each comment line you want to add, do the following:
    1. Set Type to Comment.
    2. In the Item No., select from one of the standard text codes.
  4. For each resource line you want to add, do the following:
    1. Set Type to Resource.
    2. In the Item No., select from one of the available resources.
    3. Select the Billing Type, and set the Pricing Method to Standard or Flat.
      Currently, the Milestone billing type cannot be used for a resource. A resource cannot be a milestone parent. item
  5. For the line, you can also specify the values under the Schedule Details and Shipping and Billing FastTabs.
  6. (from v 1.42.2.0) The user is able to edit and add ARCB Schedule Lines with Excel, and then publish the changes.
  1. On the SBS ARCB Billing Schedule Card page, select a line in the Schedule Lines FastTab.
  2. Select Line > Functions > Display Billing Details, which opens the SBS ARCB Billing Detail List page. You can review the following information: 
    • Start and end dates, quantities, unit price, and discount, and amounts
    • History of documents
    • Meter reading and consumption values (for usage items)
      If the item is a usage item, you can enter the meter reading values.
    • Renewal lines (for items that are automatically renewed)
  3. When you are finished, close the page.
  1. On the SBS ARCB Billing Schedule Card page, select a line in the Schedule Lines area.
  2. Select Support/Renewal > Support and Renewal, which opens the SBS ARCB Billing Support and Renewal Update Process page.
  3. Change any of the following options, if needed: 
    • Support Level
    • Renewal % or Renewal Amount
  4. Specify the Reason for the change.
  5. In the Actions tab, select Process.
  1. On the SBS ARCB Billing Schedule Card page, select a line in the Schedule Lines area.
  2. Select Support/Renewal > Support and Renewal History, which opens the SBS ARCB Billing Support and Renewal History page.
  3. When you are finished, select Close.
  1. In the list of all billing schedules, select the Schedule Number of the billing schedule.
  2. In the Schedule Lines section, select a line and select Advanced Deferral > Advanced Deferral Options, which opens the SBS ARED Transaction - Billing Schedule (Advanced Deferrals) page.
  3. To make the item a deferral item, select Deferral Item.
  4. Review the accounts for the Revenue, COGS and Discounts FastTabs. If necessary make any changes.

    5. By default, these accounts are from the SBS ARED Deferral Defaults Setup page.

  5. In the Schedule section, select the Schedule Type.

    6. Different options appear for the schedule type you choose (Straight Line or Event Based). Complete the options as needed.

  6. If needed to review the deferral item, select Preview.
  7. Select Recalculate.
  1. In the list of all billing schedules, select the billing schedule number that you want to edit.
  2. In the Schedule Lines section, add a line, and select a parent item.
    The Revenue Split check box must be selected.
    If the parent item is set up to use revenue splitting by default, the lines are updated with the parent item and all child items.
  3. To add a child item:
    1. Select the parent item, and select Add Revenue Split Child.
    2. Select the item you want to add and select OK.
  4. To remove a child item:
    1. Select the line, right-click the line, and select Delete Line.
    2. When you are asked to confirm the action, select Yes.

Currently, creating a sales quote and viewing its history is available for individual lines only.

  1. In the list of all billing schedules, select the Schedule Number of the billing schedule.
  2. In the Schedule Lines FastTab, select a line and select Sales Quote > Create Sales Quote.
  3. The sales quote is created and a message displays the sales quote number appears.
  4. To review the sales quote, in one of the following ways: 
    1. Open the Sales Quote page directly.
    2. In the Schedule Lines FastTab, select the line item and select Sales Quote > Sales Quote History. In the sales quotes history list, select the sales quote number.
  5. On the Sales Quote page, the sales quote can be approved or released.
    After the sales quote is approved or released the billing schedule line is updated with the unit price or quantity.

    6. Note icon. Note: The unit price is updated only when the Pricing Method is Flat.

After a sales order or sales invoice is created from a sales quote, the billing schedule line is updated with the corresponding Sales Document No. The sales document is not updated with the billing schedule number.

Back to top ▲

 

Schedule

This schedule header FastTab contains the following fields: 

Field Description
Group

Select the billing schedule group to associate with the billing schedule.

Any default values from the billing schedule group are automatically applied to the billing schedule.

Billing schedule groups are created on the SBS ARCB Billing Schedule Group page.

The default value is set up on the SBS ARCB Billing Schedule Setup page.

No.

Automatically updates with the next schedule number when you create a billing schedule.

Description

Specify a description for the billing schedule.

Sell-to Customer No.

Select the customer account number to associate with the billing schedule.

Customer Name

Displays the customer name.

End User No.

Select an end user ID attached to the customer number used for the billing schedule.

End User Name

Displays the end user name.

Sell-to

Displays the address and contact information related to the sell-to address. If needed, you can change any of the sell-to information.

  • Address/Address 2, City, State, ZIP Code: Displays the address details to where items are to be delivered.
  • Contact No., Contact: Displays the contact number and name.
  • Your Reference: Displays the reference number associated with the sell-to address.
External Document No.

Specify the external document number.

This value is used for creating invoices that are consolidated by customer. For example, a customer has two billing schedules that are the same. When the invoices are created, this value determines whether the invoices are consolidated: 

  • When the external document number are different, the invoices are not consolidated. Two separate invoices are created.
  • When the external document number are the same, the invoices are consolidated. One invoice is created.
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.

The default value is set up on the SBS ARCB Billing Schedule Setup page.

Start Date

Specify the start date of the billing schedule, which is used for the annual accumulation logic.

This date rolls down to lines where the deferral start date is greater than the billing start date on the header and also the lines are not billed yet.

When the billing frequency is set to One Time, the date is not rolled down to the line items.

Frequency

Select the default billing schedule frequency (for example, Daily, Weekly, Monthly, Annually, etc.).

The default value is set up on the SBS ARCB Billing Schedule Group page.

Number of Periods

Specify the default number of periods for the billing schedule. This value is used when calculating the end date for the billing schedule.

The default value is set up on the SBS ARCB Billing Schedule Group page.

End Date

Displays the end date for the billing schedule. The billing end date is used for the annual accumulation logic. The end date is automatically calculated based on the billing start date, billing frequency, and the number of periods.

This date rolls down to lines where the billing schedule end date is not specified. When the billing schedule line has a specified end date and the start date is earlier than the billing header end date, no changes occur to the line.

When the billing frequency is set to One Time, the date is not rolled down to the line items.

If you leave the number of billing periods empty or zero, you can specify an end date. The billing end date cannot be earlier than the billing start date.

Contract Length (Months)

(added in version 1.42.2.0). This field is read-only. This value is calculated whenever the user adds or edits the Start Date or the End Date. If the user modifies the Frequency , Number of Periods, or the End Date on the schedule header (which would alter the Start Date or the End Date), then the Days and Months field in the header will be recalculated.

The formula used to recalculate the Contract Length (Months) is: MONTH(end_date) - MONTH(start_date) + 12 * (YEAR(end_Date) - YEAR(start_date))

For example, if the billing schedule start date is Feb 2, 2024, and the end date is June 1, 2025, then the Contract Length (Months) value will be: June - Feb + 12 * (2025-2024) = 6 - 2 + 12 = 16
Alignment Date

Specify the alignment date. When a date is entered, the billing details for the line are aligned to the specified date. This date becomes the default date for the line items, and can be changed as needed.

  • If the alignment date is within a billing period for which the invoice has already been created, the billing details are not updated and remain unchanged.
  • If the alignment date is within a period that has not yet been invoiced, the billing details are updated and aligned to the date specified.

When adding a line item to a billing schedule, you can specify the alignment date for the line item. When the alignment date is specified, the billing details for the line are aligned to the specified date. Review the examples to learn how specifying the Alignment Date for a line item works.

Example 1: For example, a line item has the following settings: 

  • Start Date: January 15, 2020
  • Frequency: Annually
  • Number of periods: 5
  • Amount: 100.00
  • End Date: January 14, 2025
  • Alignment Date: May 27, 2020

The following table shows the billing detail: 

Start Date End Date Amount
January 15, 2020 May 27, 2020 100.00 (amount is 36.61 if proration is used)
May 28, 2021 May 27, 2021 100.00
May 28, 2022 May 27, 2022 100.00
May 28, 2023 May 27, 2023 100.00
May 28, 2024 May 27, 2024 100.00
May 28, 2025 January 14, 2025 100.00 (amount is 63.39 if proration is used)

Example 2: For example, a line item has the following settings: 

  • Start Date: January 15, 2020
  • Frequency: Annually
  • Number of periods: 5
  • Amount: 100.00
  • End Date: January 14, 2025

The following table shows the billing detail when no alignment date is specified: 

Start Date End Date Amount Invoiced
January 15, 2020 January 14, 2021 100.00 Yes
January 15, 2021 January 14, 2022 100.00 Yes
January 15, 2022 January 14, 2023 100.00  
January 15, 2023 January 14, 2024 100.00  
January 15, 2024 January 14, 2025 100.00  

Scenario 1: The Alignment Date is June 21, 2021. The alignment date is within a period for which an invoice has been created. And because the invoice has been created, the billing details are not updated.

Scenario 2: The Alignment Date is June 21, 2022. The alignment date is within a period for which the invoice has not yet been created. In this scenario, the billing details for the periods that have not been invoiced are updated. The billing details are shown in the following table: 

Start Date End Date Amount Invoiced
January 15, 2020 January 14, 2021 100.00 Yes
January 15, 2021 January 14, 2022 100.00 Yes
January 22, 2022 June 21, 2023 100.00  
January 22, 2023 June 21, 2024 100.00  
January 22, 2024 January 14, 2025 100.00  
Interval

Specify the number of intervals for the billing schedule.

The default value is set up on the SBS ARCB Billing Schedule Group page.

Renewal Lines

Specify the number of lines to add to a billing schedule that is being renewed. Available when Auto renewed is selected.

The default value is set up on the SBS ARCB Billing Schedule Group page.

Status

Displays the billing schedule status:

  • Pending Approval: The billing schedule is pending approval.
  • Active: The billing schedule is active. Billing schedules with this status can be modified and invoices can be created for them on the SBS ARCB Billing Schedule Order/Invoice Creator.
  • On Hold: The billing schedule is on hold. Billing schedules with this status cannot be edited. Also, invoices cannot be created for them. For more information, see SBS ARCB Billing Schedule Hold.
  • Last Billing: The billing schedule has been terminated and has one final billing period remaining. Billing schedules with this status are active until the last invoice has been created. For more information, see SBS ARCB Billing Schedule Termination.
  • Terminated: The billing schedule has been terminated. Billing schedules with this status cannot be edited, but can be archived. Invoices cannot be created for terminated billing schedules. For more information, see SBS ARCB Billing Schedule Termination.
  • Archived: The billing schedule has been archived. For more information, see SBS ARCB Billing Batch Archive Process.

The default value is set up on the SBS ARCB Billing Schedule Group page.

Termination Date

Displays the date on which the billing schedule is terminated.

Salesperson Code Select the salesperson code for the billing schedule. From v1.43.2.0. When a user changes the Salesperson Code on the Billing Schedule Header, the following pop-up message will appear: "This will change the dimension specified in the document. Do you wish to recalculate / update the dimensions? If "Yes", then we will update the dimensions, If "No", then we will not update the dimensions.
Responsibility Center Select the responsibility center for the billing schedule. From v1.43.2.0. When a user changes the Responsibility Center on the Billing Schedule Header, the following pop-up message will appear: "This will change the dimension specified in the document. Do you wish to recalculate / update the dimensions? If "Yes", then we will update the dimensions, If "No", then we will not update the dimensions.
Auto-Renewed

Select whether to automatically renew a recurring contract billing schedule for the next billing period: 

  • On: Automatically renews the recurring contract billing schedule for the next billing period.
  • Off: Does not renew the recurring contract billing schedule for the next billing period.

When a billing schedule is renewed, the default billing group used for renewal schedules is specified on the Renewal Schedule Group on the SBS ARCB Billing Schedule Setup page.

Notice Given Days

Specify the default number of days notice that is given before a billing schedule is due for renewal.

The default value is set up on the SBS ARCB Billing Schedule Setup page.

Renew X days in Advance

Specify the default number of days in advance that a billing schedule can be renewed.

The default value is set up on the SBS ARCB Billing Schedule Setup page.

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.

The default value is set up on the SBS ARCB Billing Schedule Setup page.

Invoice Separately

Select whether separate invoices are based on the customer:

  • On: Allows you to create a combination of consolidated invoices and separate invoices for the same customer.

    • For example, a customer have five contracts. Three of the contracts are to be consolidated on a single invoice, and the other two contracts each require separate invoices.

  • Off:  All invoices for a customer are consolidated.

The default value is set up on the SBS ARCB Billing Schedule Group page.

Align Deferral to Billing

Select whether to align the start and end dates for the deferral schedule to use the same dates as the billing schedule.

  • On: Sets the default start and end dates of the deferral schedule to be the same as the billing schedule.
  • Off Does not align the default start and end dates of the deferral schedule to be the same as the billing schedule.
Split into Separate Invoices per Quantity

Indicates whether the invoice for an item is split into separated invoices based on the quantity of the item.

  • On: Multiple invoices for the item are created based on the number the item ordered. Items that use this setting cannot use the consolidation feature when the invoices are created.
  • Off: A single invoice for the item is created regardless of the quantity ordered.

A billing schedule is created for item A001 with a quantity of 3. When this option is turned on and the invoice is created, three separate invoices are created. Each invoice is for item A001 with a quantity of 1.

On the SBS ARCB Billing Detail List for the line, you can review the following columns: 

  • The Billed check box is selected to indicate that all invoices for the line has been created.
    For this check box to be selected indicating the line has been fully billed, all invoices for the item must be created.
  • In Invoice No., the word MULTIPLE appears to indicate that more than one invoice has been created. To view all the invoices, select MULTIPLE to open a dialog where you can review the invoices created.

Note icon. Note: If one or more of the invoices for the item has been deleted, the Billed check box is cleared to indicate that one or more invoices for the line still need to be created.

Continuing with the example, one of the invoices for item A001 is deleted. So only two invoices for the item A001 of the billing schedule exist. When reviewing the SBS ARCB Billing Detail List, the Billed check box is cleared. The MULTIPLE link can be selected to review the invoices that have already been created. Also, any 'missing' invoices for the item can be created when invoices are created for the item.

The default value is set up on the SBS ARCB Billing Schedule Group page.

Calculation Method

Select the calculation method for the invoice creation date: 

  • X Days Before Start Date: The invoice calculation date is a specified number of days before the start date of the next billing period.
  • X Day of Current Month: The invoice calculation date is on a specific date of the current month.
  • X Day of Next Month: The invoice calculation date is on a specific date of the next month.
  • End of Month: The invoice calculation date is at the end of the month.

The default value is set up on the SBS ARCB Billing Schedule Group page.

Days Before Start Date

Specify the number of days before the billing period start date to create the invoice. Available when Calculation Method is X Days Before Start Date.

The default value is set up on the SBS ARCB Billing Schedule Group page.

Milestone No.

Select the milestone template that you want to use. The template determines how the price of a milestone item is allocated.

Sales Document No.

Displays the sales document number for the billing schedule.

If multiple sales documents are attached to the billing schedule, the value is MULTIPLE, and you can select the text to view a list of all sales documents for each billing schedule line item. Selecting the sales document number opens the corresponding sales document page, where you can view the details.

Estimated Usage Quantity

Specify the estimated consumption for a usage item.

For new usage items where the first invoice has not yet been created, this value is the default estimated usage quantity for a line. Also, when this value is updated, the changed value can be applied to line.

For existing usage items where the first invoice has already been created, changing this value does not affect the line.

Auto Renewal Option

Indicates how the date on which the billing schedule is automatically renewed is determined: 

  • Last Billing:  The renewal date of the billing schedule is based on the date on which the last billing period ends.
  • X Days in Advance: The renewal date of the billing schedule is based on the number of days in advance before the date on which the last billing period ends.

For X Days in Advance, the calculated renewal date is based on the Renew X days in Advance specified.

Invoice Customer

Select which customer name appears on invoices for the billing schedule. This option works with the Bill-to option for the billing schedule lines.

  • Default Customer:  When invoices are created, both the Sell-to Customer No. and the Bill-to customer specified appear on the invoice.
  • Specific Customer: When invoices are created, only the Bill-to customer specified appears on the invoice.
User Defined Fields

Only the user-defined fields that are specified on the SBS ARCB Billing Schedule Setup page appear. If you do not see the user-defined fields, select Show More in the heading of the FastTab.

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

Schedule Header Actions

The schedule header has the following actions. These actions are readily available on the header or from the Actions menu.  

Action Description
Dimensions
Dimensions Opens the Edit Dimension Set Entries page, where you can edit the dimension set for the billing schedule.
Copy
Copy Schedule Select Copy Schedule, which opens the SBS ARCB Billing Copy Schedule page, where you create a copy of the billing schedule that is currently displayed on this form.
Termination

Select an action to perform on the billing schedule: 
Terminate Schedule Opens the SBS ARCB Billing Schedule Termination page, where you terminate the selected billing schedule. When you terminate a billing schedule, the status changes to Terminated.
Remove Termination Displays a dialog where you confirm that you want to remove the termination from the selected billing schedule. When you select Yes, the termination is removed, and the status changes to Active.
Schedule Termination Hist Opens the SBS ARCB Billing Schedule Termination History page, where you review the termination history of the billing schedule.
Hold

Select an action to perform on the billing schedule: 
Hold Schedule Opens the SBS ARCB Billing Schedule Hold page, where you apply a hold to the selected billing schedule. When you put a hold on a billing schedule, the status changes to OnHold.
Remove Hold Displays a dialog where you confirm that you want to remove the hold from the selected billing schedule. When you select Yes, the hold is removed, and the status changes to Active.
Schedule Hold History Opens the SBS ARCB Billing Schedule Hold History page, where you review the hold history of the billing schedule.
Price Adjustment

Select an action to perform on the billing schedule: 
Adjust the Price Opens the SBS ARCB Billing Price Adjustment page, where you apply an price adjustment or a discount to the selected billing schedule line.
Schedule Price Adjustment History Opens the SBS ARCB Billing Price Adjustment History page, where you review the price adjustment history of the billing schedule line.
Price Index History Opens the SBS ARCB Billing Price Index History page, where you review the Price Index history of the billing schedule line.
Discount History Opens the SBS ARCB Billing Discount History page, where you review the discount history of the billing schedule line.
Renewal

Select an action to perform on the billing schedule: 
Renew Schedule Displays a dialog where you confirm that you want to renew the billing schedule.
Renewal History Opens the SBS ARCB Billing Schedule Renew History, where you review the renewal history of the billing schedule.
Archive
Archived

Select Archived, which opens the SBS ARCB Billing Batch Archive Process page, where you archive the billing schedule that is currently displayed on this form.

Stubbing Function

Select an action to perform on the billing schedule: 
Apply Stubbing Opens the SBS ARCB Billing Schedule Stubbing page, where you stub the selected billing schedule.
Reverse Stubbing Reverses the stubbing that was applied to a billing schedule.
Invoice

Select an action to perform on the billing schedule: 
Create Order/Invoice Opens the SBS ARCB Billing Schedule Order/Invoice Creator, where you create sales orders or invoices for the billing schedule.
Invoice Preview Opens the SBS ARCB Invoice Preview, where you can generate a preview of the invoice for a billing schedule.
Milestone
Milestone

Opens the SBS ARCB Billing Batch Milestone Processing page where you update the completion date for specific milestone items for multiple billing schedules or customers.
Activate Schedule
Activate Schedule

Select to activate a billing schedule. For billing schedules that have a Pending Approval status, the status is updated to Active.

After the billing schedule is active, you can use the SBS ARCB Billing Schedule Order/Invoice Creator to created invoices for the billing schedule lines.

Move Schedule Line

This functionality is not available for terminated billing schedules that have no active lines.

Move Schedule Line

Opens the SBS ARCB Billing Schedule Move Item page where you move all active schedule line items from the current billing schedule to a different billing schedule.

Move Schedule Line History

Opens the Billing Schedule Move Item Line History, where you can view the move history of the selected schedule line item.

Revenue Allocation
Revenue Allocation

Opens the SBS MERA Revenue Allocation (ARCB) page where you can specify the details of the revenue allocation.

Unbilled Revenue
Create Unbilled Revenue Initial Journal Entry

Opens the Create Unbilled Revenue Initial Journal Entry page.

This action is not available for existing billing schedules or for billing schedule lines in which the invoice has already been created.

Customer Inquiry
Customer Inquiry Opens the SBS ARCB Customer Inquiry for the selected customer.
Actions > Schedule Serialized Detail
Schedule Serialized Detail Opens a dialog where you can review the serial number details for the billing schedule.
Related
Customer

Opens the Customer Card for the customer attached to the billing schedule.

Schedule Lines

In this page there are two new fields, Price Group ID and Adjustment Line No.

Price Group ID: This field, by default, will be visible,

Adjustment Line No.: This field will display the the billing schedule line number. This field is non editable, and is added through personalization or design.

Note: Only items with the same billing frequency will be grouped together. If the frequency, start date, end date, billing type, interval, No of periods, or renewal option, of another line is different, then the user will not be able to use the Sames group ID if it is associated with the schedule line Error Message will be displayed that the Frequency should be same

This FastTab contains the following fields: 

Field Description
Type

Select the type: 

  • Item: The item for the line can be an inventory or service item or a charge.
  • Comment: The comment for the line is then selected from the standard text codes, which is part of the standard Microsoft Dynamics 365 Business Central functionality. All comment lines appear on the invoices that are created for the billing schedule line items.
    For lines that have the Comment type, only the Manage > New Line or Delete Line actions are available.
  • Resource: The resource for the line is then selected from the resources that have been created, which is part of standard Microsoft Dynamics 365 Business Central.

When the milestone functionality is used, the Resource type cannot be a milestone parent item.

No.

Select the item number.

Description

Displays the description for the item.

You can change the description if needed.
Billing Type

Select the billing type for the item: 

  • Standard: Select for use with static quantity.
  • Usage: Select for metered or usage type items.
  • Milestone: Select to use the Milestone Billing functionality.

For lines that are Resource type, select only Standard or Usage. A resource cannot be milestone parent item.

Usage Identifier

Specify the identification for the usage item.

Accumulate on Import

For Usage type items only.

Indicates whether the usage (reading or consumption) billing detail line amount is a single value or an accumulated total of multiple values.

Usage Option

Select how to record usage information for a usage item: 

  • Reading: When selected, you can specify the Current Reading value for the period on the SBS ARCB Billing Detail List page. Use this option for a usage item has a physical meter that is read each billing period. For example, a utility meter.
  • Consumption: When selected, you can specify the Quantity value for the period on the SBS ARCB Billing Detail List page. Use this option for a usage item that where the unit quantity resets to zero for each billing period. For example, a mobile phone plan that charges per minute used each billing period.

You can edit this value when Billing Type is Usage.

Location Code Specify the location code.
Pricing Method

Select the default pricing method for items in a billing schedule: 

  • Standard:  Calculates the unit price based on the total quantity entered and is based on the existing Microsoft Dynamics 365 Business Central functionality.
  • Flat: Applies a flat price to the original item price.
  • Tier: Calculates unit price using fixed quantity at different pricing brackets. Each tier must be filled before moving to the next pricing tier bracket. For more information, see Pricing Methods.
  • Flat Tier: Calculates unit price using fixed quantity and extended price amounts for different pricing brackets. The price that is charged in a billing period uses the extended price that corresponds to the tier where the billing quantity exists. For more information, see Pricing Methods.

For a parent item in a revenue split, this value is Flat Tier, and it cannot be changed.

For a Resource type, only Standard or Flat can be selected.

Unit of Measure Code

Select the unit of measure for the item. The options available are based on the base and sales unit of measures for the item as set on the Item Card. ClosedMore.

  • If both base and sales unit of measure values are empty, the billing schedule cannot be saved with the item.
  • If both base and sales unit of measure values have values set, the base unit of measure is the default value, and can be changed as needed.
  • If base or sales unit of measure value is set, the default is the unit of measure value that is set (base or sales).
Unit Price Excl. Tax Specify the price of one unit not including the tax.
Quantity

Specify the quantity for the item.

For child items in a revenue split, the quantity is automatically entered from the parent item and cannot be edited.

Variant Code

Select the variant code for the item.

Variant codes are a standard Microsoft Dynamics 365 Business Central feature. To be able to see this column, personalize the view.

Estimated Usage Quantity

Specify the estimated consumption for a usage item. Change this value as needed. For new usage items, the default value is from the header.

When reviewing the SBS ARCB Billing Detail List, this value is applied only to periods where the invoice has not been created. For more information, see Estimating Usage for an Item.

Line Amount Excl. Tax

Displays the value of the line item not including the tax. The amount is calculated as follows: Quantity * Unit Price Excl. Tax.

For items in a revenue split, this value displays a zero (0) amount for the parent item. For each child items displays a calculated value: quantity * unit price.

Tax Group Code Specify the tax group code.
Start Date

Specify the start date for the line item.

For items in a revenue split, only the date for the parent item can be edited. All child items use the same date as the parent item.

End Date

Specify the end date for the line item.

For items in a revenue split, only the date for the parent item can be edited. All child items use the same date as the parent item.

Alignment Date

Specify the alignment date. When a date is entered, the billing details for the line are aligned to the specified date. The default date is from the header. For an example, refer to the header description.

  • If the alignment date is within a billing period for which the invoice has already been created, the billing details are not updated and remain unchanged.
  • If the alignment date is within a period that has not yet been invoiced, the billing details are updated and aligned to the date specified.
Frequency

Select the default frequency for a billing schedule associated with this group: Onetime, Daily, Weekly, Monthly, Quarterly, Semiannually, or Annually.

For items in a revenue split, the value for child items is from the parent item. For the child item, you can keep the same value as the parent item or change it to One-time.

Payment Terms Code

Select the payment terms for the billing schedule line. The default value is from the Payment Terms Code in the Schedule Details FastTab, but you can change it as needed.

If the payment terms are different for each line, separate invoices are created for the lines.

Payment Method Code Select the payment method used by a customer to pay for the billing schedule.
Direct Debit Mandate ID Select the payment method used by a customer when payment for an item is directly from a customer's bank account.
End User

Select the end user for the line. The default value is from the header.

When creating invoices and consolidating by customer, the end user value is also considered for the consolidation.

Interval

Specify the billing interval you want to use.

For items in a revenue split, the value for child items is from the parent item. For the child item, you can keep the same value as the parent item or change it to one.

Status

Displays the billing schedule status:

  • Active: The billing schedule line is active. Lines with this status can be modified and invoices can be created for them on the SBS ARCB Billing Schedule Order/Invoice Creator.
  • On Hold: The billing schedule line is on hold. Lines with this status cannot be edited. Also, invoices cannot be created for them. For more information, see SBS ARCB Billing Schedule Hold.
  • Last Billing: The billing schedule line has been terminated and has one final billing period remaining. Lines with this status are active until the last invoice has been created. For more information, see SBS ARCB Billing Schedule Termination.
  • Terminated: The billing schedule has been terminated. Lines with this status cannot be edited. Invoices cannot be created for terminated lines. For more information, see SBS ARCB Billing Schedule Termination.
Auto Renewed

Select whether to automatically renew a billing schedule line: 

  • Selected: Automatically renews the billing schedule line.
  • Cleared: Does not renew the billing schedule line.
Revenue Split

Indicates that a line uses revenue splitting:

  • On: Indicates that the item uses the revenue split feature. When selected, the list is automatically updated with all child items for the revenue split template. This check box can be selected only for the parent item in a revenue split.
    For parent items that have a revenue split template already set up, this check box is automatically selected when it is added to a sales invoice, sales credit memo, or billing schedule. To use revenue splitting for a sales order, the check box must be manually selected.
  • Off: Indicates that the item is a standard item that does not use revenue split.
Parent Amount Displays the net amount of the parent item of a revenue split. This amount is the sum total of all child items in a revenue split.
Next Invoice Date Displays the date on which the next invoice is to be created.
Next Invoice Amount Displays the amount for the next invoice.
Total Contract Outstanding Excl. Tax Displays total outstanding balance (excluding the tax) of the contract. The currency amount is displayed in the currency code selected in the Schedule Details FastTab.
Total Invoiced Excl. Tax Displays the invoiced amount (excluding the tax) of the contract. The currency amount is displayed in the currency code selected in the Schedule Details FastTab.
Total Contract Excl. Tax Displays the total amount (excluding the tax) of the contract. The currency amount is displayed in the currency code selected in the Schedule Details FastTab.
Unbilled Revenue

Indicates whether the line item uses the unbilled revenue feature. This check box is automatically selected for items that are set up on the SBS Unbilled Revenue Items Setup page.

When this check box is selected, the actions for the unbilled revenue functionality are available.

Sales Document Type

Displays the sales document type that is created for the billing schedule line when the SBS ARCB Billing Schedule Order/Invoice Creator is used:  Sales Invoice or Sales Order.

The default transaction type is set up on the SBS ARCB Billing Schedule Setup page. You can change the value as needed.

For milestone or revenue split parent items, the child items are updated with the same transaction type as the parent.

Sales Document No. Displays the sales document number for the line. Select the line to open the corresponding sales document page, where you can review the details.
Bill-to

Select to where the invoice for the line is sent. The default value is from the Bill-to option on the Shipping and Billing FastTab:

  • Default: Sends the invoice to the Sell-to Customer No. specified.
  • Another Customer: Sends the invoice to another customer. With this option, you can select the other customer by No. or Name.

    The address information for the bill-to customer appears on the line.

For billing schedules created from a Sales Order or Sales Invoice, the bill-to information is from the Shipping and Billing FastTab of the sales order or invoice.

For line items that use revenue splitting, all items within the same revenue split must have the same bill-to customer. However, different revenue split groupings can use different bill-to customers.

Auto Renewal Option

Indicates how the date on which the billing schedule is automatically renewed is determined: 

  • Last Billing:  The renewal date of the billing schedule is based on the date on which the last billing period ends.
  • X Days in Advance: The renewal date of the billing schedule is based on the number of days in advance before the date on which the last billing period ends.

For X Days in Advance, the calculated renewal date is based on the X days in Advance specified. The default value is from the header option.

X days in Advance

Specify the default number of days in advance that a billing schedule can be renewed.

The default value is from Renew X days in Advance in the header.

Next Invoice Date Displays the date for the next invoice.
Next Invoice Amount Displays the amount for the next invoice.
Split into Separate Invoices per Quantity

Indicates whether the invoice for an item is split into separated invoices based on the quantity of the item.

  • On: Multiple invoices for the item are created based on the number the item ordered. Items that use this setting cannot use the consolidation feature when the invoices are created.
  • Off: A single invoice for the item is created regardless of the quantity ordered.

A billing schedule is created for item A001 with a quantity of 3. When this option is turned on and the invoice is created, three separate invoices are created. Each invoice is for item A001 with a quantity of 1.

On the SBS ARCB Billing Detail List for the line, you can review the following columns: 

  • The Billed check box is selected to indicate that all invoices for the line has been created.
    For this check box to be selected indicating the line has been fully billed, all invoices for the item must be created.
  • In Invoice No., the word MULTIPLE appears to indicate that more than one invoice has been created. To view all the invoices, select MULTIPLE to open a dialog where you can review the invoices created.

Note icon. Note: If one or more of the invoices for the item has been deleted, the Billed check box is cleared to indicate that one or more invoices for the line still need to be created.

Continuing with the example, one of the invoices for item A001 is deleted. So only two invoices for the item A001 of the billing schedule exist. When reviewing the SBS ARCB Billing Detail List, the Billed check box is cleared. The MULTIPLE link can be selected to review the invoices that have already been created. Also, any 'missing' invoices for the item can be created when invoices are created for the item.

The default setting is from the header, which can be changed as needed.

User Defined Fields

Only the user-defined fields that are specified on the SBS ARCB Billing Schedule Setup page appear.

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

Prorate Partial Period (from version 41.2 onwards)

The default prorated partial period from the Billing Schedule Header. This can be added to the Billing Schedule Line via the Personalization function. Select whether to prorate the partial billing periods:

On: Calculates partial amounts for the 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 that are not full billing periods. Partial billing periods are charged the same amount as full billing periods.

Price Group ID (from version 43.5 onwards)

User can enter the Price Group ID in this field for item lines they want to group together in billing schedule.

Note: Only items with the same billing frequency will be grouped together. If the frequency, start date, end date, billing type, interval, No of periods, or renewal option, of another line is different, then the user will not be able to use the same price group ID.
Attachments

Select the paperclip to attach files for the billing schedule.

This box shows the total number of attached files. You can review the attached files as needed. The files attached to the billing schedule are independent from the files attached to a deferral schedule.

Line Actions

This FastTab contains the following actions: 

Action Description
Manage

Select an action to perform on the selected line: 
Advanced Deferral Options

Opens the SBS ARED Transaction - Billing Schedule (Advanced Deferrals) page.

Not available for lines that are Resource type.

Add Revenue Split Child Opens a dialog where you can select a child item to add to the sales document. Available only for parent items of a revenue split.
Bill-to Opens the SBS ARCB Bill-to Customer Details dialog where you select the bill-to customer for the invoice.
New Line Adds a line above the currently selected line.
Delete Line Deletes the currently selected line.
Line

Select an action to perform on the selected line: 
Functions > Display Billing Details Opens the SBS ARCB Billing Detail List page, where you review the details of a billing schedule line.
Related Information > Dimensions Opens the Edit Dimension Set Entries page, where you can edit the dimension set for the line.
Functions > Insert Ext. Texts Adds extended text comments to the billing schedule lines. If you have added extended text to an item, and then select Insert Ext. Texts, then the extended text will appear on the billing schedule lines.
Price Options

Select an action to perform on the selected line: 
Min/Max and Free Qty Opens the SBS ARCB Price Options page, where you specify the minimum and maximum and free quantity pricing option.
Tier Pricing Opens the SBS ARCB Tier Pricing page, where can view the tier price levels for the item.
Termination

Select an action to perform on the selected line: 

Note icon. Note: For items in a revenue split, the termination options can be applied to the parent item only.

Terminate Opens the SBS ARCB Billing Schedule Termination page, where you terminate the selected billing schedule line. When you terminate a billing schedule line, the status changes to Terminated.
Remove Termination Displays a dialog where you confirm that you want to remove the termination from the selected billing schedule line. When you select Yes, the termination is removed, and the status changes to Active.
Termination History Opens the SBS ARCB Billing Schedule Termination History page, where you review the termination history of the billing schedule line.
Hold

Select an action to perform on the selected line: 

Note icon. Note: For items in a revenue split, the hold options can be applied to the parent item only.

Hold Opens the SBS ARCB Billing Schedule Hold form, where you apply a hold to the selected billing schedule line. When you put a hold on a billing schedule line, the status changes to OnHold.
Remove Hold Displays a dialog where you confirm that you want to remove the hold from the selected billing schedule line. When you select Yes, the hold is removed, and the status changes to Active.
Hold History Opens the SBS ARCB Billing Schedule Hold History page, where you review the hold history of the billing schedule line.
Price Adjustment

Select an action to perform on the selected line: 

Note icon. Note: For items in a revenue split, the price adjustment options can be applied to the parent item only.

Price Adjustment Opens the SBS ARCB Billing Price Adjustment page, where you apply an price adjustment or a discount to the selected billing schedule line.
Price Adjustment History Opens the SBS ARCB Billing Price Adjustment History, where you review the price adjustment history of the billing schedule line.
Price Index History Opens the SBS ARCB Billing Price Index History, where you review the Price Index history of the billing schedule line.
Discount History Opens the SBS ARCB Billing Discount History, where you review the discount history of the billing schedule line.
Renewal

Select an action to perform on the selected line: 
Renew Opens the SBS ARCB Billing Schedule Line Renewal Info page, where you set the selected billing schedule line to automatically renew.
Renewal History Opens the SBS ARCB Billing Schedule Renew History, where you review the renewal history of the billing schedule line.
Stubbing

Select an action to perform on the selected line: 
Apply Stubbing Opens the SBS ARCB Billing Schedule Stubbing page, where you stub the selected billing schedule line.
Reverse Stubbing Reverses the stubbing that was applied to a billing schedule line.
Support/Renewal

Select an action to perform on the selected line: 
Support and Renewal Opens the SBS ARCB Billing Support and Renewal Update Process page , where you change the support and renewal information for a billing schedule line.
Support and Renewal History Opens the SBS ARCB Billing Support and Renewal History, where you review the support and renewal changes for a billing schedule line.
Milestone
Milestone Details

Opens the SBS ARCB Milestone Details page where you edit the information for an item that uses the milestone billing functionality.

Move Schedule Line

This functionality is not available for terminated billing schedules that have no active lines.

Select an action to perform on the selected line: 
Move Schedule Line Opens the SBS ARCB Billing Schedule Move Item page where you move the selected line item from the current billing schedule to a different billing schedule.
Move Schedule Line History

Opens the Billing Schedule Move Item Line History, where you can view the move history of the selected schedule line item.

Change Item

Select an action to perform on the selected line: 
Change Item Opens the SBS ARCB Billing Schedule Change Item page where you change the item for the selected line. Only items that have an active status can be changed.
Change Item History Opens the Billing Schedule Change Item Line History, where you can view the change history of the selected schedule line item.
Unbilled Revenue

Select an action to perform on the selected line: 
Unbilled Revenue Defaults Opens the Unbilled Revenue Defaults page where you can review the review and change the values for the unbilled revenue functionality.
Create Initial Journal Entry

Opens the Unbilled Revenue Parameters page, where you specify the parameters for creating the initial unbilled journal entry. The default values are from the setup for the unbilled functionality.

This action is not available for existing billing schedules or for billing schedule lines in which the invoice has already been created.

Journal Entry Audit Opens the Unbilled Revenue Journal Entry Audit, where you view all changes for items that use the unbilled revenue feature.
Calculate Unit Price

Select an action to perform on the selected line: 

These actions are available for Standard type line items with a Flat pricing method.

Calculate Unit Price Opens the Calculate Unit Price dialog.
Unit Price History

Opens the Unit Price History dialog that shows an audit trail of the changes: new contract price and frequency, old contract price and frequency, user who made the change, and the date and time of the change.

If the billing schedule line is deleted, the unit price history is also deleted.

Sales Quote

Select an action to perform on the selected line: 
Create Single Sales Quote

Creates a sales quote for the selected line(s).

  • When a single line is selected, a single sales quote is created.
  • When multiple lines are selected, a single sales quote for all selected lines is created.

After the sales quote is created, you can review the sales quote on the Sales Quote page. The sales quote is updated with all item information for the selected line item.

Sales quotes are a standard Microsoft Dynamics 365 Business Central feature. For more information, see Make Sales Quotes .

Create Multiple Sales Quotes

Creates multiple sales quotes for the selected line(s).

  • When a single line is selected, a single sales quote is created.
  • When multiple lines are selected, separate and individual sales quotes are created for each selected line.

After the sales quote is created, you can review the sales quote on the Sales Quote page. The sales quote is updated with all item information for the selected line item.

Sales quotes are a standard Microsoft Dynamics 365 Business Central feature. For more information, see Make Sales Quotes.

Sales Quote History

Opens a dialog where you can review all the sales quotes created for the selected line item only. To review the details of a sales quote, select the sales quote number.

If a billing schedule line item is deleted from the Schedule Lines FastTab, the corresponding sales quote is deleted from the sales quote history. However, the sales quote remains on the Sales Quote list.

Service Item Tracking

Select an action to perform on the selected line: 
Service Item Tracking Line

Opens the Schedule Item Tracking Line dialog. This dialog is update either manually or automatically based on how the billing schedule for the service item is created. For a general workflow, see Serialized Items Workflow.

When manually assigning the serial tracking number(s) for the service item, the number of serial tracking numbers assigned must match the specified quantity. For example, if the service item has a quantity of 2 in the billing schedule, two serial tracking numbers must be assigned to the service item line.

The serial tracking number for the service item can be changed or deleted anytime before the first invoice is created. Also, the serial tracking number must be assigned to the item before the invoice can be created.

For billing schedules that are on hold or terminated, the Schedule Item Tracking Line dialog is read-only. Also, for terminated billing schedule, the serial tracking number(s) become available for use.

All serial tracking numbers must be previously set up on the SBS Tracking Number Master page.

Activate/Deactivate Tracking No.

Opens the tracking number activate/deactivate dialog, where you specify the activation or deactivation dates for the service item and tracking number combination.

  • The activation date must be within the start and end dates of the billing schedule.
  • A deactivation date must be later than the activation date and cannot be added if the activation date is not specified.
  • For billing schedules that are on hold or terminated, the dialog becomes read-only. If you are terminating a billing schedule, ensure to specify the deactivation date before terminating the billing schedule.

The activation and deactivation dates are currently for reporting purposes only.

Serialized Detail

Select an action to perform on the selected line: 
Line Serialized Detail

Opens a dialog where you can review the serial number details for the billing schedule line. Details include the following:

  • Initial document number is the initial document based on the transaction type (e.g., sales invoice number).
  • Reference item number is the inventory item associated with the service item.

Schedule Details

The FastTab has the following fields: 

Field Description
Currency Code Select the currency code for the item.
Customer Posting Group Select the customer posting group for the item.
Location Code

Displays the location code of the item.

Department Code Select the department code for the item.
Customergroup Code Select the customer group code for the item.
Payment Terms Code Select the payment terms for the item.
Payment Method Code Select the payment method used by a customer to pay for an item.
Direct Debit Mandate ID Select the payment method used by a customer when payment for an item is directly from a customer's bank account.
Tax Liable Select the tax liability code for the item.
Tax Area Code Select the tax area code for the item.
Payment Service Select the payment service that can be used by a customer to pay for an item. Payment services is a standard Microsoft Dynamics 365 Business Central feature. For more information, see Enable Customer Payments Through Payment Services .

Shipping and Billing

The FastTab has the following fields: 

Field Description
Ship-to

Select the address to where all billing schedule items are sent.

  • Default: Sends the items to the current customer.
  • Alternate Shipping Address: Sends items to the selected alternate ship-to address.
  • Custom Address: Sends the items to a custom address where you specify the province, postal code, and contact.
Shipment Method

Select the details for the shipment method: 

  • Code: Select the shipping method code.
  • Agent: Select the agent code.
  • Agent service: Select the type of service used for shipping the package.
  • Package Tracking No.: Specify the tracking number for the shipped package.
Package Tracking No. Specify the tracking number for the package.
Bill-to

Select the to where the invoice is sent.

  • Default: Sends the invoice to the Sell-to Customer No. specified.
  • Another Customer: Sends the invoice to another customer. With this option, you can select the other customer by No. or Name.
  • Custom Address: Sends the invoice to a custom address where you specify the province and contact.

FactBox

The following Subscription Billing FactBoxes are available for the line item in the Schedule Lines:

FactBox Description
Billing Details
Displays the billing details for the selected line. The following information is available: 
Previous invoice number Displays the invoice number for the previous billing period. Select the link to view the invoice details.
Next invoice information

Displays the information for the next invoice of the current billing period, including: 

  • Next invoice date
  • Unit price for item
  • Unit discount amount, as calculated from price adjustments
  • Unit price including discount (calculated as follows: unit price - unit discount)
  • Quantity to appear on the invoice
  • Total calculated invoice amount
Next invoice period dates Displays the start and end date of the current billing period.

Consumption details

Displays consumption information for a usage item that has the Usage Option set to Reading:

  • Initial reading
  • Previous reading from the last billing period
  • Current reading from the current billing period