3937730 Green Ribbon

Michael Bianco has the solution at SuiteSync http://suitesync.io/

Consider using a provider, such as Merchant E Solutions, who offers a tokenized solution to not store any credit cards in NetSuite. Good luck!

HI Bill, See my article on this capacity. Pretty easy solution if you are basically creating an installment plan. The idea is that you can invoice $120 today and then have 12 payments of $10 over time. Marty

Thank you David. Let me do some experimentation. My primary concern is that we won't have a credit card profile and I wasn't sure if it would simply assume that there is no Payment reference.

Received a call from Merchant-e today saying that we need to remove all firearms from our website (www.webyshops.com) or they will shut down our processing account because it's against the policy of their sponsoring bank (Wells Fargo). I am not here to comment on the politics of this decision. I am looking for…

Hello Lukas, I understand you are working on delivering the new Payments API and respect your authority on these matters. May I ask some questions? 1. Based on your previous response, does it work the same way no matter if we are using eMerchant Solutions or Cybersource? I assume so but wanted to confirm. 2. In the new…

I disovered from Support that there indeed there is a bug. Instead of returning the Campaign Response ID, we are getting back the Campaign ID. We developed a workaround due to this issue. Although not ideal, we still think we have a useful app. It is our new Outlook to NetSuite Sync application which is available free of…

We just developed a solution to help with bounced emails. The campaign response records have some bugs but we have a workaround. http://blog.prolecto.com/2010/01/01/solution-for-syncing-and-bounced-emails-between-netsuite-and-outlook Marty Zigman http://www.prolecto.com

Sorry about that. Not meant to flog. We are pretty excited about this solution. We have been experiencing the same issues others have and we think it is a breakthrough. My hope is to allow the community use of it so that we can improve it. Marty Zigman http://www.prolecto.com

We have a tool to remove bounced emails. It is designed to work with Outlook. Check out: http://blog.prolecto.com/2010/01/01/solution-for-syncing-and-bounced-emails-between-netsuite-and-outlook/ Marty Zigman http://www.prolecto.com

I spent a fair amount of time trying to get ODBC connected to multiple companies via one account. See my article here on it. Connecting ODBC to Multiple NetSuite Accounts http://blog.prolecto.com/2012/04/30/connecting-odbc-to-multiple-netsuite-accounts/ Marty Zigman Prolecto Resources, Inc. http://blog.prolecto.com

I spent a fair amount of time trying to get ODBC connected to multiple companies via one account. See my article here on it. Connecting ODBC to Multiple NetSuite Accounts http://blog.prolecto.com/2012/04/30/connecting-odbc-to-multiple-netsuite-accounts/ Marty Zigman Prolecto Resources, Inc. http://blog.prolecto.com

It's a nasty problem. Are you on .163? I had to go to a patched .166 version and then write a mass update / CSV import to get it back. I believe it maps the phone number for new contacts to an Address level (child) record to the contact. And it will wipe out the business number on the contact entity. After resolving this,…

I wrote a recent article on Inventory Received Not Billed and I supply a saved search to help explain it upon request. http://blog.prolecto.com/2017/04/29/explaining-netsuites-inventory-received-not-billed-account/

No, there is no way except via Web Service. But I am creating a service that will do this for another product we are creating. If you have interest, let me know. Marty

This is a good topic. I have written an article about it and have a saved search you can download to help explain the balance.

Because the commission module is relatively rigid, we often work to do it with some basic custom structures, searches, and scheduled scripts. We wrote about it here: http://blog.prolecto.com/2013/07/11/netsuite-driven-commissions-your-way/

I wrote a brief article about NS_CONCAT and how to use it. Really useful. http://blog.prolecto.com/2014/05/16/reveal-both-aggregate-and-detail-in-netsuite-saved-search/ -- Regards, Marty Zigman, Founder Prolecto Resources, Inc. NetSuite Systems Integration Southern California's Leading Innovation and Implementation…

I would argue that these Analytical Functions are not grouping functions. I found this article quite enlightening on Oracle Analytical functions. http://orafaq.com/node/55 I have been able to get LEAD and LAG to work outside of NetSuite group functions (it's not documented). Yet, when I use NetSuite Group functions on LEAD…

I believe transfers between currencies forces one of the currencies to be a base currency because NetSuite needs to price it (exchange rate). In your case, I think you will need to have a phantom intermediate base currency bank account which would be controlled by checking that it is always in zero balance.

Here is a method to update foreign currencies programmatically: http://blog.prolecto.com/2013/05/30/updating-netsuites-currency-rates-programmatically/

Indeed, I found the same issue. So what I did was source the information to custom fields on the transaction go from there. Also, I have started to work on a template that will just output the data model so you can see what to reference. Once it is ready, I will post a link. Marty

We are looking to create a list using nlobjForm.addfield that works like a generic Entity type. We want it to work like a column that lets you select either a company, vendor, employee, etc... What is the syntax? We tried sourcing it with an internal ID of "company" or "entity" but that doe snot seem to work. Marty Zigman…

We have a problem here as well. Example: We have a formula currency field named "custentity_actual_gp". The field works perfect on forms and when we reference is via API. Yet, when we try to show it in a saved search, we get ERROR: Invalid Expression. Permission on the field are "Edit" for both Access Level and…

Thank you for the thinking. Indeed, we had one field reference another formula field. Once I removed removed the reference, it solved the search problem. It's too bad. We really need a way to have "nested formulas". I wrote about it here:…

Thank you for the response. I should be clearer. On custom records, the customform appears to be an integer. Notice below that the customform parameter:cf below is 58?: https://system.na1.netsuite.com/app/common/custom/custrecordentry.nl?rectype=107&cf=58&whence= In a SuiteScript, I need to refer to ID to set the value to…

Do you have any thoughts on how to lookup the customform ID without having to refer to it by number? We want to make sure that our scripts reference it right but we are concerned that when we bundle and deploy the software, the IDs will change.

Am I missing something? Why would not create a category type for the entity and then use custom drop down lists that distinguish Physician? I did this for a vendor that I wanted to call an "Artist" for a music application. In combination with customer forms and some script, you could spruce up the UI to make it very clear…

We too are looking for a way to show the Tab Record Indicator on the tab of our custom sublists. Is there a way to make that show? For now, we are displaying an "o" to mimic the feature but we are not clear how to get the system to drive the built-in behavior.

We had to perform sorting in JavaScript to get the result we wanted.