Show Pick List Number(s) on Customer Order form

unknown

I am thinking surely someone has already done this?  I want to be able to see the Pick List Number(s) for an order either on the Customer Orders or Customer Orders Line form.  There is a field "Picked" that shows on Customer Orders, but it only has a value after an item has been Pick Confirmed.  I want to know if a Pick List has been created and if so, what that Pick List number is.

unknown

Below are the general steps you would follow:

• Add a secondary collection to the form for IDO SLPickListRefs
  • Change the Permanent Filter for the secondary collection to be: RefNum=FP(CoNum)
• Add an Event Handler for StdObjectSelectCurrentCompleted to refresh the new collection
  • Make to set this event to only fire for the Primary Collection
• Add a new tab for "Pick Lists"
• Add a grid to the new tab
• Bind the grid to the SLPickListRefs IDO
• Add the columns from SLPickListRefs that you want displayed to the new grid

This should work for Customer Orders or Customer Order Lines. For Customer Order Lines, you will want to add " AND RefLine=P(CoLine)" to the permanent filter to just get the Pick Lists associated with the current CO Line record.