3944195 Green Ribbon

Thanks Robert, that's what I needed - confirmation that I wasn't crazy. :)

Steve, Ditto. I've been reading and listening too. Thanks for your post on it, and also for the update. Cecelia

Krish, I've been following your issues with employee/internal security in NS for some time. First let me tell you that I'm glad you're tenacious about this, because you are absolutely right, and there are some serious holes in this functionality. But my question is: do you have a list of enhancement requests related to…

Cecilia and all, Related to your Inventory Item set-up with a slightly different twist — Would this be the appropriate, complete accounting set-up in dealing with costs for external labor in the Inventory Item/Assembly build set up? The basics: • External labor = Vendors • Inventory item (one component of the finished…

Cindi - just read your post...I'm about to head out the door but I'll reply with more info within a day or two. You have it almost right... sorry but am out of time. Will post back, though... Cecelia

Ditto - we also use inventory items for external labor, ie, for product purchased in bulk and then repacked into bags. We also keep the packaging materials in inventory and as members of the finished assembly item, but that doesn't matter for the purposes of this post. The "Repacking Labor" item (actually we have several,…

Agreed! In fact, that second ER was the first "whhhhaaaat?!?" I experienced with NetSuite - found out within a couple of weeks of signing up with NS, in fact, that we had bought into modules that essentially wouldn't work together. However I also have to say that I don't think ER# 781888 is going to be of much use without…

Sorry for the bad news - yes, they're it - you can only get the company prefix from them (and the GLN, which is based on the company prefix), and you have to have that to generate the UPCs. You must have a lot of items though, because the pricing is based (in part) on how many UPCs you need. I would give them a call, read…

Yep, you have to register with GS1 and get a company prefix first. Then you use their "data driver" web application to enter your items (with dimensions, weights, etc.), after which it generates the UPC codes for you. GS1 has a lot of info about this on their website. Read through that first, and/or call them and arrange…

There is an enhancement request, #58370, to display the total cost (summing up the purchase price of the components) on the Members tab of assemblies. You can vote for this by contacting support. It may be something you could implement yourself using SuiteScript, but I am not certain if all the applicable fields are…

Oliver.... please send me an email too (cquilty@orchardsweet.com). Among my questions: -- Will this handle costing where member quantities are fractional parts (ie, the assembly item contains .31 of a member item?). -- Could the gross profit value be extended to include costs that are not member-related? For example,…

Malin, is enhancement# 58370 only for most recent purchase price, or does it pull the current inventory costs of the members (LIFO for Cecelia, Avg. for me)? Malin - actually that's FIFO for me. ;)

Yes I think there is, Jim - but at the moment, that's more opinion than fact. The problem is that I'd need about 8 hours to do a thorough analysis of inventory costing and valuation in relation to our transactions, and frankly I don't have the time to do that right now. But I would certainly recommend that anyone using…

However.... current cost is always used, which means that if the cost changes between a Build and an Unbuild, the inventory value of the Unbuild will be different than the Build. https://usergroup.netsuite.com/users/showthread.php?p=47313 Cecelia

You know, it would be REALLY NICE if someone from NS would finally respond to this thread. Cecelia

Ya know, I've decided that I'm just not letting this one go. I re-opened the case and asked that this be escalated. Even the online Help says: "Once an assembly item has been built, it is treated like an inventory item for costing purposes. The Asset/COGS value of each built assembly item is the total value of the…

Good to know...thanks Malin. :) Cecelia

And why, pray tell, does an inventory adjustment use the CURRENT cost (last purchase price) for an item instead of the FIFO cost????? NetSuite? Any answers? Explanations? Suggestions? Cecelia

Andrew - nope, haven't looked at that (no time). However here is an update on the problem, for anyone else using FIFO and Assembly Items: 1) If you Unbuild starting with the button on the Build record, the projected value will be the same as the original build - but that's still not correct for FIFO because the system is…

Should work fine.. when you build the assembly, the current cost of the components per their costing method will be absorbed into the finished goods' value, which will then use its costing method when sold rather than the components. I have a serious problem with this. Under FIFO, the system should not be calculating the…

*bumped* Malin? Evan? Or anybody else at NetSuite? Could you respond, please? I'd really like to know what the rationale is here and why this isn't a defect. Thanks, Cecelia

Okay, I'll buy that. Thanks Evan.

The On Hand remains constant until you fulfill a SO. The Available changes as soon as you SAVE a SO. So, when I edit a SO, seems like the "Available" should be quantity remaining AFTER the current line item qty is subtracted. This makes the "Available" mean the same thing to all SOs. Jim, I have to say, you did a much…

Since NetSuite is going public soon, would they tolerate this abberation (i.e. SarBox compliance?) if this was their income statement that their CEO and CFO had to sign their reputations to? An excellent question, Tom. Sixteen MONTHS and it's still unanswered? Wow, you must be a very patient person. I think at that point…

Miguel, Here's a couple more for you... (5) There is one line in the online Help (under the topic "Enable the Multiple Units of Measure feature") that kept us from using lot numbers: "Units of measure cannot be used with lot-numbered items". Basically, lot-based inventory in NetSuite is purchased, stocked and sold in lots…

Go to Setup > Customization > Transaction Body Fields > New. In the Applies To tab, select Inventory Adjustment. As you probably noticed, the Inventory Worksheet has a New Body Field button but the Inventory Adjustment is missing this button. I'm pretty sure the Inventory Adjustment used to have this button and I bet that…

What I've heard is that you can revert back -- BUT -- support has to do it, it takes a while, and there's a significant extra charge for it. So before you do it, check with your rep and with support, to find out just how much time, effort and money it will take to revert back to one location. Hope this helps, Cecelia

Thanks for helping us test it, Jim. :) Yes, I'm certain there's at least one bug here...looks like the problem will be in deciding which one it is! I've also found that it's not 100% reproducible every time. But in any case, I'll report it to support next week and hope for the best. Cecelia

Yes, that's exactly what I did - deleted the Unbuild and then the Build (and created a new Build to accurately reflect the corrected quantity, which is why there was an unbuild in the first place). Unfortunately I now have no confidence whatsoever in the way NetSuite handles FIFO costing. Continuing this discussion here,…

Yep, that's exactly what I'm saying. Here's the sequence: 1) Build assembly 2) Receive PO for one of the member items - with a new (higher) purchase price. 3) Unbuild the assembly (no changes to member items; same qty) Result: Build and Unbuild have different inventory valuations. The Unbuild value is greater than the…