You need to edit each item, but this can be done via a CSV update.

Admit it, it's the XBOX example that makes it good ;) Mmmm, XBOX...

Hello Lisa, It does sound like you'll want to use Assembly items rather than kits. Allow me to briefly explain the difference between the various grouping item types: A GROUP item is an item that groups several sub-parts. When you sell the Group, you deduct from inventory each of the member components. The Group item…

If you're talking about automatically printing as in the printer spits out printed pages automatically, that is not possible with any browser-based program, such as Netsuite, because browsers are not authorised to access printers (I invite you to imagine a world in which spam sites can access your printer...) To achieve…

Depends on the size of the data. Not really less than 100 hours usually. Could be much more than that.

How many documents are we talking about here? Roughly speaking, what is your total file size?

you'll need to extract the month from the current date e.g. to_char({today},'mm') (I *think* MM is correct. might not be, but should be something like that)

Hi Corinna, Not sure if I understand you correctly. Are you talking about adding multiple items at once to a transaction? If so, there is a specific "Add multiple" little button above line items you can use.

I think people don't necessarely use Pick Pack Ship exactly as the names suggest. Most customers I've seen use it in a variety of "3 stage" fashion, and not necessarely as literally picked out, put in boxes then out the door. There are a variety of reason why people would want the Fulfillment to at least inittialy be…

Depends how much you care about the functionality of Serial Numbers. If you only place a custom field, say as a transaction column, you will lose the validation than ensure you don't have duplicate SNs, unless you script it back in. It will also be much harder (but not impossible) to see what SNs you currently have on…

Full Access cannot post in closed periods

I believe the problem is that roles are logged in the Audit Trail. So as soon as one person logs in using it, you can never ever delete them again. You can only Inactivate them.

Yeah we made such a script, because the fact the GL Impact is not in the same period that the inventory impact actually occurs is terrible accounting. If you're really unlucky, you could even have the two occur in different financial years, really. Changing the date/period of the fulfillment transaction is not great…

Employee Centers are specifically designed to limit your abilities (that's why they are 5 for the price of 1). So you won't be able to make them see/edit transactions, aside for Purchase Requests.

Hmm... are they making non-GL impact changes? There's an option for that in the period setup. Could it be that?

Yeah this seems like a sound approach. It's a big bite though for someone that has never scripted, there's a lot to script in there. I'd also ask your boss to clarify what he doesn't like about editing the SO, as it could reveal a simpler answer. If he's worried about users editing the wrong field, you could instead just…

From a purely empyrical point of view, I think Date (as in trandate) is indexed. Maybe you'd be best sending this query to NS Support, Performance team. Though in general, in the past, I've also tried to get performance tips and best practices and have had little success.

Wow, thanks, could have gone a loooong time without noticing that :D

The problem we didn't realize we'd face when we arrived at this solution was that Netsuite doesn't really let us do joins as we could if we were working directly with a relational database. So we can get from the cash sale to the related sales orders, but we can't really report or search in ways that go from the sales…

javier, it's kind of creepy how we said EXACTLY the same thing at exactly the same time... :D

Hello Michael, While it's a bit immodest to recommend myself (;)) I'd like to present IT-Ration Consulting as a choice for you. We all full service Netsuite Partners especially skilled in Suitescripting. If you care to contact me via PM, email or phone call, we can discuss your needs and our offer further. Best Regards,

Hmm... there are several ways. Easiest would be scripting of course, but without having to resort to that, you could manage this with 2 different items. You'd have Widget A that represents single units, and Kit A which has 5 Widget As as member. You can thus maintain a box price and a unit price. The trick is that the user…

You can customize a role and pretty much give FULL to everything except payroll. However, the Admin role is more than someone with every right, Netsuite is actually hard-coded behind the scenes to let the admin everywhere. There are some functionalities that really only an Admin can reach. Seeing private Saved Searches is…

Your performance might suffer. Customer Records and Cases are not super bad, because they have relatively few joins, compared to Transactions. There won't be generalized slow performance, but you will probably reach a point where you won't be able to run in real-time any Saved Search or Report that need to sort through the…

Chrome was specifically designed to handle high javascript applications like Netsuite, and in my experience you do get blazing speeds. However, there are bugs here and there when using Chrome. The speed is enough so that several of my customers have switched to it regardless. I personally use IE8, because it is the only…

Yeah... I haven't played that much with the SO importer, but in my experience I believe there is no way to strictly speaking update a single line. What you need to do is tick in "overwrite sublists" and reimport the ENTIRE Sales Order, closing that one line.

"Closed" appears to be a valid field in the CSV Importer, so you should be able to do this. If that doesn't work you can use a script.

Ahh, I feel better for you now :) For AR and AO, I woudl recommend, as much as possible, to only import Invoices and Bills - skip SO, PO, Fulfillments and Receipts. The Invoices and Bills will have all the GL impact you'll need, so it would be really great if you can just get those. You'll also need of course Payments,…

Have you tried Inactivating the entities in question?

Firstly I think you need to scrap your July 1st date - not gonna happen. There's no way you're doing this in a month. Try to push it back as far as you can, September or October if possible. This is a huge undertaking that challenges the best of consultants, and being new to NS you will be learning a lot (and thus making…