Not able map exact delivered quantity into order tracking report

[former_member584050]

Dear Experts,

I have an order 10155555 which is having 400 quantity in line item 10 theese 400 quantity is spitted into 3 shedule lines as shown below

With reference 10155555 line item 10 we have created two deliveries

We have report called order tracking report in which we have an issue above two deliveries created with reference to same order and same line item 1st delivery is with 100 quantity and second delivery with 300 quantity in the report to get the delivered quantity there is a logic order number and its line item passing to LIPS fro LIPS table we are getting delivered quantity but in the report two delivered quantities are shown double value because they were created with same shedule line.. due to this 1st delivery showing the second delivery quantity and second delivery showing the 1st delivery quantity like below.

Could you please suggest logic to remove duplicate quantity.
Regards
Kumar

[former_member193808]

Hi,

That will not be an easy task to show at schedule line item details, if your report is complex. However, you need to link with VBEP table, if you want to show Schedule line item details.

In VBEP, you have the schedule line item with the necessary date(s) and quantities to match with LIKP / LIPS. This will resolve the conflict.

Thanks

Prem