Confirmed quantity is less than open quantity in sales order

[Former Member]

when i create a sales order the Cumm ATP quantity was less than the amount specified in the sales order, i checked my stock and i have enough stock yet my delivery quantity is less than my sales order quantity and if i maually try to increase the amount in the delivery to what i have in the sales order it gives a message only xxxxx available . what can i do?

[former_member223981 · Accepted solution]

Some of your stock is more than likely already committed to other sales orders. Make sure you are using CO09 to view the available stock rather than MMBE. (SAP Note 89362)

Also, if the availability check is executing at multiple levels, it will only confirm the lowest amount. So make sure you have enough available at storage location level, batch level Sloc/Batch level (If you are working with batches).

[Former Member]

Yes i ran it without the simulation flag on really not sure what it means either. i went to one of the old orders that were created but not delivered and reduced the quantity to zero. i observed that the cum qty increased a bit. still not sure if this is the remedy. i am very open to your suggestions.

[former_member223981]

Are any of these orders incorrect requirements? Run report SDRQCR21 (From note 25444) to see if any of these requirements should not exist. Again, this can be run in simulation mode (Do not turn on the flag Data Transfer) before running in update mode.

[Former Member]

Date MRP e Reqd Qty Confmd Cum ATP

01.09.2011 Stock 457

15.08.2011 CusOrd Totals record 20 - 0 0

19.08.2011 CusOrd Totals record 3,780- 3,780 0

30.08.2011 CusOrd Totals record 975- 300 3,323-

31.08.2011 CusOrd Totals record 150- 150 3,773-

-

---

End Lead Time

02.09.2011 CusOrd Totals record 65- 25

02.09.2011 SLocSt 0401 378 378

01.09.2011 SLocSt 0402 79 79

[former_member223981]

I cant explain that result i'm afraid.

Were the orders actually seleced in V_V2? after hitting execute, did they appear in the result list?

Did you run without the simulation flag on?

[Former Member]

Hi ,

Go and check it in MD04, as my knowldge some stock already pegged with some other orders, because of that reasion you can't pick completely.

Thanks

Raja

[Former Member]

i ran transaction v_v2 and now what i have is Req / rec qty Confirmed qty

02-09-2011 457

- -

- -

- -

02-09-2011 65- 25

i still have the dates 15th -31st inbetween the 2 dates, but now i have 65- and 25 ,please how can i further correct this?

[former_member223981]

But what is wrong with the -65? Is this in the Cum ATP Qty column? Or in the Rec/Req Qty?

Perhaps paste the full CO09 like before.

Edited by: Noel Connolly on Sep 2, 2011 3:02 PM

[Former Member]

Thank you so much for your contribution, kindly tell me how to make use of V_V2 to correct the situation.

[former_member223981]

Transaction V_V2 will unconfirm everything, then go about assigning the confirmed quantities again. Therefore, it should correct the overconfirmation situation.

Enter the material & plant and hit execute. After that, you should not see a negative quantity in CO09.

You can run V_V2 in simulation mode too before running it in update mode.

Generally, earlier documents will get precendence on getting the confirmed quantity. However, you can change this in the sorting section, for example so that delivery priority gets considered first.

[Former Member]

Date MRP e Reqd Qty Confmd Cum ATP

01.09.2011 Stock 457

15.08.2011 CusOrd Totals record 20 - 0 0

19.08.2011 CusOrd Totals record 3,780- 3,780 0

30.08.2011 CusOrd Totals record 975- 300 3,323-

31.08.2011 CusOrd Totals record 150- 150 3,773-

01.09.2011 SLocSt 0401 378 378-

01.09.2011 SLocSt 0402 79 79

I have put the text above for your use, so you can now help me out, i hope to hear from you soon.

[former_member223981]

Ok, you have 457 in stock; this is the total amounts refelected in the receipts field that you can see.

But look at the customer orders you have on 19.08.2011, 30.08.2011 & 31.08.2011. Here you have already confirmed over 3000! Therefore, you are left with an incorrect availability situation; i.e you have a negative quantity. A negative available quantity can occur in the standard system (You post a goods receipt to insert stock, create a sales order, sales order is confirmed against the goods receipt. Then if you cancen the goods receipt, the sales order remains confirmed and you have a negative ATP quantity. See Note 153355).

Running transaction V_V2 should correct the current CO09 situation. Clearly you have more requirements than receipts at the moment, so if you want to ensure one order gets the 457 quantity before another order, you should assign it a higher priority in VA02.

Hope this helps.

[Former Member]

Date MRP e Reqd Qty Confmd Cum ATP

01.09.2011 Stock 457

15.08.2011 CusOrd Totals record 20- 0 0

19.08.2011 CusOrd Totals record 3,780 3,780 0

30.08.2011 CusOrd Totals record 975- 300 3,323-

31.08.2011 CusOrd Totals record 150- 150 3,773-

01.09.2011 SLocSt 0401 378 378

01.09.2011 SLocSt 0402 79 79

I have put the text above for your use, so you can now help me out, i hope to hear from you soon.

[Former Member]

i have tried to copy and paste it in this screen but i couldnt , can u send me an address to send it to so you will see the full view.

[former_member223981]

I dont need a screenshot; just copy and past ethe text part of CO09. It should be possible.

[Former Member]

i have checked the receipts field and it is 457 as well

[Former Member]

Hi pls take help of your MM consultant and get some stock posted using movement type 561 for the material.

Regards

Raghu.

[Former Member]

Ok thanks, i just used CO09 and discovered that the confirmed quantity and the cummulative ATP quantity are 0 while the Rec/rqd quantity is 457. How can i rectify this so that the confirmed quantity and cummulative ATP quantity will change from 0 to 457.

[former_member223981]

"Ok thanks, i just used CO09 and discovered that the confirmed quantity and the cummulative ATP quantity are 0 while the Rec/rqd quantity is 457. How can i rectify this so that the confirmed quantity and cummulative ATP quantity will change from 0 to 457"

This means you have a requirement of 457. How do you want the system to cover this requirement of 457? Do you already have stock in the system? If so is this stock already commited to other sales orders? You should be able to see this in CO09 also (Check the confirmed quantity for the other sales orders).

At the top of the CO09 screen, there is a Receipts field; What is the value in this? Is it over zero? This must be over zero to confirm the quantity. If it is zero, you need to create stock or receipts (Production orders, planned orders, purchase orders etc.) in your system.

[former_member223981]

Can you copy and paste the CO09 information into this thread? This will help me determine exactly what is going on in CO09.

[Former Member]

like already mentioned MMBE doesn't give the right picture its always CO09.

Pls check.