Version: eXtendPS-SE 1.5.0 and above

Overview

Before making the Order Status Service available to distributors, you must configure it. Configuration involves mapping fields from the NetSuite Sales Order object to their corresponding fields in the PromoStandards Order Status API response.

Configuration

To configure the Order Status service, go to eXtendTech → eXtendPS-SE → Order Status Setup.

General Setup Section

1. Saved Search ID For PO/SO (OS 1.0.0 Only) – This saved search filters Sales Order records shared for Purchase Order/Sales Order reference-based order status searches. The default saved search included with the bundle is customsearch_extend_promo_api_search_so. You can copy this saved search and modify the criteria as needed.
   
2. Saved Search ID for TIMESTAMP/ALL-OPEN (OS 1.0.0 Only) – This saved search filters Sales Order records shared for TIMESTAMP/ALL-OPEN order-based order status searches. The default saved search included with the bundle is customsearch_extend_promo_api_search. You can copy this saved search and modify the criteria as needed.
   
3. Validate Response – Determines whether to validate field data types before returning the response.
   

WSDL Field Mappings Section

1. Factory Order Number* — The Sales Order number field in NetSuite. *Recommended field: {tranid}.*
   
   Note: This field is required to generate an Order Status response. If missing, the service will return an error.
   
2. Expected Ship Date — The shipment date field in NetSuite. *Recommended field: {shipdate}.*
   
3. Expected Delivery Date — The expected delivery date field in NetSuite.
   
4. Response Required (OS 1.0.0 Only) — A checkbox field in NetSuite that indicates whether the distributor needs to provide information back to the supplier to complete the order.
   
5. Purchase Order ID* — The customer Purchase Order number field in NetSuite. *Recommended field: {otherrefnum}.*
   
   Note: If this field is empty when searching for order status by Sales Order number or timestamp, the response will use the Sales Order number and display "Not Specified" for the Purchase Order number. (Supported in version 1.3.8 and above.)
   
6. Sales Order ID (OS 1.0.0 Only) — The Sales Order number field in NetSuite. *Recommended field: {tranid}.*
   
7. Sales Order's Entity Record Type ID (OS 1.0.0 Only) — The internal ID of the entity on the Sales Order in NetSuite. *Recommended field: {salesrep}.*
   
   Note: The Sales Order entity's contact information (such as email and phone) will be included in the API response. For more configuration options, see Configure Hardcoded or Customized Elements in the eXtendPS-SE Order Status Response.
   
8. Sales Order's Entity Name Field ID (OS 1.0.0 Only)— The entity field ID used to display the entity's name in the response. *Recommended field: {entity}.*
   
9. Additional Explanation — A field ID in NetSuite for any additional information you want included in the API response.
   

Order Status 2.0.0 Settings

1. Quality Proof Link — Quality proof url for order status 2.0.0.
   
2. Audit URL — Audit url for order status 2.0.0.
   
3. Customer Service Rep — Field id for the Customer Service Rep (which must point to an Employee record) for Order Status 2.0.0.
   
4. Product Id — Specify an item field id that contains Product details. This field is supported only for Order Status 2.0.0.
   
5. Part Id — Specify an item field id that contains Product's part id. This field is supported only for Order Status 2.0.0.
   

Issue Category Mapping (Order Status 2.0)

1. See Order Status 2.0.0 New Features and Service Setup Configuration for configuration details.
   

Quantity UOM Mapping (Order Status 2.0)

1. See Unit of Measure (UOM) Mapping in eXtendPS-SE Order Status 2.0 for configuration details.
   

Click Save to submit your modifications.