I am exploring this data a little to learn both SQL and PowerBI. From what I've seen, the generated purchases from suppliers are based on previously made orders by customers that have gone unpicked. However, 9 products seem to have unpicked orders from 2013 through to 2016 that seems to accumulate, leading to purchases on these stock items to keep increasing indefinitely. This issue was expounded when I ran the PopulateDataToCurrentData procedure.
Is this an issue on my end? I feel like these early orders should get picked at some stage and not be continually brought in to purchase calculations.
I am exploring this data a little to learn both SQL and PowerBI. From what I've seen, the generated purchases from suppliers are based on previously made orders by customers that have gone unpicked. However, 9 products seem to have unpicked orders from 2013 through to 2016 that seems to accumulate, leading to purchases on these stock items to keep increasing indefinitely. This issue was expounded when I ran the PopulateDataToCurrentData procedure.
Is this an issue on my end? I feel like these early orders should get picked at some stage and not be continually brought in to purchase calculations.