Enforce UPC in the Purchase Order Print for EDI Trading Partners

Release Date: 08/22/2022

Version 8.5 & Higher

Some EDI trading partners may require that the UPC be provided on outbound EDI purchase orders (850).  An 850 may be rejected when a UPC is not provided for a line item.  Since the purchase order is initiated in Elliott, each item on the order needs to have the UPC populated in the Item record in order to be transmitted in the 850.  Since the UPC setup is not required in Elliott, this can potentially cause an issue. This enhancement will prevent a purchase order from being printed if one or more line items do not have the UPC populated in the item record or if it is an invalid length.  A valid length is anything from 12 to 14 characters to include UPC, EAN, and GTIN values.  An Event was created to allow you to be notified when a purchase order did not print due to this condition.  That way the items can be corrected before another print is attempted.  The print is required before a purchase order can be exported for EDI.

To enable this feature, go to Vendor File Maintenance or Inquiry in Accounts Payable and bring up the vendor that requires the UPC.  Select EDI Profile Maintenance in the Special Functions menu and set flag 11, Require UPC For PO Line Items, to "Y."  See sample screen below:

We suggest subscribing to the new "Printing PO Without UPC" Event to be notified when an attempt is made to print a purchase order without the required UPC.  Click the Events icon, press F5 to insert a new Event, and scroll down to select the POINVPRT Event.

The parameters can be set under Disposition to be a Recurring Request, and under File/Reference you can click the "Subscribe to All" button so you only have to subscribe once to the Event.

Then select your email options, along with what items you would like in the email.

Now you can test it by printing a purchase order for this trading partner.  If you have an item without a UPC on the order, the order will not print and the Event will be triggered for each item without a UPC.

-----Original Message-----
Sent: Monday, August 22, 2022 8:05 PM
To: Mark A. DeShazo
Subject: UPC missing for item SER-PORT

Vendor#             000100
PO#                     000014-00
Vendor Name     Computer Electronics Center
PO Line#             3
PO Item#             SER-PORT
PO Item Desc1   Serial Port For Z80 25 Meg
PO Item Desc2   Serial - Port
PO Item Qty         70.00
PO Item Price     13.0000

Item UPC

-----Message End------

An email will be sent for each item that triggers the Event.

Modified Programs: APVENEDI, POINVPRT

MAD

• Related Articles

• Enforce UPC in the Picking Ticket Print for EDI Trading Partners

  Release Date: 08/21/2022 Version 8.5 & Higher Some EDI trading partners may require that the UPC be provided on outgoing documents, like an ASN (Advanced Shipping Notice or 856) or or an invoice (810). When the UPC is not provided, the EDI ...

• Feature - Validate PO Number for EDI Orders

  Release date: 7/2/2018 The ability to validate EDI orders for selected customers has been added to COP. The validation requires the following setup steps to be completed. First, Global Setup, COP-Func, Order Header screen field "4. Mark Order As EDI ...

• Feature - PO Export by Vendor EDI Profile

  Date Released: 9/8/21 Updated: 3/30/22 Version: 8.5 and Above This feature is added to provide better support of EDI 850 in the PO module. In PO -> Utility -> Purchase Orders Export, this function will now behave based on the Vendor EDI Profile if ...

• Feature - Disallow GTIN in UPC Code Field in Item Extra Data

  Release Date: 10/25/21 Version: 8.5 and Above EDI partners may not accept a GTIN (14-digit UPC code) as a valid UPC code. A new Global Setup option has been added to prevent a GTIN from being added to the item extra data field designated as the UPC ...

• Feature - PO Number Validation for EDI Customers

  Release date: 7/12/2018 This feature will add PO number validation for customers that have an EDI Partner profile set up and a new Global Setup flag set to "Y." To use this new feature, the following field in Global Setup/cop-Func/order Header screen ...