Olivier Gagnon NC Red Ribbon

In this scenario, I guess that would mean you could use scripting to create the WO with the right parts based on the options selected. It would be cleaner than using adjustments, I think.

Your Chart of Account should not contain coding in reference to locations or any other classfification. This is a mistake. Are you in implementation pahse? You should address this now by reviewing your CoA. Otherwise, no, there is no work-around. You should have a single, uncoded COGS account, and NS will take care of…

Just to confirm - you are saying that I do not have to assign a location at all when I set up new item codes? Correct. There is a "location" field on Items, but this is only the preferred location, which means that is what will default when you place an item on a transaction. Just like khultquist says, items span across…

Just pick an account and distribute. If at year's end you realised you picked the wrong account you can just Journal the money to the right place. This is far better than halting your business.

Yes, sort of, but it's insanely complex and requires a lot of scripting. Still interested?

Another idea might be to pull a Transaction Saved Search. You can group by Date, Price Level and Amount

What exactly is the distinction between the adjust inventory worksheet and adjust inventory? I'm SO glad you asked that! :) I go into the important distinction between the two in this blog post. It is VERY important inventory managers know the difference between the two.

You want to do an Invedntory Adjustment, not a transfer. The Inventory Adjustment will allow you to actually decrement stock. A Transfer just moves is, which has no GL impact really.

No, it is not. Qty Committed quantity reserved for an order. If you have Back Ordered 1 you are necessarily out of stock, and thus nothing can be comitted. Once you restock, you should see that "Back Ordered" flip to "Committed". You can find more detailed information about inventory management in the Help system.

The 3 Golden Rules of Bin management: 1. Don't use bins 2. Don't use bins 3. Don't use bins. Now, with that out of the way - the bin functionality basically rests on top of the normal inventory functionality. What this means is that even though you have bins on, there are still ways to affect inventory directly at the…

I would carefully point out this app does Inventory Adjustments, not Inventory Adjustment Worksheets. (to be fair, since Inventory Adjustment Worksheets are not exposed to scripting/web services/CSV, there is NO app that can do them).

Netsuite does not alloow you to change Unit Types because Netsuite would not know how to convert the quantities since there is no way to define relation between Unit Types. Example, say you have Unit Type "Boxes" and Unit Type "Packages". You may want to change an item's unit type from Boxes to Packages, knowing that, for…

Hi Warren, From what I'm seeing, this is "normal". Netsuite outputs expenses as negatives and income as positive when running saved searches. Just slap an Absolute function on the amount. There is nothing wrong with your syste,, just a NS reporting quirk.

Cost estimate Type. Keyword estimate. This field is used to calculate gross profit BEFORE you know the actual cost of the item (such as on an opportunity). So Netsuite asks you how you'd like to go about figuring out what your cost is. Your TRUE profit (as basically reflected in your financial reports) is calculated using…

Where do they show up as negative? On the transactions? Do you mean the amounts are nagtive when you run saved searches, specifically?

You'll have to use scripting to do that

You'd want to use entire new Item records to track this? If so, that's cool, you could just add 2 custom fields to track the superceded From and To. Wouldn't be any other functionality related to that, though (like nothing would stop you from ordering the old part, etc).

Remove the Income account from the item. This will cause the item to not appear on Transactions, but still be available as a parent (in fact, on saving you'll get a message indicating what I've just said).

Inventory Items from a "library" location with Inventory Transfers to check them out into a "Checked Out" location, and then back when they come back in.

No, I don't see how that would be possible. Not even with scripting. It's a fundamental NS thing.

No it doesn't matter. The tax code won't ever be used. NS just didn't put in selective mandatory-ness on the field.

This topic actually very recently came up in another thread. You can review what was said about it here.

Transactions->Inventory->Transfer Inventory If you do not have this, are you currently using Multi Location Inventory?

The always highly entertaining Wizard is correct, you can CSV update BOMs.

Hmm, that's an interesting problem. One way to go might be to start using Units of Measure. You can set up your item's purchasing unit to be a multiple of 1000.

If you've been fulfilling items when they were 0, you don't have backorders, you have negative inventory (also known as underwater). This typically causes innacurate COGS and financials, so unless absolutely necessary to your business I advise not doing that. As to your question - do you really mean distribute or do you…

Typically this is done with Assembly or Kit Items.

You are correct in your assumptions

First create a subtab and save it. That's really just a matter of giving it a label under the appropriate record type. Next you,ll need to create a sublist: Setup->Customization->Sublist. Before you do this, make sure the search you want to use is Pulbic and has that "available as sublist" box ticked in, as well as being…

Mmm using only formulas, I wouldn't think so. Easy peasy with scripting though. Could be a nightly batch process to update items. Or, rather than using custom fields, you could use a sublisted saved search to display it on the item record on a tab somewhere.