Version: eXtendPS-DE 1.4.64 and above
Audience: Administrator

Overview

eXtendPromoStandards Distribution Edition (eXtendPS-DE) allows you to configure the PromoStandards Purchase Order service in NetSuite. This integration enables you to:

  • Place blank purchase orders to vendors with purchase order service endpoints
  • Map shipping methods between NetSuite and your vendors
  • Configure field mappings for sending order details
Additional configuration and custom scripting is required for configured purchase order placement. Contact eXtendTech Support for assistance.

Prerequisites

Purchase Order Filter Search

Create a saved search to filter which purchase orders are available for purchase order placement:

  • Use the provided bundle search eXtendPS-DE Place PO Saved Search[B] {customsearch_extend_ps_de_place_po_ss} as a template, and save a new version of it
  • Add any additional filters needed for your business requirements

Configuration

1. Access the Setup Page

Navigate to eXtendTech → eXtendPS-DE → Purchase Order Setup.
If you don't see this menu option, follow these steps to create it:
  1. Go to Customization → Scripting → Scripts
  2. Find the script named eXtendPS-DE Suitelet
  3. Create a new deployment with these settings:
    • Name: eXtendPS-DE Purchase Order Setup
    • ID: _extend_psde_po_setup (will save as customdeploy_extend_psde_po_setup)

    • Audience: Administrator (default), or specific roles or employees
    • Status: Released
    • Log Level: Audit or Error
    • Execute as role: Administrator
  4. Set the script parameter eXtendPS-DE to promo_po_setupImage Placeholder
  5. Configure the menu location:
    • Center: Classic Center
    • Section: eXtendTech
    • Category: eXtendPS-DE
    • Label: Purchase Order Setup
      Image Placeholder

2. General Configuration

Configure these basic settings:
  • Purchase Order Filter Search: Enter your saved search ID from the Prerequisites section
  • Show Place PO Button: Enable to display the "Place PO" button on purchase order records. Note that this controls the scripted button that's added by eXtendPS-DE. If a workflow is being used to show the button, the workflow would need to be modified as well. eXtendPS-DE Place PO[B] is the base workflow included in eXtendPS-DE
  • Place PO Button Label: Customize the button text
  • Additional Columns: Used for scripted hooks - do not modify without first consulting eXtendTech Support
  • Vendor Ship Method Mapping: Go to the eXtendPS-DE Purchase Order setup page and select Vendor Ship Method Mapping ListClick New eXtendPS-DE Vendor Ship Method Mapping to create a mapping record with these fields:
    • Vendor: Select the vendor for the mapping
    • NS Ship Method: Choose the NetSuite shipping method
    • Vendor Ship Method: Enter the vendor's corresponding shipping method
    • Vendor Ship Carrier: Specify the vendor's carrier service
Note: Users can add ship methods directly from the vendor record using the Vendor Ship Method Mapping subrecord list present under eXtendPS-DE subtab - 



3. Field Mappings

Order Body Fields

