Skip to:

Skip to Jira Navigation
Skip to Side Navigation
Skip to Main Content

FOLIO Jira

UX Product

Software project

Menu

Checklist for Jira Cloud

Create from template

You're in a company-managed project

Exporting Orders and Importing Invoices in EDIFACT format (Thunderjet work)

Description

Building out the plumbing necessary for FTP of EDIFACT files based on details captured in the vendor record as well as the parsing of those EDIFACT from orders and to invoices in FOLIO format.

Note: This does not include other types or formats of EDI messages.

Likely EDI required:

EDIFACT orders: GOBI, Harrassowitz, Adlibris (for Chalmers), Bokus (for Chalmers)

EDIFACT invoices: GOBI, EBSCO Subscriptions, Harrassowitz, WT Cox

Priority

P3

Labels

ACQDRAFTACQFSEacquisitionsinvoicesorders

Fix versions

None

Development Team

None

Assignee

Unassigned

Unassigned

Parent

None

Parent Field Value

None

Parent Status

None

Child issues

93% Done

EDIFACT order export default file naming convention includes colon

1

Serhii_Nosko

Order export date not set during EDIFACT export

2

Andrei Makaranka

Job ID is not set correctly during EDIFACT mapping

3

Dennis Bridges

Search and filter organization export logs NOT working

0

Mikita Siadykh

Display lock total on invoice view when there is one

1

Dennis Bridges

Remove EDI configuration from organization record

2

Dennis Bridges

View details - Organization record can contain multiple "Integration details" configurations

2

Dennis Bridges

Display integration configuration view

2

Dennis Bridges

Search and filter organization exports logs

3

Dennis Bridges

Schedule date not saving correctly

1

Dennis Bridges

Validate All POLs on order that is set to export via EDIFACT have same account number

1

Dennis Bridges

Strange arrow appears in select boxes over scrollbar

1

Dennis Bridges

"Server address" validation not clear

1

Dennis Bridges

Implementation : Mapping FOLIO orders to EDIFACT order file

3

Andriy Kundyukov

Implement export flow Mapping FOLIO orders to EDIFACT order file

5

Andriy Kundyukov

Spike : Choose approach for mapping FOLIO orders to EDIFACT order file

5

Andrei Makaranka

Spike : Choose library for implementing SFTP upload service in the mod-data-export-worker

2

Andrei Makaranka

Rework scheduling approach for supporting multiple Cron jobs with different configurations

5

Andrei Makaranka

Do not export order lines where Manual is true for the PO

1

Dennis Bridges

Filter orders lines by export date

1

Dennis Bridges

Filter orders lines by export date

0

Andrei Shumski

Third pane view - Rerun action

1

Dennis Bridges

Implement Kafaka consumer for EDI export job finish message

3

Siarhei Hrabko

Fix issue with EDIFACT Job hour scheduling after mod-data-export-spring restart or update

2

Andrei Makaranka

Add Sent to and File name to export job details

1

Dennis Bridges

Allow user to set EDI naming convention

1

Dennis Bridges

Exported date not removed when order is duplicated

1

Dennis Bridges

bugfest order export jobs showing "Currency" not found error

2

Dennis Bridges

Spike : Investigate an issue with Kafka message with deleted Job. Message is not marked as processed

2

Dzmitry Butramyou

Orders with no Account number not exported with "Default integration"

2

Andrei Makaranka

Improve error handling if provided data from EDIFACT export configuration has incorrect format

2

Andrei Makaranka

Log error and don't throw exception if order lines were not found

1

Andrei Makaranka

Prefix, suffix as well as PO and POL tags missing from export

1

Dennis Bridges

Refactor existing approach to store configuration for Schedulers based on "export type"

3

Artsem Churakou

Add a new export type

2

Artsem Churakou

Allow user to update invoice line connection to POL from invoice view

-

Kimie Kester

Attempting to send "schedulingDate" for EDI config returns error

1

Yury Saukou

Create EDIFACT invoice parser to create Invoices

-

Dennis Bridges

Ability to test EDI connection

-

Import invoice in EDIFACT format (Folijet work)

-

Ann-Marie Breaux

Support for "Import invoice in EDIFACT format" (TJet work)

-

Dennis Bridges

Export FOLIO orders in EDIFACT format

-

Dennis Bridges

Add scheduling details for EDI import

-

Ann-Marie Breaux

Import EDIFACT compatible purchase orders for renewals

-

Dennis Bridges

Implement SFTP Upload service in the mod-data-export-worker

3

Siarhei Hrabko

Third pane view - Search and filter organization exports logs

1

Dennis Bridges

Allow user to set Acq method EDIFACT export triggers for POL

1

Dennis Bridges

Export records from search results in acquisitions apps

-

Dennis Bridges

Part 2 - Support for "Import invoice in EDIFACT format" (TJet work)

-

Dennis Bridges

Migration script for removing invoice number from the invoice line number

2

Aliaksandr Pautau

Remove invoice number from the invoice line number

1

Aliaksandr Pautau

Part 3 - Support for "Import invoice in EDIFACT format" (TJet work)

-

Dennis Bridges

Create schema to support EDI order export functionality

1

Andrei Makaranka

Define Acquisition method schema as controlled vocabulary

2

Andrei Makaranka

