Angela Bayliss · Senior Solution Architect · Silver Crown

Angela, Another great primer on inventory mgt! :D You should really consider writing a white paper (for sale) detailing the procedures, tips and tricks you have learned in dealing with NetSuite Inventory Mgt. I'm sure it would be a best seller! Would you mind explaining in more detail the "clean up" adjustments that you…

The adjustments and the time taken to stay on top of it....do people really sit down and tackle this full on? I would need a few wet Sundays to fix our number of items showing zero qty in stk with a few cents tacked on as a "value on hand". The people who want it fixed do. The time it takes to stay on top of it is nominal,…

Angela, you're nuts! :p There's no way I'm going to spend time cleaning up after the system and think this is normal. NetSuite is supposed to keep track of inventory costs going in and out, and not leave orphaned money lying around, period, end of story. Yes, I might be able to stand on my head every full moon and mutter…

Wow, Tom, as one who has dealt with public accounting for years, let me tell you I look forward to NS going public, hopefully, it will trickle down to us. I agree with Cecelia, you have an issue and the louder you yell, the sooner it will be fixed. On the other point: For the items having a value with zero on hand, this is…

Hi Heather, It seems to me that you have two options here: Either you can change your process flows with your employees to use the sales order cycle with cash sales, which will prevent them from selling comitted items, and use the system as designed. Or, you can create a script that blocks the save on cash sales, if there…

Chris, are you on 11.0.6, or 2007?

Totally understood. I didn't mean to offend you, if I did. That was not my intent. However, if we all want some changes, my experience with software enhancements in the past is to talk a lot about it. Then, the folks at NS will see that is really is wanted/needed and perhaps put it into the queue. This thread was started…

Evan, I filed a case for this request. Support said the capability is there but I don't see it. It is great that the vendor name (ie vendor sku) is visible on item receipts. It would also be great to add the same vendor name to the "Bill Purchase Order" functionality. For example, today I am billing a PO with about 40…

Hi Cindy, Was the serial number issue just for that one item? The rest of the serials were working fine? If this is what happened, then I bet it has to do with the limits in place by NS, and I have an idea how to get around that if this is the Physical Inventory Worksheet that I created. As long as all of the serials are…

2) Put the newest at the back/ oldest at front (Grocery stores do it). 3) Mark items in some way - with a grease pencil, a sticker with date and/or cost (Restaurants do it). In any event, it is a process change and requires buy-in from users. Let the users/warehouse know what you need as far as information/tracking and ask…

Hi Matt, Is this report something you would be using ongoing? Is it something that you will be providing to mgmt? I ask only because it should be possible, but it may get a little 'busy'- meaning, more information than you might actually need. Due to this, and the time it would take me (I would have to update my test…

The serial number issue is for this one item (initially we thought it was more, but I think that was due to our warehouse manager making a copy of the initial output file and Excel's per cell character limit for copies). All of the serial numbers are in Netsuite. The work around we used was to copy and paste the SN's from…

ahh, I am starting to get the picture. Essentially, it will not allow you to go back, and pull the info needed to actually use FIFO methods- it will only allow you to get it going forward. Would be a lot of help, as long as you have no inventory is stock when your upgraded.

ok guys, I have some bad news for you. Since I am trying to combine a search on serials (item search), and a search upon dates received (transaction search), I am not having a lot of luck. Due to this, I doubt that there will be any easy solution (1 step process) to keep track of FIFO in your inventory. Below, I mentioned…

I understand exactly what you are facing. I ran into this wall some time back. If I am correct, you want FIFO to apply, even to your serialized items. NS will not work that way- I went back and forth with them quite a bit. Anything serialized in NS uses only specific costing, no exceptions. The only way that I could come…

Jcoffman, WIth all due respect, my friend, you are kind of preaching to the choir. You see, I could not agree with you more. I had a conversation in here not so long ago, regarding the fact that serialized items are all given specific costing, even though specific costing is not one of the global choices for costing…

alternatively, you can add a simple task to your month end process of creating an inventory adjustment to zero out the negative quantity of the sample. Since it should be a net zero adjutment, it may meet your needs with a minimal amount of fuss, and still keep your accounting department happy.

Maybe we could surprise our collective selves if there was an enhancement number we could all pitch in our hopes and dreams for. I know it's a bit of a pain in the posterior to go through voting for an enhancement, but as Angela says, thats what it needs to climb the priority pole. Angela, was there an enhancement number…

Hi Robert, You are missing something, I hope I can help. I know a bit about serialized items, but do not actively use multi-location. I did get myself into a fiasco with multiple bin management, so I now understand a little more. serial numbers are a dependent subrecord under the primary item record. The locations of the…

Case number: 646391 End result: "The system is behaving as intended. When an assembly item with lifo/fifo costing method is unbilled, the most recent cost is used on the assembly members rather than the build cost. QA has confirmed that this is a system design." Question: WHY? Cecelia Good Question- this cannot be…

got me on that one, Cecelia, guess my analytical brain pulled the wrong example- thanks for correcting me...

just a thought, but would it not be easier for you to take the 100' cables, and enter them in at a cost per meter, as 100? this way, you could sell them in whatever increments you wanted, easily, the entire roll, or individual meters? I usually try and keep things as simple as possible, but thats just me... now, WTH is a…

Carrie, Do you have serialized items in multiple locations (bins)?

yes. I deal with this. Because samples, for us, are always something we aquire with a zero liability as well as a zero revenue, I am able to lump them all together. You are not that specific, as your wording says that you then sell to customers. If so, you are looking at 100% markup, but you should still be allowed to…

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…

hey, I was wrong, I admit it- I wasn't concentrating on MIlk, I was concentrating on serialized components. lol- never ever did I say I was perfect ;)

Morning Cecelia, Not trying to be to elementary here, but understanding the basics of costing will take you everywhere in understanding the solution to your question. Here goes- LIFO/FIFO- both of these are essentially specific costing- hence the cost of the items, in the order they are purchased, will determine the cost…

We have serialized items in multiple location, but not in bins. Sorry. ahh, my bad, big difference. Now I understand. thanks!

Cecelia, hopefully, your not using any items that are serialized. I have just pointed out a major issue with the way netsuite applies costing to serialized- there is little logic an GAAP compliance with the way they are working it. just a heads up.

ROFL- I am a morning person, always have been, its the posts late in the afternoon you need to take with a grain of salt. and for the record- three a day- otherwise, my sales teams threatens me for being annoying- can you imagine? me, annoying....:D