Map these essential order fields:
  1. Order Number - Select the transaction field that will provide the order number to the Purchase Order service. Typically uses the tranid field.
  2. Order Date - Select the transaction field that will provide the order date to the Purchase Order service. Typically uses the trandate field.
  3. Order Type - Select the transaction field that will provide the order type to the Purchase Order service. Uses the bundle field eXtendPS-DE Order Type {custbody_extend_promo_order_type}
  4. Rush - Select the transaction field that will indicate if this is a rush order in the Purchase Order service. Uses the bundle field eXtendPS-DE Rush {custbody_extend_promo_is_rush}
  5. Last Modified - Select the transaction field that will provide the last modified date to the Purchase Order service. Typically uses the lastmodifieddate field.
  6. Payment Terms - Select the transaction field that will provide the payment terms to the Purchase Order service. Typically uses the terms field.
  7. Terms & Conditions - Select the transaction field that will provide the terms and conditions to the Purchase Order service. Uses the bundle field eXtendPS-DE Terms & Conditions {custbody_extend_promo_terms_n_conditio}
  8. Sales Channel - Select the transaction field that will provide the sales channel to the Purchase Order service. Uses the bundle field eXtendPS-DE Sales Channel {custbody_extend_promo_sales_channel}
  9. Promo Code - Select the transaction field that will provide the promo code to the Purchase Order service. Uses the bundle field eXtendPS-DE Promo Code {custbody_extend_promo_code}
  10. Total Amount - Select the transaction field that will provide the total amount to the Purchase Order service. Typically uses the amount field.
  11. Third Party Account Name - Select the transaction field that will provide the third party account name to the Purchase Order service. Uses the bundle field eXtendPS-DE Third Party Account Name {custbody_extend_promo_thirdparty_ac_na}
  12. Third Party Account Number - Select the transaction field that will provide the third party account number to the Purchase Order service. Uses the bundle field eXtendPS-DE Third Party Account Number {custbody_extend_promo_thirdparty_ac_nu}
  13. Third Party Contact Details - Select the transaction field that will provide the third party contact details to the Purchase Order service.
  14. Ship References - Select the transaction field that will provide the ship references to the Purchase Order service. Uses the bundle field eXtendPS-DE Ship References {custbody_extend_promo_ship_references}
  15. Packaging List Required - Select the transaction field that will indicate if a packaging list is required in the Purchase Order service. Uses the bundle field eXtendPS-DE Packaging List Required {custbody_extend_promo_packaging_list_r}
  16. Blind Ship - Select the transaction field that will indicate if this is a blind shipment in the Purchase Order service. Uses the bundle field eXtendPS-DE Blind Ship {custbody_extend_promo_blind_ship}
  17. Allow Consolidation - Select the transaction field that will indicate if consolidation is allowed in the Purchase Order service. Uses the bundle field eXtendPS-DE Allow Consolidation {custbody_extend_promo_allow_consolidat}
  18. Shipment Comments - Select the transaction field that will provide the shipment comments to the Purchase Order service. Uses the bundle field eXtendPS-DE Shipment Comments {custbody_extend_promo_shipment_comment}
  19. Shipment ID - Select the transaction field that will provide the shipment ID to the Purchase Order service.

Order Line Item Fields

Configure these line level fields:
  1. Line Number - Select the transaction column field that will provide the line number to the Purchase Order service. Typically uses the linesequencenumber field
  2. Line Type - Select the transaction column field that will provide the line type to the Purchase Order service. Uses the bundle field eXtendPS-DE Line Type {custcol_extend_promo_line_type}
  3. Item - Select the transaction line or item field that will provide the item to the Purchase Order service. Typically uses the item field
  4. Description - Select the transaction line or item field that will provide the item description to the Purchase Order service. Typically uses the memo field
  5. Tolerance Type - Select the transaction line or body field that will provide the tolerance type to the Purchase Order service. Uses the bundle field eXtendPS-DE Tolerance Type {custcol_extend_promo_tolerance_type}
  6. Tolerance Value - Select the transaction line or body field that will provide the tolerance value to the Purchase Order service. Uses the bundle field eXtendPS-DE Tolerance Value {custcol_extend_promo_tolerance_value}
  7. Tolerance UOM - Select the transaction line or body field that will provide the tolerance UOM to the Purchase Order service. Uses the bundle field eXtendPS-DE Tolerance UOM {custcol_extend_promo_tolerance_uom}
  8. Allow Partial Shipments - Select the transaction line or body field that will provide the partial shipments allowance to the Purchase Order service.
  9. Requested Ship Date - Select the transaction line or body field that will provide the requested ship date to the Purchase Order service.
  10. Requested In Hands Date - Select the transaction line or body field that will provide the requested in hands date to the Purchase Order service.
  11. Customer Supplied - Select the transaction line or body field that will provide the customer supplied value to the Purchase Order service.

Order Part Item Fields

Set up these part-specific fields:
  1. Item Part Name - Select the transaction line or item field that will provide the item part name to the Purchase Order service. Common fields include item.custitem_extend_promo_product_part_id and item.vendorname.
  2. Description - Select the transaction line or item field that will provide the item description to the Purchase Order service. Typically uses the memo field.
  3. Unit Price - Select the transaction line or item field that will provide the unit price to the Purchase Order service. Typically uses the rate field.
  4. Extended Price - Select the transaction line or item field that will provide the extended price to the Purchase Order service. Typically uses the amount field.

Additional Configuration

After completing the setup and creating ship method mappings, you can place blank purchase orders to vendors. For configured or decorated purchase orders, contact eXtendTech Support to discuss implementation of the required custom scripting.