AnsweredAssumed Answered

EDI 850 PO1 Loop Split Issue

Question asked by sramanan217031 on Apr 22, 2017
Latest reply on Apr 24, 2017 by sramanan217031

Hi,

 

I have EDI 850 data as below for PO1 Loop. When I try to split based on the PO1 Loop, it is not breaking the loop correctly. 

 

Please find below sample. Can you please help what is not correct here?

 

EDI Data as below

 

PO1~1~1~EA~379.53~~VP~VP0001~BP~BP0001

PID~F~~~~VP DESC 1
DTM~010~20170411
DTM~002~20170425
PO1~2~1~EA~54.63~~VP~VP0002~BP0002
PID~F~~~~VP DESC 2
DTM~010~20170411
DTM~002~20170425

 

After Split

 

Split1

 

PO1~1~1~EA~379.53~~VP~VP0001~BP~BP0001

PID~F~~~~VP DESC 1

 

Split2

 

DTM~010~20170411
DTM~002~20170425
PO1~2~1~EA~54.63~~VP~VP0002~BP0002
PID~F~~~~VP DESC 2

 

Expected Split

 

PO1~1~1~EA~379.53~~VP~VP0001~BP~BP0001

PID~F~~~~VP DESC 1
DTM~010~20170411
DTM~002~20170425

 

Split 2

 

PO1~2~1~EA~54.63~~VP~VP0002~BP0002
PID~F~~~~VP DESC 2
DTM~010~20170411
DTM~002~20170425

Outcomes