Looking at the Stock table, I see that I have a lot of cases where a product is listed multiple times with a different STOCOU number. Everything else is identical (except for the quantities).
For example: Product (ABC), STOCOU#, Bin Location and Qty.
ABC 3837838 W180 25
ABC 3815780 W180 5
ABC 3802076 W180 1
ABC 3835948 W180 1
ABC 3641630 W180 1
I checked STOALL to see if anything is allocated to these STOCOU numbers and none of the were in there. Is there a way to combine these 5 records into 1 record with QTY of 33?
Thank you for your help!