Olivier Gagnon NC Red Ribbon

You may want to look a Kits instead of Assemblies.

Well you can put it on a subtab on a tab. You can't put it directly on an existing tab.

Using scripting this is fairly easy to do, which is basically what the BlueBridge one does well. However, without Scriptable Checkout, this has to happen AFTER the user submist his order. With Scriptable Checkout, you should be able to do this live as the user adds stuff to his cart, which is a much better user experience.

You should create a new item. Changing accounts on an item retroactively changes the account on all previous transactions. If any of these transactions are in closed periods, game over. But even if this is not the case, "retroactively changes the account on all previous transactions" should sound suitably scary enough for…

Are you using multi-location inventory? Does the PO have a location?

If you're using Pick Pack Ship that turns into {quantity}-{quantitypicked}

I believe the OP is running an Item search whereas you are running a Transaction search.

Yeah, use a search. Just add criteria to only grab negative inventory and transactions posting = true.

There is little difference, from an accounting perspective, between all non-inventory affecting types. I recommend going with what seems most logical. Don't be afraid to make a mistake as, well, you can't really make a mistake here, they are all basically the same. * Freight -> service * Port Fees -> other charge * Customs…

So, in your columns, do you have Item, Inventory Location and Inventory Location On Hand? So what are you seeing, items where Inv Location on Hand is empty or 0 for given locations?

You need to add a filter to Inventory Location Quantity on Hand is not empty (and possibly >0 depending on your wishes)

To clarify, do you mean something like the following scenario: You have 100 widgets on many different SOs. You curently have 0 widgets on hand. You issue a PO for 50 widgets. You receive that PO. You now have 50 widgets on hand. Of the many SOs that require that Widget, you want to be able to say which SOs get the widgets…

Thank you for your reply. You understanding is correct. I was looking for a way to commit the items when the receipt is posted, rather than having to go into each item and reallocate. Is it possible to do what I am looking for? Items will automatically commit. Netsuite will commit to oldest transactions first.

Class and Department are NOT used to classify customers. That's what the Category field is for, or a custom field.

G'day Susan (:)) * When Lot Numbered Items is enabled, does it apply to all items, types of items or specific items? Only require it to apply to all steel products which are currently the Inventory type items. Will have Service & Other Charge Items that we don't wish to have the lot numbered feature. Lot Numbered Items are…

Wait - When you say "Although prior accountant entered the value of new inventory (Debit - inventory, Credit - A/P), individual items were then entered through inventory adjustments (debit - inventory?, credit - opening balance?) " Do you mean that the value of the inventory was entered using Journal Entries, and the…

Hmm, so you never actually put the join in the Columns as to avoid NS making an inner join, but you call it in a formula and test it that way? That's pretty clever. That's basically a way of making right joins...

Well the search will work, just that it will exclude items never sold. You'd then need a second search for items never sold. If you must have then together, the options I see are a) get ODBC connector toi extract the info and build an external report b) export your 2 searches in excel and manually merge them c) wait for NS…

Hi Jean-Étienne, As has been pointed out Netsuite does not support substitute items. Netsuite struggles as a light manufacturing module, and you probably won't get a perfect fit for your needs. The solution outlined by wsmith is probably the best option available to you, with all the drawbacks so very well pointed out…

It's possible to do by running a transaction search to finmd that MAX() of the date of the last transaction. The downside is that the search would not pick up items that have NEVER been sold. Thinking right now, I wonder if you could also customize an Inventory Valuation report. I remember that not working though.

You need to edit the transactions that create the serial number. In the case of opening balances, this is an Inventory Adjustment.

It will work, you can set the intial value, there is no problem there. I think I understand what you are thinking. I think you think that the only way to enter the inital quantity of items is on the Item record itself, because in the UI, when you create items (and only on create), the Quantity field is open and allows you…

To a certain point, you can achieve this with some scripting. While only the Reallocate Items screen truly gives you (manual only) control of where items get committed, there is also a dropdown on orders that allows you to select "commit" or "do not commit". You could thus default that selection to "do not commit" and have…

Hey, Evan, after your post we started testing this, and your formula works, but then we also just tested a straight up max of transaction.date and... it worked! It returned items without transactions. Now, I could swear this was not the case say a few weeks ago. Netsuite did inner joins. I can also swear, though, that…

Celigo's product uses Web Services to create Inventory Adjustments. As Jim points out, nothing and nobody has direct access to the DB, ever.

That is indeed impossible. If you really want to send them to seperate GL accounts, you'll either need to use seperate item records, or (and I don't recommend this unless desperate) making a journal entry to shift the GL impact every time you sell the item.

What exactly is your concern? What is the gap between out-of-the-box serialized items and what you need?

For our customers that require Physical counts (aka stocktake) we use Web Services apps to automate the process. They feed the app an CSV, and the app creates inventory Adjustments. Inventory Adjustments are NOT the same as Inventory Worksheets, but right now that's the best that can be done (while macro programs are neet,…

Depends. If it's a bar code you can read it, but often dates are human-readable (i.e actual datres) which scanner can't usually read. Like petermac says they are basically just keyboards so the problem probably lies in what you are trying to scan exactly.

Call Netsuite Support :)