Hi,
From below example, I have 2 tables:
1. Stock Balance by Item Code
2. Usage by Material Code & Customer
Thus, I want to make query to get how many more need to purchase based on stock on hand minus Usage.
Below example is, I have different customer SHARE same item. so I want to get...