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.
  2. The item number is automatically updated with the item of the line.

  3. Select Price Adjustment > Price Adjustment, which opens the SBS ARCB Billing Price Adjustment page.
  4. Specify the Price Index Calculation.
  5. 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.
  6. In the Actions tab, select Adjust the Price.
  7. 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 1000USD. Apply the price adjustment to it 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.

 

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.
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.

End Date

Select the end date for the price adjustment or discount.

Price Index Calculation Option

Specify the calculation method for the price index:

  1. None: The calculation is based solely on the value defined in the Price Index Master.

  2. Lower of A OR (B+C): The system will use the lower value between option A and the sum of options B and C.

  3. 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.

 

Flat Tier Example 1

Create a new billing schedule and enter the item in the Line. For example, 1896 has a quantity of 80, and the Unit Price will is calculated as 30. Select the Pricing Method as flat tier as shown below.

Flat Tier Example 1

 

No changes are made to the ARCB tier pricing page.

Flat Tier Example 1

 

Use the Price Adjustment option to change the price.

Flat Tier Example 1

 

From here, users escalate the Unit price 10 % for every quarter and then adjust the price. Now the impact of the price adjustment will be seen in the Billing Details for Flat tier pricing method

Flat Tier Example 1

 

 

Tier Example 2: User-Created Line Standard Billing Option, Tier Pricing Method

Flat Tier Example 2

 

After the price adjusted by 10%, the quarterly billing details will appear as follows:

Flat Tier Example 2

 

 

Tier Example 3: User-Created Line with Usage, Tier Pricing Method

Flat Tier Example 3

 

Line adjusted with 10% for quarterly.

Flat Tier Example 3

 

 

Flat Tier Example 4: User-Created Line with Usage Billing Type, Flat Tier Pricing Method

Flat Tier Example 4

 

After the price adjusted by 30.

Flat Tier Example 4

 

The user now has the following flat tier prices:

Flat Tier Example 4

 

Here are the Billing Details before the adjustment:

Flat Tier Example 4

 

Here are the Billing Details after the adjustment:

Flat Tier Example 4