What are Dated List Price Adjustments in Salesforce and Why are they Useful?
On a pre-determined date, Dated List Price Adjustments will automatically change the List Price of the Pricebook Entry of a Product in Salesforce.
The new List Price can be calculated by applying either a positive or negative percentage to the current List Price of the Product. Or, the new List Price can be specified.
The new List Price will automatically be applied on the New List Price Effective Date, which can also be set on the Pricebook Entry.
So, if you have, for example, a series of price changes to apply to your products, you can prepare these in advance and have Flexpricer automatically apply the updated prices
Flexpricer will automatically apply the discount to line items if they are added to opportunities or quotes between the pre-configured discount dates.
How to Set Up Dated List Price Adjustments in Salesforce
- Add the following fields to your Pricebook Entry page layout
- New List Price Percentage
- New List Price Currency
- New List Price
- New List Price Effective Date
- On the Flexpricer Settings page and the Settings sub-tab, check the checkbox next to the feature called ‘Dated List Price Adjustments’.
- On the Flexpricer Settings page and the Scheduled Jobs sub-tab, check the ‘cron schedule’ for Pricebook List Price Updates and press the ‘Schedule’ button. This will scheduled the job that checks the New List Price Effective Date to determine if any price changes are required.
How to Use Dated List Price Adjustments in Salesforce
- This feature requires two pieces of information
- EITHER New List Price Percentage OR New List Price Currency
- New List Price Effective Date
- The New List Price Percentage field is a percentage by which a List Price will be adjusted on the New List Price Effective Date. So, entering a value of 5% into the New List Price Percentage field and a date of 01-Jan-2022 in the New List Price Effective Date field will raise the List Price of the Pricebook Entry by 5% on 01-Jan-2022. (Entering a value of -5% into the New List Price Percentage field will reduce the List Price of the Pricebook Entry by 5%.)
- The New List Price Currency field is a currency field whose value will be used to overwrite the List Price of the Pricebook Entry on the New List Price Effective Date. So, entering a value of $1,100 into the New List Price Currency field and a date of 01-Jul-2022 in the New List Price Effective Date field will change the List Price of the Pricebook Entry to $1,100 on 01-Jul-2022.
Useful Information for Advanced Administrators
- The cron schedule for Pricebook List Price Updates follows Salesforce’s standard format. The first digit in the cron schedule denotes ‘seconds’ and must always be set to an integer between 0 and 59 (usually 0) and the second digit denotes ‘minutes’ and must always be an integer between 0 and 59.
- Salesforce does not permit AppExchange Apps to schedule jobs more frequently than once per hour, so it is not possible to set either seconds or minutes to ‘*’ to denote ‘every second’ or ‘every minute’.
- If you wish to manually run the batch process to force Flexpricer to check for Pricebook List Price Updates, then press the ‘Run Batch’ button on relevant row.