cancel
Showing results for 
Search instead for 
Did you mean: 

Confirmed Qty incorrectly updated thr SDV03V02

former_member287204
Participant
0 Kudos

Hi experts,

Found that one Sales Order (refer SO as below) confirmed Qty was incorrectly updated from 1200 to 0 after our daily scheduled job - "SDV03V02" run this morning.

Details in Material Requirement List are as below -

1) Sales Order (SO) with Qty 1200; The SO was created on 11.07.2013 and Required Delivery date is 29.07.2013.

2) Production Order with Qty 1200 (to cover the SO); The Production Order was created around 12.07.2013, Order Start date is 12.07.2013, Order Finish date is 16.07.2013 and confirmed Production Order date is 29.07.2013 (960 Qty) and 30.07.2013 (240 Qty but confirmed after the scheduled job of this date).

3) Quotation with Qty 8; The Quotation was created on 25.07.2013 and Required Delivery date is 12.09.2013.

4) Planned Order with Qty 8 (to cover the Quotation); The Planned Order was created around 26.07.2013.

The confirmed Qty had ever been updated for the SO from 0 to 1200 on 12.07.2013, but incorrectly updated from 1200 to 0 on 30.07.2013.

Could you advise the cause and solution of the above problem ? Pls let me know if you need more info.

Tks,

KH Fong

Accepted Solutions (0)

Answers (2)

Answers (2)

Lakshmipathi
Active Contributor
0 Kudos

If the sale order is blocked for credit release, then stock will not be confirmed to that sale order.

G. Lakshmipathi

former_member287204
Participant
0 Kudos

Dear all,

Attached screen is the setting of SDV03V02 which is scheduled every morning at about 0800. Pls review it first and advise if any idea to solve my above issue.

Tks,

KH Fong

former_member287204
Participant
0 Kudos

Hi DB49 and all experts,

Answer to DB49's questions of the 1st paragraph -

How many schedule lines did this sales order item have before rescheduling?  ANS: Normally one unless full Qty cannot be confirmed after ATP check. Then, will be more than one.

How many schedule lines does it have now?  ANS: One for my above docs.

What happens when you re-ATP the Sales order right now (VA02)?  Does it confirm?  How many schedule lines does it propose during the ATP check?  Does the full item quantity confirm, or does some of the item remain unconfirmed?   ANS: When re-ATP the Sales order, only 1192 of 1200 Qty can be confirmed (less 8). DB49's questions of 2nd - 3rd paragraphs should be irrelevant.

Also, I found some more info. as below -

For the setting of SDV03V02 as above screen, I found the 1st considering factor is "Delivery Priority" and the 2nd considering factor is "Item Creation date". I also found the "Delivery Priority" of my above Sales Order item and its Sold-to party was "0 (Blank)", while the "Delivery Priority" of my above Quotation item and its Sold-to party was "1 - High". Therefore, the Qty 8 was occupied first when the Quotation item had been created. Even if the Creation date of the Quotation item (25.07.2013) was later than that of the Sales Order item (11.07.2013), system still arranged to confirm Qty for the Quotation item first. The Planned Order with Qty 8 was actually generated (by MPS) for the SO item.

Could you advise whether my above understanding is correct ?

Tks,

KH Fong

Former Member
0 Kudos

KH,

DB49's questions of 2nd - 3rd paragraphs should be irrelevant.

A bold statement indeed.

Anyhow, check the default setting in OVZJ.  If you have set "Avail.check rule" to anything other than 'E', you could get the symptoms you have described.

Best Regards,

DB49

former_member287204
Participant
0 Kudos

Hi DB49 and all experts,

Q1) As DB49 advised "all ATP investigation should start in CO09" which is required to input the "Checking Rule, which "Checking Rule" should be relevant ? The default one is "BO - Backorder Processing" and should I use this "Checking Rule" ?

Q2) After some testing, I found the 1st considering factor - "Delivery Priority" and the 2nd considering factor - "Item Creation date" were not the cause of updating the confirmed Qty from 1200 to 0 in Sales Order, but may be due to the following two factors (or either one factor) -

a) "Availability" unchecked for customed Schedule line cate. - "ZN - with MRP from BN" for "Quotation" (Refer the above screen). Therefore, all quotations created are automatically confirmed and considered as higher priority than the Sales Order even if there is not enough stocks or not enough qty in planned order(s) or production order(s) to replenish. Is it correct ?

b) "Unconfirmed documents required" was somehow unchecked for the setting of SDV03V02 (though it was checked in the variant of our scheduled job like the above screen). One question is - "IF this checkbox is checked, does it mean that the Sales Order confirmed qty will NOT be updated to "0" (for the case of not enough stocks / qty in MD04) ?" Another question is - "IF this checkbox is not checked, does it mean that the Sales Order confirmed qty will then be updated to "0" (for the case of not enough stocks / qty in MD04) ?"

