Skip to Content
0
Former Member
May 24, 2013 at 09:35 AM

Count on Sales Document and Item

34 Views

Hi Experts ,

I need some help on the following scenario . I have a report Open Orders , which will be based on Sale Quan greater than Delivered Quan . Data in Backend

Comp Code Sales Order Sales Item Delivery Order Delivery Item Sales Quan Del Quan
1600 100 10 1 10 5 2
1600 100 10 2 10 5 3
1600 200 10 3 10 8 2
1600 200 10 4 10 8 5


As you can see data in backend is at Delivery Order Level (multiple Deliveries for a single Sale Order) . What I need the report to do is it should consider the Sale Order 100 , Sale Quantity as only 5 (though exists as two records) and compare with Delivery Quantity 5(2+3) and decide it as not open order .

For Order 200 , it should compare Sale Quantity 8 with Delivery Quantity 7 (2+5) and give it as open order .

Issues I face are only Company Code level of data should be displayed in report . Also sale order quantity should not summarize eg consider Sale Order 100 and Item 10 (first two records) , it should consider only 5 not (5+5) . I tried many ways through codes in backend , but in vain . Please help me out on this .

Text removed by moderator

Message was edited by: Matthew Billingham