on 10-27-2011 6:52 AM
Hi All,
From which table, balance qty will be referred against Sales Order ?
So Qty - 100
Delivered - 30
Balance Qty - 70
Thanks,
Nandish Gowda K M
Hi Nandish,
You con't see the open quantity from one field,as per Mr.Raghu said you need to fetch the data from two fields and take the
difference quantity as open quantity.
pass the sales document no VBAP - KWMENG
pass the delivery no LIPS - LFIMG
difference between the two values can be considered as open quantity.
Check and revert
Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear nandish017
The balance quantity will not be stored in any table in the respective field as per my observation.
However you can get the balance quantity by
(VBAP-KWMENG) - (LIPS-LGMNG) = Balance quantity.
Please check it and revert
Thanks&Regards
Raghu.k
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nandish,
Please check table VBBE for open quantity againest a sales order.
Regards,
Dharminder
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.