cancel
Showing results for 
Search instead for 
Did you mean: 

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

ali-sd
Active Participant
0 Kudos

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/

Accepted Solutions (0)

Answers (2)

Answers (2)

JL23
Active Contributor

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)

JL23
Active Contributor

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.

ali-sd
Active Participant
0 Kudos

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.

JL23
Active Contributor
0 Kudos

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

ali-sd
Active Participant
0 Kudos

Hi Jurgen,
Please find the attached 6 images.

JL23
Active Contributor

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

ali-sd
Active Participant
0 Kudos

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.

ali-sd
Active Participant
0 Kudos

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