We currently print a barcode (on header level) on our picking sheets, I am trying to insert a formula into the report to fill in the background color yellow if any line items on the report contain a value greater than 0 in "UDF_QTY_PULLED" field on the line level. One caveat, is I only want to look at regular items, ItemType =1. I thought it could be a simple code but I think I need to look at all the lines. Any itemtypes <> 1 I have a script populating the UDF_QTY_PULLED with the orderqty, so all those items will always have a qty in that field. That is the reasoning to try to filter those out.
IF {SO_PickingSheetWrk.ItemType}="1" and {SO_PickingSheetWrk.UDF_QTY_PULLED}<>0 then crYellow else crNoColor