DPAS SCR: 01656



  • SCR Number
    01656
  • Title
    DAI Accounting Interface Report
  • DPAS Module
    Enterprise
  • Reporting Organization
    MDA
  • State
    New
  • History
    Submitted: 15 Jan 2021
  • Description

    Description
    In order to ensure transactions interface from DPAS to DAI, MDA reconciles reports from both systems.  Currently, DPAS Interface System Initiated report is only available in PDF format and makes it extremely difficult to validate transactions.  The process requires extensive steps in Exporting the PDF to Excel and utilizing formulas to attain necessary information. This is a timely process since Exporting PDF to MS Excel does not convert the same way each time.  Currently, it takes at least 4 man-hours to reconcile transactions between both systems; therefore, currently MDA only reconciles once a month.

    Recommended
    Converting the report from PDF to Excel will minimize the man-hours required to reconcile the DAI Accounting Interface Report and allow the users to perform the report on a more frequent basis.

    Mission Critical
    No: This action will allow for a more efficient work flow and minimize the man-hours required to reconcile the report. 

    Benefits
    All agencies that utilize the DPAS and DAI will benefit from the Excel format.  On average it will save at least 3 man-hours each time personnel reconciles reports between DAI and DPAS.   Additionally, reconciliation can be conducted on a more frequent basis (daily or weekly); therefore, any issues between DAI and DPAS will be identified in a timelier basis.

    Users
    This will affect the Accounting/Financial users of DPAS.