Thank you thank you! I'll check this out tomorrow and report back.

Hi Brian, We ended up writing a workflow that runs every 30 minutes. The workflow criteria identifies sales orders that have been printed, fulfilled, and have items that still need to be fulfilled on them. We created a new field called "back order status" on the sales order and the worflow changes that field to "Pending…

Hey Patrick, Weirdly enough we stumbled upon the source of the problem. It has to do with our address form I think. The customer is Canadian but when I went in to edit the address on the customer record for some reason the Province wasn't populated even though it was showing in the preview. I updated the address and voila,…

Thank you for confirming I had the right field and I am using the correct notation so looks like I have some more troubleshooting to do... thanks!