JohnCirocco · Sr. NetSuite Administrator · Silver Trophy

My first guess is that the field for Check Number on the results is different than the filter. Second guess (and this is a stretch) is that there is a trailing Blank???

I know it is a few extra keystrokes but you could use "IS" and then use a wildcard like %Apple%

That's good. Normally a stand alone does. But apparently not if you copy one originally from a sales order. One new thing learned today!

You actually should try the join to the "Inventory Numbers" on hand or available. That is by serial number (What they refer to as Inventory Number)

Actually, If a stand alone Cash Sale was done (No sales order), it in fact DID reduce inventory. You can verify by using an inventory activity report. If you refund the cash sale, it will also impact…