DPAS SCR: 00940



  • SCR Number
    00940
  • Title
    Tabular Format for DPAS Excel Exports
  • DPAS Module
    Warehouse
  • Reporting Organization
    USMC
  • State
    New
  • Description

    Description
    DPAS Excel exports are currently only available in compact form. This format prevents relative data from being displayed horizontally next to related fields, which are indented to show a nested relationship with the data directly below.? It is imperative for users to have the ability to export Excel files in an automated manner into tabular form so that all related records are viewable in a linear style.

    Recommended
    Users should have the option to choose whether they want DPAS Excel exports in compact or tabular format. Both formats are useful and needed by different parties and requires a mutually exclusive option to be available for each individual export. It is vital that there be an option to automatically export data to Excel in either format.

    Mission Critical
    This is mission critical for users. The current compact format is rendering the users unable to compute required metrics and to perform analysis of inventory and transactional records in a fast and accurate manner.

    Benefits
    This solution will greatly reduce the time to prepare exports of data which consequentially results in a significant reduction in labor cost and allows users to complete tasks more efficiently. Most importantly, a solution directly from the software system itself will improve the accuracy of the exported information in report creation, computing, and analysis of data to effectively eliminate the possibility of user error as this can occur when manually converting records from a compact format to tabular format.

    Users
    This affects all Systems Analysts and 20% of Warehouse Management users.