Solved

Error message “transaction counts in group don’t match reality” when running file through Liaison EDI Notepad

Posted on 2016-10-22
4
39 Views
Last Modified: 2016-10-22
Error received is "At envelope 01/080211920->01/018978783, Ctrl+000000700
At group 080211920->018978783, Ctrl=900021426
The transaction counts in group don't match reality. 6 vs. 1
0
Comment
Question by:Larry Drolet
  • 2
4 Comments
 
LVL 57
ID: 41855423
Not sure your going to get an answer....may have to call Liaison directly.  I use EDI notepad, but not for translation.

Was that the exact error message?  And it may not be EDI notepad; can you look at the raw EDI data and verify that indeed the document is invalid (assuming you got this while loading the document)?

I'll look around to for a better topic area.   SQL Server is certainly not it.

Jim.
0
 

Author Comment

by:Larry Drolet
ID: 41855564
Hi Jim,

"At envelope 01/080211920->01/018978783, Ctrl+000000700
At group 080211920->018978783, Ctrl=900021426
The transaction counts in group don't match reality. 6 vs. 1"

is the exact error message received.  The ASN raw data below is what I am working with.  I just have never encountered this error before and do not know what it means.  There are 5 POs in the ASN – PRF segments.  The GE segment references 6.  Is this what is throwing the data off?  Thanks for responding.

