Angela Bayliss · Senior Solution Architect · Silver Crown

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

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…