P
pbuscio
Hi. I have two tables merged together by a query. One is an inventory tableand the other an open order table. The issue I am running into is duplicatine fields from the inventory table for every open order. For example:
PN Qty PO PO Qty
ABC 4 1234 1
ABC 4 5678 1
The issue is if I the do a sum or a pivot table afte exportation, the actual qty on hand is multiplied by the number of open POs. Is there a way to show what the remaining qty is? I tried a simple formula but for something like this I would get the remainder as 3 for each occurrence of this part. Any ideas would be great. Thanks
PN Qty PO PO Qty
ABC 4 1234 1
ABC 4 5678 1
The issue is if I the do a sum or a pivot table afte exportation, the actual qty on hand is multiplied by the number of open POs. Is there a way to show what the remaining qty is? I tried a simple formula but for something like this I would get the remainder as 3 for each occurrence of this part. Any ideas would be great. Thanks