[Bug 25759] New: Invoices hyperlink is broken on edifactmsgs.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Bug ID: 25759 Summary: Invoices hyperlink is broken on edifactmsgs.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: kyle@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org The "Invoices" hyperlink on edifactmsgs.pl has always been broken. We can parse out the invoice number from the message and have the link search for that invoice number in Koha. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |kyle@bywatersolutions.com |ity.org | -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #1 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 105888 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=105888&action=edit Bug 25759: Invoices hyperlink is broken on edifactmsgs.pl The "Invoices" hyperlink on edifactmsgs.pl has always been broken. We can parse out the invoice number from the message and have the link search for that invoice number in Koha. Test Plan: 1) Locate an imported invoice from edifactmsgs.pl 2) Click the "Invoices" link for that invoice 3) Note no invoice is found 4) Apply this patch 5) Restart all the things! 6) Reload the page 7) Note the link now reads "Invoice: $invoice_number" 8) Click the new link 9) Note it is now found by Koha! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Kyle, is there a way to add 'fake' EDI data for testing this? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #3 from Kyle M Hall <kyle@bywatersolutions.com> --- Create an invoice with a invoice number of 2035199664, then run this query to insert an EDI invoice message with the same invoice number: INSERT INTO `edifact_messages` VALUES (9999,'INVOICE','2020-06-09',NULL,NULL,'new',NULL,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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Amit Gupta <amitddng135@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |amit.gupta@informaticsgloba | |l.com, | |amitddng135@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Kyle, the query gives me an error and I am not sure how to best fix it as I don't know EDI - can you help again? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #5 from Kyle M Hall <kyle@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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #6 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 112188 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=112188&action=edit Sample database with invoice and edi message already added. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Small patch Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #105888|0 |1 is obsolete| | --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 112451 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=112451&action=edit Bug 25759: Invoices hyperlink is broken on edifactmsgs.pl The "Invoices" hyperlink on edifactmsgs.pl has always been broken. We can parse out the invoice number from the message and have the link search for that invoice number in Koha. Test Plan: 1) Locate an imported invoice from edifactmsgs.pl 2) Click the "Invoices" link for that invoice 3) Note no invoice is found 4) Apply this patch 5) Restart all the things! 6) Reload the page 7) Note the link now reads "Invoice: $invoice_number" 8) Click the new link 9) Note it is now found by Koha! Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |martin.renvoize@ptfs-europe | |.com --- Comment #8 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Er.. just wondering.. shouldn't this be at the Koha::Object level rather than within the DBIC Class? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #9 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Hmm.. also since bug 20782 this does work correctly for us.. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |In Discussion --- Comment #10 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Also, having now conferred with Colin, we believe a message is allowed to contain multiple invoices, so the extraction of invoice_id here may be too simplistic. We do store message_id in the invoices table to allow the link from invoice to message to be recorded.. which is what we're using for the GetInvoices search in current code. Perhaps a ByWater EDI plugin skips setting of message_id somewhere? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- QA Contact|testopia@bugs.koha-communit |martin.renvoize@ptfs-europe |y.org |.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #11 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Confirmed.. see the loop for 'messages' inside process_invoice within Koha::EDI. It loops through messages in the invoice file and extracts a docmsg_number for each one. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #12 from Kyle M Hall <kyle@bywatersolutions.com> --- (In reply to Martin Renvoize from comment #8)
Er.. just wondering.. shouldn't this be at the Koha::Object level rather than within the DBIC Class?
That was a development decision made by Colin iirc. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=20782 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #13 from Kyle M Hall <kyle@bywatersolutions.com> --- (In reply to Martin Renvoize from comment #11)
Confirmed.. see the loop for 'messages' inside process_invoice within Koha::EDI.
It loops through messages in the invoice file and extracts a docmsg_number for each one.
I think we can make it work with multiple messages! Let me see what I can do. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|In Discussion |RESOLVED Resolution|--- |INVALID --- Comment #14 from Kyle M Hall <kyle@bywatersolutions.com> --- (In reply to Martin Renvoize from comment #11)
Confirmed.. see the loop for 'messages' inside process_invoice within Koha::EDI.
It loops through messages in the invoice file and extracts a docmsg_number for each one.
Ok, I feel like a nut ;) The invoice links are definitely working in master now! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #15 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Must have messed up testing the before here as well :( -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25759 --- Comment #16 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- :), thanks guys, really glad it's working as expected. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org