Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unpicked sales in WorldWideImporters database causes purchases to increase indefinitely? #1262

Open
CallananD opened this issue Feb 28, 2024 · 0 comments

Comments

@CallananD
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant