I believe this button is only displayed on sales order forms that are intended to generate an invoice, as opposed to a cash sale. Check out the form you are using and maybe test some other ones to see if this is the cause?

You should be able to just switch the vendor field on the PO form, no need to edit the SO. I've done this in the past - at first I was skeptical as to whether it would maintain the connection to the SO or read in the proper cost/vendor code, but it sure does. Give it a try. Edit the PO, change the vendor, save it, and then…

If the slowness of the import might be caused by scripts and/or workflows on the records you're updating, you *could* try disabling that in Setup -> Import/Export -> CSV Import Preferences. Might be dangerous though, depending on what customizations you have running. This sounds like a nightmare, I don't envy you.

Click the "CSV Response" link on the right, you'll download a CSV with the failed rows and any error messages.

+1 for BHacker 's solution - this is how I have been handling my UPC uploads as well and it does work.

Did you set up a new full year for 2017?

nicholasmschultz - FWIW this ended up being a non-issue for us; we are not going to have a split cart after all. However, if we were going to, then we would have just allowed the main line "department" field just get set to whatever value was mapped from the site/store where the customer checked out from. It wouldn't have…

Anyone have any thoughts? Particularly interested in whether anyone has experience with custom GL plugins at all - whether they've worked for you in the past or any hurdles you may have come across. Anything would be helpful.

+1 for Michoel's response

NetSuite Full Data Export does not include all your transaction data. There is no stock way to export all of this data from NetSuite that I know of. You have a few options. You can write a script (or hire someone to write a script if you can't do it in-house) that exports all transactions / lines systematically, generating…

Great!

What you want is a "Sales Tax by Tax Group" report. I created this by using the "Tax Code" field in the leftmost column, followed by transaction types, dates, amounts etc - you can customize to your liking. See my screenshot, give that a try.

Oops - you're right. I should have looked closer. Looks like what I customized was the "SALES TAX ON SALES SUMMARY" stock report, not the other one. Sorry for the confusion!

jprice - I guess I quoted the wrong title. The one I have is "Sales Tax Liability by Tax Item" - so I based mine off of that one, I believe.

skanive - I started with the "Sales Tax by Tax Group" report and customized from there.

I believe you would need Advanced Taxes turned on for that, and you could have a couple Tax Schedules set up - one for not taxable, one for taxable - the taxable one would apply only to the NY Nexus. All NYS tax codes can be downloaded based on your nexus directly from within NetSuite, and then NS should automatically…

Gabby JavaScript is not a fully-fledged programming language per se; it isn't strictly typed and it's interpreted so there's no need for a compiler etc. If you have experience in C, I think you'll pick it up fast. I would absolutely say it's worth learning.

EleniPalmos you will quickly discover how easy it really is!

I would also recommend the SuiteScript training. I've taken several of the NS courses and that one is by far the most useful. It's pricey though...you could go with poking around in SuiteAnswers or the guide you found but it probably won't be very guided. This forum is a great resource as well for questions. Also, be sure…

Are you looking at an old (CRMSDK) template, or has it already been converted to the new (Scriptable) template?

Glad you got it worked out MarthaHakes - I agree, it would be nice to have a consolidated report like that available in stock NetSuite.

It's not easy to do, but the best way to do it is actually to start by reporting on the sales order record type. Once you have that, you can connect via the applying and applied to transactions to get the other info you're looking for. If you need more assistance with this, feel free to reach out directly to me via PM or…

EleniPalmos it sounds like what you are after is creating a Saved Search. Check out this answer for starters: https://netsuite.custhelp.com/app/answers/detail/a_id/8493/

cctenergy - the second column had the "Age in Days" function applied, so instead of displaying the last date, it would display the number of days since the last date. You may not need both, but I find both helpful.

If you don't like that report you can create a saved search fairly easily: (Item Saved Search) CRITERIA: - Type is Inventory Item (or any other items you care about sitting, Assemblies is likely the only other relevant type) - Transaction : Type is Item Fulfillment - On Hand is > 0 RESULTS: - Name, Summary Type = Group -…

Hey rickwilk - check out Answer 8484: Highlighting Search Results in SuiteAnswers. Here's the URL: https://netsuite.custhelp.com/app/answers/detail/a_id/8484/kw/highlighting (be sure to log into SuiteAnswers first).

sethu - you probably want to add Transaction : Main Line = True

cctenergy I would just include the field "Total Value" in the results tab.

sethu you may want to add a filter for Use Bins = True, that should only include items that are intended to be in your warehouse. As for the multiple transaction lines, I'm not sure what to recommend at this point but perhaps if you attach some screenshots I can help further?

sethu - that is exactly what my suggested saved search will do for you. Item Fulfillments are only used in this instance to let you know how long it has been sitting. This does assume that you have at least fulfilled it once. Are you concerned with items that may have not been fulfilled? The search can be adjusted if this…