[Koha-bugs] [Bug 25759] Invoices hyperlink is broken on edifactmsgs.pl

Thu Oct 22 14:35:44 CEST 2020

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759

--- Comment #5 from Kyle M Hall <kyle at bywatersolutions.com> ---
Here is an updated query:

INSERT INTO `edifact_messages` ( id, message_type, transfer_date, vendor_id,
edi_acct, status, basketno, raw_msg, filename, deleted ) VALUES
(9999,'INVOICE','2020-06-09',NULL,NULL,'new',NULL, 'UNA:+.?
\'UNB+UNOA:2+1556150:31B+3504069:31B+200609:0311+428\'UNG+INVOIC+1556150:31B+3504069:31B+20200609:0311+428+UN+D:96A\'UNH+1210+INVOIC:0:96:UN\'BGM+380+2035199664+9\'DTM+137:20200608:102\'NAD+DP+3504069
0059::31B\'NAD+BY+3504069
0059::91\'NAD+SU+1692100::31B\'LIN+4++9780062912756:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158155\'RFF+ON:10734
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+33++9780310357179:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:164038\'RFF+ON:11100
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+25++9781984804938:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:163698\'RFF+ON:11073
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+13++9780316477536:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:162817\'RFF+ON:11032
AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+44++9780062988904:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:163717\'RFF+ON:11073
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+18++9781250216991:EN\'QTY+47:1\'MOA+203:9.19\'PRI+AAB:8.99::SRP\'PRI+AAA:5.39::DPR\'RFF+LI:163691\'RFF+ON:11073
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+23++9780062937728:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:164156\'RFF+ON:11105
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+15++9781538715642:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:158933\'RFF+ON:10782
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780316494861:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:157316\'RFF+ON:10670
LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9780316494861:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:159550\'RFF+ON:10821
LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780525539520:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:154348\'RFF+ON:AF20
10442\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+32++9780062953926:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158183\'RFF+ON:10734
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+27++9781982136116:EN\'QTY+47:1\'MOA+203:13.4\'PRI+AAB:16::SRP\'PRI+AAA:9.6::DPR\'RFF+LI:160430\'RFF+ON:10886
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+57++9780062993861:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:162861\'RFF+ON:11032
AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:15\'CNT+2:14\'MOA+86:258.12\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:57\'ALC+C++++TX\'MOA+124:0\'UNT+171+1210\'UNH+1211+INVOIC:0:96:UN\'BGM+380+2035200766+9\'DTM+137:20200608:102\'NAD+DP+3504069
0059::31B\'NAD+BY+3504069
0059::91\'NAD+SU+1692100::31B\'LIN+2++9781496720139:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:152771\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781496720139:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:154677\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+21++9780385544962:EN\'QTY+47:1\'MOA+203:20.6\'PRI+AAB:29.95::SRP\'PRI+AAA:16.8::DPR\'RFF+LI:159724\'RFF+ON:10835
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9781524745202:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:152331\'RFF+ON:AF20
10307\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+24++9781250168962:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:163697\'RFF+ON:11073
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780062951663:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162164\'RFF+ON:10984
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+17++9781250210883:EN\'QTY+47:2\'MOA+203:37.88\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158168\'RFF+ON:10734
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+16++9780735291027:EN\'QTY+47:1\'MOA+203:13.39\'PRI+AAB:15.99::SRP\'PRI+AAA:9.59::DPR\'RFF+LI:163689\'RFF+ON:11073
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+5++9781984805997:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:163524\'RFF+ON:11069
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+16++9781250261878:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:159061\'RFF+ON:10786
ANF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+19++9781420149975:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:163692\'RFF+ON:11073
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9780525542353:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:160067\'RFF+ON:10863
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9780316422130:EN\'QTY+47:1\'MOA+203:18.39\'PRI+AAB:26::SRP\'PRI+AAA:14.59::DPR\'RFF+LI:158921\'RFF+ON:10782
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+4++9781982137977:EN\'QTY+47:3\'MOA+203:61.89\'PRI+AAB:30::SRP\'PRI+AAA:16.83::DPR\'RFF+LI:156872\'RFF+ON:10631
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+31++9781982137977:EN\'QTY+47:2\'MOA+203:41.26\'PRI+AAB:30::SRP\'PRI+AAA:16.83::DPR\'RFF+LI:161022\'RFF+ON:10920
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+10++9781501188589:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158161\'RFF+ON:10734
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+22++9781250154224:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:158173\'RFF+ON:10734
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9781250154224:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162750\'RFF+ON:11026
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:157317\'RFF+ON:10670
LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:159183\'RFF+ON:10795
LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9780593171653:EN\'QTY+47:1\'MOA+203:22.4\'PRI+AAB:31::SRP\'PRI+AAA:18.6::DPR\'RFF+LI:162324\'RFF+ON:10988
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+33++9780440000839:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158184\'RFF+ON:10734
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+39++9781250252203:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:163712\'RFF+ON:11073
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+34++9781538717820:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:163707\'RFF+ON:11073
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+4++9781250107497:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:160906\'RFF+ON:10913
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+3++9781250107497:EN\'QTY+47:1\'MOA+203:19.5\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:163118\'RFF+ON:11049
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781984802705:EN\'QTY+47:1\'MOA+203:13.4\'PRI+AAB:16::SRP\'PRI+AAA:9.6::DPR\'RFF+LI:157214\'RFF+ON:10657
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+5++9780593171592:EN\'QTY+47:1\'MOA+203:21.2\'PRI+AAB:29::SRP\'PRI+AAA:17.4::DPR\'RFF+LI:159768\'RFF+ON:10837
LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+25++9781643852997:EN\'QTY+47:1\'MOA+203:18.94\'PRI+AAB:26.99::SRP\'PRI+AAA:15.14::DPR\'RFF+LI:162829\'RFF+ON:11032
AF20/AF\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+29++9781524760380:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:158180\'RFF+ON:10734
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+39++9780062966742:EN\'QTY+47:2\'MOA+203:39\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158190\'RFF+ON:10734
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+54++9780778310099:EN\'QTY+47:2\'MOA+203:39\'PRI+AAB:27.99::SRP\'PRI+AAA:15.7::DPR\'RFF+LI:158205\'RFF+ON:10734
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+23++9780735223103:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:158174\'RFF+ON:10734
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+6++9781538761465:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:153700\'RFF+ON:AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+1++9781538761465:EN\'QTY+47:2\'MOA+203:40.14\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:157636\'RFF+ON:10697
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+14++9781538761465:EN\'QTY+47:3\'MOA+203:60.21\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:160990\'RFF+ON:10919
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+30++9781538761465:EN\'QTY+47:3\'MOA+203:60.21\'PRI+AAB:29::SRP\'PRI+AAA:16.27::DPR\'RFF+LI:162637\'RFF+ON:11019
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:11.4\'LIN+20++9781250302045:EN\'QTY+47:1\'MOA+203:18.38\'PRI+AAB:25.99::SRP\'PRI+AAA:14.58::DPR\'RFF+LI:163693\'RFF+ON:11073
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+8++9780062956163:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:162385\'RFF+ON:10994
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+2++9780062956163:EN\'QTY+47:1\'MOA+203:8.59\'PRI+AAB:7.99::SRP\'PRI+AAA:4.79::DPR\'RFF+LI:164412\'RFF+ON:11123
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:52\'CNT+2:40\'MOA+86:973.07\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:197.6\'ALC+C++++TX\'MOA+124:0\'UNT+457+1211\'UNH+1212+INVOIC:0:96:UN\'BGM+380+2035201654+9\'DTM+137:20200608:102\'NAD+DP+3504069
0059::31B\'NAD+BY+3504069
0059::91\'NAD+SU+1692100::31B\'LIN+15++9781644450178:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:159060\'RFF+ON:10786
ANF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:161001\'RFF+ON:10920
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+12++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:161761\'RFF+ON:10953
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+12++9780525429760:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:164422\'RFF+ON:11123
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+8++9781472267474:EN\'QTY+47:1\'MOA+203:17.82\'PRI+AAB:24.99::SRP\'PRI+AAA:14.02::DPR\'RFF+LI:161591\'RFF+ON:10943
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+41++9780593129463:EN\'QTY+47:1\'MOA+203:18.95\'PRI+AAB:27::SRP\'PRI+AAA:15.15::DPR\'RFF+LI:164046\'RFF+ON:11100
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+43++9780525479123:EN\'QTY+47:1\'MOA+203:19.51\'PRI+AAB:28::SRP\'PRI+AAA:15.71::DPR\'RFF+LI:163716\'RFF+ON:11073
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+34++9780785233527:EN\'QTY+47:1\'MOA+203:13.99\'PRI+AAB:16.99::SRP\'PRI+AAA:10.19::DPR\'RFF+LI:164039\'RFF+ON:11100
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+1++9781538752111:EN\'QTY+47:2\'MOA+203:42.38\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:154404\'RFF+ON:LP
10446\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:7.6\'LIN+2++9781538752111:EN\'QTY+47:1\'MOA+203:21.19\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:160894\'RFF+ON:10911
LP\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'LIN+10++9781538752111:EN\'QTY+47:1\'MOA+203:21.19\'PRI+AAB:31::SRP\'PRI+AAA:17.39::DPR\'RFF+LI:162714\'RFF+ON:11024
AF20\'ALC+C++++FC\'MOA+8:0\'ALC+C++++CA\'MOA+8:3.8\'UNS+S\'CNT+1:12\'CNT+2:11\'MOA+86:233.07\'ALC+C++++DL\'MOA+8:0\'ALC+C++++CA\'MOA+131:45.6\'ALC+C++++TX\'MOA+124:0\'UNT+138+1212\'UNE+3+428\'UNZ+1+428\'','OUT149066162243.INT',0);

-- 
You are receiving this mail because:
You are watching all bug changes.