AnsweredAssumed Answered

EDI profile 00410VICS segment SDQ

Question asked by avanderpost413936 on Mar 2, 2016
Latest reply on Mar 11, 2016 by avanderpost413936

Based on PO1 Loop - we need to get a row for each individual combination of store/qty as defined in SDQ segment.

The other day - I saw an example here - cannot find it anymore.

 

I am using the "standard settings for the SDQ segment - not modified by me" and end up with one header record and one detail record for the first store 0322 for sku SKU_A with a quantity of 6.

 

If we have:

PO1*1*24*EA*60*PE*UP*890764002118*VA*SKU_A*IN*0^

SDQ*EA*92*0322*6*0427*12*0629*6^

PO1*2*6*EA*60*PE*UP*990764002118*VA*SKU_C*IN*0^

SDQ*EA*92*0320*1*0418*1*0729*1^

SDQ*EA*92*0322*1*0420*1*0730*1^

 

For PO1 line 1 we need

header record 1 for Store 0322

orderdetail record 1 line 1     SKU_A    Ship to Store 0322   Qty  6

header record 2 for Store 0427

orderdetail record 2 line 1     SKU_A    Ship to Store 0427   Qty  12

header record 3 for Store 0629

orderdetail record 3 line 1     SKU_A    Ship to Store 0629   Qty  6

 

For PO1 line 2 we need

header record 4 for Store 0320

orderdetail record 4 line 2     SKU_C    Ship to Store 0320   Qty  1

header record 5 for Store 0418

orderdetail record 5 line 2     SKU_C    Ship to Store 0418   Qty  1

header record 6 for Store 0729

orderdetail record 6 line 2     SKU_C    Ship to Store 0729   Qty  1

( Have already header record 1 for Store 0322 )

orderdetail record 7 line 2     SKU_C    Ship to Store 0322   Qty  1

header record 7 for Store 0420

orderdetail record 8 line 2     SKU_C    Ship to Store 0420   Qty  1

header record 8 for Store 0730

orderdetail record 9 line 2     SKU_C    Ship to Store 0730   Qty  1

 

Any help is greatly appreciated!

Thanks - Anton

Outcomes