Version: eXtendPS-DE 1.3.1 and above
Audience: Administrator

Overview

eXtendPS-DE allows you to save PromoStandards vendor invoice responses as an eXtendPS-DE Invoice Response custom records in NetSuite. This feature lets you review all PromoStandards invoices from your vendor (including the ones that failed to create Vendor Bills in NetSuite) and print a PDF of the invoice data without requesting a copy from the vendor via email. The invoice PDF can be fully customized using native NetSuite Advanced PDF/HTML templates.

Configuration

There are two methods to create eXtendPS-DE Invoice Response custom records: real-time creation and scheduled creation.

Real-Time Invoice Custom Record Creation

For creating on-demand invoice custom records, eXtendPS-DE provides you an option to execute the record creation process from the eXtendPS-DE Job Runner.
Follow these steps to execute 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 Date & Invoice End Date.Image Placeholder
  3. Click Submit.
  4. On successful execution of this job, a status of "Complete" will be shown on your screen and the eXtendPS-DE Invoice Response records will be available in your list for that record type.

Scheduled Invoice Custom Record Creation

The eXtendPS-DE Create Custom Bill Record Map/Reduce script is included in eXtendPS-DE and will create eXtendPS-DE Invoice Response custom records 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 available for this script:
  1. eXtendPS-DE Stop Create Custom Invoice Script Execution - Stops the Map/Reduce script at any point.
  2. eXtendPS-DE Invoice Vendor Search Start From - Specifies where to begin searching for vendors within a range. Default value is 0. (Used when scheduling the next batch of vendors for custom record creation in large batches.)
  3. eXtendPS-DE Invoice Request Date Day Filter - Requests invoices for either the current date or previous date. Default is today if not specified. Note: Only today and yesterday are currently supported.
  4. eXtendPS-DE Invoice Date Specific Filter - Requests invoices for a specific date.
  5. eXtendPS-DE Invoice End Date Filter - Works with the eXtendPS-DE Invoice Date Specific Filter field. The date in this field serves as the end date, while the date in the Invoice Date Specific Filter serves as the start date for fetching invoice records. Note: Maximum date range is 30 days.

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

Frequently Asked Questions (FAQs)

Q: What error messages might I encounter during invoice response creation?
A: Here are the common error codes and their descriptions:

Error Code: PO_NOT_FOUND
Error Message: Purchase order not found
This error occurs when the purchase order is not found in the NetSuite account while creating the custom Invoice record.

Error Code: INVALID_INVOICE_DATE
Error Message: Invalid invoice date {{INVOICE_DATE}}
This error occurs when an invalid invoice date is received from the invoice response.

Error Code: VENDOR_CREDIT
Error Message: Credit memo received from vendor
This error occurs when the invoicetype received from PromoStandards is CREDIT MEMO.