There is a potential backdoor to do this: read this thread I don't know that I'd recommend it, but you can investigate.

Yeah we ran into this same problem a while back. I haven't looked at it recently, but when I looked at it there was not a good way to do price breaks. You can try to use a 'schedule', but for us this did not have the flexibility we needed. We ended up creating phony vendors called 'Price Level 1', 'Price Level 2', 'Price…

CSV is not good for removing records, or lists from records. I would do this through a script. Perhaps, depending on your business needs, you could even build a script that actively monitors for items with >1 active bin, and remove any empty bins.

Two ideas: 1. You could always export two searches: A list of all bins; A list of Items with associated bins. Then use the spreadsheet to find unassociated bins. 2. Create a fake item associated with all bins (perhaps it could be imported through CSV). Then create a saved item summary search, grouped by bin, where the…

Yes you can do it in a few steps, see this thread https://usergroup.netsuite.com/users/forum/product-areas/accounting-transactions/inventory-management/32141-conflicting-quantity-on-hand-bin-on-hand-stock-count?t=31246

There's an "out of stock option" choice, can your workflow adjust that?

You could have: >Items that need to be put away. Try a bin putaway worksheet >The 6 pieces in a different bin that has been removed from the item record. Try adding all bins to the item record. Save and refresh. >The item was set to 'use bins' = No for a receipt, and so the bin never got the item. For that case, you could…

Your saved search will only show results for "Preferred Bin is Yes", so you can't get the other bins with this method. You might be able to make some SQL formulas with CASE WHEN... ELSE... END that trick the criteria into allowing what you need.

If you don't want to script it, you could create a saved search with your criteria and export the results. Then csv import as a Sales Order to a misc company for $0. Fulfill and your inventory is zeroed. This will hit your sales account, but if it's only a few dollars then you can ignore the cogs or have your accounting do…

Lot Numbering will allow you to track a container, or when it was received, so that will work. However, normally Lot Numbers and Bins are not associated, in other words you cannot track what Lot Number is in what Bin. To do that, you have to enable 'Advanced Bin / Numbered Inventory Management'.

There's an option to purchase assembly items, will that work?

You can purchase them as non-inventory items

This is how we did it: Type Name: Each Line 1: Name: Each; Plural: Each; Abbr: Ea; Pl Abbr: EA; Conversion: 1; Base: Yes Line 2: Name: Box4; Plural: Box4; Abbr: Box4; Pl Abbr: Box4; Conversion: 4; Base: Line 2: Name: Box16; Plural: Box16; Abbr: Box16; Pl Abbr: Box16; Conversion: 16; Base:

Multiple Units of Measure is available, it might be part of a module though (extra $) Setup>Company>Enable Features>Items&Inventory>Multiple Units of Measure Then set up UOM under Lists>Accounting>Unit of Measure

Here are a few ideas: Scripting You could add a client script to validate the item selection. This way you could prevent the wrong item from being ordered from the vendor. This won't prevent you from seeing the item in the dropdown list though. Custom Sublist Using a sublist you can show a list of items for that vendor.…

Nice thanks, I've turned it off and will see if that helps.

Same problem here, only with Chrome though, and only with some users.

Alan - you could script each transaction type to fill in the dummy bin on the sublists. It wouldn't be very complicated to do if you can script. PM me if you want some ideas about how to do it.

You can create a saved search for where the item is used. And then (I haven't tried this) you should be able to add a sublist on the item record, using this search, that shows where it's used.

I thought you were asking if you have to set up the same item at each location, i.e. would each item be a new record at each location. We use One World and Bins... what I can tell you is when I add a new item, I have to setup the part in the proper subsidiary, and allow a bin at each location, and then it works fine. If…

Sounds like a bug, maybe with 2011.2? I had so many problems with making copies that I removed the button: wrong accts, wrong descriptions, wrong prices, etc. Edit to add: the problems were with my users not being careful, not a NS bug.

No, your items span across locations.

In an inventory adjustment there is no 'from' and 'to', we simple adjust it (in the main location). The key is to set up an adjustment account that captures the impact for the gl.

we use 'Inventory Adjustment' and capture the cost in an 'Inventory Increase/Decrease' account.

Just a guess: the order total is rounded to 2 decimals. eg if you purchased 71 pcs, your oder total would be $4.47, not $4.473. And then the per pc price shows as $0.062957746

I don't think so, but since you exporting to excel you can do it with macros or pivot tables.

Peter - the other fields in serial number records are accessible thru search scripts. I know this because I'm working on a similar project where I need to add these fields to the fulfillment form. Depending on how you are printing labels (at receipt? from item record) you could have a script that pulls data from a search…

When we started NS, we did not use bins, but since then we've rolled them in. While there are some issues, overall for us it's better with than without. Addressing the original post: when we have inventory discrepancies, it's been one of two things: [LIST] a deleted transaction (or transaction line), often an inventory…

Here's a dumbed-down version of my fulfillment label script and the popup html. The script is loaded with the fulfillment form, and is activated by a button on the form. The popup is saved in our NS file cabinet. The script makes hidden input fields on the NS form page, the input fields are either header-level (such as SO,…

I found the labels in standard NS to be too simplistic. We have the need to print all kinds of data, and it differs based on the situation... there's no good way to handle this is vanilla mode. Without going into too much detail, the solution I came up with is scripting on the record or transaction page that [LIST]Makes…