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 | ||
| 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 | ||
| 2110 AX Interface Diagram ENHANCED.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.xls | 1/9/21 | ||
| ID Number | Description | Module | Status |
| 12 | Vendor master automated export for EWIS/ACWIS | A/P | Complete |
| 17 | Validation logic for financial dimensions prior to A/P invoice submission | A/P | Complete |
| 32 | Remove address information on proforma invoice | A/R | Complete |
| 47 | Add vendor to the grant proposal | P&G | Complete |
| IM2 | Ceridian HR budget positions interface | Budget | Complete |
| IM3 | Cash flow statement (MR report) for proprietary funds | General | Complete |
| IM6 | Analyze users, roles and license levels | General | Complete |
| 49 | Ability to hit sub-ledger thru EWIS/ACWIS integration | General | Complete |
| IM8 | Address open issues with A/P invoicing and A/P invoice journals workflow | A/P | Complete |
| IM7 | CAFR Report (MR report) | General | Complete |
| 34 | New vendors are set up with fund 100 default | A/P | Complete |
| 41 | Validation for bank statements (BAI2) that include 0 dollar lines | Cash | Complete |
| 43 | Make the invoice desc field on the invoice mandatory | A/P | Complete |
| 59 | Changes to F/A balances report - add columns and rearrange existing columns | F/A | Complete |
| 44 | Report or list view that combines Pcard and A/P payments by vendor | A/P | Complete |
| 51 | Populate pcard vendor names in JE that shows vendor names in G/L | A/P | Complete |
| 55 | Import project-based transactions via G/L import | P&G | Complete |
| 20 | Add "ACH reference number" on ACH payments | A/P | Complete |
| 54 | Auto-generate unique prenotes file name with Johnson Bank - specific filename format | Cash | Complete |
| 48 | Expand field size for ACH remittance emails stored in the vendor file | A/P | Complete |
| 13 | Cashiering integration with AX - provide tender type, create ALE lines with totals by type | Cash | Complete |
| 53 | Inquiry for cash account balances and unposted journal lines | Cash | Complete |
| 62 | Inquiry for "All Bank Statement Lines" | Cash | Complete |
| 9 | Selection of department remit-to address on customer invoices | A/R | Complete |
| 2 | Incr. character limit on item descr. On requisition, text on purchase orders | Purch | Complete |
| 52 | Auto-populate invoice lines entry fields | A/P | Complete |
| 18 | Laserfiche integration - HIPAA and confidential info printing on cover sheet | A/P | Complete |
| 19 | Laserfiche integration - Deletion of sertain laserfiche references | A/P | Complete |
| 56 | G/L Account Detail Lookup report - SSRS report | General | KC Approved |
| 57 | Vendor payment report | General | KC Approved |
| 58 | Purchase order history report | General | KC Approved |
| 70 | Vendor creation for DA and Victim Witness | A/P | Complete |
| 71 | Change Vendor Lookup in "All Pcard Transactions" | A/P | Complete |
| 72 | Pcard charges for projects posting as non-chargeable | A/P | Complete |
| 73 | 1099 Pcard transactions - do not post as 1099 balances | A/P | Complete |
| 74 | Remove duplicate reference nos. in daily bank file | Cash | Complete |
| 75 | Revise "1099 reportable" listing to not include Pcard transactions | A/P | Complete |
| 76 | Fix Pcard error messaging re: timestamp | A/P | Complete |
File details come from the government source that posted it. Updated .