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

Overview

When PromoStandards-enabled items are added to an Estimate (Quote) or Sales Order, eXtendPS-DE can display vendor stock quantities from the vendor’s PromoStandards Live Inventory service in a configurable, line-level inventory field.

Image Placeholder

This article explains the deployment options and recommended workflows/scripts for populating vendor stock on sales transactions.

Prerequisites

  1. Your items are linked with PromoStandards.
  2. Your eXtendPS-DE Vendor on the item record is configured with the PromoStandards Live Inventory service.
  3. The item(s) added to the Quote or Sales Order return a Live Inventory response from the vendor.
  4. The vendor stock field you’ll use is available on your Quote/Sales Order custom form as a line item field.

Configuration

Create script deployments

eXtendPS-DE Set Inventory WFA {customscript_extend_psde_wfa_set_invento}

This workflow action script populates stock quantities on transaction lines in real time.

Deploy it on:

  • Estimate (Quote)
  • Sales Order

Configure these script parameters:

  1. Max Parent Items For Real-time
    This sets the maximum number of parent items allowed for real-time inventory updates. We recommend keeping this as low as possible, and using a maximum of 10, to help prevent performance issues in NetSuite.
  2. Inventory Stock Field
    By default, the built-in field eXtendPS-DE Vendor Stock {custcol_extend_promo_vendor_stock} stores the inventory stock level. You can optionally provide a different custom column field.
    Image Placeholder

eXtendPS-DE Set Inventory Trigger MR {customscript_extend_psde_wfa_set_inv_but}

This workflow action script triggers the Map/Reduce script:

eXtendPS-DE Set Inventory MR {customscript_extend_psde_mr_set_inventor}

Deploy it on:

  • Estimate (Quote)
  • Sales Order

eXtendPS-DE Set Inventory MR {customscript_extend_psde_mr_set_inventor}

This Map/Reduce script processes inventory updates asynchronously when the number of items on a Quote or Sales Order exceeds the configured threshold.

This approach helps avoid SuiteScript governance and execution timeout issues that can occur during real-time inventory updates.

By default, eXtendPS-DE bundle installation includes these deployments to support concurrent execution of inventory requests:

Deployment name
Internal ID
eXtendPS-DE Set Inventory MR
{customdeploy_extend_psde_mr_set_inventor}
eXtendPS-DE Set Inventory MR 1 [DNS]
{customdeploy_extend_psde_mr_set_inven_1}
eXtendPS-DE Set Inventory MR 2 [DNS]
{customdeploy_extend_psde_mr_set_inven_2}
eXtendPS-DE Set Inventory MR 3 [DNS]
{customdeploy_extend_psde_mr_set_inven_3}

If any of these deployments are missing in your account, recreate them using the same internal IDs to ensure proper concurrent processing of stock inventory requests.

Create workflows

Sample workflows are included in eXtendPS-DE for reference. We recommend copying the samples and then modifying them (as needed) with any additional criteria or business-specific logic before using them in production.

eXtendPS-DE Set Inventory [B]

This workflow automatically updates vendor stock on transaction line items.

The workflow first attempts to update inventory in real time using eXtendPS-DE Set Inventory WFA, based on your script parameter configuration.

Workflow behavior

  • If the transaction qualifies for real-time processing, vendor stock is updated immediately on the Quote/Sales Order line items.
  • If the transaction exceeds the configured threshold (or is otherwise not eligible for real-time processing), the workflow runs eXtendPS-DE Set Inventory Trigger MR, which triggers eXtendPS-DE Set Inventory MR.
  • After the Map/Reduce execution completes successfully, vendor stock quantities are populated on the transaction item lines.

eXtendPS-DE Set Inventory WFA Button [B]

This workflow adds a button labeled eXtendPS-DE Set Inventory to:

  • Estimate (Quote)
  • Sales Order

When you click the button, the workflow triggers eXtendPS-DE Set Inventory MR. After the Map/Reduce process completes, vendor stock quantities are updated on the transaction item lines.

Image Placeholder

Frequently Asked Questions (FAQs)

Q: When should I use the Map/Reduce approach instead of real time?
A: Use Map/Reduce when the transaction has many items (or you’re seeing governance/timeouts) and the real-time approach may exceed SuiteScript limits.
Q: Do I need all the M/R deployments listed above?
A: They’re included to support concurrent execution. If any are missing, recreate them with the same internal IDs so concurrent processing continues to work as expected.