CODEWITHSUNDEEP
netsuite
Brendan Mitchell
Brendan Mitchell

Reputation: 477

NetSuite Summary Saved Search Can't Access Certain Fields

I'm trying to execute a saved search for work orders that evaluates a formula for each line item to determine whether the work order is ready to complete. I'm fairly confident that I know how my formula should work, but I don't seem to be able to access all the fields I need in my Formula (numeric). The fields I need are labeled "Quantity", "Backordered", "Committed", and "Used In Build. According to this page, the IDs of these fields are quantity, quantitybackordered, quantitycommitted, and quantityfulfilled. I'm able to use the quantity and quantitycommitted without issues, but the other two just give me "ERROR: Field Not Found".

I've used two simplified searches to reproduce this. Under Results I have this, with "Sum" as the summary type and {quantity} as the formula. This works as expected (result). But when I change the formula to {quantityfulfilled} (as shown here) I get the error shown here.

I'm very new to NetSuite; what am I missing here?

Upvotes: 0

Views: 622

Answers (1)

Krypton
Krypton

Reputation: 5256

The documentation page you linked is for the Work Order record - there is a different page for Transaction Search IDs.

There you will see that to get quantities used on a build, you can reference Quantity Fulfilled/Received (quantityshiprecv). AFAIK, backordered quantity is not directly available - but you can get it by using a formula {quantity} - {quantityshiprecv} - {quantitycommitted}.

Upvotes: 0

Related Questions