Is it possible to create a search for sales orders...
# general
g
Is it possible to create a search for sales orders to only appear if every single line? if so, how? and is it possible to also have it at order level rather than line level?
m
Yes create a transaction search Type - sales order Status - pending fulfillment, partially fulfilled, pending fulfillment/partially fulfilled Mainline - false Tax line - false Shipping line - false Add your columns Date - summary type group Document number - summary type group Main line name - summary type group Item Memo Quantity Quantity committed Quantity Fulfilled Recieved Formula numeric (summary type - SUM) {quantity} - NVL({quantitycommitted}, 0) - NVL({quantityshiprecv}, 0)
πŸ™Œ 1
Then also add the same formula numeric in the summary tab of the criteria with a condition of β€˜is equal to 0’
πŸ™Œ 1
This is assuming you want order where all lines are FULLY committed instead of partial commitments
πŸ™Œ 1
s
I dont understand what "only appear if every single line?" I am assuming there is a typo there? What is that actual question?