Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Electronic Data Interchange (EDI)

    Translatable
    To configure EDI communication with vendors, you must have the following role:
    • Vendor Manager
    Electronic Data Interchange (EDI) is an automated method of communication between an institution and its vendors.
    EDI requires files to be placed in a certain directory. Files to be sent to an EDI-enabled vendor are automatically exported by Alma to an FTP location where they are fetched by a vendor system. Files placed at the FTP location by an EDI-enabled vendor are automatically loaded and parsed by Alma.
    The following acquisition activities are supported for EDI-enabled vendors:
    • Sent from Alma to the vendor:
      • Purchase orders (POs)
      • Claims – Claims sent to the vendor regarding missing items. For vendors that support this feature, claims are sent using EDI instead of by email. EDI claims can be used for both one-time and continuous orders.
        Unlike POs, each EDI claim message contains a claim for a single PO line.
      • Order cancellations – For vendors that support this feature, cancellations are sent using EDI instead of by email.
        Unlike POs, each EDI cancellation message contains a cancellation for a single PO line.
    • Sent from the vendor to Alma:
      • Invoices
      • Order Responses: Shelf-Ready – These responses contain barcodes and other item information for delivered items. After receiving the Order Response, Alma updates the relevant PO lines.
        For more details about shelf-ready processing and Order Response EDI files, refer to the Shelf-Ready Processing using EDI video (1:49 mins).
      • Order Responses: Order Report – These responses contain status information about orders: whether they were sent, backordered, or canceled, any fulfillment issues, if the delivery date changed, and so forth. Typically, Order Reports are sent daily from the vendor. The vendor and institution can arrange for some other frequency, such as weekly, or only if there are problems with the order.
        When an Order Report is received, the summary in the report is added as a note to the relevant PO lines. The status of items in the report may indicate that a PO line requires additional attention from the user.
      • Order Responses: Claim Responses – These responses are sent in response to claims sent from Alma. They appear in the Order Response Journal Claim section of the job report and the Notes tab of the relevant PO line.
    The Manage EDI Tasks page contains a task list with order responses that require attention. See Managing EDI Order Responses.
    The EDI files that are created for EDI communication are based on the international standards for EDI transmission and should be agreed upon with each vendor prior to entering information in Alma. For a description of the EDI standards with which Alma operates, refer to https://developers.exlibrisgroup.com/alma/integrations/edi.
    For the purposes of EDI communication, the PO and PO line numbers are case-sensitive.
    EDI communication has successfully been tested with the following vendors: Baker & Taylor, Coutts (ingramcontent), Dawson, Harrassowitz, Swets, YBP, and Ebsco. EDI communication should work with any vendor that uses the EDI message types used by Alma, but it has not been tested.

    Configuring EDI for a Vendor

    When configuring EDI communication with a vendor, in addition to the vendor EDI code and EDI type, you must enter an EDI code and EDI type that the vendor uses for your institution. Optionally, you can also define an EDI code and type for each library served by the institution. When an EOD is received after an EDI has been loaded, you can reload the EDI.
    To configure EDI communication with a vendor:
    1. On the Search Vendors page (Acquisitions > Acquisitions Infrastructure > Vendors) select a vendor. The Vendor Details page appears.
    2. Click the EDI Information tab.
      Vendor Details Page – EDI Information Tab
    3. Enter the EDI information as required. A description of the fields is provided in the following table.
      EDI Information Tab Fields
      Section Field Description
      Vendor EDI Attributes EDI code A unique code for the vendor, per institution.
      When an EDI code is entered, the mandatory fields in this tab are indicated with a red asterisk and must be completed before saving this page.
      EDI type The list is predefined by Ex Libris. You can choose from:
      • 014 – EAN-13
      • 091 – ID assigned by supplier
      • 092 – ID assigned by customer
      • 31B – US-SAN
      EDI naming convention The list is predefined by Ex Libris. You can choose Alma’s standard file naming convention (Standard, which is the default), or one of the following vendor naming conventions: Blackwell, Ebsco, Ingram, Harrassowitz, Brodart.
      EDI vendor format Select:
      • Harrassowitz – Removes line feeds so that all information is provided on a single line. Can also be selected for Harrassowitz-like vendors.
      • Baker & Taylor enriched – Includes enriched data that is customized for Baker & Taylor. The GIR segment includes library and location information in two separate fields, even though the PO line may not include this data.
      If you are not working with one of these vendors, select Other.
      The other options appearing in this list are for future use.
      Incoming Incoming Whether the vendor submits EDI files, such as invoices or order responses. Both invoice and Order Response files are processed by Alma after being placed in the directory specified in the Input directory field. Both types of files are fetched by the same Alma service.
      Shelf Ready Parameters If the vendor submits Order Responses, you may configure additional parameters to control the handling of the Order Responses. When this check box is selected, the fields Receive Items, Keep in Department, and Next Step appear. If there are changes in the item information, such as the barcode or policy, these are changed in Alma.
      Receive Items Sets the items specified by an Order Response as received. This updates the item's arrival date to the current date.
      Keep in Department If you selected Receive Item, select to indicate that further work is required before the material can be made available in a library. The step specified in Next Step is then applied to the item. For more information, see Receiving Physical Material.
      Next Step The step to apply to items that you keep in the department (see above). For the available options, see Receiving Physical Material.
      Outgoing
      Note that the relevant EDI letter must be enabled (see Enabling/Disabling Letters) and can be configured (see Configuring Alma Letters)
      POs Whether to enable EDI POs for the vendor.
      Additional order number Whether the additional PO number (a unique vendor order number entered in the PO line) is included in the EDI file sent to the vendor.
      Include fund code Whether the fund code is included in the EDI files sent to the vendor and received from the vendor.
      Claims Whether to enable EDI claims for the vendor. When set, Alma does not send claims by email.
      Order Cancellation Whether to enable EDI cancellations for the vendor. When set, Alma does not send cancellations by email.
      Invoice Job Parameters – Job Scheduling Status Whether the EDI communication is active or non-active. By default, Active is selected.
      Schedule The time at which the EDI job runs.
      This is relevant only for invoices and not for POs.
      To run the EDI job immediately (as soon as the Alma system can accommodate it), click Run Now to the right of the Schedule box.
      Run Now Click to run the EDI job immediately.
      Email Notification Configure who receives notification after the EDI jobs. Opens the Email Notifications for Scheduled Jobs page. For more information, see Configuring Email Notifications for Scheduled Jobs.
      Invoice Job Parameters – Job Parameters Upload EDI The EDI file to upload. To upload the file, click Add and Execute.
      VAT expended from fund Whether to have VAT specified at the invoice level in EDI invoices expended from funds. The field Expended from Fund on the Invoice Details page remains selected. The field is selected by default.
      Clear to leave Expended from Fund on the Invoice Details page unselected. A proportional amount of VAT is added in the Adjustment line for each invoice item.
      Do not prorate Whether, when an invoice is loaded from an EDI file, overhead and discount amounts are charged to their own invoice lines instead of being prorated among all invoice lines.
      Fund The fund from which overhead and discount amounts are charged. This field appears only when Do not prorate is selected.
      S/FTP Connection
      (Note: these settings should match the settings in the FTP server.)
      Description An optional description of the EDI submission details.
      Max. number of files Not in use. Accept the default value.
      Max. file size Not in use. Accept the default value.
      Server The IP address of the FTP server receiving the EDI files.
      User name The user name for the FTP server.
      Port The port to use on the FTP server, if the connection is not secure. This is generally port 21.
      Password The password for the FTP server.
      Input directory The name of the subdirectory in which the incoming EDI files are stored. If you enter / (a forward slash), Alma searches for incoming files in the root directory. The default is /.
      The vendor must define one input directory per institution.
      The maximum length for the full path to the file, including the path from FTP root directory + the filename, is 100 characters.
      Output directory The name of the subdirectory in which outgoing EDI files are stored. By default, Alma displays orders in this field. If you leave this field empty, Alma places the EDI files in the root directory.
      The input directory must be different than the output directory. Alma does not validate this.
      The maximum length for the full path to the file, including the path from FTP root directory + the filename, is 100 characters.
      Max. file size Not in use. Accept the default value.
      Allow Navigation Whether to enable access to other areas of the FTP site. The default is to allow navigation (check box selected).
      FTP Server Secured Whether the FTP server is secured.
      FTP mode The mode used for sending the outgoing EDI files, from a list predefined by Ex Libris:
      • ASCII – Each EDI file includes many lines, one for each segment (default).
      • Binary – Each EDI file includes one long line.
      Send command The send command:
      • Append – Does not overwrite a file on the FTP server if the existing file has the same name as the new file (default).
      • Put – Overwrites a file on the FTP server if the existing file has the same name as the new file.
      FTP passive mode Whether the client IP works in passive mode.
      Test FTP Click to verify that the S/FTP parameters entered are valid. In the event of invalid data, an error message displays at the top of the page.
      Per Organization Unit EDI In this section, you must select your institution and define the EDI code and type used by the vendor for the institution. Optionally, you can also select libraries served by the institution and define the EDI code and type used by the vendor for the library.
      Click Add Organization Unit, fill in the fields, andAfter completing the details in this section, click Add to add the EDI file details for the institution/library.
      Organization unit An institution/library.
      EDI code The code used by the vendor for the organization unit.
      EDI type EDI type:
      • 014 – EAN-13
      • 091 – ID assigned by supplier
      • 092 – ID assigned by customer
      • 31B – US-SAN
      EAN per Account code This section maps the EAN (Envelope Address Node) code to the vendor account. Click Add EAN and fill in the fields. This affects only outgoing purchase order sent to the vendor.
      Account code Vendor accounts code.
      EAN code The EAN code to be mapped to the previously selected account code. Click Add EAN to add the code.
      An FTP process tries to connect to an external system for one minute before retrying. The process tries five times, in increments of one minute each, before failing. Any files remain where they are to be processed at the next time scheduled.
    4. Click Save to store the information you entered.
    For Alma to use the S/FTP connection that you defined, you must allow the FTP server access to Alma. For details, see Configuring Allowed S/FTP Connections During Testing.
    See the Acquisitions customer parameter invoice_split_additional_charges for information on how additional charges are handled in EDI invoices.

    Monitoring EDI Jobs

    The following role can monitor a vendor’s EDI jobs:
    • Vendor Manager
    To monitor EDI jobs:
    On the Search Vendors page, locate the vendor whose EDI jobs you want to monitor and select Actions > View history in the row actions list (available only for EDI-enabled vendors). The Monitor Jobs page appears.
    For more information, see EDI Job Reports.

    Working with EDI Files

    To work with EDI files:
    1. On the Search Vendors page, locate the vendor whose EDI incoming files you want to edit, delete, download, or reload, or for which you want to view a report, and select Actions > View EDI files in the row actions list (available only for EDI-enabled vendors).
      EDI Files
    2. On the Attachments page, select one of the following actions from the Actions drop-down list:
      • Edit – Add a file with a URL as an attachment to the EDI file.
      • Delete – Delete the EDI file from the list of files.
      • Download – Download the EDI file.
      • Reload – Reload the EDI file after confirming that the EOD was loaded. You must ensure that the EDI file was received before the EOD was processed and the EDI file did not find any incoming matches.
      • Report – View a report for the EDI file.

    Managing EDI Order Responses

    To manage EDI order responses, you must have one of the following roles:
    • Purchasing Manager
    • Purchasing Operator
    You can manage EDI order responses of types Claim Responses or Order Report on the Manage EDI Tasks page (Acquisitions > Purchase Order Lines > Manage EDI Tasks). For Shelf-Ready order responses, see EDI Job Reports.
    Manage EDI Reports Page
    The page contains the list PO lines for which order responses were received in the last day. There are two tabs:
    • Review – PO lines which require attention.
    • All – All PO lines for which order responses were received.
    You can filter the list of PO lines by:
    • Response type – The status of the order at the vendor.
    • Response date – The message date from the response. Typically, this is the date that the response was created, but it may be a future or past date.
    The fields that appear for each PO line are:
    • Order Number – The PO line number; click to view the PO Line page.
    • Order Description – The PO line description; click to view the MARC Record Simple View page
    • Vendor – Click to view the Vendor Details page.
    • Response Summary – A free text summary of the order status
    • Response Type – The status of the order at the vendor
    • Ordered Items – The number of ordered items
    • Discrete Items – The number of ordered items, excluding multiple copies of the same items
    • Split Delivery Items – The number of items that were split into multiple deliveries
    • Dispatched Items – The number of dispatched items
    • Backordered Items – The number of backordered items
    • Pieces Delivered – The number of physical objects sent; for example, an encyclopedia might contain 30 physical books.
    • Expected Delivery – The expected delivery date
    In the Review tab, you can perform the following tasks.
    Edit a PO line:
    Select Actions > Edit PO Line in the row actions list.
    The PO Line Summary page appears.
    Change the expected date of a PO line:
    1. Select Actions > Update Expected Receipt Date in the row actions list.
      This is a shortcut that saves you from having to edit the entire PO line. A dialog box appears.
      Change Expected Release Date Dialog Box
    2. Enter a new expected release date, enter an optional note, and click Save. The expected receive date is changed in the PO line and the item.
    Cancel a PO line:
    Select Actions > Cancel PO Line in the row actions list.
    Defer a PO line:
    Select Actions > Defer PO Line in the row actions list.
    Dismiss one or more notifications:
    • To dismiss a single line, select Actions > Dismiss in the row actions list.
    • To dismiss several notifications at once, select the items, select Dismiss Selected from the drop-down list near the Execute button, and click Execute.
    • To dismiss all alerts, select Dismiss All from the drop-down list near the Execute button, and click Execute.
    Edit an item:
    Select Actions > Edit Resource in the row actions list.
    This takes you to the relevant editor page. For example, for physical items, this takes you to the Physical Items Editor page.