Create Acquisition method schema and API

1

Artsem Churakou

Create Acquisition method schema and API

1

Artsem Churakou

Copy FTP upload service from mod-invoice into mod-data-export-worker

2

Andrei Makaranka

Define and implement CRUD Storage API for acquisition method

-

Spike : Create index for "poNumbers" array for the invoice

-

Define and implement CRUD Business API for acquisition method

-

View organization exports action

2

Dennis Bridges

Allow user to choose Acq method EDIFACT export triggers for each organization

-

Dennis Bridges

Save flag "automaticExport" in the POL to support EDIFACT orders export

1

Artsem Churakou

Implement scheduling of the EDIFACT orders export

3

Dzmitry Butramyou

Allow user to Download or resend EDIFACT order exports

-

Dennis Bridges

Leverage useIntegrationConfigs hook from ui-organizations

0

Andrei Shumski

useIntegrationConfigs hook usage from stripes-acq-components

0

Andrei Shumski

Create export_history table, schema, API

2

Andrei Makaranka

Add field "lastEDIExportDate" into POL to support filtering on UI side

1

Andrei Makaranka

Support filtering EDI export configs by vendor UUID and find jobs by export config reference

1

Dennis Bridges

Leverage useOrganization hook from ui-organizations

0

Yury Saukou

useOrganization hook usage from stripes-acq-components

0

Yury Saukou

Fixes and improvements for FOLIO orders to EDIFACT format mapping

3

Siarhei Hrabko

Support filtering EDI jobs by user UUID from source filter (metadata.createdByUserId)

1

Andrei Shumski

Support filtering EDI jobs by user UUID from source filter (metadata.createdByUserId)

0

Andrei Shumski

Disable "Automatic export" when Manual = True on PO

-

Display export details accordion for exported order lines

2

Dennis Bridges

Display export details on ORDER view

1

Dennis Bridges

Remaining fixes and improvements for FOLIO orders to EDIFACT format mapping

3

Andriy Kundyukov

Scheduled parameters UUID is not saved in the DB and rescheduling doesn't work

2

Dennis Bridges

Resolve EDIFACT order export syntax errors

2

Dennis Bridges

Expense class not included as combined code in edit file

1

Dennis Bridges

Implement Re-send EDIFACT export logic

2

Adesh Singh

Fix issue with permissions for EDIFACT orders export

1

Dennis Bridges

Undefined user in the mod-data-export-worker after upgrade mod-data-export-spring from same artifact

-

Andrei Makaranka

SFTP not working for EDIFACT export

-

Dennis Bridges

Update permissions

0

Dennis Bridges

Fix issue with permissions for EDIFACT manual orders export

1

Andrei Makaranka

Scheduled Job is not saved in the Lotus Bugfest Database

2

Dennis Bridges

Improve error handling if provided data from EDIFACT export configuration has incorrect format

1

Andrei Makaranka

Filter organization export logs limited to 10 options

2

Dennis Bridges

Load test EDIFACT order data into performance testing environment

2

Siarhei Hrabko

Update EDIFACT export model to support exporting single order

-

Dennis Bridges

Order line is exported when "Manual" checkbox is enabled in PO

2

Dennis Bridges

Export time is set as when configuration is saved rather than the time chosen in the UI

3

NinaChistova

POL exported even though manual export for PO is true

-

Add step to save orders in EDIFACT format in the Minio object storage

3

Dennis Bridges

Implement download logic from MINIO for Download export file

3

Dzmitry Butramyou

Order export job should not be rerun for deleted integration methods

3

Dennis Bridges

Implement Re-send EDIFACT export logic

3

Dzmitry Butramyou

Populate kafka payload with required fileds for Export History

2

Adesh Singh

Implement Orders Export History API

3

Siarhei Hrabko

Re-export order via export

2

Dennis Bridges

Third pane view - Download and re-send actions

2

Dennis Bridges

Implement support of sftp client to login by private key for Edifact Orders Export

-

Add Private key field for FTP details tab

-

Populate kafka payload with "jobName" for Export History

1

Dennis Bridges

EDI orders are place in /files directory regardless of directory defined

2

Serhii_Nosko

Use Orders Export History API (mod-orders)

1

Dennis Bridges

Spike: DB issues with Hourly large Edifact exports

3

Dzmitry Butramyou

Spike: Define an approach how to store scheduling configuration In DB

2

Dzmitry Butramyou

Sorting by export method resets search

0

Azizbek Khushvakov

Sorting by export method resets search

1

Dennis Bridges

Scheduled export job fails when at least one order for export has Acquisition unit

0

Dennis Bridges

Provide more detail in EDIFACT export jobs regarding the orders causing a failed export

-

Prevents execution of the same scheduled EDIFACT export task from another node (or thread).

0

Tatsiana Tarhonskaya

EDIFACT export scheduling doesn't support work in the cluster and after restart docker container

0

Tatsiana Tarhonskaya

EDIFACT order message incorrect note field syntax

2

Irakli Merabishvili

Display Order number(s) in error details of EDIFACT order export jobs

-

Checklist

hide

TestRail: Results

Activity

Show:

Details

Reporter

Dennis Bridges

Dennis Bridges

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created September 20, 2018 at 4:13 PM

Updated December 13, 2024 at 8:25 AM