I know this is going to sound a little nuts but I had the same issue back in 2010. What we ended up doing was to create a "fake" $0 Invoice to a dummy customer whenever we created a new item. That way you could create your item search using the Transaction Join including both PO's and Invoices so you will always get at…

When you created a Filter for Lot code, you can specify multi-select.

JohnCCole , I tried to create a custom transaction column field, store data was off but for the life of me I could not find a field to source from (Item Rate and Amount didn't work). To make matters worse, when I had it as Store Data False, could not make it show on fulfillment form even though it was checked to be…

Michoel, Thanks. If you look at initial question, I am trying to get the Sales Amount from the Sales Order so I can calculate actual Profit at time of fulfillment.

Oh, and another interesting bit... When viewing the XML of the Fulfillment, there are 2 fields for each item the DO link back. <orderdoc>345989</orderdoc> <orderline>2</orderline> Orderdoc is the internal ID of the Sales Order Orderline is the LineID of the Sales Order

This should work... CASE WHEN {item.class} IN ('Implementation Services', 'Consulting Services',, 'Managed Services', 'Third Party Implementation', 'Third Party Consulting', 'Third Party Managed Services', 'Third Party Services', 'Training', 'Professional Services', 'Residency', 'Service Desk' THEN {altsalesamount} END Me…

You hit the nail on the head there JCirocco I had no idea I could create a custom field on Class. That would have saved me so much time writing these CASE WHEN statements. Thank you! You are very welcome. That is why this group is so helpful!

I used to do this using a transaction search using all transactions that affect inventory (Item Fulfillments, Transfers, etc) along with the item available at zero. By using the system notes date field I was able to get a report of items that went out of stock on or after "yesterday" each morning.

You can just change the Summary Label on the definition of the results.

Actually, you are correct. We default our W/O's to released and commit inventory when created (Available Quantity). Technically I teach my customers that a Sales Order not yet approved, and Work Order not released are just pieces of paper and another order can come along and commit the inventory. We also have the same…

If you do a fulfillment search you actually get the Kit members. You can get back to the Sales Info (like dates) using the Created From join

Mike, Criteria Member Item:Type is any of Assembly/Bill of Material, Inventory Item Member Item:Inventory Location is Warehouse Results Formula (Numeric) Summary Type=Minimum Formula=FLOOR(NVL({memberitem.locationquantityavailable}, 0)/{memberquantity}) Available Filters Internal ID

I have a search on the Assembly item that calculates the Buildable Quantity. Since it is not stored it is not available normally for another transaction field to source from BUT you could have a scheduled workflow update a Stored field on the Assembly record every 30 minutes and then source that to a custom transaction…

Sorry, I have used the Max Results before but not in a dynamic group. Assumed it would work (silly me...)

If I understand what you want correctly, on the Results tab check the box for Run Unrestricted and then you can enter a value for Max Results. From the help: Enter a number in this field to define a maximum number of records that this search can display as results. If you define a Max Results limit, and the number of…

I believe in much older NetSuite releases you needed criteria specified to have a filter and it allowed the null value there. One of my customers has a boatload of searches defined with the Null but cannot be recreated as such now.

Sorry, try CASE WHEN {yourfieldname} IS NULL THEN '!' ELSE {yourfieldname} END

Just a guess but how about including a formula field with a case statement replacing the empty field with the lowest possible ASCII printable character (! I think) and then do the sort on the formula field? CASE WHEN {fieldname} ='' THEN '!" ELSE {fieldname}

Same/similar here. Ours was donotreply@

If you use a formula similar to: decode{custom_status}. 'Open', 1 decode{custom_status}. 'Closed', 1 decode{custom_status}. 'Pending', 1 and additional lines for the other status's you could then Group the Status field and Sum the status counters. You would end up with the count in each column.

Alex, Thought there was a glimmer of hope there but it also truncated. Thanks for the idea though

snip... as well as pulled of a successful prank on my boss sending an email from his future self back to himself. Love it!

Alex, Good thought but the only thing it does is truncate BUT removed the More...

Also just tried the Bin join and that didn't work also.

We got our response yesterday that if we use Inventory Location in either the criteria or filters, that particular field will be truncated. I made a copy and removed Inventory Location from the criteria and it was not truncated. Our problem is that this is an export used to push inventory availability to other store fronts…

Alex, Thanks. Will give it a try. Sorry didn't see you at the conference.

I forgot to mention that I was trying to use the Ship Date field in a filter to show SO lines needing to be picked. I added the custom transaction body field (type=Date) and initially populated a few test records. I then went into the Saved Search I created and added the new field in results BUT when I went to add it to…

Alex, Thanks. Knew it would be simple. See you at SuiteWorld

Mike, I have an old document where it describes how to create a "selection tree" which is when I think you are looking for. Let me know your email through private message an I will pass it along.

Well, just a guess, but if a customer has multiple items besides that particular 1 it would still show the customer because they have at least 1 item not equal to 'Mid-Market : American Contractor : AC Service Management/Work Orders' possibly?