transaction report

[deepucec9]

Would like to create a transaction report for warehouse inventory.
there are two table "in" (records data of product coming into the warehouse) and "out" (product going out from the warehouse)
"in" fields produtcid-productname-quantityin-uoqin-ROSdate-transaction(default value IN)-ponumber
"out" fields produtcid-productname-quantityout-uoqout-ROSdate-transaction(default value OUT)-ponumber
want to create a report report for stock movement, say between ROS date range.


selected all these fields and created the product but report is showing duplicate entries.
For example: productA, when this product comes into the warehouse and when it was exported from the warehouse.
In a week this product might come multiple times and also exported multiple times.

[June7]

Do two aggregate (GROUP BY) Totals queries that summarize the records of the two tables by product.

Join those two queries to Products table and do calcs for net difference.