Version: eXtendPS-SE 1.3.6 and above
Audience: Administrator
Applies to: Live Inventory 1.2.1 and 2.0.0.

Overview

The Custom Product Message field lets you send more information regarding the Live Inventory service data response. eXtendPS-SE lets you configure a custom message using NetSuite saved searches. For this configuration, you will create a transaction saved search and group the results based on the item record. Then, add a formula field to create a message which will be sent as the Custom Product Message response.

Below are some points to consider while creating the saved search:
  1. The saved search should of the desired transaction type (which may be other than Purchase Order).
  2. The search should support item and location filters, which will be dynamically added by eXtendPS-SE if NetSuite's multi-location inventory feature is enabled.
  3. The search results should be sorted to display the first result of an item if there are multiple results for the queried item.
  4. Make sure to add exactly one formula text field, as we will use this in the custom product message.
A sample saved search is included in eXtendPS-SE for reference: eXtendPS-SE Purchase Order Search[B]

Note: If an item is configured with an EXTENDPS-SE - CUSTOM MESSAGE value, the override value will be returned.

Configuration

After creating the saved search, specify the search id on the Inventory Service Setup screen in the "PRODUCT MESSAGE SAVED SEARCH ID" field at eXtendTech → eXtendPS-SE →Inventory Setup.


Note: If the DO NOT SHOW PRODUCT MESSAGE ON RESPONSE preference is enabled, the product message will not be sent in inventory responses.

Example:
a. Saved search result for sending a product message on snm-FXL-Iv1.


b. Inventory Response Sample for 2.0:
<GetInventoryLevelsResponse>   <Inventory xmlns="http://www.promostandards.org/WSDL/Inventory/2.0.0/SharedObjects/">
    <productId>snm-FXL-Inv1</productId>
    <PartInventoryArray>
      <PartInventory>
        <partId>snm-FXL-Inv1</partId>
        <mainPart>true</mainPart>
        <partDescription>description</partDescription>
        <quantityAvailable>
          <Quantity>
            <uom>EA</uom>
            <value>0</value>
          </Quantity>
        </quantityAvailable>
        <manufacturedItem>false</manufacturedItem>
        <buyToOrder>true</buyToOrder>
        <attributeSelection>Material: snm-FXL-Inv1</attributeSelection>
        <InventoryLocationArray>
          <InventoryLocation>
            <inventoryLocationId>2</inventoryLocationId>
            <inventoryLocationName>01: San Francisco</inventoryLocationName>
            <postalCode>94403</postalCode>
            <country>US</country>
            <inventoryLocationQuantity>
              <Quantity>
                <uom>EA</uom>
                <value>0</value>
              </Quantity>
            </inventoryLocationQuantity>
            <FutureAvailabilityArray>
              <FutureAvailability>
                <Quantity>
                  <uom>EA</uom>
                  <value>288000</value>
                </Quantity>
                <availableOn>2019-07-26T02:42:00.000Z</availableOn>
              </FutureAvailability>
            </FutureAvailabilityArray>
          </InventoryLocation>
        </InventoryLocationArray>
        <customProductMessage>Next PO Date: AUGUST 08, 2019, Quantity: 288000</customProductMessage>
        <lastModified>2019-07-26T08:26:34.487Z</lastModified>
      </PartInventory>
    </PartInventoryArray>
  </Inventory>
</GetInventoryLevelsResponse>