Question Re: Inconsistency in confirmed qty at schedule line level in a sales order. in Enterprise Resource Planning Q&A

Inconsistency in confirmed qty at schedule line level in a sales order.

ali-sd — Thu, 30 Aug 2018 11:29:12 GMT

Dear all,

Please guide me for below issue.

AS-IS
Inconsistency in confirmed qty at schedule line level in a sales order.
Replicable data - ref PRD SO (123456) which has many items, most of them have been delivered fully except 2nd and 3rd items were delivered partially.

2nd item has 1000 qty, where user first partial delivered 405 qty, but its respective schedule line shows confirmed qty as 173.

Only after carrying out availability check for 2nd item, this confirmed qty gets corrected to 405 qty (from 173)

This behavior of SAP is impacting the open delivery report (Table VBEP - showing incorrect data). This report’s data can not be validated.
But VBEP shows the same incorrect data (173 qty) before carrying out availability check. After carrying out availability check, VBEP shows 405 qty.

How to fix this issue?
Or is there any table where I can find absolutely correct qty data?

Re: Inconsistency in confirmed qty at schedule line level in a sales order.

jpfriends79 — Thu, 30 Aug 2018 12:08:31 GMT

Did you try looking at MD04 for the give material or in Sales Order -Item - Item Data - Environment (Menu bar) - Availability?

Forget to check the change log for the item. This to know, whether the confirmed quantities were changed by a system user or a user manually.

Thanks,
JP

Re: Inconsistency in confirmed qty at schedule line level in a sales order.

Lakshmipathi — Thu, 30 Aug 2018 12:21:20 GMT

There is no correction report to the best of my knowledge. Raise an OSS message and take the help of SAP to rectify this issue permanently.

Re: Inconsistency in confirmed qty at schedule line level in a sales order.

ali-sd — Mon, 03 Sep 2018 05:34:07 GMT

Dear Jyoti Prakash,

Please refer MD04 screen. Yellow highlighted is my sales order.

I am confused on how to link these columns (Receipt/Reqmt & Available Qty) with the columns in sales order (Confirmed Qty and Delivered Qty). Also, order qty for 2nd item is 1000 qty but I think receipts are only 595 qty. Please guide on my confusion and particularly on the issue.

Re: Inconsistency in confirmed qty at schedule line level in a sales order.

jpfriends79 — Mon, 03 Sep 2018 10:08:47 GMT

Check my response in the screenshot.

Thanks,
JP

Re: Inconsistency in confirmed qty at schedule line level in a sales order.

ali-sd — Mon, 03 Sep 2018 10:33:00 GMT

Thanks a lot JP sir.

But the order qty is 1000 but not 595. I am surprised how come system shows 595 in Receipt/Reqmt column!
Please refer the order qty in sales order.

Re: Inconsistency in confirmed qty at schedule line level in a sales order.

Lakshmipathi — Mon, 03 Sep 2018 11:04:55 GMT

Have a look at OSS note 1888035

Re: Inconsistency in confirmed qty at schedule line level in a sales order.

jpfriends79 — Mon, 03 Sep 2018 12:35:50 GMT

Until I see your Schedule Line for the Item, I can't help you.

It seems like screenshots provided by you in your initial question, is different from screenshot provided for MD04. As quantities don't match.

Moreover, I would suggest using VA03 - display, instead of VA02 for providing "Screenshots".

Please update the requirement type used in the transaction.

Thanks,
JP

Re: Inconsistency in confirmed qty at schedule line level in a sales order.

ali-sd — Tue, 04 Sep 2018 05:07:40 GMT

Dear JP sir,

Please find the below VA03 images

First screen in VA03

This is Req Type details

This is Schedule lines details

Now, lets the see the schedule lines behavior after running availability check.
This is change mode screen, highlighted the 2nd item and clicked (Clicked item availability)

If I click Continue

Below is the scheduled line behavior

If I run availability check and click Dely proposal for 349

Below is the scheduled line behavior

Please guide.

Re: Inconsistency in confirmed qty at schedule line level in a sales order.

jpfriends79 — Tue, 04 Sep 2018 08:51:50 GMT

First, this MTO order.

As per the last screenshot,
Order Qty = 1000
Delivered = 405
Confirmed = 349
Backlog Quantities (yet to be confirmed) = 246

So, you need to ask PP guy, why in phases the MRP is running for the material?

Moreover, if you can edit confirmed qty in delv proposal screen, then why didn't match that with open order qty.

Thanks,
JP