(877) 334-9650
June 14, 2019

EDI Insider Newsletter June 14, 2019

Read our EDI Insider Newsletter for useful EDI HQ software tech tips, download the EDI Buyer’s Guide and more!

If you are having any trouble viewing this email Open This Email in Your Browser HERE.
Love Our Popular EDI 101 Guide? You’ll Love Our EDI Buyer’s Guide Too!
Download Our   Free EDI Buyer’s Guide   for Insightful Resources and Recommendations for Evaluating Your EDI Infrastructure.

We cover these topics and much more:
  • Why use EDI?
  • New to EDI insight and direction to increase efficiency of your current system
  • Understand all aspects of EDI: Communication, Data Management, Translation, Integration and Mapping
  • Finding the best EDI solution for your industry
EDI HQ “How To”?
POs with SDQ Segments – What Does the Parser Do for Mapping?
​​SDQs in 850s – What Parsing Does

EDI HQ has an option for when there are SDQ segments in inbound 850s to either “parse” the SDQs into separate 850s at the time of map designing and mapping, or to keep the 850 whole and unparsed. The option can be found on the Mapping tab of the T-Set setup.
It is important to understand how SDQ segments hold the data for the various locations in pairs of Location+Quantity. Each SDQ segment can have up to ten of these pairs – SDQ03+SDQ04, SDQ05+SDQ06, … SDQ21+SDQ22. The mapper cannot loop on these pairs. You can, however, loop on SDQ segments, since some trading partners can send many SDQ segments with many quantities for the various locations. 

Below is a small example of a PO with two line items and the SDQ segments for those lines.
For a mapping example we will use a smaller sample to visualize a PO that will be parsed into three separate POs during mapping based on the three locations found in the SDQ segments. But first let’s understand the quantities and how they work. If an 850 has been set up correctly, the sum of the PO102 quantity for the line item will be equal to the sum of the quantities in the SDQ segments for that line item. 

Here is an image that shows these quantities.
If the “Suppress Multi-Store Purchase Order (SDQ) Parsing for this T-Set” setting does not have a checkmark in it, the 850 will be “parsed” in both the map designer and during mapping. But what does parsing do to change the PO and split it up?​​​​

A. It creates a new N1 segment for the Location ID – “N1*ZZ*SDQ STORE*92*111” where the blank will contain the store name.

B. Replaces the PO102 quantities with the quantity found in the Location+Quantity for the location represented in the new N1 segment. If a line item does not contain a particular location, that line item will not be included in the parsed PO.

C. Removes the SDQ segments.

Example from the map designer comparing with original EDI:
The following transactions will be created from that single PO:

1.

ISA*00*     *00*     *ZZ*ABCD      *ZZ*0123456789   *190819*1019*U*00400*000001522*0*P*>
GS*PO*ABCD*0123456789*20190819*1019*1522*X*004010
ST*850*0001
BEG*00*SA*112245**20190819
N1*ZZ*SDQ STORE*92*111
PO1*1*3*EA*2.99**IN*11111111*VN*1234
PO1*1*5*EA*1.49**IN*22222222*VN*1235
CTT*2
SE*8*0001
GE*1*1522
IEA*1*000001522

2.

ISA*00*     *00*     *ZZ*ABCD      *ZZ*0123456789   *190819*1019*U*00400*000001522*0*P*>
GS*PO*ABCD*0123456789*20190819*1019*1522*X*004010
ST*850*0001
BEG*00*SA*112245**20190819
N1*ZZ*SDQ STORE*92*112
PO1*1*6*EA*2.99**IN*11111111*VN*1234
PO1*1*7*EA*1.49**IN*22222222*VN*1235
CTT*2
SE*8*0001
GE*1*1522
IEA*1*000001522

3.

ISA*00*     *00*     *ZZ*ABCD      *ZZ*0123456789   *190819*1019*U*00400*000001522*0*P*>
GS*PO*ABCD*0123456789*20190819*1019*1522*X*004010
ST*850*0001
BEG*00*SA*112245**20190819
N1*ZZ*SDQ STORE*92*113
PO1*1*4*EA*2.99**IN*11111111*VN*1234
PO1*1*2*EA*1.49**IN*22222222*VN*1235
CTT*2
SE*8*0001
GE*1*1522
IEA*1*000001522
In our example, SDQ parsing has turned the PO into three POs. One note to be cautious about when parsing POs – the PO number BEG03 will remain the same for each “separated” PO. You should take care during map designing to be able to differentiate between the PO’s. We often see the SDQ STORE location number attached to the PO. For example 112245-111,112245-112, 112245-113. That way you can be ensured of not confusing the parsed POs.
For Helpful EDI Tips and Downloads, Visit Our Knowledge Center!
1 EDI Source provides leading hands-on curriculum with over 30 years of EDI industry experience.  1 EDI University  provides a solid working knowledge of EDI tasks, techniques and management. Check out the training schedule below:

Upcoming Sessions
July 8th – 12th
August 5th – 9th
September 9th – 13th

Call 877-334-1334 to Register Today!
Stay up to date with important trading partner updates and expand your EDI knowledge.
Learn how 1 EDI Source can offer you the best EDI solution for your unique business needs.
1 EDI Source, Inc. | 877.334.1334 |  [email protected]  |  www.1edisource.com

Copyright © 2019 All Rights Reserved.