Adjust Prices on Subscription Orders
When a larger set of prices needs adjustment on a large Subscription Order or across multiple Subscription Orders it can be done with a Subscription Price Adjustment batch job.
Note
Prices on subscription orders are by default automatic and will be updated when posting or when running Refresh Prices from the Subscription Order > Actions > Refresh Prices. Price adjustment can only be run on lines with the Subscription Order > Lines > Manual Price field selected.
To adjust manual prices
The batch job changes the contents in the Unit Price field on the Item Card. The batch job changes the content of the field in the same way for all Items or selected Items. The batch job multiplies the value in the field by an adjustment factor that is specified.
Tip
Prices can be also adjusted in the Subscription Order by selecting Actions > Adjust Prices.
Choose the Search icon, enter Adjust subscription prices, and then choose the related link.
Effective Date: Specifies the date when the new adjusted price will be effective. If a date is not entered, the new price will default to the current Work Date. The Effective Date determines when the new price is applied in posting.
- When posting a Subscription Order, lines that have entries in Subscription Price with an Effective Date before or at the start of the period, but not inside the period, will generate one entry using the price from Subscription Price.
- When posting a Subscription Order, lines that have entries in Subscription Price with an Effective Date inside the period, will generate one entry per entry and period.
Adjustment Factor: Specifies an adjustment factor to multiply the unit prices. By entering an adjustment factor, you can increase or decrease the amounts. For example, enter 1.5 to increase the value by 50%.
Rounding Method: Specifies a code for the rounding method that you want to apply to costs or prices that you adjust.
Filter (Header): Used to set filters that specify which orders to process with the batch job.
No.: Specifies the Subscription Order No. to use as a filter.
Price Index Adjust: Specifies whether to include the Price Index adjust (if one is setup on the Subscription Order) in the price calculation batch job. Options are Yes or No.
Price Index Code: Specifies which Price Index Code to use in the adjustment.
+Filter: Click + Filter to optionally add additional filter fields.
Filter: Lines: Used to set additional filters to specify which orders to include in the price calculation batch job.
- Document No.
- Active
- Project No.
- Task Code
- Type
- +Filter: Click + Filter to optionally add additional filter fields.
Click OK to create the Subscription Price Adjustment batch.
Note
For every Subscription Order Line where the prices are adjusted, a Subscription Price Entry with an Entry No., Order No., Line No., Date, previous Price, new Price, Adjustment Factor, and Rounding Method will be saved. The history can be accessed from Action > Price History on the Subscription Order Lines.
Price Index Adjustments
Rules for price adjustment can be defined using two fields in the Details FastTab of the Subscription Order.
The Price Index Adjust field can be set to indicate that the prices should be adjusted. There is no logic connected to this field, it is purely for information and filtering.
The Price Index Code field can be set to indicate how prices should be adjusted. The field is a lookup into a list of Subscription Prices Indexes, each having a non-blank Code and a Description. There is no logic connected to this field, it is purely for information and filtering.
Subscription Prices Indexes
Subscription Prices Index page allows the setup of price agreements (indexes). These indexes are referenced by a Code and Description and are used for informational and filtering use only
In the search, enter Subscription Prices Indexes and select the related link.
Code: Specifies a unique, user defined, identifier to classify the Subscription Price Index.
Description: Specifies information about the Subscription Price Index.