DPAS SCR: 02045

• SCR Number
  02045
• Title
  External ICP 846R without Project Code
• DPAS Module
  Warehouse
• Reporting Organization
  USMC
• State
  New
• History
  Submitted 07/15/2024
• Description
  Change Request: Process Improvement

  
  

  Description: 

  USMC is utilizing Navy ERP as its ICP with their Albany warehouse operation supported by DPAS. It's been reported that Navy ERP manages its inventory by RSA (Remote Storage Activity), Stock Nbr, and Condition Cd.  The DLMS 846R End of Day (EOD) inventory balance file that DPAS produces includes "Project Code" as part of the reporting. Currently Navy ERP is not designed to summarize RSA generated DLMS 846R transaction sets to the level the inventory is managed by Navy ERP.  Thus the inventory totals for items that do contain a project code that DPAS is reporting do not match the inventory totals that Navy ERP has.  The proposed solution is for DPAS to generate its EOD inventory reporting  balance without including the "Project Code" in the group by.

   

  Recommended:

  1)  Create a version of the DLMS 846R EOD transaction set that does not include "Project Code" in the group by in the inventory count (RSA, Stock Nbr, and Condition Cd).
  2)  Add this DLMS 846R EOD option as a configuration setting for the warehouse similar to the setting that enables the Warehouse to generate a DLMS 867I Issue transaction set that is required by Navy ERP.

   

  Mission Critical:
  

  This change would enable DPAS to generate the DLMS 846R EOD transaction set with inventory counts that will match the inventory balance of Navy ERP and other ICPs that may not manage inventory at Project Code level.  

   

  Benefits:

  Providing this option enables systematically inventory balance reconciliation between the RSA and ICP via the the DLMS 846R EOD transaction set.  Navy ERP adjusts its inventory using the Qty reported within the DLMS 846R EOD.  Currently this is resulting in invalid inventory counts.  

   

  Frequency: Daily

   

  Users:

  Navy ERP is the only known external ICP where DPAS Warehouse is being used as the RSA.