2021 Sep 25 2:55 PM
Dear Experts,
I am using Packaging size 10000 in my select query for sales order table I am getting results like this
line.no Sales.ord Item no.
9997 10009 10
9998 10009 20
9999 10010 10
10000 10010 20
In next iteration:
line.no Sales.ord Item no.
1 10010 30
2 10010 40
But my requirement is Sales order(10010) with multiple items should not split. Can anyone suggest how to achieve this ?
Regards,
KKS.
2021 Sep 25 3:12 PM
You don't really have the choice. Either you do this:
SMALLER PACKAGE 1
line.no Sales.ord Item no.
...
9997 10009 10
9998 10009 20
PACKAGE 2
line.no Sales.ord Item no.
1 10010 10 ┐
2 10010 20 ├──── sales order 10010
3 10010 30 │
4 10010 40 ┘
5 10020 10
...
or this:
BIGGER PACKAGE 1
line.no Sales.ord Item no.
...
9997 10009 10
9998 10009 20
9999 10010 10 ┐
10000 10010 20 ├──── sales order 10010
10001 10010 30 │
10002 10010 40 ┘
PACKAGE 2
line.no Sales.ord Item no.
1 10020 10
...