Description
Defense Property Accountability System's (DPAS) current build, version 3.2.01, contains a data validation rule for Sets, Kits, & Outfits (SKO) assets that restrict the Condition Code (C/C) of the Master Stock Number (MSN) to the lowest C/C that exists within its components.
The MSN is commonly referred to as the Header. This disables the user's ability to change and manage the C/C of an asset strictly based off of the results from a Quality Control (QC) inspection. For example, if a component of the SKO is in C/C = 'F' and the QC technician determines the asset should be C/C = 'A', the data validation rule currently in place will prevent the user from assigning the correct C/C to the Header.
Furthermore, when inventory changes to SKO assets are made in DPAS, only the MSN attributes at its level are sent to Stock Control System (SCS), the Inventory Control Point's (ICP) inventory management system.
Consequently, if an MSN received as a Component is in C/C = "A" and a secondary Component is received in C/C = "F", the Header appears to be in C/C ?F? and is erroneously interfaced as such through Defense Logistics Agency (DLA) Transaction Services to SCS.
Recommended
Due to disparities in the business processes between each of DPAS's client organizations, this specific data validation rule does not pose a problem with all users.
It is recommended that Leidos develop a feature that gives users the ability to enable or disable this data validation rule at the Logistics Program level.
The preferred solution is the creation of a new check box for the MSN in the SKO Catalog.
The check box should be captioned: "Condition Code dependent on Components" (or something similar).
This would create a new field on the Collateral Item table in the DPAS database, CC_DEPENDENT_ON_COMP (or something similar).
If the CC_DEPENDENT_ON_COMP = True, then the current data validation rules would be in effect; however, in the case that the CC_DEPENDENT_ON_COMP = False, the MSN's C/C should no longer be affected by components within the Header's SKO configuration. The customer would also like to have the ability to indicate whether the MSN is complete or incomplete.
This would simply be a check box captioned "Complete Kit?" in the Receipt > Verification > Components area next to the Header record when receipting for the SKO asset.
This would create a new field on the Inventory table and the Inventory Update table to indicate if the MSN is complete "yes" or "no".? The default should be "no".
The other area the check box would be placed is in the Inventory Update > Manager > Edit (Update Inventory window) to allow the user to check or uncheck this box if any changes have been made.?
Mission Critical
This is mission critical due to the fact that inaccurate C/Cs are being reflected in DPAS and SCS.
Benefits
The implementation of this solution will greatly reduce the time taken to complete Q/C validations, which lower cost, in addition to improving the accuracy and accountability of Physical Inventory (PI) data.
Users
Though the data validation rule only specifically affects direct users in certain organization, the results with this issue affect all users by secondary and exponential implications to PI accuracy.
11 Mar 2021 – cancelled per Jack Sanders
No Longer Needed.
Disclaimer | Accessibility