SBS ARCB Billing Batch Price Update Process

Use this page to update the unit price for the selected billing schedule lines.

• You can apply the same percentage or amount increase to a range of selected items for a range of selected billing schedules.
• When you update the unit price of an item from this page, the minimum and maximum amounts and the free quantity amount are not affected.

Apply Price Update

To apply a price update to billing schedules, follow these steps: 

1. Select the Pricing Method you want to use.
2. Specify the From Date the price update is valid.
3. If you set Pricing Method to Flat, specify the Change Option, Variation Option, and Price Variation.
4. If you want the price update to be prorated, select ProRate.
5. Select Actions > Process > Update.

Note: The display data will show the billing details. The Update price process will update all unbilled billing detail lines with updated prices. From Version 41.0 onwards, the following changes have been made:

1. Removed the filter of “From Date” and “Prorate”.

2. The display data will show the Billing Schedule Lines instead of the Billing Details.

3. The Start Date and the End Date have been removed.

4. The Update price process will update all unbilled billing detail lines with updated price and will update the price on billing schedule line as well.

For example, if we selected the variation option By Amount, Price Variation 100 and update the process. Here For the selected line, It will increase the Price by 100 for all the unbilled billing details and Unit price in schedule line as well.

Note: Previously, contracts for which a price adjustment had already been applied were not updated from the Batch Price Update process. As of Version: 1.46.6.0, the Batch Price Update process now updates all contracts, regardless of whether a price adjustment has already been applied.

 

Fields

This page contains the following fields: 

Field	Description
Pricing Method	Select the pricing method used to calculate the updated unit price of an item:  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 change to the original item price. When you select this option, you must also specify the Change Option, Variation Option, and Price Variation.
From Date	Specify the date from which the price is updated.
Change Option	Select how the price is to be updated: Increase or Decrease. Available only when Pricing Method is Flat.
Variation Option	Select how the price is updated: By Percent or By Amount. Available only when Pricing Method is Flat.
Price Variation	Specify the percent or amount change in the price. Available only when Pricing Method is Flat.
ProRate	Indicates whether the price update is prorated for the billing period:  Selected: The price update is prorated for the billing period. If the price update occurs in the middle of a billing period, the price update is effective from the date specified in From Date. Cleared: The price update is not prorated for the billing period. The price update applies to the item for the full billing period.
Lines
Billing Schedule number	Displays the billing schedule number. Read-only.
Item No.	Displays the item number.
Description	Displays the description for the item.
Sell-to Customer No.	Displays the customer account ID or number.
Customer Name	Displays the customer name.
Start Date	Displays the billing start date.
End Date	Displays the billing end date.
Quantity to Invoice	Displays the quantity that is billed on the invoice.
Old Unit Price	Displays the unit price for the item before the price update.
Old Amount	Displays the total amount of the invoice based on the old unit price.
New Unit Price	Displays the unit price for the item after the price update.
New Amount	Displays the total amount of the invoice based on the new unit price.
Pricing Method	Displays the pricing method used to calculate the unit price for the item.
Billing Type	Displays the billing type for the item.
User-Defined Fields (Lines)	Only the user-defined fields that are specified on the SBS ARCB Billing Schedule Setup page appear with values mentioned in the Billing Schedule Lines. If you do not see the user-defined fields, design the view (added in version 1.1.41.2 onwards)

Buttons

This page contains the following buttons: 

Button	Description
Actions tab
Process	Select an action to perform:  Update: Updates the price for the selected lines.