Skip to Content
0
Former Member
Feb 04, 2014 at 05:08 AM

Create a single record for main and batch split item in LIPS

253 Views

Hi all,

I am having a problem wherein, in LIPS if there is batch split then I need to add the summation of all batch split item quantity to main item and show in one record only.

Like for Delivery 2000089 there are 2 main items 10 and 20 with quantity (LFIMG) 2 and 4.

For Item 10 there are two batch split item with quantity 50 and 50.

And for item 20, 3 batch split item with qunatity 20 30 40.

So now I want only two record in my final LIPS internam table as there are only two main item and qunaity for first records should be (first main item quanity + batch split quantity - in this case it should 2+50+50) and for second record quantity should (4+20+30+40).

Can you please suggest how to do the coding for this? Is there any common field?

Do not go with whether quantity will be zero in main item when there is a batch split.