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

image.png

I am trying to find work orders that don't have an issue or completion w/ backflush attached, can anyone divulge some help here?

Also do a formula like CASE WHEN {applyingtransaction.type} = ‘Work Order Issue’ THEN 0 WHEN {applyingtransaction.type} = ‘Work Order Completion’ AND {backflush} = ‘T’ THEN 0 ELSE 1 END

Use that in a summary search where you group by work order date, number and built quantity. Then sum that formula

Any work order where the sum of that formula &gt; 0 does not have the proper issuance or backflish 

hm, thanks close... this one has an issue and still shows

When it has an issue, and completion w/o backflush, i get a returned value of 2

this has a completion w/o backflush, and an issue, but a group on applying transaction only shows the completion

Could you use Quantity Ship/Recv instead. So quantity - Quantity ship/recv 