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 ...

• A Summary to Outline of Elliott EDI Integration Flow

  Release Date: 06/15/2023 Version: 8.x & Up Q - We currently use SPS Fulfillment Portal for our EDI processing. We are getting too great of a volume of EDI orders and we are evaluating whether to automate it with Elliott. Can you give me an outline of ...

• Can BarTender Print a UPC-12 and EAN-13 Based on the UPC Size In Elliott?

  Release date: 09/30/2021 Version: BarTender 2021 and Up Yes, BarTender can print based on the field size, but there are two conditions that have to be set. First, you will need to create two barcodes. Both will print in the same area. Next, you will ...

• Canceled PO Line Items Still Exporting on EDI

  Released Date: 11/7/2022 Version: 8.5 & Up Q - We’ve seen this happen twice in the last month. We create a purchase order, then cancel line items on it. When we export the EDI document again, it still contains the cancelled line items on it, which we ...

• CP0200 Customer Order Processing Print Pick/Pack Tickets and Ship Labels

  Print Pick/Pack Tickets & Ship Labels Application Overview Picking Tickets are documents that list all the items in the order that are eligible to be taken from stock (picked) and shipped from a particular warehouse. These items are listed in order ...