Tom, We get to the data via https://manager.paypal.com/ and the merchant account also shows up in our regular paypay account.

We would like for the cc to be declined at the Sales Order level if there is no match. Mary, I do not know the answer to your specific question in NetSuite. I do know from experience that declining the order due to CVV mismatch can cause challenges. In our case the challenge is that even though we set the gateway to…

I have used Authorize.net for the last three years. I have found them to be great. We are currently moving our web store to NetSuite. I have voted for the enhancement to have Authorize.net support. That said, CyberSource announced in June 2007 that they are acquiring Authorize.net. Over a 2-3 year time horizon, I believe…

@rnedelkow Is there a suite answer on how to make territory management based on ship to address?

@Robbie Were you able to make this work?

Current status of issue: s3 Description: "SUMMARY:Promocode values are stored in a cookie while Leadsource does not" That would certainly create the senario discussed in this thread.

A fellow NetSuite user and NetSuite support contacted me (separately) this afternoon and both raised interesting points / questions that others may find useful: From the fellow NetSuite user: Question: "You use both Google Analytics (GA) and Clickable to track PPC, why do you care about NetSuite's Keyword Marketing…

This is my current thought on this thread: 1) NetSuite captures clicks from PPC and CSE but it CANNOT report on that data. Stated another way, the data can be seen on a Marketing Campaign Record | Statistics | Unique Vistors. If you look at that number each day, it will roughly move similar to what you see form the PPC and…

This is just an observation from testing. I observed the HTTP header traffic related to the coded URL's I'm using. When you enter the following into the browser: http://www.mysite.com/my-item?leadsource=900090&utm_source=bing&utm_medium=cs&utm_term=17737&utm_campaign=cs NetSuite issues this 301:…

...getting accurate data in my Campaign response report... Ajax, Please confirm my understanding of this statement: 1) Does Amazon Ads = Product Ads where the individual URLs for each product are uploaded to Amazon? 2) In Amazon Seller Central are you running the "Performance Over Time" report with a specific date range?…

NetSuite created issue 186804. Question / Request: Is anyone successfully using the Campaign Keyword functionality to accurately track: 1) Visitors (raw or unique) 2) Leads generated 3) Purchasers From the testing I am seeing, reliable numbers are not being generated for #1 above. For #3, it appears that sometimes it works…

We have a great example if this today. For a sales order received today, NetSuite shows the customer used the promo code "shopping". This code is from Shopping.com. The promo code is passed via the destination URL using &promocode=shopping Unfortunately, the order does NOT show the leadsource as being Shopping.com.…

This has been escalated in support. Part of the challenge is that the two reps I've spoke with really do not have a deep level of understanding of how coded URL's work. The most recent rep said that the following is not allowed: ?leadsource= He said it had to be &leadsource= Obviously, he was not aware that ? is for the…

I have not used the NS ODBC connector but have a few battle scars from the combination of ODBC and Crysta. Not all ODBC is created equal and at time Crystal can be flaky. Have you tried accessing the ODBC connector using another tool? Something like MS-Access using "Linked Tables" or MS-Excel using Data | Import External…

Why was this redirected to Outlook integration. This has nothing to do with outlook. It is a basic Plug-In under Customization | Plug-ins?

Netsuite says there is an enhancement request for this and confirms this is how it currently works.

We create RA's from cash sales and invoices for two reasons. First is the cash sale properly pushes the credit card p/ref information and second because while unlikely it is possible the cash sale/invoice could have a different amount than the sales order. I think your idea about the custom field may work.

KCSF Bud The is a customer Return Authorization (RA). The challenge is while the Vendor Return Authorization VRA automatically picks up the PO is a drop ship, the RA does not. If you forget to check that little box on the RA, then the item goes back inventory. :-( Thanks for the confirmation that it is not each to resolve.…

@rnedelkow Thank you for the reply, I was able to get this method to work.

@moonparas Thank you for your reply. I was not able to get this to work. To test / learn, I placed CASE WHEN max(nvl({activity.date},TO_DATE('01/01/1900','MM/DD/YYYY'))) < MAX({TODAY}-7) THEN 'MATCH' END in as a result on the saved search and received an error. I was wondering how Formula (Text) = Is > MATCH works. I would…

Can't you just test customer : leadsource is none of none? Evan, Sorry, I was not clear. I'm trying to test the customer.leadsource.type field from the Sales Order. Stated another way, on the Leadsource "table" there is a field called Type which for us is email, Pay Per Click, Comparision Shopping, etc. I would like one…

Because we only support a single-level join in search, The only way to access both the type field on the customer's lead source and the sales order data is to use a customer search, using both "Transaction Fields" and "Lead Source Fields". Thank you for the confirmation.

Mathieu, Thank you!! Since formula fields are essentially Oracle SQL, wouldn't the CASE statement accept a LIKE clause? Oops, that is a little embarrasing. I thought I tried that but I obviously did not because this works: (case when {messages.subject} like 'My%' then 1 else 0 end)

Also, on the summary tab you would: 1) Summary Type = Sum 2) Field = Formula (Numberic) 3) Description = is 0 4) Formula is listed above.

Evan, Thank you -- it worked!! Notes to others using this logic: 1) Use messageS (plural) sum(case when {messages.subject}='My email message' then 1 else 0 end) 2) On the Results tab, at least one field must be defined as Group in the Summary Type column. Very cool, very fast.

I have a list of customers in Excel. I need to know if any of these customers are in our NetSuite customer list. How can I achieve this? Do you have some type of primary key in the Excel file? Using web services you could figure it out. Call or email if you want to chat.

I am missing something or does Netsuite fail to pass the sales order / cash sale number to paypal? You are not missing something; there is no link.

I seem to be spending hours and hours reconciling every week/month!... PayPal, ... Vicki, PayPal is a challenge for the following reasons: 1) You can receive money via PayPal standard before the item is shipped so PayPal online will show more money than is in the PayPal cash account. (ie: you have the money but no cash…

khultquist Great idea but it does not solve the issue. The function parser is evaluating every field before doing the case statement so the nest does not solve the issue. pcutler I think you are on the right track, making a script/workflow that would set this field rather than doing a formula without saving the value.

@khultquist - thank you for your post about pculter. I did not understand the solution the first time I read it. @pcutler Creating the two fields worked. @MikeBucklaew Thank you for testing it, the workflow works as well. The is the solution I used: custbody_cleared_hidden Type = Free-Form Text Applies to Purchase and…