on 03-02-2013 6:11 AM
Dear Experts,
I am trying to calculate open order quantity for a SO, from searching previous threads i came to know that it can be found in table VBBE, but in my case this table VBBE is not getting updated for the SO.
i have checked the item category in VOV7 and also Availability check field in Material Master, in both places correct entries are maintained. ( schedule lines allowed in item category and availability check = 2 in material master )
so what i am missing so that the table VBBE will be updated for the all SO's
Regards
Ashutosh Singodia
Hi,
Have you tried for VBEP table there you can find the Order Qty and Delivered Qty.
So you can calculate it and accordingly open order qty will be fetched.
Thanks,
Suman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
I have to display open order quantity in sales register, so here input is billing document, and when system searches delivery against that billing document, it can show the open quantity for the order, now problem starts when there are multiple line items in billing for a SO or multiple bills are there for a SO.
suppose i have SO qty as 100, and one delivery of 10, another is for 20 and separate billing document for each delivery, so for the first billing it shows open order qty as 90 which is correct but for the second billing is shows open qty as 80 which is wrong, ( actual open order qty is 100 - ( 10+20) = 70 )
Hi,
Hope you can also check the same in VA05-- Open orders.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.