Has anyone found a successful solution for changing the order that items appear on a pick list? I have a client that is using numeric itemids (1, 100, 1000, 2, 200, 2000, etc.) They need the pick list to print 1, 2, 3, 100, 200, 300; however, because the ItemId field is alphanumeric the items are sorted by 1, 100, 1000, 2, 200, 2000, etc. This is creating a nightmare since their items are on the racks in numeric order. All of their finished goods items are in the same bin.
Short of creating a separate bin for each item so that we can pick by bin, is there another easy option? We have looked at changing the ItemID field to numeric, but the implications there are horrific.
Is there a way to change the Crystal Report?
Thoughts?
