Story

As a user, I would like a report that provides information about Suggested Count usage by store.

Details

The idea for the report by item is to include:

• The store number
• The last time the item was counted with suggested count
• The suggested count value
• The value when the count was submitted
• If the count was edited by the user

CFA would like a report, by item, that lists:

• Excel Header
  • "Suggested Count Usage: By Item"
  • "%Item Name and Number%"
    • The name and number of the item the user selected when running the report
  • "Generated At: %Date and Time%"
  • "From: %Time Range of the Report%"
• Report Columns and Data
  • Store
    • The store name and number that counted the selected item using "Use On Hand Values" functionality where the count submitted date falls within the user-selected period.
  • Last Count Date
    • The submitted date of the count associated with the item.
  • Suggested Count
    • The original suggested value if applicable.
  • Submitted Count
    • The total count submitted for the item on the submitted date
  • Cost
    • This value is available in the Order History of a specified count
  • User Edited
    • Was the count of the item edited by the user after they chose to apply the "Use On Hand Values" data? "Yes" / "No"

• Report Default Sort
  • 1st sort by "Store" A-Z
  • 2nd sort by "Submitted Date", Newest to Oldest

• Filename
  • The filename includes the name of the report and the username of the user who generated the report. Example:
    • SuggestedCountUsageByItem-JasonPowell.xlsx / .csv

• Data Consolidation ^{Update 3/16}
  • When there are multiple store matches for the same item, consolidate those matches. See wireframe below.
    • Sort consolidated section by "Submitted Date" newest to oldest.
    • 

AC

Confirm

1. The .XLSX report includes the headers above
   1. The .CSV just includes the data
2. The columns are labeled correctly based on the info above.
3. The data returned in each version of the report matches the description above.
4. The report is sorted as defined above
5. Data that is available over multiple orders is consolidated by store and sorted as defined above
6. The filename matches the details above
7. When the user selects to send the report to the Download Center, the report lands in the download center.