2110 Exhibit 1 Enhancements.xlsx

XLSX spreadsheet 18 KB Posted

Attached to
Upgrade Microsoft AX to Microsoft Dynamics 365
Solicitation number
2110
Issued by
Kenosha County, Wisconsin

About this file

This is an ERP Enhancements exhibit documenting completed and approved system modifications for Kenosha County, Wisconsin's Microsoft Dynamics 365 upgrade project. The document lists 76 enhancement initiatives spanning multiple financial modules including Accounts Payable, Accounts Receivable, General Ledger, Cash Management, Purchasing, Budget, Fixed Assets, and Projects & Grants. The enhancements address critical system functionality requirements such as vendor master automation, financial dimension validation, bank statement processing, ACH payment processing, invoice management, reporting capabilities, and integration with external systems including EWIS/ACWIS, UKG (for HR and payroll), Laserfiche, and Johnson Bank. The majority of enhancements (71 items) have been marked as complete, while three items (IDs 56, 57, and 58) are marked as Kansas City (KC) approved, indicating they have received approval but may be pending implementation or verification.

The enhancements reflect the County's transition from Microsoft AX to Microsoft Dynamics 365 Cloud, with a focus on modernizing financial operations while maintaining integration with existing human resources and payroll systems through UKG and preparing for integration with a cashiering solution scheduled for installation by spring 2022. The modifications address both standard financial processes and county-specific requirements, including vendor creation for specialized departments, pcard transaction handling, 1099 reporting adjustments, and enhanced reporting and inquiry capabilities across all financial modules. These enhancements were systematized and tracked as part of the larger upgrade initiative, which was expected to be completed by fall 2022.

View the file

Other files

File Type Posted
2110 Attachment 6 Effort.xlsx XLSX spreadsheet
2110 Attachment 1 Checklist.docx DOCX document
2110 RFP Documents.pdf PDF
2110 Attachment 3 Proposer Statement.docx DOCX document
2110 Enhancement List - REVISED.xlsx XLSX spreadsheet
2110 Attachment 5 Reference REVISED.docx DOCX document
2110 Addendum 1.pdf PDF
2110 AX Interface Diagram ENHANCED.pdf PDF
2110 Attachment 7 Interfaces.xlsx XLSX spreadsheet
2110 Attachment 8 Cost.xlsx XLSX spreadsheet
2110 Attachment 4 Prof Services.docx DOCX document
2110 Attachment 2 Signature.docx DOCX document
2110 Attachment 1 Checklist REVISED.docx DOCX document
2110 Attachment 5 Reference.docx DOCX document
Show all 14

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1

ERP Enhancements.xls1/9/21
ID NumberDescriptionModuleStatus
12Vendor master automated export for EWIS/ACWISA/PComplete
17Validation logic for financial dimensions prior to A/P invoice submissionA/PComplete
32Remove address information on proforma invoiceA/RComplete
47Add vendor to the grant proposalP&GComplete
IM2Ceridian HR budget positions interfaceBudgetComplete
IM3Cash flow statement (MR report) for proprietary fundsGeneralComplete
IM6Analyze users, roles and license levelsGeneralComplete
49Ability to hit sub-ledger thru EWIS/ACWIS integrationGeneralComplete
IM8Address open issues with A/P invoicing and A/P invoice journals workflowA/PComplete
IM7CAFR Report (MR report)GeneralComplete
34New vendors are set up with fund 100 defaultA/PComplete
41Validation for bank statements (BAI2) that include 0 dollar linesCashComplete
43Make the invoice desc field on the invoice mandatoryA/PComplete
59Changes to F/A balances report - add columns and rearrange existing columnsF/AComplete
44Report or list view that combines Pcard and A/P payments by vendorA/PComplete
51Populate pcard vendor names in JE that shows vendor names in G/LA/PComplete
55Import project-based transactions via G/L importP&GComplete
20Add "ACH reference number" on ACH paymentsA/PComplete
54Auto-generate unique prenotes file name with Johnson Bank - specific filename formatCashComplete
48Expand field size for ACH remittance emails stored in the vendor fileA/PComplete
13Cashiering integration with AX - provide tender type, create ALE lines with totals by typeCashComplete
53Inquiry for cash account balances and unposted journal linesCashComplete
62Inquiry for "All Bank Statement Lines"CashComplete
9Selection of department remit-to address on customer invoicesA/RComplete
2Incr. character limit on item descr. On requisition, text on purchase ordersPurchComplete
52Auto-populate invoice lines entry fieldsA/PComplete
18Laserfiche integration - HIPAA and confidential info printing on cover sheetA/PComplete
19Laserfiche integration - Deletion of sertain laserfiche referencesA/PComplete
56G/L Account Detail Lookup report - SSRS reportGeneralKC Approved
57Vendor payment reportGeneralKC Approved
58Purchase order history reportGeneralKC Approved
70Vendor creation for DA and Victim WitnessA/PComplete
71Change Vendor Lookup in "All Pcard Transactions"A/PComplete
72Pcard charges for projects posting as non-chargeableA/PComplete
731099 Pcard transactions - do not post as 1099 balancesA/PComplete
74Remove duplicate reference nos. in daily bank fileCashComplete
75Revise "1099 reportable" listing to not include Pcard transactionsA/PComplete
76Fix Pcard error messaging re: timestampA/PComplete

File details come from the government source that posted it. Updated .