NurulScare
Member
- Local time
- Today, 12:30
- Joined
- Jan 6, 2021
- Messages
- 31
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 balance based on below:
Can someone Help me pleasee..
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 balance based on below:
Can someone Help me pleasee..
ITEMCODE | CUSTOMER | STOCK | USAGE | TO PURCHASE | Remark |
A | APPLE | 50 | 23 | 0 | Stock Balance 27 so No need to purchase because have stock |
A | LIME | 27 | 30 | 3 | Balance stock bring forward to next customer. Need to purchase 3 because not enough stock |
A | GRAPE | 0 | 10 | 10 | No stock anymore, so need to purchase another 10. |