SBS ARCB Billing Price Adjustment

Use this page to process a price adjustment or discount for a billing schedule or for one or more billing schedule lines that belong to a single billing schedule.

This page has a filter applied to it that specifies the billing schedule number and the line number.

Processes

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.

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.

Price Adjustment Calculation

Consider a billing schedule line item with a Line Amount excluding tax of 1000 USD. Apply the price adjustment as shown below.

1. SBS ARCB Billing Price Adjustment - Price Escalation SBS ARCB Billing Price Adjustment

To apply a price adjustment:

1. Enter the Amount and Percentage.

2. Click the Adjust Price button.

3. Review the updated billing details to confirm.

SBS ARCB Billing Detail List

When Accumulated Price is selected, the system calculates adjustments on a compounded basis. Each line uses the adjusted total from the previous line as its new base amount.

Example:

• Line 1: Starts at 1,000.

  • Adds a fixed Amount of 100 → 1,100.

  • Applies a Percentage of 10% (110) → Final Total: 1,210.

• Line 2: Uses 1,210 as its starting base amount.

• This compounding logic continues for all subsequent lines.

2. SBS ARCB Billing Price Adjustment- Discount SBS ARCB Billing Price Adjustment

To apply a price adjustment:

1. Enter the Amount and Percentage.

2. Enable Discount.

3. Click the Adjust Price button.

4. Review the updated billing details to confirm.

SBS ARCB Billing Detail List

When Accumulated Price is selected, the system calculates adjustments on a compounded basis. Each line uses the adjusted total from the previous line as its new base amount.

Example:

• Line 1: Starts at 1,000.

  • Applies a fixed Discount Amount of 100 → 900.

  • Applies a Discount Percentage of 10% (90) on the new amount → Final Total: 810.

• Line 2: Uses 810 as its starting base amount.

• This compounding logic continues for all subsequent lines.

3. SBS ARCB Billing Price Adjustment- Price Escalation + Discount SBS ARCB Billing Price Adjustment

To apply a price adjustment:

1. Enter the Amount and Percentage.

2. Enable Discount.

3. Click the Adjust Price button.

4. Review the updated billing details to confirm.

SBS ARCB Billing Detail List

When Accumulated Price is selected, the system calculates adjustments on a compounded basis. Each line uses the adjusted total from the previous line as its new base amount.

Example:

• Line 1: Starts at 1,000.

  • Applies a fixed Price Increase Amount of 100 → 1,100.

  • Applies a Discount Percentage of 10% (110) on the new amount → Final Total: 990.

• Line 2: Uses 990 as its starting base amount.

• This compounding logic continues for all subsequent lines.

4. SBS ARCB Billing Price Adjustment- Price Escalation using Price index Schedule (B) SBS ARCB Billing Price Adjustment

To apply a price adjustment:

1. Specify the Price Index Schedule No.

2. Perform the setup in SBS ARCB Billing Price Adjustment using the Price Index Schedule (B).

SBS ARCB Billing Detail List

 

This same functionality has also been added to the SBS ARCB Billing Batch Price Adjustment Process via a new Price Adjustment Calculation field. The default value will come from SBS ARCB Billing Schedule Setup.

Base Price Index Date (V1.46.6.0 Onwards)

The Base Price Index Date is the reference date used for price adjustment calculations and determines which date value acts as the starting point for an escalation. By default, it is set to the first billing period date, but users can select another date as long as a value exists for that date.

Rules

1. If the Price Index Schedule (B) is empty:

   1. The Base Price Index Date will also be automatically empty.

   2. The Base Price Index Date field will remain disabled.

2. The default Base Price Index Date value will be set to the First Billing Period date, however, this can be changed as needed as long as a value exists for that date.
   Note: If the Index value is missing, users will receive the following error message: "Price Index value does not exist on or before the specify date."

3. For cases where a price adjustment is added with the default values populated, and the Start Date or End Date on the Schedule Line is later changed, the Base Price Index Date will automatically be recalculated based on the new billing period dates.

For existing schedules (before version 1.46.6.0), when a price index is applied, the default date is added as the billing start date, however, no calculation will be present.

Price Index Month (V1.46.6.0 Onwards)

The Price Index Month refers to the month that is used for annual price adjustments after the initial adjustment (applies to contracts with an Annual Escalation Frequency only). By default, it is set to the month of the first billing period, but users can select any date as needed.

Rules

1. The Price Index Month field can contain month names only (e.g., January, February) along with “Prior”.

2. The field is only enabled when Escalation Frequency is set to Annual.

3. The default value is the month of the first billing period. (This can be changed manually when required.)

4. When the Start Date or End Date on the schedule line is updated, the Price Index Month will automatically be recalculated based on the first billing period, even if the value was previously modified manually.

For existing schedules (before version 1.46.6.0) where the price index is applied, the default value will be "Prior."

Fields

This page contains the following fields: 

Field	Description
Item No.	Displays the item number.
Price Index Calculation	Select to determine the method used for the Price Index price adjustment calculation: Prior Price Index: Uses the previous Price Index value for the price adjustment calculation. Base Price Index:  Uses the base Price Index value for the price adjustment calculation.
Price Adjustment Calculation	Base Price: When multiple price escalations are applied for the same billing period, each escalation is calculated independently on the base price of that billing period. The escalations do not impact one another. Accumulated Price: When multiple price escalations are applied for the same billing period, each escalation is applied sequentially, based on the order or effective date defined in the Price Adjustment window. Each escalation is calculated on the price resulting from the previous escalation.
Lines
Discount	Select whether the change in the amount is a price adjustment or a discount: On: The change is to apply a discount to the billing schedule or billing schedule line. Off: The change is to apply a price adjustment to a billing schedule or a schedule line.
Start Date	Select the start date for the price adjustment or discount.
Frequency	Select the frequency of the price adjustment or discount: None, Monthly, Quarterly, Semiannually, Annually., or One Time (Discount only).
Percentage (A)	Specify the percentage for the price adjustment or discount.
Amount	Specify the price adjustment or discount amount.
Price Index Schedule (B)	Select the Price Index schedule that is used for the calculations.
Base Price Index Date	Specify the Base Price Index Date. The default value is the first billing period.
Price Index Month	Specify the Price Index Month. The index value is based on the month's name (e.g., 0-Prior, 1- Jan, 2-Feb, 3- Mar… 12- Dec).
End Date	Select the end date for the price adjustment or discount.
Price Index Calculation Option	Specify the calculation method for the price index: None: The calculation is based solely on the value defined in the Price Index Master. Lower of A OR (B+C): The system will use the lower value between option A and the sum of options B and C. Higher of A OR (B+C): The system will use the higher value between option A and the sum of options B and C.
Percentage Along Price Index (C)	Specify the percentage value used to calculate the price index.

Buttons

This page contains the following buttons: 

Button	Description
Actions tab
Adjust the Price	Applies the price adjustment or discount to the items in the billing schedule line.
Manage	Deletes the line.