Version: eXtendPS-DE 1.2.7 and above
Audience: Administrator, User

Overview

eXtendPS-DE allows you to update the PromoStandards Order Status on your purchase order records in bulk. You can do this using both an on-demand and scheduled update method.

This article will cover the configuration aspects of the order status bulk update using the on-demand method and the scheduled update method.

On-Demand Bulk Update

To initiate an on-demand bulk PromoStandards Order Status update, you can use the eXtendPS-DE Job Runner. Below are the details for setting up this feature and using it.

Configuration (Administrator)

On the eXtendPS-DE Setup screen at eXtendTech → eXtendPS - DE → Setup, you need to provide a saved search ID for the process to use. This will be used to filter the purchase orders that should be targeted for the PromoStandards order status update. Your saved search should return the purchase order results which should be included when an on-demand bulk update is triggered.

After creating your saved search, add its saved search id in the Order Status Saved Search Id field on the Order Status subtab as shown below.
Image Placeholder

Usage (User)

1. To trigger the on-demand bulk update, go to eXtendTech → eXtendPS - DE → Job Runner.

2. Select the Order Status Batch Jobs option and click Submit


A processing screen will appear showing the status of the bulk update.
Image Placeholder

3. Once the batch process is complete, the status of the batch job will change to Complete and email the recipients that have been configured by your NetSuite Administrator.
Image Placeholder

Scheduled Bulk Update

Configuration (Administrator)

If you want to schedule the PromoStandards Order Status Bulk Update to happen automatically, you can do so by creating a script deployment of the eXtendPS-DE Update Order Status {customscript_extend_promo2os_schedule} script.

1. Go to Customization → Scripting → Scripts and find the Map/Reduce script named "eXtendPS-DE Update Order Status".

2. If a scheduled script deployment is not already in place and running, create a new scheduled script deployment. When creating a new script deployment, there are script parameters available to further refine the update process. Below are the details regarding these parameters:
Image Placeholder

  1. eXtendPS-DE Stop Update Order Status Script Execution
    Enable this option to stop the script execution and avoid further scheduling of order status script.

  2. eXtendPS-DE Update status PO Search Start From
    Used internally by the update process. You do not need to specify a value here.

  3. eXtendPS-DE Order Search Size
    This is the search page size. The default value is 1000. Setting a high value (1000+) can lead to script execution time errors. Setting a low value can result in multiple script instances running. The recommended value is 1000.

  4. eXtendPS-DE Vendor IDsIf you only want to execute the order status update for specific vendors, you can do so by specifying the internal IDs of those vendor records separated by commas in this field. Please note that this is recommended for testing purposes only.

3. Schedule and deploy the new script based on your preferred schedule.