I've tried using MySQL Workbench and Power BI. But I know nothing about how to navigate through a sql tables. So far I've managed to figure out how see the data in the tables, and how to search for an individual transaction or record, but can't figure out how to get to that found transaction. It's all very complicated for…

thx!

Upgrade triggered last night and now are locked out. Web site is down as well. What now?? What a way to start the weekend. 

Upgrade was due to trigger last night and now are locked out just like you, Tom. Web site is down as well. What a way to start the weekend.

Thanks for posting this, kastnerd. I rec'd the email notice as well, and I'm wondering the same thing. Angie S.

Hi Sean - I see Issue # 133408; it's listed as an Enhancement. thx, Angie S. FilterSolution.com

Thanks, Cat!

Hi Tom - I found this on another thread: In order for the phone number to be sent from PayPal to NetSuite, you have to set the phone number as required in your Profile at PayPal: Profile -> Website Payment Preferences -> Contact Telephone Number We were having the same frustration until I found this info. Later, Angie S.…

My bad - The phone number is populating in the Customer record, but only on the address tab - not on the General tab. Thanks, Angie S. FilterSolution.com

Doug - We went into our PayPal Profile at Profile at PayPal: Profile -> Website Payment Preferences -> Contact Telephone Number and set the phone # as required. The customers' phone numbers now show up in our PayPal account, but they're still not populating into our NS customer records. Please advise. Thanks, Angie S.…

We've been having a different sort of problem, but seems to be a NS/PayPal glitch: Some of the web store orders with PayPal payments show up as back-ordered, even though there is plenty of the item in stock. For instance, the screen will show Qty. Ordered -1; On Hand - 0; Available - 17; BO'd - 1. The order's status…

Here's the results of my testing: Test customer group - one test group member is confirmed opt-in with # 1 of 5 possible subscriptions. Another group member who is set to Soft Opt-in is also subscribed just to Subscription #1. Test Email template configured with Subscription # 3. Sent Bulk Merge email using Test template…

thx Jacky!! I see the explanation in the Global Subscription Status Field Help has been updated/clarified as well :)

Hi David - Did you ever get an answer to your last question? I'm wondering as well. Ken, is there a way to customize the subject line of the email? thx, Angie S. FilterSolution.com

I'm about at the end of my rope here.:mad: I've had an ongoing support case # 877299 since last Saturday (5/9) with this same issue. I've followed all of the support rep's suggestions and others posted here, including clearing the cache and cold-booting the computers, running the update on different comuters, shrinking the…

Just ran a Confirm Subscription Mass Update myself early this morning, so server activity shouldn't have been too busy. The Preview results showed 8,096 customer records. Filters were 'Script Status Soft Opt-in', Date created btw 9/14/04 and 3/15/05, 'Email not empty', 'Email contains @'. After running the Update, NS…

Just ran the update again. Says successful on 31 records again. Someone with NS, please advise!!! Angie S FilterSolution.com

I'd like to see an answer to DCM's last post as well. To me, NS is acting as a 3rd party just like Constant Contact or Lyris. Why do these keys need to be set up in order to improve deliverability with NS, but not with these other vendors? thx, Angie S.

Hi Kent - It's my understanding that you have to contact your DNS provider and request that new domain or sub-domain for email campaigns. Here's a quote from another thread: For more information, please reference Help topic: Setting Up Domain Names in NetSuite. We had our DNS provider set up a sub-domain,…

Malin - We also have a big discrepancy between the value in the Chart of Accounts ($105K) and the Valuation Summary ($67K, which sounds about right). We've only used one inventory asset account ever. The only journal entries ever made were when we set up NS back in 2003. Inventory adustments are at $11k in the Chart of…

Thanks, Barry! With fiscal quarter approaching , I figured it's a good time to dig down to try to get to the bottom of this. I suspect that part of our problem is that when NS was first set up, we chose the Average costing method, as opposed to FIFO. Angie S.

Cat - I have a similar situation. We have widgets that are set up as follows: -Inventory Item -Units Type Piece Count / base unit is labeled "Each" with a count of 1 -Stock Units = Ea. (1) -Purchase units = Ea. (1) @ $1.00 ea. -Sale Units = Box of 6 Customer orders Box of 6. We created drop-ship PO, which shows Qty 1,…

Can anyone with NS advise us? Would one of us have to submit an enhancement request?

Dave - Did you ever find out how to do create your search? I'm needing to perform this exact custom search!! I've looked high and low, and I also don't see the "Item Drilldown Template" as an option. Thx Angie S. Filtersolution.com

Nope. Just voted for the enhancement.

I am having a similar issue. I have a saved search that is supposed to send an email when purchase orders for a particular vendor are created. Specific recipients are me and the vendor. This search was created back in September, 2013 and worked fine until on or around May 14, 2014. I've made sure all of the suggestions in…

To Paul Horos - Hi - were you ever able to get a search that outputs one tracking number per line? Thx, Angie S. FilterSolution.com

Hello Yang - I used your instructions below, got the desired results (THANKS!) and created a saved search from it. I tried to create a dynamic customer group from this saved search, but it won't show up in the drop-down list. Please advise. thx, Angie S.

One of our critical Saved Searches wasn't working this morning, but then it worked later on. Entered a Support Case, and they referenced the same defect #. Angie S. FilterSolution.com

Here's the reply I got back from Support: "Based on my research, the 'Number of Rows in List Segments' setting located in Home>Set Preferences>General tab does not really affect the Reconcile Bank Statement screen since it does not have a list, though it does have a worksheet, similar to what we see in receiving POs and…