Our client uses mostly scheduling agreements and these are carried forward from long time since 2007. They are using a custom report to see the open schedule lines for each agreement.
I am supporting this client recently from last one month only.
Business recently reported the open order reports are not showing correctly, i mean to say is it is not showing the latest schedule line, instead it is leaving few schedules and showing. Why?
After doing analysis and debug, it is observed that the scheduling agreement has negative cumulative quantity in the deliveries tab, this became positive after few deliveries. The report is calculating based on the cululative issue quantity of SA, in agreement now it is shown as 374, as the negative qty is showing -200(178+del 22) , in run time it is taking as 574 and omitting few schedules.
I understood that these are in beginning of the SA, and might be loaded from a legacy to SAP. If so why and how we will have negative cumulative quantity? it should be positive only as per my knowledge. In LIPS table these are showing as normal values only.