This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

on a transaction saved search - how do i show the quantity on backorder? I have this formula which I think works but not sure what where the quantityshiprecv comes from: {quantity}-NVL({quantitycommitted},0)-NVL({quantityshiprecv},0)

isnt there already a backordered field on the SO?

or is that showing all backorders across all SO maybe

id think you would want something like committed - on hand/available

i didn't find any BO fields. there is a back-ordered field on the item but not sure that's what i need

Backordered on the item would be the total across all transactions.

<@U29QCJQF3> would you say quantity - quantitycommitted - quantityshiprecv is accurate to the BO quantity?

Here is what we use for work orders, abs({quantity})-nvl({quantitycommitted},0)