Is there any way to check/compare the quantity ord...
# suiteanalytics
e
Is there any way to check/compare the quantity ordered with the quantity committed per line on a sales order? I'm try to create a saved search with that purpose, I have added the filters type= sales order, main line = F, ship line = F, tax line = F and added some formula fields in the results but I always get the quantity committed and ordered as total/global value not per line of the specific sales order.
For this particular example, I would like to get ordered = 1 and commited = 0/null but that is not happening, I am not sure if that is even possible.
r
You're using the Quantity fields here that show up on the Results tab of a Transaction search? Those have always worked for me.
e
Yes, Quantity and Quantity Committed, I am thinking this account something else enabled that is not allowing me to get expected results. If I go to the item record, I can see for example commited = 10 but in the sales order line it says 1, so I want the 1 not the 10 value.
r
That should be just those fields here. If it's not, I'm not sure what the issue is. Are you starting with an item search or transaction search?
e
This is a transaction search, thanks for the help! Pretty weird, I would expect the results by line and not globally, it seems I get the committed quantity as the sum of all the inventory not per the line of the sales order