The file's text, extracted by GovTribe without its formatting.
STORES
| | STORES Management Information Reports | | |
| Section | Report Title | Description | Input Parameter | Output Format |
| Weekly Catalog Processing | Catalog Item Disapproval: | Item updates on a specific catalog that were disapproved, the users that disapproved them and the reasons they were disapproved. | Contract Number | Crystal/Excel |
| Catalog Update/Error/Warning: | This provides the option to run three reports at once: | | |
The Error Report - which displays items that were sent in with errors. Items listed in this report will not process in the current weekly catalog process.
The Warning Report –This displays pending items that have been flagged for additional review. These updates will process if approved by both Customer and Supplier Ops.
| The Update Report – This displays all updates (added items, changed items and deleted items) for the weekly catalog process. | Contract Number, | | | | |
| Stock Number | Crystal/Excel | | | | |
| | Initial Catalog Item Verification Report: | Verifies that the vendor has submitted the correct Distribution Fee Category and Unit of Measure for an item when it is added to the vendor catalog. | Vendor Item Catalog | Crystal |
| | Pending Distribution Fee Warning Report: | Impacts the weekly review process and saves time by verifying that a submitted unit price is contractually accurate before performing a Fair and Reasonableness | Vendor Item Catalog | Crystal |
Fair/Reasonable Tools Catalog Item Size Change History: Displays a history of all size changes (Package Size, PRF, Package UoM, Units per Purchase Pack) for a particular stock number(s) for a selected period of time. Contract Number, Stock Number(s), Report Update Range
| Crystal | | | | |
| Distribution Fee by Stock Number | Search for distribution fee in the catalog by Stock number | Stock Number | Excel |
| Price Deviations: | Provides a comparison of current stock item prices versus a statistical threshold (based on prices of the same or similar items) and highlights outliers (above and below threshold) to the user. Comparison can be run on a single stock number, by contract number or by item group. | Select Criteria from options | Excel |
| Price Trending & EPA Ceiling | Identifies items on a given Vendor Item Catalog that have had price increases by more than an entered percentage from the time that item was added on the given Catalog to the current date. Helps ensure that price increases for stock items on a given Vendor Item Catalog are within an acceptable range. | | |
Identifies items on a given Vendor Item Catalog that have had price increases by more than an entered percentage from the time that item was added on the given Catalog to the current date. Helps ensure that price increases for stock items on a given Vendor Item Catalog are within an acceptable range Vendor Item Catalog Number, Catalog Item Status Price Category Base Price on Item's
| Price Percentage Increase Threshold | HTML/Excel | | | |
| | Vendor Price Comparison: | Provides weekly vendor prices for a stock number on a group of contracts to compare prices over a period of time and to the mean. | Date Range, |
Stock Number,
| Contract Number(s) | Excel | | | |
| | Vendor Price: | Provides weekly price history for an item on a particular catalog for a date range. | Contract Number |
Stock Number Date Range Crystal
| Catalog Views | Catalog: | Displays detailed information for the stock items on a current catalog | Contract Number | Crystal |
| | Catalog Snapshot: | Provides historical catalog details by searching for specific contract number as of a specific date | Date Range, | |
| Contract Number | Excel | | | | |
| | Ordering Point Catalog: | Displays available and hidden stock items for catalogs assigned to the selected Ordering Point. | Ordering Point | Excel |
| | Hidden Items: | Provides a list of all items hidden on a specific catalog or from a specific ordering point | Ordering Point, | |
| Contract Number | Crystal | | | | |
Customer Processing Open Orders Provides a list of Purchase Orders (POs) that have not been receipted by a specified number of days past the Required Delivery Date (RDD) based on election criteria in column D. Days Past RDD Select one or more of the following:
Contract Number(s), Ordering Point(s), ShipTo(s),
| UserID(s), | Crystal | | | | |
| | Receipt Adjustment (Excel): | Provides a list of all receipt adjustments performed during a specific time frame. Note: If a line is adjusted more than once all adjustment lines will be displayed. | Select either Purchase Order Number OR Other Criteria | Excel |
| | Unsent Receipts and Adjustments: | User can search by specific contract number or all contracts to see if there are any unsent receipt and adjustments. | Select All Contract Numbers, OR A Contract Number | Crystal |
| Order/Receipt History | Order-Receipt Detail (Excel): | Provides line item detail information for orders and receipts based on criteria input by user. | Select either Purchase Order Number OR Other Criteria | Excel |
| Order-Receipt Information (Crystal): | Provides line item detail information for orders and receipts based on criteria input by user. This report provides grand totals for all order and receipt data by PO Number. | Select either Purchase Order Number OR Other Criteria | Crystal |
| Order-Receipt Summary (Excel): | Provides summary information of orders and receipts based on criteria input by user. Note: Running this report by stock number will allow the display of additional details including totals of Units of Issue and Units of Measure. | Enter date range based on, | |
Date Range, Subtotal by Excel
Vendor Performance Fill Rate Management: Provides fill rates by line item based on customer receipt data. This report is mainly used for Navy customers based on their requirement of needing all items that are ordered for load-out. Fill Rate Type, Search By Purchase Order Number
| Crystal | | | |
| On-Time Delivery: | Lists on-time and late deliveries for a specific Purchase Order or Contract Number over a date range. | Purchase Order Number, |
Contract Number, Date Range Crystal
Vendor Award Tracking Awarded Contract/VIC Lookup Summary/Detail/Age: Contains the business details maintained within STORES for Awarded Contracts and Vendor Item Catalogs (VICs). Contains options to generate three reports within the Vendor Item Catalog (VIC) module. All reports return results based on specific search criteria. The three report options are:
1. Summary- Provides an overall summary for the contract
2. Detailed- Will provides detailed information for the contract
3. Contract Age- Provides information on the effective date and Expired date of the contract Date Range, Awarded Contract, Vendor Catalog, Contract Type, Total option Years, Current Option Year, Account Manager,
| Excel | | | | |
| | Bridge Contract: | Provides information about Bridge Contracts, which are sole-source contracts used to temporarily extend an existing contract when a new contract cannot be awarded. | Contract Type or Other Criteria | |
| Excel | | | | |
| | Contract-Obligation Tracking: | Tracks contract award spending. This report is critical for tracking dollars spent during a base or option period for a contract, as well as for ensuring that spending on a contract is not prematurely maxed out. Automates the previous manual spreadsheet process. | Contract Number(s) | HTML/Excel |
| | Contract Usage: | Provides quantities and dollar values ordered and received for a contract number over a date range | Contract Number, | |
| Date Range | Crystal | | | | |
| . | UGR-A Contract Associations (Excel): | Contains functionality to generate a report for UGR-A Awarded Contracts. “UGR A” refers to Unitized Group Ration-A (meal kits for breakfast, lunch, and dinner used to sustain military personnel during worldwide operations) | UGR-A Awarded Contract, | |
| Status | Excel | | | | |
| . | | | | |
| Maintenance Tools | Duplicate Item Check: | Lists any stock numbers assigned to more than one catalog servicing a particular ordering point. | Ordering Point or | |
| Contract Numbers | Excel | | | | |
| | Vendor Price Verification: | Provides verification for a particular vendor catalog as to whether or not the submitted vendor price matches the sum of the submitted product price and distribution fee. | Contract Number | Crystal |
| Organizational Information | Ship-To Association (Contract): | Provides all ship to delivery addresses for a particular catalog. | Contract Number |
| Ship-To Association (State): | Provides all ship to delivery addresses for a particular state (CONUS), Country (OCONUS) and Service. | Country, |
State, and/or Service Type Excel
| ICC/PII Reports | ICC Master Report: | Displays a snapshot of ICC data based on input parameters chosen for Codes, Code Descriptions, Attribute Codes/Values, and Attribute Code/Value Descriptions. | Item Classification Code(s), | |
| ICC Description(s) | HTML/Excel | | | | |
| | ICC Associations Report: | Displays the assigned relationships among ICCs, PPI Codes, Distribution Fee Categories, and Stock Numbers based on input parameters chosen. | Item Classification Code(s), | |
| ICC Description(s) | HTML/Excel | | | | |
| | PPI Master Report: | Snapshot of the PPI data contained in STORES and shows updates and/or changes made to the PPI tables during a specified date range. | Commodity Code Levels | HTML/Excel |
| Manufacturer Reports | Manufacturer Information Report | Report shows a listing of established Manufactures that are either part of the NAPA and/or MPA Program and the brands under them. | Select Type, | |
| Active/inactive | HTML/Excel | | | | |
| | MPA Agreement Item Details Report | MPA Item Detail report used to send to manufacturers a list of MPA items that are available for the upcoming month. | Enter Manufacturers or Manufacturer Code | HTML/Excel |
| | NAPA Agreement Item Detail Report | Report shows stock numbers that are currently associated to NAPA program participants and the current/future effective NAPA allowances for them. | Manufacturer, | |
| FSOM | HTML/Excel | | | | |
| UGRA | Master Menu End Items/Exceptions Missing Items Report: | Report enables the Subsistence Operational Rations personnel the capability to verify that the UGRA Master Menu has been accurately established at the High-level of detail in addition to identifying any missing End Items, or Generic Component Items required for completing that menu in STORES. | Search By Type, |
| Menu ID | HTML/Excel | | | |
| | Master Menu Generic Items & Exceptions Report | Report enables the Subsistence Operational Rations personnel the capability to verify that the UGRA Master Menu has been accurately established at the mid-level of detail in addition to identifying any missing End Items, or Generic Component Items required for completing that menu in STORES. | Menu Type, |
| Menu ID | HTML/Excel | | | |
| | Master Menu Specific Items & Exceptions Report | Report enables the Subsistence Operational Rations personnel the capability to verify that the UGRA Master Menu has been accurately established to the lowest level of detail in addition to identifying any missing End Items, Generic Component Items, or Specific Component Items required for completing that menu in STORES. | Menu Type, |
| Menu ID | HTML/Excel | | | |
| | Catalog Update, Error & Warning Report | STORES Catalog Error report was modified to perform validations relevant to UGRA vendor submissions. These validations include ensuring that the appropriate stock item information is being submitted on the Vendor Item Catalogs | Awarded Contract Number, Vendor Item Catalog Number, |
| Stock Number | HTML/Excel | | | |
| | Vendor Submission Reports | The Vendor Submissions report is really the "UGRA Vendor Submission Report" and it shows UGRA Submitted Vendor Item Catalogs with Pricing and Packaging Details and any current exceptions concerning them. | |
| Report Type, | | | |
Search By,
| Vendor Item Catalog (VIC) | HTML/Excel | | | |
| | Vendor Menu Items & Exceptions Report | Report enables the Subsistence Operational Rations personnel the capability to verify that the UGRA Vendor Menu has been accurately established in addition to identifying any missing End Items, Generic Component Items, or Specific Component Items required for completing that menu in STORES. | Awarded Contract Number, |
| Menu ID | HTML/Excel | | | |
| Core Catalog | Compliance Report | This report displays which Stock Numbers are compliant with specific Core Catalog Association Type Values. Catalog Association Type Values, will assist in managing a specific Core Catalog and can track core item compliance for their core projects. | Select Project | HTML/Excel |
| | Non-Compliance Reports | Is similar to the existing compliance report (stated above) that was previously implemented in STORES. The report displays which Stock Numbers are not in compliance with Core Catalog Association Type Values, so that whoever manages a specific Core Catalog can view which items are in non-compliance on their core projects, giving them the opportunity to track any potential problems. | Select Project, | |
| Association Type | HTML/Excel | | | | |
| | Non-Compliance Reports within Subregions | Allows users to run a report against Projects with an Association Type of Vendor Item Catalog, based on Subregion, to track compliance for the BDFA Project and like projects. | | |
| This report only shows for Project with an Association Type of Vendor Item Catalog and for Subregions that have Association Type Values. | Select Project, | | | | |
| Subregion | HTML/Excel | | | | |
| | STORES Recon | | |
| Section | Report Title | Description | Parameters | Output Format |
| | Vendor Invoice Updates to Web Invoices: | Provides the percent that is derived from the number of mismatched Purchase Orders divided by the number of total Purchase Orders. Also shows the percent that is derived from Purchase Order from Vendor Updates divided by the number of mismatched Purchase Orders. That is entered for specific contract and the time period for Invoices received and closed. | Contract Number, | |
| Date Range | HTML | | | | |
| | Monthly Statistics: | Provides numbers calculated from closed invoices for the month(s) requested that are contracts assigned to the user. | Month Range | HTML |
| | View Invoice Information: | It allows view of what data is sent to EBS | | |
| Also can view of what is still present in STORES. This report can only be viewed by vendors only. | Purchase Order Number | | | | |
| and or Contract Number/Invoice Number | HTML | | | | |
| | Mismatched Invoices: | When a customer receipt and vendor invoice lines do not match. | | HTML |
| | Mismatched 5 -Day: | Report shows Mismatched Invoices to be moved to EBS within five (5) or less days. | | HTML |
| | Weekly Invalid: | Allows users choose dates that they wish to view. | | |
| This Report displays information of why the Invoice was invalid (e.g. invalid PO, contract number, stock number, price, CLIN, etc.). | Reporting Period | HTML | | | |
| | STORES Catalog Reports | | |
| Section | Report Title | Description | Parameters | Output Format |
| Baseline Report | Abbreviated LSN Report | A STORES Catalog report that allows user to view the primary details for LSN Items currently residing on a given Baseline Catalog. | Contract Number | HTML |
| Abbreviated NSN Report: | A STORES Catalog report that allows user to view the primary details for NSN Items currently residing on a given Baseline Catalog. | Contract Number | HTML |
| NSN Report: | Displays master National Stock Number (NSN) item detail and item statuses based on user entered criteria. | Contract Number | HTML |
| LSN Report: | Displays master Local Stock Number (LSN) item detail and item statuses based on user entered criteria. Both brand name and generic LSNS are returned. | Contract Number | HTML |
| Matched Items Report: | Provides DLA items that match with the Vendors items stock number. | Contract Number | HTML |
| Unmatched Items Report: | A STORES Catalog report that displays a list of stock numbers that have no part number for a given Baseline Catalog. | Contract Number | HTML |
| Wartime Report: | A STORES Catalog report that displays a list of all wartime stock numbers for a given Baseline Catalog. | Contract Number | HTML |
| Items by Stock Number: | Displays the baseline catalog sorted by Stock Number. | Contract Number | HTML |
| Items by DLA Description: | Displays the baseline catalog sorted by DLA Description. | Contract Number | HTML |
| Items by Vendor Description: | Displays the baseline catalog sorted by Vendor Description. | Contract Number | HTML |
| Items by SFSC/Vendor Description: | Displays the baseline catalog sorted by SFSC/Vendor Description. | Contract Number | HTML |
| Baseline/Production Comparison Report: | This allows users to compare items in baseline(sandbox) before it goes into production(Live). | Contract Number | HTML |
| Production Report | Catalog Update/Error/Warning Report(s): | Provides the option to run three reports at once: | | |
| The Error Report - displays items that were sent in with errors. Items listed in this report will not process in the current weekly catalog process. The Warning Report – displays pending items that have been flagged for additional review. These updates will process if approved by both Customer and Supplier Ops. The Update Report – displays all updates (added items, changed items and deleted items) for the weekly catalog process. | Contract Number, | | | | |
| Stock Number | HTML/Excel | | | | |
| | Catalog Item Disapproval: | Item on a specific catalog that were disapproved, the report show the TVLS that disapproved them and the reasons they were disapproved. | Contract Number | Excel |
| | Pending Distribution Fee Warning Report: | Impacts the weekly review process and saves time by verifying that a submitted distribution fee is contractually accurate before performing a Fair and Reasonableness | Contract Number | Crystal |
| | Initial Catalog Item Verification Report: | Verifies that the vendor has submitted the correct Distribution Fee Category and Unit of Measure for an item when it is added to the vendor catalog. | Contract Number, | |
| Sort By | Crystal | | | | |
| | Hidden Items Report: | Provides a list of all items hidden on a specific catalog or from a specific ordering point | Ordering Point(s), | |
| Contract Number(s) | Crystal | | | | |
| | 832 Version Compliance Report(s): | Allows user to check current catalog versus map version requirements | Contract Number | HTML/Excel |
| | Price Trending and EPA Ceiling Report: | Used by TVLS in order to highlight potential issues related to stock item price percentage increases on a given production catalog. | Vendor Item Catalog Number, | |
| Select Criteria | HTML/Excel | | | | |
| | Recatalog Advice Report: | For a specific contract, detailing all stock number standardization issues. Incorporates Instructions and Comments from Tech/Quality. Shows replacement stock number advice, if applicable for all contracts. Also summarize statistics by contract. | Vendor Item Catalog, | |
| Display Recatalog Advice For | HTML/Excel | | | | |
| Producer Price Index Report: | PPI Master Report: | Snapshot of the PPI data contained in STORES and shows updates and/or changes made to the PPI tables during a specified date range | Commodity Code Levels | |
| Select Criteria | HTML/Excel | | | | |
| . | VIC Update: PPI Adjusted Report: | The report takes into account pricing trends using the producer price index if associated to any stock numbers on the catalog to help with fair and resonableness evaluations of price updates by vendors. | Vendor Item Catalog Number | HTML/Excel |
| Item Classification Code Report | ICC Master Report: | Displays a snapshot of ICC data based on input parameters chosen for Codes, Code Descriptions, Attribute Codes/Values, and Attribute Code/Value Descriptions. | Item Classification Code(s), |
| ICC Description(s) | HTML/Excel | | | |
| | ICC Association Report: | Displays the assigned relationships among ICCs, PPI Codes, Distribution Fee Categories, and Stock Numbers based on input parameters chosen. | Item Classification Code(s), |
| ICC Description(s) | HTML/Excel | | | |
| | STORES Web Customer Reports | | |
| Section | Report Title | Description | Parameters | Output Format |
| Catalog Change Report: | Allows customers to see changes in the Catalogs attached to their account. | | HTML |
| Send Order Report: | Allows Customers to view Orders after the order was sent. | | HTML |
| . | Send Receipts Report: | Allows STORES Customer users to generate a report to view past receipts from Purchase Orders. | Purchase Order Number | |
or ShipTo DoDAAC
| And Date Range | HTML | | | |
| | MIL STRIP Report: | Shows current customer profile data for a particular ordering point/ship to combination. | HTML |
&"Arial,Bold"&20STORES REPORT
Qlik
| QLIK Reports | |
| Header | Report Name |
| Catalog Workload | |
| Selection Wall Report |
| Workload Summary Report |
| Submission Reviews Processing Report |
| Review Needed Dashboard Report |
| Vendor Submssions Report |
| Submission Processing Detail |
| Adds Report |
| Disapprovals Report |
| Deletes Report |
| Review Action Summary Report |
| Customer/Suplier Actions by Date Report |
| Vendor Performance | |
| Selection Wall Report |
| Vendor Overview Report |
| Vendor Rates Table Report |
| Vendor Rates Pivot Report |
| Vendor Metrics Pivot by Vendor & Catalog |
| Vendor Fill rate Trending & Pivot |
| Catch Weight Fill Rate Dashboard |
| Catch Weight Fill Rate by Country & State Report |
| Invoice Lines Without Recepit Percent |
| Invoice Lines Without Recepit Percent by County & State Report |
| Invoice Mismatches Dashboard |
| Invoice Mismatch Percent by County & State Report |
| Line Receipt All Dashboard |
| Lines Receipt All Percent by Country & State Report |
| Non-Catch Weight Fill Rate Dashboard |
| Non-Catch Weight Fill Rate by Country & State report |
| On Time Delivery Percent Dashboard |
| On Time Delivery Percent by Country & State Report |
| On Time Delivery Scatter Plot Report |
| PO Receipted Percent by Country & State Report |
| Receipt Lines Without Invoice Percent Dashboard |
| Receipted Lines Without Invoice Percent by County & State Report |
| Short Ship Replacement Percent Dashboard |
| Short Ship Replacement Percent Dashboard |
| Short Ship Replacement Percent by County & State Report |
| Total Usage Dollars by Country & State Report |
| Total Demand Dollars by Country & State Report |
| Total Demand vs. Total Usage Dollars Report |
| Total Adjustments by Country & State Report |
| Invoice Lines w/o Receipt vs Receipt Lines w/o Invoice Report |
| CONUS - Prime Vendor Analysis Report |
| On Time Delivery Detail Report |
| BDFA Reports | |
| Food Cost Index Report |
| Food Cost Index Totals & Comparison Report |
| Problem Report Summary |
| Problem Report Detail |
| Monthly Trending Report |
| Food Index Detail Report |
| Regional Summary Report |
| Percent Change by Month Report |
| Percent Change by Month Report and Region |
| Percent Change by Month and CONUS/OCONUS |
| Percent Change by Month and CONUS/OCONUS |
Scheduler
| Data/Report Description | Requestor | Manual Pull/Automated? |
| STORES order file* | EBS | Automated |
| STORES receipt/adjustment file* | EBS | Automated |
| BUPERS file | NAVY | Automated |
| ARMY FCM file | ARMY | Automated |
| STORES order file(to vendor)* | (To)Vendor | Automated |
| LMARS file | Subsistence | Automated |
Defense Logistics Agency