When my company was moving to NetSuite the lack of a Debit Memo was an issue. In our case the debit memo's our accounting team were creating had the same pattern. So when we moved the Debit memo from Sage-Accpac into NetSuite we did so with an invoice and a journal entry. I'm a developer not an accountant but the solution…

BFO will work for you but you need to build the string that is fed into BFO to get a result in PDF. This requires some knowledge of suite script.

If this is becoming a regular type of thing. Some simple scripting and a custom field would work. Create a custom field email_to_add, and that's the field you target with your CSV import then have a user event script on beforeSubmit executing when the runtime context is CSV_Import. You could pull the value from your custom…

Does anyone have the effective dates for each state. For example say a company shipped 500,000 USD this year to date into Michigan, it's above the threshold but what is the effective date for calendar year 2018.

How did you read the email. Is it only pertaining to online sales, or does the channel matter. Is it if the product is entering the state is all that matters and how the order was placed is irrelevant?

Do you know of the states where Amazon has already started collecting tax from the states named in the email? We don't have Nexus setup for any other state than Florida. Our Amazon FBA orders shipping to Florida come into NetSuite via Farapp and have tax charged on these cash sales. I'm not in finance, does Amazon remit to…

Retroactive meaning if I shipped 150K worth of product into Washington state in previous Calendar year I would need to self assess and assuming an average rate of 8% send Washington state a cheque for 12K? This is a mess. We have Amazon FBA shipping into Washington state. Amazon has already started collecting tax . But…

I am an accountant so I am not sure I can help; but, I will give a couple of ideas. Is the creator (assuming you mean person) not in the field called "Created By"? I don't have subsidiaries; however, the system probably created an account in the GL called something similar to "Intercompany ....". When I customize the…

Hi John, Just a shot in the dark here, but I know when you're searching fulfillment records, if you're setting mainline to False or no, this results in 3 entries showing up in your search. To remove these, you can use a formula field MOD({linesequence},3) = 0. The multiple entries are due to how the process for fulfilling…

Proud Canadian based in Ontario

I don't think you can default to confirmed opt-out, and I have tried to set confirmed opt-out via suitescript and suitetalk with no luck. The danger in defaulting to Soft Opt-Out is that the act prohibits sending subscription invitations which soft-opt out will allow in NetSuite. This in ability to have a certain role be…

When you say item page do you mean someone is viewing the page inside the NetSuite UI or on an e-commerce site. If they are viewing the item page in NetSuite then yes I know for sure it's possible, and likely possible to on ther e-commerce site just have no experience with that. You can have a beforeLoad user event script…

I would recommend using the internalid for storing in another system. The tranid (Document Number) is what shows up in the General Ledger, and technically can have duplicates.

You're down today as your in the test window for TLS 1.2 on May 9th - 20th your code will run no issue. May 21st is the official stop of support for anything less TLS 1.2 I believe. It seems depending on where the code is running can affect if you need to change anything at all. Here's some links I stumbled on when looking…

May 21st 2018 was the day they went live with only accepting TLS 1.2 connections to the best of my knowledge.

Your passing the NLAuth parameters in the Authorization header right? Your examples sort of indicate your passing these as url parameters.

It appears how you referenced the web service in Visual Studio is why the previous reply references a NetSuiteService class that you don't see. From what I can see you added a service reference which generates different proxy classes than if you added a Web Reference under the advanced button on the service reference…

Behind the scenes of the line item NetSuite does record the weight in lbs for the line item but it isn't exposed in search or the UI. So you'd be looking at a small customization. Or could you define a new Shipping Item called First Class international to Canada and define your rates that way? If you were to build a rate…

You can create a transaction saved search that will sum the weights from the item record, and then use that search result on a custom non-stored transaction body field that references the search. Then in the UI the sales reps will see this value once the new custom body field is added to the sales order form.

A Netsuite solution will really only work if the item your shipping is sold in a way to erase any empty volume in the box that ups gets. If you have a wide range of products with their varying size there will always be the chance for empty volume in the box that ups gets there by increasing the likely hood of getting hit…

rnedelkow Are Sandbox, Production and Release Preview for shared accounts all on the same hardware setup. I have found release preview accounts to be much slower than sandbox and production prior to this database upgrade, and I'm concerned testing a new database upgrade becomes harder for the end user if the hardware…

Hmmm if UPS is writing the software this seems a little odd that they're not investing in learning NetSuite themselves. One would think they would know the calls to get this information. First, I think you need to find out how they are accessing the information from NetSuite? Are they using a webservice, restlet or are…

I don't think NetSuite allows access to any of their documentation outside of NetSuite, so for you to provide them with this information would be tough. UPS will need a user account to connect to NetSuite. So initially you could a create a limited role for them and give them access so that they can access the help files…

Have you tried not using div element tags. I have found seen strange behaviour and errors when using div elements. In my templates I user for BFO I exclusively use table elements and have no problems. You should not need to escape your entire string you send to BFO, but you should deal with data fields that might contain…

I don't think you can do the contact linking to the order via CSV import. I don't use SalesForce but if you want the SalesForce and NetSuite contact to be mapped when creating the netsuite contact record you could set the externalid of the contact record in NetSuite to a sales force contact key field. For a contact to show…

Oliver, when I mentioned I was wrapping the column values that contained a comma with quotes, I did not generate a new csv I appended by accident to an old file which did not have the column values with a comma wrapped with quotes for some records. Long story short every thing is fine. Bruce, any data import tool I have…

I've noticed this as well something has changed on NetSuite's end when they went to the new Sandbox architecture. However, does it actually email to the recipients in the scheduled report? In my case the emails goto the creator of the scheduled report or the email indicated under Sandbox Options from the Setup -> Company…

khultquist We're using Google G Suite, and had this happened to us yesterday do you know of a issue specific to Google G Suite?

david.lyle I filed a defect for this and the fix was pushed to my account. Case Number3051187Case SubjectDefect 493511: SANDBOX > Open Customer Record > Notice (SuiteScript) An unexpected SuiteScript error has occured While I suspect the issue won't present itself on your next sandbox refresh if you contact support perhaps…

Just filed a defect for this as well. In my testing appears to be file size related anything under 1MB seems to get uploaded fine.