CRUD Payment and Credit Vouchers Manually and automatically when Invoices are processed (UXPROD-1140)

[UXPROD-2297] Part 2 - Export Library Accounting vouchers (Create Batch and Upload to ftp) Created: 03/Mar/20  Updated: 16/Sep/21  Resolved: 13/Jul/20

Status: Closed
Project: UX Product
Components: None
Affects versions: None
Fix versions: Q2 2020
Parent: CRUD Payment and Credit Vouchers Manually and automatically when Invoices are processed

Type: New Feature Priority: P1
Reporter: Dennis Bridges Assignee: Dennis Bridges
Resolution: Done Votes: 0
Labels: acquisitions, appreport, cap-mvp-split, po-mvp, transactions
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Cloners
clones UXPROD-916 Export Library Accounting vouchers (P... Closed
Defines
is defined by MODINVOICE-124 Limit document size Closed
is defined by UINV-142 user with invoice permissions can't C... Closed
is defined by MODFIN-121 Return helpful and clear error code, ... Closed
is defined by MODFISTO-101 Return helpful and clear error code, ... Closed
is defined by MODINVOICE-156 Create MODINVOICE Hotfix release Closed
is defined by MODINVOICE-157 mod-invoice running with high memory Closed
is defined by MODINVOICE-158 Batch voucher XSD schema changes Closed
is defined by MODINVOICE-161 Fix batch voucher converting from JSO... Closed
is defined by MODINVOSTO-17 Create view for search and filtering Closed
is defined by UINV-143 Create UINV Hotfix release Closed
is defined by UINV-146 Support breaking changes on the back-... Closed
Relates
relates to MODINVOSTO-68 Migration scripts for breaking-change... Closed
relates to UINV-130 Add batch group to invoice Closed
relates to MODINVOICE-168 Populate field "voucherLine.fundDistr... Closed
relates to MODINVOICE-170 Fix batch voucher file name generation Closed
relates to MODINVOICE-171 The BatchedVoucher.vendorInvoiceNo fi... Closed
relates to MODINVOSTO-69 Migration script populate "fundDistri... Closed
relates to UIF-188 Error message not helpful when saving... Closed
relates to UINV-126 Download batch vouchers Closed
relates to MODINVOICE-131 Create batch-voucher-export CRUD API Closed
relates to MODINVOICE-132 Batch voucher generation and persistence Closed
relates to MODINVOICE-133 Implement the "upload" endpoint Closed
relates to MODINVOICE-136 Evaluate fund distributions when gene... Closed
relates to MODINVOICE-137 Implement "test" endpoint Closed
relates to MODINVOICE-177 Exclude vouchers with empty accountin... Closed
relates to MODINVOSTO-57 Implementing cascade deletion for bat... Closed
relates to MODINVOSTO-58 Invoicing schema changes Closed
relates to UINV-104 Run voucher export manually Closed
relates to UINV-110 Test voucher settings ftp connection Closed
relates to UINV-123 Add "Export to accounting" toggle to ... Closed
relates to UXPROD-2843 Implement secure connection methods f... Closed
Epic Link: CRUD Payment and Credit Vouchers Manually and automatically when Invoices are processed
Analysis Estimate: Very Small (VS) < 1day
Front End Estimate: Large < 10 days
Back End Estimate: XXL < 30 days
Development Team: Thunderjet
Report ID (pre-May 2019): ID218; ID219
Report Contact(s):
Sharon Beltaine
Report Functional Area(s):
Resource Management
PO Rank: 102
Rank: Chicago (MVP Sum 2020): R1
Rank: Cornell (Full Sum 2021): R1
Rank: 5Colleges (Full Jul 2021): R1
Rank: GBV (MVP Sum 2020): R2
Rank: TAMU (MVP Jan 2021): R5
Rank: U of AL (MVP Oct 2020): R1

 Description   

Note: This work was split from UXPROD-916 Closed as all work relating to generating and uploading batch vouchers to an ftp server could not be completed in Q1 2020. Also scheduled creation of vouchers has been split and moved to Q3 see UXPROD-2417 In Refinement

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

"Invoice Control report: gather financial data in total for all of the invoices approved the day before"

Proposed approach:
Each invoice will generate a voucher summary when approved.
This summary will summarize the necessary transactions outlined in the invoice by external account number associated with each Fund code.
IF "Export to accounting" toggle on invoice equals true the associated voucher will be sent for export via the institutions configured integration
Integrations may include FTP services, API connections etc. (these possibilities will need to be investigated and prioritized)

  • Mod-invoice will communicate with Edge-voucher which will allow for the authentication of external systems that require voucher information.

Electronic Feed: sending by vendor, by invoice, by account number to university financial system to be paid (batch job)"


Generated at Fri Feb 09 00:22:47 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.