MMS - Data Export - Suggested Count Export contains duplicate data

Steps to Reproduce: 

1. Run the Suggested Count Export from the Data Export page on MMS and Store 01919 and using Start Date : Dec 1, 2021 and End Date Jan 6, 2022  
2. Select to export to Download Center
3. View Report in Download Center

Expected Functionality

• There should not be duplicates items.

Defect: Duplicate data exist in the report for most items (see attached)

Other observations: 

1) the Export from the Server Manager does not work at all. We observed that when we run this export from the Data Export page in MMS and send it to the Default - we now see the export in the folder on the server manager 

2) After looking at he the Stored Procedure - it was noted some possible issues with the query that we would like to discuss around startdate enddate logic and why the StockCountSubTypeID = 2 is being used. (AC 2 and 3 don't seem to be taken into account currently) 

3)AC 4 - seems to be saying that will return data from all stores in the Suggested Count Zone for this month (previous monthly count) regardless if the count is submitted or not.  Question: are you returning these values based on Counts in progress but not applied. We just need more information on what to expect here and possibly a walk through of a scenario that meets this criteria. Right now we are only guessing.