ISA~00~          ~00~          ~01~080211920      ~01~018978783      ~161022~1504~U~00200~000000700~0~P~=
GS~SH~080211920~018978783~20161022~1504~900021426~X~004010
ST~856~214260004
BSN~00~386984400002~20161022~100140
HL~1~~S
TD1~CTN~1212~~~~~30760.03~LB
TD5~~2~HJBT~T
REF~BM~019166900002
REF~CN~5441025
DTM~011~20161021
N1~ST~~92~0101
N1~CA~J.B. HUNT TRANSPORTATION
N1~SF~DALLAS - TOPS DIST CNTR
N3~39324 LBJ FREEWAY
N4~DALLAS~TX~75232~USA
CUR~91~USD
HL~2~1~O
PRF~0107047
REF~AI~386984400002
HL~3~2~T
MAN~GM~00100875471016086426
PAL~6~~~2
HL~4~3~I
LIN~006~IN~UNV35262~UP~087547352625
SN1~~20~BX~~20~BX~~AC
SLN~006~~I~20~BX~6.95
HL~5~1~O
PRF~0107808
REF~AI~380908100001
HL~6~5~T
MAN~GM~00100000001016086283
PAL~6~~~23
HL~7~6~I
LIN~003~IN~UNV35210~UP~087547352106
SN1~~55~BX~~175~BX~~AC
SLN~003~~I~55~BX~7.93
HL~8~6~I
LIN~021~IN~UNV36102~UP~087547361023
SN1~~60~BX~~60~BX~~AC
SLN~021~~I~60~BX~21.59
HL~9~5~T
MAN~GM~00100000001016086481
PAL~6~~~32
HL~10~9~I
LIN~009~IN~UNV35267~UP~087547352670
SN1~~55~BX~~180~BX~~AC
SLN~009~~I~55~BX~7.72
HL~11~9~I
LIN~014~IN~UNV35292~UP~087547352922
SN1~~4~BX~~4~BX~~AC
SLN~014~~I~4~BX~28.25
HL~12~9~I
LIN~023~IN~UNV36301~UP~087547363010
SN1~~70~BX~~70~BX~~AC
SLN~023~~I~70~BX~14.04
HL~13~9~I
LIN~028~IN~UNV40102~UP~087547401026
SN1~~25~BX~~25~BX~~AC
SLN~028~~I~25~BX~7.96
HL~14~5~T
MAN~GM~00100000001016086689
PAL~6~~~29
HL~15~14~I
LIN~002~IN~UNV35209~UP~087547352090
SN1~~10~BX~~10~BX~~AC
SLN~002~~I~10~BX~16.25
HL~16~14~I
LIN~005~IN~UNV35261~UP~087547352618
SN1~~20~BX~~20~BX~~AC
SLN~005~~I~20~BX~7.19
HL~17~14~I
LIN~007~IN~UNV35264~UP~087547352649
SN1~~40~BX~~340~BX~~AC
SLN~007~~I~40~BX~6.25
HL~18~14~I
LIN~012~IN~UNV35290~UP~087547352908
SN1~~16~BX~~16~BX~~AC
SLN~012~~I~16~BX~23.47
HL~19~14~I
LIN~016~IN~UNV36002~UP~087547360026
SN1~~24~BX~~24~BX~~AC
SLN~016~~I~24~BX~4.3
HL~20~14~I
LIN~022~IN~UNV36300~UP~087547363003
SN1~~15~BX~~15~BX~~AC
SLN~022~~I~15~BX~14.57
HL~21~14~I
LIN~033~IN~UNV42101~UP~087547421017
SN1~~30~BX~~30~BX~~AC
SLN~033~~I~30~BX~7.54
HL~22~14~I
LIN~041~IN~UNV45165~UP~087547451656
SN1~~2~BX~~2~BX~~AC
SLN~041~~I~2~BX~37.52
HL~23~5~T
MAN~GM~00100000001016087068
PAL~6~~~12
HL~24~23~I
LIN~001~IN~UNV35202~UP~087547352021
SN1~~20~BX~~20~BX~~AC
SLN~001~~I~20~BX~11.9
HL~25~23~I
LIN~025~IN~UNV36321~UP~087547363218
SN1~~40~BX~~40~BX~~AC
SLN~025~~I~40~BX~12.57
HL~26~5~T
MAN~GM~00100875471016086006
PAL~6~~~30
HL~27~26~I
LIN~010~IN~UNV35268~UP~087547352687
SN1~~20~BX~~20~BX~~AC
SLN~010~~I~20~BX~11.71
HL~28~26~I
LIN~017~IN~UNV36003~UP~087547360033
SN1~~55~BX~~55~BX~~AC
SLN~017~~I~55~BX~15.12
HL~29~26~I
LIN~019~IN~UNV36100~UP~087547361009
SN1~~15~BX~~15~BX~~AC
SLN~019~~I~15~BX~18.8
HL~30~26~I
LIN~020~IN~UNV36101~UP~087547361016
SN1~~15~BX~~15~BX~~AC
SLN~020~~I~15~BX~19.6
HL~31~26~I
LIN~026~IN~UNV40099~UP~087547400999
SN1~~10~BX~~10~BX~~AC
SLN~026~~I~10~BX~8.81
HL~32~26~I
LIN~027~IN~UNV40100~UP~087547401002
SN1~~20~BX~~20~BX~~AC
SLN~027~~I~20~BX~7.89
HL~33~26~I
LIN~039~IN~UNV44165~UP~087547441657
SN1~~6~BX~~6~BX~~AC
SLN~039~~I~6~BX~23.07
HL~34~5~T
MAN~GM~00100875471016086297
PAL~6~~~20
HL~35~34~I
LIN~007~IN~UNV35264~UP~087547352649
SN1~~100~BX~~340~BX~~AC
SLN~007~~I~100~BX~6.25
HL~36~5~T
MAN~GM~00100875471016086303
PAL~6~~~20
HL~37~36~I
LIN~007~IN~UNV35264~UP~087547352649
SN1~~100~BX~~340~BX~~AC
SLN~007~~I~100~BX~6.25
HL~38~5~T
MAN~GM~00100875471016086310
PAL~6~~~30
HL~39~38~I
LIN~006~IN~UNV35262~UP~087547352625
SN1~~20~BX~~20~BX~~AC
SLN~006~~I~20~BX~9.44
HL~40~38~I
LIN~008~IN~UNV35265~UP~087547352656
SN1~~25~BX~~25~BX~~AC
SLN~008~~I~25~BX~9.96
HL~41~38~I
LIN~013~IN~UNV35291~UP~087547352915
SN1~~4~BX~~4~BX~~AC
SLN~013~~I~4~BX~21.9
HL~42~38~I
LIN~015~IN~UNV36000~UP~087547360002
SN1~~12~BX~~12~BX~~AC
SLN~015~~I~12~BX~3.81
HL~43~38~I
LIN~030~IN~UNV41165~UP~087547411650
SN1~~16~BX~~16~BX~~AC
SLN~030~~I~16~BX~18.75
HL~44~38~I
LIN~031~IN~UNV41907~UP~087547419076
SN1~~10~BX~~10~BX~~AC
SLN~031~~I~10~BX~10.57
HL~45~38~I
LIN~032~IN~UNV42100~UP~087547421000
SN1~~10~BX~~10~BX~~AC
SLN~032~~I~10~BX~6.6
HL~46~38~I
LIN~034~IN~UNV42102~UP~087547421024
SN1~~10~BX~~10~BX~~AC
SLN~034~~I~10~BX~8.88
HL~47~38~I
LIN~035~IN~UNV42165~UP~087547421659
SN1~~6~BX~~6~BX~~AC
SLN~035~~I~6~BX~23.27
HL~48~38~I
LIN~036~IN~UNV42907~UP~087547429075
SN1~~5~BX~~5~BX~~AC
SLN~036~~I~5~BX~12.38
HL~49~38~I
LIN~037~IN~UNV44104~UP~087547441046
SN1~~12~BX~~12~BX~~AC
SLN~037~~I~12~BX~17.89
HL~50~38~I
LIN~038~IN~UNV44105~UP~087547441053
SN1~~2~BX~~2~BX~~AC
SLN~038~~I~2~BX~17.53
HL~51~38~I
LIN~040~IN~UNV44907~UP~087547449073
SN1~~15~BX~~15~BX~~AC
SLN~040~~I~15~BX~12.7
HL~52~5~T
MAN~GM~00100875471016086341
PAL~6~~~20
HL~53~52~I
LIN~007~IN~UNV35264~UP~087547352649
SN1~~100~BX~~340~BX~~AC
SLN~007~~I~100~BX~6.25
HL~54~5~T
MAN~GM~00100875471016086365
PAL~6~~~20
HL~55~54~I
LIN~009~IN~UNV35267~UP~087547352670
SN1~~100~BX~~180~BX~~AC
SLN~009~~I~100~BX~7.72
HL~56~5~T
MAN~GM~00100875471016086600
PAL~6~~~11
HL~57~56~I
LIN~009~IN~UNV35267~UP~087547352670
SN1~~25~BX~~180~BX~~AC
SLN~009~~I~25~BX~7.72
HL~58~56~I
LIN~024~IN~UNV36319~UP~087547363195
SN1~~6~BX~~6~BX~~AC
SLN~024~~I~6~BX~3.61
HL~59~5~T
MAN~GM~00100875471016086761
PAL~6~~~24
HL~60~59~I
LIN~003~IN~UNV35210~UP~087547352106
SN1~~120~BX~~175~BX~~AC
SLN~003~~I~120~BX~7.93
HL~61~5~T
MAN~GM~00100875471016086785
PAL~6~~~17
HL~62~61~I
LIN~004~IN~UNV35260~UP~087547352601
SN1~~170~BX~~170~BX~~AC
SLN~004~~I~170~BX~6.17
HL~63~1~O
PRF~0107809
REF~AI~101565800001
HL~64~63~T
MAN~GM~00100421671016085945
PAL~6~~~11
HL~65~64~I
LIN~001~IN~OFF82292~UP~042167822927
SN1~~5~BX~~5~BX~~AC
SLN~001~~I~5~BX~11.92
HL~66~64~I
LIN~002~IN~OFF82301~UP~042167823016
SN1~~10~BX~~10~BX~~AC
SLN~002~~I~10~BX~7.42
HL~67~64~I
LIN~003~IN~OFF82302~UP~042167823023
SN1~~30~BX~~30~BX~~AC
SLN~003~~I~30~BX~8.44
HL~68~64~I
LIN~004~IN~OFF82303~UP~042167823030
SN1~~10~BX~~10~BX~~AC
SLN~004~~I~10~BX~10.25
HL~69~64~I
LIN~005~IN~OFF82304~UP~042167823047
SN1~~5~BX~~5~BX~~AC
SLN~005~~I~5~BX~14.82
HL~70~1~O
PRF~0108319
REF~AI~216853600001
HL~71~70~T
MAN~GM~00100421671016086577
PAL~6~~~27
HL~72~71~I
LIN~001~IN~UNV10201~UP~087547102015
SN1~~20~BX~~20~BX~~AC
SLN~001~~I~20~BX~13.46
HL~73~71~I
LIN~002~IN~UNV10202~UP~087547102022
SN1~~20~BX~~20~BX~~AC
SLN~002~~I~20~BX~13.46
HL~74~71~I
LIN~004~IN~UNV10251~UP~087547102510
SN1~~10~BX~~10~BX~~AC
SLN~004~~I~10~BX~13.46
HL~75~71~I
LIN~010~IN~UNV10503~UP~087547105030
SN1~~70~BX~~70~BX~~AC
SLN~010~~I~70~BX~9.3
HL~76~71~I
LIN~030~IN~UNV13930~UP~087547139301
SN1~~10~EA~~10~EA~~AC
SLN~030~~I~10~EA~5.67
HL~77~71~I
LIN~048~IN~UNV57119~UP~087547571194
SN1~~5~BX~~5~BX~~AC
SLN~048~~I~5~BX~10.18
HL~78~70~T
MAN~GM~00100875471016086426
PAL~6~~~22
HL~79~78~I
LIN~029~IN~UNV13910~UP~087547139103
SN1~~35~EA~~35~EA~~AC
SLN~029~~I~35~EA~5.61
HL~80~78~I
LIN~034~IN~UNV14215~UP~087547142158
SN1~~150~BX~~630~BX~~AC
SLN~034~~I~150~BX~6.68
HL~81~70~T
MAN~GM~00100875471016086457
PAL~6~~~48
HL~82~81~I
LIN~009~IN~UNV10502~UP~087547105023
SN1~~15~BX~~15~BX~~AC
SLN~009~~I~15~BX~9.3
HL~83~81~I
LIN~011~IN~UNV10504~UP~087547105047
SN1~~60~BX~~60~BX~~AC
SLN~011~~I~60~BX~9.3
HL~84~81~I
LIN~012~IN~UNV10505~UP~087547105054
SN1~~15~BX~~15~BX~~AC
SLN~012~~I~15~BX~9.3
HL~85~81~I
LIN~013~IN~UNV10506~UP~087547105061
SN1~~35~BX~~35~BX~~AC
SLN~013~~I~35~BX~9.3
HL~86~81~I
LIN~014~IN~UNV10507~UP~087547105078
SN1~~5~BX~~5~BX~~AC
SLN~014~~I~5~BX~9.3
HL~87~81~I
LIN~017~IN~UNV12122~UP~087547121221
SN1~~35~BX~~35~BX~~AC
SLN~017~~I~35~BX~6.73
HL~88~81~I
LIN~018~IN~UNV12301~UP~087547123010
SN1~~15~BX~~15~BX~~AC
SLN~018~~I~15~BX~8.59
HL~89~81~I
LIN~021~IN~UNV12305~UP~087547123058
SN1~~5~BX~~5~BX~~AC
SLN~021~~I~5~BX~8.59
HL~90~81~I
LIN~023~IN~UNV13410~UP~087547134108
SN1~~25~BX~~25~BX~~AC
SLN~023~~I~25~BX~8.01
HL~91~81~I
LIN~026~IN~UNV13522~UP~087547135228
SN1~~10~BX~~10~BX~~AC
SLN~026~~I~10~BX~13.41
HL~92~81~I
LIN~042~IN~UNV16166~UP~087547161661
SN1~~20~BX~~20~BX~~AC
SLN~042~~I~20~BX~10.01
HL~93~70~T
MAN~GM~00100875471016086617
PAL~6~~~35
HL~94~93~I
LIN~003~IN~UNV10212~UP~087547102121
SN1~~15~BX~~15~BX~~AC
SLN~003~~I~15~BX~14.89
HL~95~93~I
LIN~005~IN~UNV10272~UP~087547102725
SN1~~5~BX~~5~BX~~AC
SLN~005~~I~5~BX~14.48
HL~96~93~I
LIN~006~IN~UNV10303~UP~087547103036
SN1~~20~BX~~20~BX~~AC
SLN~006~~I~20~BX~14.99
HL~97~93~I
LIN~007~IN~UNV10318~UP~087547103180
SN1~~30~BX~~30~BX~~AC
SLN~007~~I~30~BX~17.14
HL~98~93~I
LIN~022~IN~UNV13110~UP~087547131107
SN1~~10~BX~~10~BX~~AC
SLN~022~~I~10~BX~8.31
HL~99~93~I
LIN~025~IN~UNV13510~UP~087547135105
SN1~~10~BX~~10~BX~~AC
SLN~025~~I~10~BX~9.18
HL~100~93~I
LIN~027~IN~UNV13526~UP~087547135266
SN1~~10~BX~~10~BX~~AC
SLN~027~~I~10~BX~14.94
HL~101~93~I
LIN~031~IN~UNV14116~UP~087547141168
SN1~~20~BX~~20~BX~~AC
SLN~031~~I~20~BX~6.22
HL~102~93~I
LIN~032~IN~UNV14118~UP~087547141182
SN1~~10~BX~~10~BX~~AC
SLN~032~~I~10~BX~6.22
HL~103~93~I
LIN~033~IN~UNV14142~UP~087547141427
SN1~~16~BX~~16~BX~~AC
SLN~033~~I~16~BX~9.33
HL~104~93~I
LIN~037~IN~UNV16122~UP~087547161227
SN1~~5~BX~~5~BX~~AC
SLN~037~~I~5~BX~11.71
HL~105~93~I
LIN~038~IN~UNV16140~UP~087547161401
SN1~~10~BX~~10~BX~~AC
SLN~038~~I~10~BX~12.91
HL~106~93~I
LIN~043~IN~UNV16466~UP~087547164662
SN1~~10~BX~~10~BX~~AC
SLN~043~~I~10~BX~5.68
HL~107~93~I
LIN~044~IN~UNV24113~UP~087547241134
SN1~~20~BX~~20~BX~~AC
SLN~044~~I~20~BX~6.53
HL~108~93~I
LIN~045~IN~UNV24213~UP~087547242131
SN1~~5~BX~~5~BX~~AC
SLN~045~~I~5~BX~8.16
HL~109~70~T
MAN~GM~00100875471016086815
PAL~6~~~44
HL~110~109~I
LIN~015~IN~UNV12110~UP~087547121108
SN1~~50~BX~~50~BX~~AC
SLN~015~~I~50~BX~6.22
HL~111~109~I
LIN~019~IN~UNV12302~UP~087547123027
SN1~~10~BX~~10~BX~~AC
SLN~019~~I~10~BX~8.59
HL~112~109~I
LIN~020~IN~UNV12303~UP~087547123034
SN1~~30~BX~~30~BX~~AC
SLN~020~~I~30~BX~8.59
HL~113~109~I
LIN~024~IN~UNV13420~UP~087547134207
SN1~~40~BX~~55~BX~~AC
SLN~024~~I~40~BX~11.48
HL~114~109~I
LIN~035~IN~UNV15121~UP~087547151211
SN1~~15~BX~~15~BX~~AC
SLN~035~~I~15~BX~8.12
HL~115~109~I
LIN~039~IN~UNV16150~UP~087547161500
SN1~~15~BX~~15~BX~~AC
SLN~039~~I~15~BX~14.48
HL~116~109~I
LIN~047~IN~UNV57115~UP~087547571156
SN1~~10~BX~~10~BX~~AC
SLN~047~~I~10~BX~7.18
HL~117~109~I
LIN~049~IN~UNV57122~UP~087547571224
SN1~~10~BX~~10~BX~~AC
SLN~049~~I~10~BX~10.18
HL~118~109~I
LIN~050~IN~UNV57123~UP~087547571231
SN1~~40~BX~~40~BX~~AC
SLN~050~~I~40~BX~10.18
HL~119~70~T
MAN~GM~00100875471016086822
PAL~6~~~7
HL~120~119~I
LIN~008~IN~UNV10325~UP~087547103258
SN1~~5~BX~~5~BX~~AC
SLN~008~~I~5~BX~24.28
HL~121~119~I
LIN~040~IN~UNV16162~UP~087547161623
SN1~~15~BX~~15~BX~~AC
SLN~040~~I~15~BX~12.8
HL~122~119~I
LIN~041~IN~UNV16164~UP~087547161647
SN1~~15~BX~~15~BX~~AC
SLN~041~~I~15~BX~12.8
HL~123~70~T
MAN~GM~00100875471016087904
PAL~6~~~20
HL~124~123~I
LIN~036~IN~UNV15363~UP~087547153635
SN1~~100~BX~~200~BX~~AC
SLN~036~~I~100~BX~8.52
HL~125~70~T
MAN~GM~00100875471016087942
PAL~6~~~20
HL~126~125~I
LIN~036~IN~UNV15363~UP~087547153635
SN1~~100~BX~~200~BX~~AC
SLN~036~~I~100~BX~8.52
HL~127~70~T
MAN~GM~00100875471016088017
PAL~6~~~48
HL~128~127~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~129~70~T
MAN~GM~00100875471016088031
PAL~6~~~48
HL~130~129~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~131~70~T
MAN~GM~00100875471016088123
PAL~6~~~48
HL~132~131~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~133~70~T
MAN~GM~00100875471016088154
PAL~6~~~48
HL~134~133~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~135~70~T
MAN~GM~00100875471016088260
PAL~6~~~48
HL~136~135~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~137~70~T
MAN~GM~00100875471016088284
PAL~6~~~48
HL~138~137~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~139~70~T
MAN~GM~00100875471016088314
PAL~6~~~48
HL~140~139~I
LIN~016~IN~UNV12113~UP~087547121139
SN1~~240~BX~~1680~BX~~AC
SLN~016~~I~240~BX~5.13
HL~141~1~O
PRF~0108320
REF~AI~019166900001
HL~142~141~T
MAN~GM~00100421671016086577
PAL~6~~~6
HL~143~142~I
LIN~001~IN~OFF82007~UP~042167820077
SN1~~5~BX~~5~BX~~AC
SLN~001~~I~5~BX~20.8
HL~144~142~I
LIN~002~IN~OFF82020~UP~042167820206
SN1~~40~BX~~40~BX~~AC
SLN~002~~I~40~BX~5.15
HL~145~142~I
LIN~003~IN~OFF85343~UP~042167853433
SN1~~4~BX~~4~BX~~AC
SLN~003~~I~4~BX~16.9
CTT~145
SE~556~214260004
GE~6~900021426
IEA~1~000000700
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 41855648
Larry,

<<  The GE segment references 6.  Is this what is throwing the data off?  >>

 Yes, you spotted it!.   Your GE indicates six documents in the group, but there is only one ST/SE pair.

This:
GE~6~900021426

Should be:
GE~1~900021426

Jim.
1

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Read about how to choose the best possible content marketing agency to suit your needs. Content marketing has become an integral part of running a successful tech business, so it is wise to be informed.
Every business owner understands the significance of online customer reviews and the impact it can have on sales and revenues. With technology advancing at such a rapid pace, getting online reviews has never been easier, especially when many regions…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now