on 04-08-2014 5:58 AM
Hi gurus,
Due to sales org change in production some of the orders got over commit by ATP check.
By doing re atp check manually order quantity is getting corrected.
How to find list of affected orders.
Inputs are highly appriciated.
Thanks,
Bala B.
Hi Bala,
By 'over commit' if you stock gets blocked wrongly then you may run program SDRQCR21 for Recovery sales and delivery requirements to free the wrongly blocked stock.
Take care of the check box 'Data Transfer'.
Best regards,
Suman K Bhowmik.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Why over-commit?
Normally system confirms the quantity based on the scheduling(either backward/forward)
If the order quantity is 10 and there is only 5 qty available then system confirms the remaining qty by doing forward scheduling.
from your screen shot it is clear that (take example-24 line item the order quantity is 2 and initially there is no available Qty so schedule line number 1 shows ZERO and has been confirmed in the subsequent schedule line numbers..
Can you please confirm what was the issue make you think like above??
Phanikumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lakshmipathi,
Thanks for the reply. But it is not giving me problem identification.
Can you pl help me in identifying or compare requested qty in main item and total sub line item quantity generated is more than requested qty.
Then it can be more helpful.
Thanks,
Bala.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bala,
Relationship between main Item and subitem can be found in VBAP-UEPOS. In general, if this field is empty, then it is a main item (or there are no subitems). If there is an item number in this field, it indicates that this item is a subitem, and the item number contained here is the related main item.
Best Regards,
DB49
Hi,
It is quite an unusual behavior of the system. However if you say that running ATP again corrects the order then you may consider running ATP on all open orders or orders which the business needs to execute in near future in the background.
The below link should help you do this.
Availability check and update in sales order. | SCN
Best regards,
Suman K Bhowmik.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi DB49,
For line 20 subline items were created upto 32. Due to batch job line 34 got created and committed.
Now job is not able to correct it. Only manul ATP is successful.
It is removing the line item 32 and 34 and giving commit for 5 qty in line 30 itself by changing requirement qty to 5 from earlir req. qty 4 for the sub line item.
We want to identify these orders or requirement qty deviations from order qty. So that we can manulaay update these orders.
Thanks,
Bala.
Hi,
To eloborate the issue more in parent line requirement given as 12 qty. Child lines created for requirement qty 17. commit is given for 12 qty only. How to identify all the wrong orders.
Thanks,
Bala.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes you can achieve the desired result in SQVI. What you can do is let the input parameters be
and the output be
You can get all the above fields from VBAP but for the last one which is available in VBEP. If you dont have the sale order references, then consider adding VBAK also where you input Sales Document Type, if need be.
G. Lakshmipathi
Bala,
To elaborate the issue more in parent line requirement given as 12 qty. Child lines created for requirement qty 17. commit is given for 12 qty only. How to identify all the wrong orders.
I am not seeing this. Parent line quantity for item 20 is 12. The confirmations you have highlighted are for other items. Items in the same order are normally unrelated. Are these to be considered subitems under Rules-based-ATP, or a similar ATP check that creates subitems?
Best Regards,
DB49
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Due to sales org change in production some of the orders got over commit by ATP check
Sorry not able to get you. Do you mean, sales area has changed? If so, how the existing orders got over confirmed? Ideally, you must be aware, for any configurational change, you must foreclose all open sale orders and create a new one. Let me know if system is not performing ATP for the newly created orders.
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lakshmipathi,
Sales Ordg change in the sence some of the values of sales org are changed.Not complete sales area change. There are thousands of sales orders open and it is necessary for reorg. ATP check is happening now also.
But we need to drag all the orders where over confirmation happend.
So, that atleast we can update orders manually or with a program.
Thanks,
Bala.
In VBEP table, you can see both these fields, viz.Order quantity and Confirmed quantity. So once you execute this table, wherever system shows the confirmed quantity in excess of order quantity, you can correct it. But still, I am unable to understand as to why system is behaving the way you had indicated.
G. Lakshmipathi
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
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.