Grouping Kit Component items on a Pick Sheet

SOLVED

In SO entry a bill type of kit always explodes on the sales order and we have "include kit items on picking sheets" checked in SO options. Have a request for the picking sheet to print and group all kit component items first followed by any other items not part of a kit. Can't seem to find the best way to do this and would welcome suggestions. Was thinking subreport but it's just not working out. (v2021) Thanks.

Parents Reply
  • 0 in reply to BigLouie

    Delete all groups?  I'd try adding a group for the component flag between #2&3... that way you don't have to redo the page break logic.

    I completely agree though... not easy to do properly, if this simple step doesn't get the desired results.  Structural changes to forms get complicated quickly.

Children
  • +1 in reply to Kevin M
    verified answer

    My colleague got this to work.

    Created a formula: 

    if ({SO_PickingSheetWrk.ExplodedKitItem}="N" and {SO_PickingSheetWrk.SkipPrintCompLine}="N" and {SO_PickingSheetWrk.StandardKitBill}="N") then
    totext("2") + totext({SO_PickingSheetWrk.LineSeqNo}) else
    totext("1") + totext({SO_PickingSheetWrk.LineSeqNo}) 

    Inserted a new group and grouped by this formula.