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

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 -