I prepared a cross tab which need to display the item no, description, pur/sales price and the inventory qty.
e.g.
Item Description PurPrice SalesPrice WarehouseA
WXYZ sample item 0.5 3 20pcs
ABCD example 1.5 6 40pcs
For actual inventory qty, WXYZ is 5pcs and ABCD is 10pcs. However, It sums the actual qty 4 times.
Do you guys know how it could be fixed ?
Thank so much!