]> git.koha-community.org Git - koha.git/commit
Bug 7736: Support Ordering via Edifact EDI messages
authorColin Campbell <colin.campbell@ptfs-europe.com>
Wed, 20 Jan 2016 11:31:31 +0000 (11:31 +0000)
committerBrendan A Gallagher <brendan@bywatersolutions.com>
Fri, 1 Apr 2016 20:03:17 +0000 (20:03 +0000)
commite2e991634854d940405593cb1e05945de2295d4c
treea1c75a894547c0454c6c642fd0707e049f1c0702
parent9658085d1eafae6fe7f51fb1b39452fbb6f9bf4d
 Bug 7736: Support Ordering via Edifact EDI messages

Add support for processing incoming Edifact Quotes, Invoices
and order responses and generating and transmission of
Edifact Orders.
Basic workflow is that an incoming quote generates an aquisition
basket in Koha, with each line corresponding to an order record

The user can then generate an edifact order from this (or another)
basket, which is transferred to the vendor's site

The supplier generates an invoice on despatch and this will
result in corresponding invoices being generated in Koha
The orderlines on the invoice are receipted automatically.

We also support order response messages. This may include
simple order acknowledgements, supplier reports/amendments
on availability. Cancellation messages cause the koha order
to be cancelled, other messages are recorded against the order

Which messages are to be supported/processed is specifiable on a
vendor by vendor basis via the admin screens

You can also specify auto order i.e. to generate orders from quotes
without user intervention - This reflects existing
workflows where most work is done on the suppliers website
then generating a dummy quote

Received messages are stored in the edifact_messages table
and the original can be viewed via the online

Database changes are in installer/data/mysql/atomicchanges/edifact.sql
Note new perl dependencies:
    Net::SFTP:Foreign
    Text::Unidecode

Signed-off-by: Paul Johnson <p.johnson@staffs.ac.uk>
Signed-off-by: Sally Healey <sally.healey@cheshiresharedservices.gov.uk>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Brendan A Gallagher <brendan@bywatersolutions.com>
55 files changed:
C4/Acquisition.pm
C4/Installer/PerlDependencies.pm
Koha/EDI.pm [new file with mode: 0644]
Koha/Edifact.pm [new file with mode: 0644]
Koha/Edifact/Line.pm [new file with mode: 0644]
Koha/Edifact/Message.pm [new file with mode: 0644]
Koha/Edifact/Order.pm [new file with mode: 0644]
Koha/Edifact/Segment.pm [new file with mode: 0644]
Koha/Edifact/Transport.pm [new file with mode: 0644]
Koha/Schema/Result/Aqbasket.pm
Koha/Schema/Result/Aqbookseller.pm
Koha/Schema/Result/Aqbudget.pm
Koha/Schema/Result/Aqinvoice.pm
Koha/Schema/Result/Aqorder.pm
Koha/Schema/Result/Branch.pm
Koha/Schema/Result/EdifactEan.pm [new file with mode: 0644]
Koha/Schema/Result/EdifactMessage.pm [new file with mode: 0644]
Koha/Schema/Result/MsgInvoice.pm [new file with mode: 0644]
Koha/Schema/Result/VendorEdiAccount.pm [new file with mode: 0644]
acqui/basket.pl
acqui/basketgroup.pl
acqui/edi_ean.pl [new file with mode: 0755]
acqui/edifactmsgs.pl [new file with mode: 0755]
acqui/edimsg.pl [new file with mode: 0755]
acqui/invoices.pl
admin/edi_accounts.pl [new file with mode: 0755]
admin/edi_ean_accounts.pl [new file with mode: 0755]
installer/data/mysql/atomicupdate/edifact.sql [new file with mode: 0644]
installer/data/mysql/kohastructure.sql
installer/data/mysql/sysprefs.sql
installer/data/mysql/userpermissions.sql
koha-tmpl/intranet-tmpl/prog/en/includes/acquisitions-menu.inc
koha-tmpl/intranet-tmpl/prog/en/includes/admin-menu.inc
koha-tmpl/intranet-tmpl/prog/en/modules/acqui/basket.tt
koha-tmpl/intranet-tmpl/prog/en/modules/acqui/basketgroup.tt
koha-tmpl/intranet-tmpl/prog/en/modules/acqui/edi_ean.tt [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/acqui/edifactmsgs.tt [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/acqui/edimsg.tt [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/admin/admin-home.tt
koha-tmpl/intranet-tmpl/prog/en/modules/admin/edi_accounts.tt [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/admin/edi_ean_accounts.tt [new file with mode: 0644]
koha-tmpl/intranet-tmpl/prog/en/modules/tools/tools-home.tt
misc/cronjobs/edi_cron.pl [new file with mode: 0755]
misc/cronjobs/remove_temporary_edifiles.pl [new file with mode: 0755]
t/EdiInvoice.t [new file with mode: 0755]
t/Edifact.t [new file with mode: 0755]
t/Ediorder.t [new file with mode: 0755]
t/Ediordrsp.t [new file with mode: 0755]
t/edi_testfiles/BLSINV337023.CEI [new file with mode: 0644]
t/edi_testfiles/QUOTES_413514.CEQ [new file with mode: 0644]
t/edi_testfiles/ordrsp1.CEA [new file with mode: 0644]
t/edi_testfiles/ordrsp2.CEA [new file with mode: 0644]
t/edi_testfiles/ordrsp3.CEA [new file with mode: 0644]
t/edi_testfiles/ordrsp4.CEA [new file with mode: 0644]
t/edi_testfiles/prquotes_73050_20140430.CEQ [new file with mode: 0644]