Hi,
I have a few scenarios where I need to know if a sales order has back order items on it. My dilemma is that a back order quantity is a line item level field and not on the main line level. I have one saved search reminder that is called Past Due SO Lines Pending Fulfillment. I want to use this reminder as a way of putting high priority on orders we have missed and it is now shipping late. We have some customers that don't want us to ship the order unless we can ship the whole order. We call this "Ship Complete". If the sales order has any back order quantity on it then the system does not let us wave the order. I can't figure out how to remove lines from the Past Due SO Lines Pending Fulfillment saved search that can't be shipped because one of the lines on the same sales order is on back order (can't ship complete). It would be nice for this reminder to be able to reach zero lines but it can't due to this inaccuracy in the data. For now I just added the ship complete field as column so I can see if its a ship complete order then I can assume (but verify) that it is held up by a back order item. If the column for ship complete is false then I know it is for sure late. I don't know how to have one line know that another line on the same order is on back order. Any ideas? This has been plaguing me for months. Thank you in advance!