Story

As an admin, I would like an all inclusive Suggested Count Details Export.

Details

CFA would like a concatenated export that includes all suggested count items for all suggested count stores including some additional details. Suggested count functionality is only available in monthly counts

The data should be from stores in the suggested count zone.

This data should include:

• "Item Name and Number - Any inventory item at a suggested count store (In the suggested count zone)
• "Store Name and Number - The store name and number associated with the item
• "Suggested Value" - The suggested system value for the item in the last monthly count.
• "Submitted Value" - The submitted value for all items in the last monthly count
• "User Edited" - a "Yes" / "No" result. Yes if the suggested value is different than the submitted value. No if the values are the same.
• "Individual costs" - The Individual costs of each item.
• "Extended costs" - The extended cost of each item

the original research ticket: https://jira.hotschedules.com/browse/CFAMX-15488

We should be able leverage the current sp for the report by creating a new sp and make it for list of stores: MXC_ReportData_SuggestedCountUsageByStoreReport

AC

1. The export includes all the data listed above
   1. The data is accurate
2. The export should be configured by default to run on the 7th of every month
   1. This run date is configurable
3. The data is specific to the submitted monthly count from the month prior to the run date month.
4. All items from all stores should be included in the export even if there isn't a submitted monthly count for the previous month.
   1. If there is no submitted monthly count from the previous month leave all fields except "Item" and "Store" blank for locations where this condition applies