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

Overview

This article explains how to check order status and order shipment notifications in eXtendPS-DE. You can perform these checks either manually on individual orders or automatically through scheduled updates.

Prerequisites

  • Configure vendor Order Status and Order Shipment Notification endpoints on vendor records
  • Set up valid Vendor ID and Vendor Secret information on vendor records

Manual Order Status Update

You can check an order's status directly from the purchase order:
  1. Open the purchase order you want to check
  2. Click Update Order Status to get the current Order Status, Expected Ship Date, and Expected Receipt Date from your vendor.

  3. The order details will update after the page refreshes.


Note: The "Update Order Status" button won't be shown if:

  • The PromoStandards Order Status is "Complete"
  • The vendor doesn't have PromoStandards Order Status endpoints configured
  • The vendor is marked as inactive in NetSuite
  • The mapped "Purchase Order External Id Field" in the eXtendPS-DE Setup is not populated on the Purchase Order

Bulk Order Status Updates

Scheduled Update

Use the "eXtendPS-DE Update Order Status" Map/Reduce script to automatically update order statuses on a schedule See Bulk Update the PromoStandards Order Status on Purchase Orders for details.

On-Demand Update

To run on-demand updates:
  1. Go to eXtendTech → eXtendPS-DE → PromoStandards Job Runner
  2. Select Order Status Batch Jobs and click "Submit"
    bs

Updates will apply to the orders that match your saved search criteria in the "ORDER STATUS SAVED SEARCH ID" field in the eXtendPS-DE Setup.

Order Shipment Notification Updates

Manual Update

To check order shipment notification details on a purchase order:

  1. Open the purchase order record
  2. Select the eXtendPS-DE subtab (may be labeled "PromoStandards")
  3. Click Update Order Shipment Notification

Note: This button won't appear if:

  • The vendor doesn't have PromoStandards Order Shipment Notification endpoints configured
  • The vendor is marked as inactive in NetSuite
  • The shipment status is "Complete"

Combined Status and Shipment Update

Administrators can enable combined updates in the eXtendPS-DE Setup by enabling the "COMBINE OS AND OSN HTML" preference.

The combined view shows:

  • Purchase Order details
  • Order status information
  • Shipment tracking
  • Expected dates
  • Shipping addresses
  • Hovering your mouse over the Item # will show a tooltip with additional item information

A success message appears after a successful update:

Combined View Examples

When Only Shipment Information is Available

If only Order Shipment Notification data is received, you'll see these columns:

  • Purchase Order #
  • Factory Order #
  • Quantity
  • Shipment Date
  • Tracking #
  • Distributor Item Id
  • Distributor Part Id
  • Supplier Item Id
  • Supplier part Id
  • Ship From Address
  • Ship To Address

You'll see this success message:


When Only Order Status is Available

If only Order Status data is received, you'll see these columns:

  • Purchase Order #
  • Factory Order #
  • Status
  • Expected Ship Date
  • Expected Delivery Date
  • Respond To
  • Additional Explanation
  • Updated (statusTimeStamp from OS)
You'll see this success message:

Additional Notes

  • Order Status and Order Shipment Notification 2.0.0 provides more detailed information in the eXtendPS-DE Order Search Details field:

  • If multiple Order Status responses are received, then all statuses will be shown in the table:

Bulk Order Shipment Notification Update

Scheduled Update

The "eXtendPS-DE OSN Glom" Map/Reduce script handles bulk updates of Order Shipment Notifications. You can schedule this script to run automatically.

By default, the script uses the saved search ID from the "ITEM SHIPMENT SAVED SEARCH ID" field in eXtendPS-DE Setup.


You can override this by setting the "OSN INPUT PO SAVED SEARCH ID" parameter in your scheduled deployment. Contact your NetSuite Administrator for help with configuration.

On-Demand Update

You can run bulk shipment updates on demand:
1. Go to eXtendTech → eXtendPS-DE → PromoStandards Job Runner
2. Select the Order Shipment Batch Jobs option and click "Submit"

Note: The update uses orders matching the saved search in the "ITEM SHIPMENT SAVED SEARCH ID" field. If no value is set, it uses the "OSN INPUT PO SAVED SEARCH ID" parameter.

Order Shipment Notification Update (On Sales Order Record)

You can also display shipment information on Sales Orders. However, Since sales Orders don't have vendors, you'll need to specify which vendor to use.

You can select a vendor in two ways:
  1. Use the "eXtendPS-DE Vendor" field on the Sales Order
  2. Use the "eXtendPS-DE OSN VENDOR ID" script parameter on the "eXtendPS-DE OSN Glom" deployment.
Note: Sales Order updates are only available through scheduled or on-demand updates. There are no update buttons directly on the Sales Order record.