Martha, Try a transaction search Criteria Then add summary Criteria And finally the results This will get you work orders with Multiple builds

If you start with a Customer search you can get to your Custom Entity fields, any contact records (via the Contacts join) and the Sales Orders (via the transaction join)

Paul, I would think you could create a Customer Search and get to the contacts and sales orders through the joins that way.

We do a separate location just to reserve for our e-commerce orders like the last section Herdi Rana says. 

You should be able to set the Shipping Item to be $0.00 which would accomplish the same without a workflow

Tom, One of my old customers wanted something similar to what you are looking for. They had many items that were Drop Ship capable but we normally had stock. If someone wanted bulk (cases) and we didn't want to clear out our inventory, we would manually create the Drop Ship. What we did: We created a Custom Item field…

A couple of options... If you want an immediate notification, you can create a Transaction search for any transaction than can reduce inventory (Item Fulfillments and Inventory Adjustments) and send the alert if your new Available Quantity PLUS your Quantity On Order for the item is less than or equal to the reorder point.…

When I was in consulting, one of the first things we did was create a custom Item field called Discontinued. We would use that to drive reports and sale pricing. Once a Discontinued item was sold out and all transactions completed (Invoice/cash sale) we would then make inactive.

Thanks, I will reach out to my account rep

Purchase Price is only available on assemblies if you have the accounting preference "Allow Purchase of Assembly Items" Accounting > Accounting Preferences > Order Management It is only used on Purchase Orders to Debit Inventory on a PO Receipt. Otherwise the Assembly/Workorder Build transaction hits Inventory

I searched suiteanswers as well as the bundles and cannot find this. Is this part od a SuiteSollutions install?

Is that something Custom in your NetSuite account? I do not have that in mine that I can see but I know that could be very helpful!

When you say it does not appear in sales order selection, are you referring to the CSV import? Go back into edit mode and click Apply to Forms. I am betting it is not on your default form

Jack, thank you as always! Never sure when to plug the to_date into the formula...

Actually, you can have the same item number if the item type is different. I unfortunately will have users create an Inventory type item when it is already set up as an Assembly. Same issues when the item is created but the user uses Lower Case and not Upper even when both are Inventory items

There are no "predefined" alerts other than looking at the order items but can easily be created using saved searches For POs created through the Order Items, the context will be "Bulk Processing" and will follow what your normal Approval Workflow currently is (if any)

Martha, Try 2 things: 1) I usually leave the Action to trigger on Entry 2) If I select Scheduled instead of on Entry, I always also specify the saved search that I used in the main section under Saved Search Condition

Paul, Here is my version that shows current available quantity for components that are either Inventory Items or Sub-AssembliesAssemblies. Note we use normal BOMs (not versioning) and we make use of the Obsolete and Effective dates so this search takes the obsolete into account. Also note that since we have multiple…

Do you have the FedEx integration turned on? https://netsuite.custhelp.com/app/answers/detail/a_id/9279/kw/Delivery%20Instructions "If Date Certain or Appointment is selected as the FedEx Home Delivery Type, enter Delivery Instructions for the driver. These instructions are encoded into the delivery barcode. A maximum of…

I am just going to take a guess that it is because a Custom Field that is derived from search results is for "viewing" only and will not have a value if used in another formula

Interesting, I do not have a field by that name or ID within my environment. 

Paul, I am sure you have this resolved but I am trying to find the original SuiteAnswer on how to deal with Customer Deductions. I think they may have pulled that answer now that they have the Deductions and Chargeback SuiteSolution. I do not have time to install/learn that process. Do you have a "simple" solution you use?…

Martha, I think you can create a journal entry to Debit AR making sure you include the customer on the journal entry line so it can be applied. I assume the Credit whatever the original GL Account was on the Credit Memo

We have multiple issues also. Scripts are erroring out (Avalara when saving a sales order) Cannot view customers And now unable to login

I do that with transaction numbers all the time so when looking at just the tran ID you know what type. Might be doing for similar reason for Customers and Vendors.

Sorry for the delayed reply as I was at the Highjump conference. I do not know how I had never seen COGS amount before... Thanks for the help

I use a scheduled Workflow to do the same. Just create a saved search of all sales orders pending billing and run every 30 minutes

Are you currently trying with a workflow? Are you using the join to "Created From"?

Yes, if you use fulfillments (and the above assumptions are true-Always have a sales order) then the fulfillment works as when you sell a Kit type item and fulfill it, you actually get the fulfillment of the component items.

In the past I have used Fulfillments (created from sales orders) as a basis of sales as you can get full data on kit members and quantities. It assumes that if it is fulfilled it has been sold. It also assumes that you do not do invoices or cash sales without starting from a sales order.