DPAS SCR: 01459



  • SCR Number
    01459
  • Title
    Implement Validation of Trading Partner Info
  • DPAS Module
    PA
  • Reporting Organization
    Leidos
  • State
    New
  • History
    Submitted: 4/15/2019
  • Description

    Description
    DAI has requested that DPAS review its validation of Trading Partner (TP) data within its Accounting Transactions.  They are seeing some transactions that they believe should contain TP data, but do not.  Note:  They could be old transactions as their review encompassed a large time period. They are also receiving Accounting Transactions where the TP data is not valid.  They would like to see DPAS implement additional validation for TP data.  Currently DPAS is only validating the Department Cd allowing the user to type in the Main Account and Limit with only validation that it be 4 characters.

    Recommended
    DPAS feeds several Accounting Systems that require TP2, TP4, and TP5 data.  DAI and SABRS are two notable interfaces, but there could be others as the DAI interface is considered the current std for new accounting interfaces.  It is recommended that DPAS establish master lookup tables for TP4 (Basic Symbol / Main Account) and TP5 (Subhead/Limit),in addition to the current Department Cd lookup and create associations between them.  The information to populate these lookup values is available from the DFAS Manual 7097.01, Treasury Website and/or from the DCMO Authoritative SFIS Values website. For Non-097 appropriation, the limit/subhead may not be required/applicable. It is also recommended that DPAS review the capture of TP data for all accounting systems regardless of whether that interface accepts the data. Even if the accounting interface does not support it, the user may be required to provide this information off-line.

    Mission Critical
    Yes - As the DoD continues to strive for FIAR compliance, accurate reporting of PP&E financial activity is essential.

    Benefits
    Improves financial reporting accuracy, and reduces the time required to input the data.

    Users
    Yes