2110 AX Interface Diagram ENHANCED.pdf

PDF 123 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 interface diagram for Kenosha County, Wisconsin's Microsoft AX Dynamics system, dated April 6, 2021, illustrating the county's current enterprise resource planning (ERP) infrastructure and data integration architecture. The diagram depicts the AX Dynamics system as the central hub connecting to multiple external systems and data sources, including FIS Tyler Cashiering for payment processing, Ceridian for payroll integration via SFTP, Johnson Bank for ACH and positive pay services, and LaserFiche for document management. The system processes various transaction types through multiple channels: bi-weekly and monthly payroll information from Ceridian, daily bank statements via BAI2 format from Johnson Bank, cashiering transactions through a Tyler custom API, accounts receivable and non-accounts receivable payments, vendor payments, and specialized transactions related to foster care, eWISA, CWS, TriMin, P-Card, Juror fees, and witness fees. Data integration occurs through AX AIF (Application Integration Framework), custom KC-built web applications for payment transaction uploads and LaserFiche integration, and Management Reporter for enterprise portal reporting.

The diagram reflects the county's existing technical environment as of the contract opportunity date, which seeks to upgrade the current Microsoft AX configuration to Microsoft Dynamics 365 Cloud while maintaining Human Resources and Payroll functions in UKG (formerly Kronos). The scope encompasses financials migration only, with integration to the UKG platform and a future cashiering solution anticipated for spring 2022 implementation. The upgrade project is expected to achieve completion by fall 2022, requiring experienced Microsoft implementers to manage the cloud migration while preserving existing system integrations and data flows across the county's financial operations ecosystem.

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 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
2110 Exhibit 1 Enhancements.xlsx XLSX spreadsheet
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

April 6, 2021AX Dynmaics Interface Diagram

AX DynamicsAX Dynamics

AOS

Management Reporter

Enterprise Portal

Reporting

AX Dynamics

AOS

Management Reporter

Enterprise Portal

Reporting

FIS Tyler Cashiering

AXDocuHandler

AX File Portal Ceridian SFTP

KC-built Web App for users to Upload payment transactions

AX File Portal Notes:

(1) Standard format based on JE imports

(2) File layout specified by US Bank; gets loaded directly into AX

(3) State file format; file is transformed once imported

KC-built App to handle integration between LaserFiche and AX

AX AIF

(App Integration

Framework)

AX AIF

(App Integration

Framework)

• Bi-wkly: Payroll Information

• Monthly: Monthly payroll data

• BAI2 (Daliy Bank Stmt (daily)

Cashiering Transactions

(posted via a Tyler custom API)

• Non-A/R pmts (eg: marriage lic, dog tags, Health fees/charges, etc)

• A/R pmts (A/R exists in AX)

ACH

(Vendor

Pmts)

Johnson Bank

Tyler API eWISACWIS

Foster Care related Pmts

Pmt Reqts data?

(Crowe file layout)

Vendor Pmt data?

(Crowe file layout)

Positive Pay (Check data)

LaserFiche

• GCS (1)

• TriMin (1)

• TrakIt (1)

• P-Card (2)

• Juror (3)

• Witness Fees (3)

AX - Service Interface Diagram_Dtls.vsdx
Page-1

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