Export batch vouchers based on schedule settings

Description

Note: This work was split from as priority was given in Q2 2020, to the ability to export batch vouchers manually and have them upload to an FTP server.

Description
Overview: Financial summaries of approved invoices that can be sent to the external accounting system for payment.

Use cases:
Librarian wants batch voucher created automatically at a set time each day/week/month.
Librarian does not need to supervise the creation of the batch file or approve it etc.
Accounting system is configured to retrieve voucher information from ftp server at a certain time each day for payments to be processed the following day. In order to be sure the information will be there librarian wants the batch exports created on a timer.

Proposed approach:
Each bach group will have its own schedule settings
Export will run automatically at that time and file will upload to server if ftp details are configured

Priority

Fix versions

None

Development Team

Assignee

Solution Architect

Parent Field Value

None

Parent Status

None

Attachments

1

Checklist

hide

TestRail: Results

Activity

Show:

Dennis Bridges January 10, 2022 at 5:50 PM

As additional work has been identified to make possible the remaining update for this feature must be deferred to the next release. Moving to Morning Glory.

Dennis Bridges March 22, 2021 at 4:10 PM

Given the available workaround and relatively low ranking for this feature the R2 2021 fixed version is being removed. This will make room for higher priority features, improvements and fixes.

Dennis Bridges December 10, 2020 at 11:42 PM

Thanks just a quick note. This only relates to the automated export of batch vouchers based on a schedule. Vouchers can currently be export manually at any time from the FOLIO invoice settings area. Currently a user need to actually go there and click the export button when they want this to happen.

Tod Olson December 10, 2020 at 6:17 PM

Chicago - clearly we need to be able to get vouchers out so we can send them to the Comptroller. If we can get them out reliably through the APIs or through the LDP, it should be possible to schedule the exports outside of FOLIO.

Dennis Bridges December 7, 2020 at 7:16 PM
Edited

Yes, the development team discussed supporting SFTP. However, this feature only covers automating the export process based on a set schedule.

will allow us to collect more feedback from the community regarding methods and priorities.

Details

Reporter

PO Rank

PO Ranking Note

Current workaround is to run the export manually when desired. Everything about the export file is the same but a user actually needs to trigger the export by clicking a button in settings. The frontend portion of this feature has already been contributed to FOLIO. This remaining fork is needed allow it to function correctly.

Estimation Notes and Assumptions

Front end was implemented and commented out for release. Waiting for remaining backend logic

Front End Estimate

Front-End Confidence factor

Back End Estimate

Back-End Confidence factor

Score

Rank: 5Colleges (Full Jul 2021)

Rank: Cornell (Full Sum 2021)

Rank: GBV (MVP Sum 2020)

Rank: TAMU (MVP Jan 2021)

Rank: Chicago (MVP Sum 2020)

Rank: U of AL (MVP Oct 2020)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created May 4, 2020 at 9:53 PM
Updated April 16, 2024 at 7:17 PM
TestRail: Cases
TestRail: Runs