You may want to change you stock units to UNITS/PIECES but keep your purchase units to CASES. That way you can purchase in sets of 4 but when you count, inventory and sell, it would be in UNITS/PIECES.

Sorry if not clear... The field types for the Assembly name and Member name would be type List/Record and the List/Record would be Item. You would then go into the Member Item and set up a record for each Assembly that this item is in based upon your example above.

Yes with reservations. I have some vendors where the limit is a minimum sale, others with an amount to get to free shipping. My international is a total weight for containers. In the case of one of my vendors we have both the minimum and also the Free Ship amount. But yes, the custom fields will end up being the way to go…

I forgot one VERY important point. Do not remove the bins if there is quantity assigned. We had someone "fix" Bin errors by removing bins and unchecking Use Bins when they had a quantity. Because of the "design" in how they implemented Bins, NetSuite remembers the quantity so that if you ever turn Bins on for that item…

As long as the dummy bin is marked as preferred at that location there is no need to enter extra data. You can assign Preferred Bin once for each location. We have been doing it for just over 6 months without a hitch. When an item is created in our system we automatically add the dummy bins as preferred via a script.

You can definitely add the corrected Bins and make them Preferred via CSV but I do not believe you can delete. We use the SmartClient tool from Celigo which lets me use excel to automate the process. Also could look at a utility for FireFox and Chrome called GreaseMonkey to automate mouse clicks and screen layouts..

Ken, Do you also use Multi-Location Inventory? We have an open issue "Case: 1356184 Defect 204834" where prior to turning on MLI we had used locations on records as a means to display the proper address of the purchasing rep so every PO and Item Receipt had a location attached. When we enabled MLI it just so happened that…

You should have defaults set. directly above that checkbox. <setup>, <accounting>, <accounting preferences>, Items and Transactions tab

I am hoping it is this simple... We experienced the same thing and found out that our warehouse needs to run the "Bin Put Away Worksheet" https://system.netsuite.com/app/accounting/transactions/binwksht.nl What happens is Customer Service (or who ever takes customer returns back) does a return for an item. NetSuite…

I asked the same to support and was told that the system notes for members of assemblies and kits is an enhancement request. Sorry but I didn't record the number.

I do not subscribe to the rule. Took us a couple of months to get it correct but I would never go back to using No Bins.

Our biggest problem was our purchasing group would remove "Use Bins" while a bin had a quantity on hand. Perform a few weeks of transactions and then add the bins back. This is what throws bins WAY out of whack. Example: item ABC has bin# xyz with a quantity of 10 User changes item to uses Bins = False you sell 3 item ABC…

Actually on your item saved search specify Vendor, Vendor Code, Vendor Price and Vendor Schedule. For items with multiple vendors entered you will get multiple entries. To get the info for just the preferred vendor, add criteria of "Vendor Is Preferred"=True or to get just the secondary, use False. Do not specify it and…

Did you ever find a resolution for this? I may have stumbled upon one for you. We had a similar problem except it was the inventory group that was turning off Bins, doing transactions and then turning it back on with the original Bin number. How we resolved: Created New Bin Numbers that were VERY similar (but different)…

Check to see if someone Attached a script to the entry form. I had an intern attach a bad script to a production form and had a similar problem.

@andy I know how you feel. I just found that out yesterday as well...:D

Are you using the actual "Locations" function of NetSuite and is that what is really causing the problem? Or are you just trying to do a mass move of items from their current Bin to another?

That is perfect. Thanks! Having never had formal training in Saved Searches I keep forgetting I can use the SQL Expressions. You have greatly simplified my life :)

We use Bins also and found that just unchecking the Use Bins function may cause more damage than good if you ever want to go back. That being said, since you want all stock to come out of location "City, State" are Bins really needed? Or do I not understand this and your "City, State" just part of the Bin Name/ID? Also…

In order for a Sales Order to impact inventory it must be in approved status. Once the Sales Order is approved, use the Available Quantity to reflect what your inventory is. If you are using the NetSuite cart, that should already be happening.

<snip> When adding the DEF in our method, I'd just alter the item description to note what is going on. So, if the standard line item says... Item #.........Description............PRICE DEF............brass widget ....... $10 We would alter it to..... Item…

Thanks for the replies. Unfortunately I need an order to go to the warehouse to still Pick/Pack/Ship the original ABC item. If I send an order out to the customer with a pack slip of DEF I will get another call of possible mis-ship as many of our products are similar with important minute changes. So my original problems…

If I remember correctly, it takes till the next day to be able to do transactions against it.

Interesting. Wish I would have seen this sooner... We used custom forms Edit pricing only - Form has All field Inline only (except pricing as it cannot be changed) Edit all BUT pricing is displayed on the form, we didn't even show it.

I would just mass update the old item setting the Obsolete Date and the add the new member item setting an effective date that same.

Go look at the default uncustomized form. "Should" be on the main tab and visible by default

Shot in the dark BUT if you use Bins, have you checked the Bin Putaway Worksheet?

I still have the Contact (and customer) joins in both 2018.2 as well as my release preview for 2019.1 Does the role of the person doing it have Contacts under the list permissions?

My apologies as this does not directly answer your question BUT if you were using Kits in place of Groups, this would be a very simple search.

Way too detailed probably to go into here. I almost always will just save the CSV to a PC Folder and use Microsoft Query to import into Excel. I can do additional sorting, criteria, move columns around and even create calculated columns using SQL. If this is data you will run often and want to do different functions, the…