Skip to Content
0

LIS Report (MTCA) shows wrong data (incorrect material qty) in Incoming Orders column

Apr 10, 2017 at 11:42 AM

99

avatar image

Good evening all,

LIS Report (MTCA) shows wrong data (incorrect material qty) in Incoming Orders column. Because it is not equal to the material qty in sales order or invoice.

Kindly visit the below link and click on LIS shows double, triple the data to see system behavior captured in word file:

https://mmakweb.wordpress.com/

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jürgen L
Apr 10, 2017 at 12:13 PM
1

In your subject and in the beginning of your question your talking about double value, and then you post a F1 help about quantity and ask how you can get the quantity in sales order unit.

Is the upper and lower part of the question related to each other or are these 2 different questions.

Show 6 Share
10 |10000 characters needed characters left characters exceeded

Hi Jurgen,

There is only one question, how to change incoming order quantity?
It was the drill down option, which helped me to get to know the sales order quantity in LIS is doubled than the actual sales order qty, so I updated the message.

0

would it possible for you to add screenshots which show that the quantity doubles.

It is not yet clear if it doubles from one screen in the drill down to another one, or if you have double quantity in LIS compared to another statistic, or just a kind of "double quantity" because your base unit is LBs while the order unit is KG

0

Hi Jurgen,
Please find the attached 6 images.

0

I know Easter is around, but searching is not my aim - where are the pictures?

1

Hi Jurgen,

Kindly find the below link to see the word file directly.

https://mmakweb.wordpress.com/

Once u visit this link, click on LIS shows double, triple the data to download and view.

0

Or you may directly click on the link to download LIS shows double, triple the data

0
Jürgen L
Apr 11, 2017 at 02:29 PM
1

The screenshots have not been able to convince me about an error.

The info structure captures information from multiple sources, e.g. sales orders and invoices.

In your case it is not standard by period, it is customized to be by date.

Anyhow, it means you have 1 record in the info structure for the combination of date and customer which collects data from sales orders and invoices.

If you enter 2 sales orders from customer 100006 and send him 1 invoice for a totally different business case on the same day (e.g. on January 17) then this single record in the info structure is updated from both sales orders and this single invoice, and has the total from both objects.

Based on this I would investigate table VBAK and VBAP for entries regarding this customer 100006 with a document date of January 17 (this is just based on the assumption that the update rules are still standard bei ERDAT creation date)

Share
10 |10000 characters needed characters left characters exceeded