Version: eXtendPS-DE 1.3.1
Audience: Administrator

eXtendPS-DE allows you to save the PromoStandard Vendor Invoice responses as a custom record named eXtendPS-DE Invoice Response. 

This feature allows you to review all PromoStandards invoices from your vendor (including the ones that failed to create Vendor Bills in NetSuite). This also allows you print a PDF copy of the Invoice data received from the vendor so that you do not need to request a PDF copy from the vendor via email. The Invoice PDF can be fully customized as per your own theme and layout using native NetSuite Advanced HTML/PDF Templates.

Details regarding configuring this feature are below:

Real-time Invoice Custom Record Creation

For creating on-demand invoice custom records, eXtendPS-DE provides you an option to execute record creation process from eXtendPS-DE job runner.
Follow below steps for executing this job runner:

  1. Navigate to eXtendTech → eXtendPS-DE → PromoStandards Job Runner.
    Image Placeholder
  2. Select the Import Invoice from PromoStandards option and specify invoice start & end date under fields Invoice Start Date & Invoice End Date respectively.
    Image Placeholder
  3. Click Submit.
  4. On successful execution of this job, status Complete will be shown on your screen.

Scheduled Invoice Custom Record Creation


The eXtendPS-DE Create Custom Bill Record Map/Reduce script is included in the bundle which will create eXtendPS-DE Invoice Response custom record based on the invoice responses received from PromoStandards. 

You can create scheduled deployments of this script for creating the eXtendPS-DE Invoice Response records as per your requirements.

Below is a list of the script level parameters which are present in this script:

  1. eXtendPS-DE Stop Create Custom Invoice Script Execution - This field is used for stopping the Map/Reduce script at any point.

  2. eXtendPS-DE Invoice Vendor Search Start From - This field is used for searching the vendor from a specific range, and the vendor search starts from the specified value. The default value is 0. (This is used for scheduling the next batch of vendors for creating the custom records which there is a large batch.)

  3. eXtendPS-DE Invoice Request Date Day Filter - This field is used for requesting the invoices for the current date or previous date. If this is not provided, then the default value for this is today.
    Note: Only today and yesterday are supported at this time.

  4. eXtendPS-DE Invoice Date Specific Filter - This field is used for requesting invoices for a specific date.

  5. eXtendPS-DE Invoice End Date Filter - This field will work in conjunction with eXtendPS-DE Invoice Date Specific Filter field. The date mentioned in this field will act as end date & the date mentioned in eXtendPS-DE Invoice Date Specific Filter field will act as start date for fetching invoice records. Note: The maximum limit for date range is upto 30 days. 

Note: The page size of the vendor search result is configurable from the eXtendPS-DE Setup page using the field INVOICE SERVICE VENDOR PAGE SIZE.


Error list

The section below lists the error codes and error messages which you might receive during eXtendPS-DE Invoice Response creation.

  1. Error Code: PO_NOT_FOUND
    Error Message: Purchase order not found

    This error message and error code will be set in the custom record if the purchase order is not found in the NetSuite account while creating the custom Invoice record.
  2. Error Code: INVALID_INVOICE_DATE 
    Error Message: Invalid invoice date {{INVOICE_DATE}}

    This error message and error will be set in the custom invoice record if an invalid invoice date is received from the invoice response while creating the custom invoice record.
  3. Error Code: VENDOR_CREDIT 
    Error Message: Credit memo received from vendor

    This error message and error will be set in the custom invoice record if the invoicetype received from PromoStandards is CREDIT MEMO.