Olivier Gagnon NC Red Ribbon

Well there is a whole slew of reports and searches you could use. A good starting point is reviewing the reports available to you under the Reports->Inventory. Inventory Activity Detail will quickly show you movement on your inventory. Inventory Turnover may also provide the kind of information you are looking for. You…

I believe this is explained in the help, so you should double-check the logic there, but basically, when you sell an item and push it into negative quantities (aka "underwater"), you are setting up a physically impossible situation. How can you give something you don't have? So Netsuite, to determine the Cost of the good…

So do Inventory Adjustments

I strongly recommend you routinely use Inventory Adjustment Worksheets to manage your inventory. Netsuite has many little flaws that can slowly cause your inventory to be off by a few dollars to thousands in extreme cases. Using the Worksheet is the only way to truly control your inventory's cost. In the case of cleaning…

Creating your Maintenance as Markup items would be simplest and most effectiuve way to go. Markup items can be configured to be a % markup of the item immediatly above it. So you could add the item, then select the appropriate maintenance plan, which would automatically calculate the price based on percentage.

If I recall correctly, a Markup, just like a Discount, can post to a specified account, rather than just inflating the previous item's price. The reselling part - depends how you want to handle that. Do you want to have the SO tied to a PO, such as in a Special Order scenario? That might be tricky if using a Markup, yes.

Couple of ways - 1. Use your browser to print. Comes out looking not so good, but it's easy. 2. Create a Saved Search to output the info. Comes out looking a bit more organized but I believe you cannot output all fields as they are on the Inv Adj. 3. Use scripting to build a perfect-looking PDF excactly as you want it to…

Everything Jim says is extremely important to understand. I have my own blog post about these notions here. To make a few additional comments: Regarding the 24 hour delay, this is caused by COGS recalculations. The problem really occurs only if you back date a Worksheet (or a regular Inventory Adjustment, for that matter).…

Mmm, what do you mean by fixed price? An Item can use Average, FIFO or LIFO. Or, you can use Lot Numbered or Serialized. Check the Help under Items and Inventory Management : Using Item Records : Item Costing : Selecting an Inventory Costing Method to understand these different options.

What is your question?

Yup JM is on the ball. I would particularly stress Netsuite does NOT currently support UOMs on Assemblies. All Assemblies are in your base unit, and they consume all members in base units when built.

Ouch. Both Bins and Lot Numbered items do not output well as "Quanity As Of". They are basically intemporal - from a system perspective what you have now is what you have always had and what you will always have, if you see what I mean. This makes figuring out adjustment quantities difficult, to say the least. Your best…

Oh I didn't see "open" for 4. Yeah, that makes sense. Well, when I was starring down the barrel of that particular gun, we were starting to plan everything out, but, for very special circumstances, Netsuite agreed to switch it in the backend. That was a very special set of circumstances, I don't think that's a standing…

Right, everything is scratch built using Suitescript UI objects (well, except for the subtab you show the sublist on I guess). Using script I add a sublist, then define the fields on it (so member item, quantity, and whatever else I want). Then, the script iterates through the "real" Member sublist and fetches all the…

Hmm... interesting problem. Do you track each inventory for each revision seperatly? Must you maintain seperate stock for everything? If not, you could use Item Options or Custom Fields to track this little detail. Otherwise Netsuite doesn't really have a built in solution for alternate items. You can customize the whole…

Price Levels can be defined as being a certain markup of the Base Price (like a price level "VIP Price" can be -5% of base price"). Is that what you are looking to do?

I just remembered we actually have a blog post regarding this. So for more details, read this.

So... you make POs, SOs, fulfill and receive and such, but you never actually pay attention to your financials? Interesting. Should make things easier, yes. Well anyway, I mean, you've got the general idea. There is no other option So yeah, you can hire PS to do it or hire a Partner. Pretty much comes down to that. I…

Are you sure a Worksheet won't work? You tried it and it didn't make things balance? If a Worksheet doesn't work, I would call Support. This would sound like a pretty heavy duty problem.

The Member sublist is not currently customizeable. What you can do (and something I did for a client) is recreate a subtab that has all the info from the Member tab, plus the additional fields. You can even synch the two so that if something is added to the "fake" tab it gets added on the real tab. It's a bit of a…

So you need the ability to determine whom the present customer on the SO is, and if one of 2-3 select ones, then do not show items out of stock. Yeah, you can't use searches on the SO items as described above; those are incapable of 'dynamic' filtering, i.e. looking up which customer is presently selected. Scripting is…

Yeah I've gone through that. Steps 1 to 3 are fine. Step 4 - I don't know how you plan to do that. It's nearly impossible and extremely risky. You're talking about editing every single transaction in your system, including those in closed periods. I would write that step off, and only start calculating as FIFO going…

It doesn't change the type. After your Worksheet, your item will still be FIFO. However, if you use the Worksheet, your FIFO history up to that point will be lost and the item's value will reset to an average based on what you enter in the Worksheet. AFTER the worksheet, you will being rebuilding your FIFO cost.

Haha that's one we recently had fun with. It would require some detailed analysis to say for certain, but in our case thgis was because they had Qty on Hand in the Bins, but negative qty on hand on the "base" location. The Location On Hand is [bin qty]+[location qty]. So if you have 5 in the bin but you accidentally…

Perhaps the simplest way would be to use the custom search functionality on Sales Orders, to remove items that have Qty on hand = 0. You can do this by Customizing your SO form, and then going on Screen Fields->Columns. The "Item Filter" dropdown is where you select a saved search you have previously created to filter on…

You will have to create a Save Search that recalculates your Average Cost over that period of time, based on Transactions in the system at that time. In other words, Netsuite doesn't maintain historical Avg Cost information. You have to recalculate it from scratch yourself.

Yes - the hard and long way. There is no concept of inventory "as of" a certain date. If you want it, you have to build back your inventory status by totalling up ALL transactions from day 0 to today - the exception being if you hit an Inventory Worksheet, in theory, you can start from there instead of day 0 but in…

This should indeed be possible. You can do a Transaction search, listing out Item Receipts, with a Join in Item Number... to get serial numbers. If you want to go the othe way around, you should also be able to run an Item Search, including the serial number, and then join on Transactions and pull out Item Receipts and…

Yes, you are right. Rereading the original post, I believe I missed the part about the Lot not being in stock yet upon SO creation. One thing you could do is add a custom column (freform text) to the SO, where you can write in the intended Lot number to use. As there is no verification since this is only a text field, this…

I read too fast on my first reply and thought you were looking for the Average Cost at different times. This is indeed different from the Average Value - Andi's answer will guide you in the right direction.