Could DB49 and/or other experts answer my above question ?

Tks,

KH Fong

Former Member
0 Kudos

KH,

a) "Availability" unchecked for custom Schedule line category - "ZN - with MRP from BN" for "Quotation" (Refer the above screen). Therefore, all quotations created are automatically confirmed and considered as higher priority than the Sales Order even if there is not enough stocks or not enough qty in planned order(s) or production order(s) to replenish. Is it correct ?

Your config for ZN indicates that the ATP will not be performed for orders containing this SLC.  However, the "Req Assembly" checkbox means that requirements for these orders are transferred.  Therefore OTHER order types that do use ATP will have to compete with these orders for supply elements during their ATP checks. 

ATP in general does not have 'priority', all requirements are generally considered equally.  When you ATP a ZN order, it will automatically confirm.  When you ATP, say, a 'CP' order, it will only confirm if there are sufficient supply elements to cover all the demand elements, including the demand elements generated from ZN orders.

b) "Unconfirmed documents required" was somehow unchecked for the setting of SDV03V02 (though it was checked in the variant of our scheduled job like the above screen). One question is - "IF this checkbox is checked, does it mean that the Sales Order confirmed qty will NOT be updated to "0" (for the case of not enough stocks / qty in MD04) ?"

Not in and of itself.  "Unconfirmed docs required" checked means that fully confirmed documents will be skipped - they will not be checked.  Such docs cannot lose their confirmation during the rescheduling run.

Another question is - "IF this checkbox is not checked, does it mean that the Sales Order confirmed qty will then be updated to "0" (for the case of not enough stocks / qty in MD04) ?"

Not necessarily.  It does mean that all previously confirmed documents will be rechecked.  If, when they are rechecked, and the available quantity is then calculated to be "0", the order item schedule will be unconfirmed, and the confirmed quantity will be changed to "0".

Best Regards,

DB49

Former Member
0 Kudos

Hi KH Fong,

With ref to your points 3 & 4 :

In an ideal scenario, quotations will not have Requirements passed to the Logistics modules.

Regards

former_member287204
Participant
0 Kudos

Hi,

Sales quotation is created from VA21 and will be found in MD04.

Tks,

KH Fong

Former Member
0 Kudos

Hi KH Fong,

Please let me know on what Item Cat., (VOV7) and its associated Schedule Line cat., (VOV6) that you are using (If standard, Else please share the screen print for the Schedule line category settings).

Please note in a standrad scenario, and even in SAP, the requirements would not get transferred to the other Logisitics modules. The LOGIC reason is that @ Quotation level we will not knwo that whether we will be able to do the business with the concerned party.

Please let me know for any further clarification.

Regards

former_member287204
Participant
0 Kudos

Dear

Former Member
0 Kudos

Hi,

Please make me understand on why do you want to transfer the requirements at quotation level. ven if i agree that, why again @ Sales Order level you are apassign the requirements Implies Double entry of requirements.

To rectify your issue:

Please follow the below steps:

Please check the change log of the sales order and let me know for any scehdule line changes.

Please confirm whether any Reschdeuling (V_V2) transaction is being used ?

regards

Former Member
0 Kudos

Raj et al

The quotation seems to me to be mostly irrelevant to KH's original problem.  He wants to know why the entire original Sales order item schedule was unconfirmed during SDV03V02 (which is the program called by V_V2).  At worst, the quote should normally have reduced the total Sales order item confirmation quantity only by 8 pieces.

KH,

You have not supplied enough information.

The answer would differ, based upon Scope of check, settings for the rescheduling check, and settings for cumulation of requirements.

How many schedule lines did this sales order item have before rescheduling?  How many schedule lines does it have now?  What happens when you re-ATP the Sales order right now (VA02)?  Does it confirm?  How many schedule lines does it propose during the ATP check?  Does the full item quantity confirm, or does some of the item remain unconfirmed?   

In general, all ATP investigation should start in CO09.  Does the production order show on CO09?  Is there any stock showing available on CO09?  Is the Production order relevant for ATP (scope of check)?  Are there any other requirements in CO09? Are the Sales order and the production order relevant for the same storage location?  What is the Material Master MRP type and (optionally) MRP strategy?

Have there been any stock transactions since the sales order was originally confirmed (MB51)?  Have there been any production or purchase orders added or cancelled since the sales order was originally confirmed?  Have there been any sales requirements added or cancelled since the original sales order confirmation?

Best Regards,

DB49