ItemID: 1
Item: Quartz
Qty_Recvd: 10

Date_Recvd: 06/10/2024

Again received same item from supplier

ItemID: 1
Item: Quartz
Qty_Recvd: 20

Date_Recvd: 06/12/24

Now I have
ItemID: 1
In total received quantity of 30

Now when I sell quantity of 10 in in single transaction and when I run query for total sold quantity, it should return 10 for total sold quantity of this particular item, but for some reason it returns 20, not sure why?
If that same item above (with same ID) was received just once in whatever quantity, then the query returns the true value of 10 for total quantity sold.
Bottom line, every item that was purchased once I get the true value for total sold quantity, except for the one’s that were purchased multiple times, the total sold value just gets double or triple depending upon how many times they were purchased.
Would appreciate any help with this issue. Thanks.

I just tried to explain what issue i have with running query and hoping someone will have the answer for it.