Version: eXtendItem 1.0.0
Audience: Administrator
eXtendItem allows you to update purchase prices in bulk from integrated vendors on a scheduled basis for items that are either created with eXtendItem or linked to it. We support updating purchase prices at both the body level and the vendor sublist level, so you're covered even if the multiple vendors feature is enabled in NetSuite.
The Map/Reduce script eXtendItemDB Update Purchase Price {customscript_extend_itemdb_update_pur_pr} is used to update the purchase price of items specified under the vendor sublist by creating the necessary script deployments.
Configure the script deployment using the steps below:
- Saved Search Creation
Before creating the script deployment, you must create a saved search against the items which you want to consider for purchase price update routine.
The eXtendItemDB Update Purchase Price[B] {customsearch_extend_itemdb_upda_price_ss} saved search is included in the eXtendItem bundle and provided as a reference for creating your search. - Deployment Creation
- Go to Customization → Scripting → Scripts and open the Map/Reduce script eXtendItemDB Update Purchase Price {customscript_extend_itemdb_update_pur_pr}.
- Click Deploy Script to create a new script deployment.
- Specify the schedule as per your requirements.
- Enter the saved search that contains the items to be updated in the script level parameter eXtendItemDB Item Search Id as shown in the screenshot below:
- If no value is specified for the script level parameter eXtendItemDB Item Search Id, then the bundle search eXtendItemDB Update Purchase Price[B] {customsearch_extend_itemdb_upda_price_ss} will be used to filter items for updating their purchase price.