I would like to know if there Sql Query to convert the quantities of Parent item to be Single item , i would explain it with an example
single item Itemlookupcode is 123456 and Qty 1
Parent item (outer pack of single item) like 6 cans of cola drink forms a pack which can be sold as single as well as pack item Itemlookupcode 123456-06 Qty 2
I need an sql query to produce result like 123456 QTY = 13 and 123456-06 Qty =0.
Formula = Qty of Single item + Number of pieces in a single pack * Qty of parent item
it would be great help that if it would be possible in sql