Increase Decrease Report extract using XLS vice PDF (NH-CNO)

PA

Navy

Done

Submitted: 17 August 2016

Description
Problem: The DPAS Increase/Decrease Report can ONLY be extracted as a ".pdf" file.

Recommended
FSA FIAR Team is requesting the DPAS Increase/Decrease Report be available as an "excel file." With the system extracting the information in a ".pdf" it is time consuming for the team to reconcile the reports against the Key Supporting Documents (KSDs) from the subordinate commands. This will provide the FSA FIAR Team the capability to filter by "UIC" and reconcile the DPAS report by Activities in a more efficient and timely manner.

Mission Critical
BSO General Equipment Corrective Action Plan (CAP) Implementation Guide, CAP 2, KSD to APSR Reconciliation, requires BSO Personal Property Managers (PPM) to verify and validate responses received by Activities. In order to complete this task, the current Increase/Decrease Report can only be downloaded in a .pdf file. The solution would assist in completing mandated tasks and complying to implementation guides in a more efficient and timely manner.

Benefits

1. Reduce Time - Filter for the multiple Activities by UIC more accurately and timely manner
2. Increases Accuracy - Reconcile DPAS Report to Activities report with fewer errors.

The Asset Management 6.2 CAP 2 KSD TO APSR RECONCILIATION states the following:
- On a quarterly basis (or as deemed more frequently required by the Command), the PPM or other designated official obtains:

1. All asset acceptance and disposal documents as of the last review period
2. DPAS reports capturing acceptance and disposals in the system as of the last review period .

The PPM (or other designated official) determines if the documents reconcile with DPAS records created in the last review period. Any discrepancies between the two lists are researched and resolved. Once the reconciliation is completed, the PPM (or other designated official) signs and date-stamps the reconciliation report and retains for audit purposes.
To conduct the reconciliation, the Activity PPM (or delegated official) will: 

• Gather all acceptance/disposal documents (KSDs) for assets acquired as of the last review period
• Generate a DPAS Increase/Decrease report for the applicable quarter (located in the forms-reports tab of DPAS), and compare the two (2) documents, notating any discrepancies/differences. 
• - A comparison can be conducted via an excel worksheet to facilitate the comparison of the DPAS report and acquisition/disposition documentation.
• Research and resolve the noted discrepancies until no differences exist between the DPAS report, and the KSDs

Users
This solution can be useful across all Components/Agencies that use the DPAS Increase/Decrease Report for reconciling. It can decrease time spent on filtering information, decrease the chance of inadvertent errors, and increase efficient work productivity.

Completed - Release 5.1 - 28 April 2017