DPAS SCR: 01772

• SCR Number
  01772
• Title
  Modification of Materiel Forecast Report
• DPAS Module
  Warehouse
• Reporting Organization
  NSWC-WARCOMSPEC
• State
  New
• History
  Submitted: 25 March 2022
• Description
  Description:

  The DPAS Materiel Forecast Report 'LPWHR17' includes Stock Nbrs that do not have a Stock Item record for the warehouse it is run for and it includes Stock Nbrs that have not yet been approved for requisition or reacquisition has ended for it. These Stock Nbrs should not be included in this report as the organization has identified them as not applicable or is no longer used by that entity.

   

  Recommended:

  reports after Reportable Commodity Type and before Unit Price. 2) Add Stock Item Replenishment Start Dt, Stock Item Replenishment End Dt to the Warehouse Tier report after the Stock Nbr Replenishment End Dt and before Unit Price. 3). When determining which Stock Nbrs to include in the report, only include those Stock Nbrs where the Stock Nbr Replenishment Start Dt is Report Dt. When no Replenishment Start or End Dt values have been entered, they are considered in range. 4) In addition to using the above determination, the Stock Item Replenishment Start and End Dates must be taken into consideration. Only include the stock nbrs that have an active Stock Item record where the Stock Item Replenishment Start Dt is Report Dt or when the warehouse has 1) On Hand, 2) Returnable Issued, and 3) On Order quantities. No Stock Item Replenishment Start or End Dt values are considered in range. 5) When the Stock Nbr replenishment Start and End dates are in range, and the Warehouse Stock Item Replenishment values report dates are not in range, only include: 1) On Hand, 2) Returnable Issued, and 3)On Order quantities in the forecast report that is run at a tier higher than warehouse.

   

  Mission Critical:

  NSWC would like to use this report to identify their potential buys, and believes the report would be more useful if the Stock Nbrs that are not applicable to acquisition are not included.

   

  Benefits:

  The benefits for implementing this change reduces time by removing unneeded its. It also prevents items that are no longer from being purchased, thus saving the government in lost funds through purchases of unneeded items.

   

  Users:

  Yes. This is a change to the report. All users of this report would benefit.