Create a report in MxConnect for inventory items found on orders

User Story
As a supply chain user in InFORM, I would like the ability to generate a vendor report for download, as a csv, that displays order detail for inventory items.

Detail

Chick-fil-A would like the ability to generate a report for download that contains the item-level data for placed orders for a specific vendor. This would provide the restaurant users better visibility of the data that goes into suggested orders. This report is intended to be run to evaluate ordering information from previous ordering events.

The enhancement would provide a page where the user can enter report parameters. Once entered the data should be populated on a page.

The report parameters should include:

• New - 2/19 Store that is running the report, i.e. the logged in store
• Start and End Date (not exceeding 90 days)
• Vendor
• Specific Items, Multiple Items or all items

Data Points included in the sample:

• Vendor
• Order Number
• Item Description
• Item Number
• Forecast Qty
• Safety Stock
• On Hand
• On Order
• Ordered Qty
• Suggested Qty
• Default Order Quantity (not in sample)
• Ordered vs. Suggested
• Allocation Limit
• Original Receive
• Corrected Receive
• Shipped Qty
• Receipt Correction
• Auto Received
• Date Create Date
• Date Placed Date
• Minutes to Place
• Date Shipped
• Date Received
• Date Applied
• Created by
• Receipt Applied by

Acceptance Criteria

• Confirm a report exists in MxConnect for viewing vendor orders.
• Confirm this new report will allow the user to select a start date.
• Confirm the new report will allow the user to select an end date
• Confirm the new report will allow the user to select a vendor.
  • Note, Vendors displayed should be based on those vendors that have a vendor entity relationship
• Confirm the new report will allow the user to select a specific item
  • Note, it is possible that a restaurant may move from Vendor A to Vendor B, in this case, when running for an item that spans both vendors (one of which is no longer assigned to the restaurant) all available details should be included
• Confirm the new report will allow the user to select multiple items
• Confirm the new report will allow the user to select all items
  • Note: All Items should only be available when a single vendor is selected
• Confirm this report when run for a date range will display a line for each order the item is found on.
• Confirm that when the report is run it is sent the download center as a csv file