I'm trying to dig these numbers out of sales order...
# administration
c
I'm trying to dig these numbers out of sales orders in a saved search...anyone have any idea how to get to them?
s
if you do the transaction search type: sales order on the result tab you will see all these under quantity
message has been deleted
c
Thanks - but I think those are custom body fields there. Here's what I am seeing in the results tab:
s
all of them are right there, what is the problem
s
i think he is looking for the back order
s
Backorder is easy formula to get, its just
qty - shipped - committed
l
For back orders NS do not have a specific field on saved search so we could use formula (Numeric) on search columns something like this
NVL({quantity},0)-NVL({quantityshiprecv},0)-NVL({quantitycommitted},0)
c
Thanks @LakshmanMuppuri - that's perfect.
👍 1