Pick Slip Grouping based on the Order+Item
The requirement is to Print Pick Slip report by grouping the lines with same items in a sales order.
Pick Slip Grouping rule has been created with Group By: Order Number + Item. Refer below example:
Order Number | Line# | Item | Quantity |
|---|---|---|---|
100 | 1 | ABC | 3 |
100 | 2 | ABC | 2 |
100 | 3 | DEF | 3 |
Expectation is that Pick Slip report should have only 2 lines as mentioned below:
Line | Item | Qty |
|---|---|---|
1 | ABC | 5 |
2 | DEF | 3 |
Please suggest how to achieve this requirement.
Tagged:
0