Angela Bayliss · Senior Solution Architect · Gold Crown

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

NS- anyone going to jump in here and enlighten us?

Alison, As seen in the new help: Reallocating Items As each sales order is created or approved, NetSuite automatically allocates inventory from the item's quantity available. NetSuite also automatically commits inventory to fill backorders when goods are received from your vendors. You can use the Reallocate Items page to…

sorry Matt, while we have a manufacturing division in Israel, we have not integrated to one system. All of my inventory is located at one location. a competitor to support- not certain that is true (I gotta believe support knows more than I do- at least someone there) but thanks, I think. What can I say, I have no life...:D

ahh, jeff, sorry to hear that. However, not certian I agree that NS failed. There is a way to do it, just not one you are wanting to utilize. Also, you may want to go back to the original post here, We have a full inventory of items already set up in Netsuite, with pricings, descriptions, rules for quantities and etc all…

I tried to do this before 2007, and had no luck whatsoever. Would be nice to hear you can do this in 07....

If your imports keep failing, your best bet is to call support and ask them why. They can see the specific problems in ways we in the UG cannot.

If you answer my questions, I can assist you in formulating a plan of attack, if you like. Nothing like taking a problem to the table and being able to say- I think this might be how we can fix this......;)

ok, I can help, at least for now. Step one, go to help, guides, and pull up the guide on CSV imports. Do some reading. Then go to setup-Import-Import CSV and get a feel for the templates. Once you do that, you will be able to better manage your plan. Come back here with questions. good luck!;)

One way it is possible is if you are using drop ship sales order forms instead of regular sales orders forms. may or may not be your problem, just one way it can happen.

Matt, I see that I didn't respond to you as I said I would. Are you finished, or do you still need this information? Exporting the count sheet is only step one of my physical count process. If you want the parameters of the report, or the whole process, let me know. My apologies for missing this -

Hi Angela, When you say 'export the physical count sheet'; what are you using to do that? The Adjust Inventory Worksheet or a Saved Search that you've formatted specially? I'm just trying to finalize stocktake procedures for 17,000 items in the warehouse and my head is spinning too fast... Thanks, Matt Matt-, its easy, its…

The only thing you have to remember is that Netsuite does what Netsuite chooses to do. Enhancements may be a way for users to vote for, to gage the demand, but that is not a guarantee. I have personally found that as long as NS is designed to meet one way of doing things, they stubbornly stand firm on allowing options. I…

what was that, Ray? did I get something wrong?

absolutely correct. However, I bet Jeff is a little intimidated at the moment, this is information that may be a bit overwhelming. Jeff, if you would like a step by step overview of what is needed and how to go about it, tell me a few key bits of information, and I will give it a shot. What types of items do you currently…

Doesn't seem like a use case that's very likely to occur... ? not very likely to occur? Malin, do you think I make this stuff up? I assure you, that is not the case. case in point: However "likely" or not this is to occur, it was routed to my desk yesterday when a 9k piece of hardware was RMA'd from the customer, and the…

matt, what are you saying? do you want my macros? remember- those who ask shall often receive ;) The physical inventory worksheet is a standard report- found in reports-inventory, physical count sheet ( or very similar, not looking at it at the moment). I just modified it to incude bins and serials. The macros are a snap-…

well, Andy, ask and you shall receive. Please remember that I use ALL serialized items. This process is directly dependent upon items being serialized. I modified our basic physical count sheet to include our serial numbers, bins, and not show zero's. Since the output has the serials on a report listed horizontally, I…

scrapping the whole thing, then?

Hope you don't have any 'Kit's as they don't advertise that Kits don't work with serialized components! True- but item groups work like a dream.

Angela, thanks for your advice. #2 that you stated above ..... sounds like our only option. Can you please share the steps to do things that way ? Thanks. Jeff, I hate to be the breaker of bad news here, but I was not listing your options. I was listing some but not all of the tasks that will have to be completed in order…

You just opened up a huge can of worms, my friend. I know quite a bit about serialized inventory, but what you are asking is much more than that. You may want to take a step back here, and reassess your approach. you can get yourself into quite a mess if you are not careful. Items- once you have items in your system, you…

If you create the RMA from the cash sale/invoice, it would have the serial # on it already. Likewise, if you create the RMA from the sales order, and you put the serial # on the SO to commit it before fulfillment. So in those cases, it's a matter of verifying that # on the physical item at receipt. That leaves 2 other use…