Version: eXtendPS-DE 1.3.7
Audience: Administrator
Use Case
- Update purchase prices from PromoStandards.
- Update sales pricing from PromoStandards.
- Update different NetSuite price levels with different PromoStandards price types.
Summary
By default, the pricing type used when setting the pricing on an item is Customer pricing upon item constitution. If the vendor is specified on the eXtendPS-DE Setup page's Net Pricing Vendors, then Net pricing will be set on the constituted items. This workflow allows you to update multiple NetSuite price levels with different PromoStandards price types.
Prerequisites
Ensure that the PromoStandards price type you will use is mapped to at least one NetSuite price level on the eXtendPS-DE Setup page.
Workflow Configuration Details
- Create a saved search to filter the item records that you want to update pricing for. You can review or modify the saved search by saving a copy of the eXtendPS-DE To Update Item Pricing [B] search. We recommend reviewing the items in the saved search before scheduling the workflow to ensure that the applicable items are updated.
- Create a workflow against item records.
- Schedule the workflow according to your desired schedule and specify the saved search from step #1 in it.
- Add the eXtendPS-DE Item Price Update WFA custom workflow action to the workflow.
- Specify values against the following parameters.
- eXtendPS-DE Price Configuration Type
Select the price configuration type which will be used for setting the pricing on the item record. If no value is specified, the value specified on eXtendPS-DE Setup page's Price Type will be used. - eXtendPS-DE Price Type
Select the price type which you want to update.
- eXtendPS-DE Skip Purchase Price Update
This checkbox determines whether to update the purchase price of the item or not.
Note: This setting is helpful when you want to update the purchase price based on a specific price type. - Save the workflow.
- To update other price types, such as Net and Customer, repeat the process by creating additional saved searches and scheduled workflows for the items that should receive updates from those price types.
Note:
You can review updated item prices using the eXtendPS-DE Review Refreshed Purchase Price [B] saved search. We recommend saving a copy of this search and restricting the criteria to a smaller date range for reviewing updates.
You can review updated item prices using the eXtendPS-DE Review Refreshed Purchase Price [B] saved search. We recommend saving a copy of this search and restricting the criteria to a smaller date range for reviewing updates.