Anyone using Box for NetSuite?

Bank reconciliation question: How do I clear a bill payment that has already cleared the bank (and NetSuite) but reappeared in NetSuite's reconciliation once the bill payment was voided? Further background: a bill payment cleared in July (both NetSuite and the bank). This bill payment was voided in August and appeared back in our NetSuite bank reconciliation as uncleared (again it cleared the bank in July). The GL impact from the void is correct (the funds were returned) - the decision to void the check was so we could reissue payment for the same bill.

I published a dashboard for a role with no restrictions for the Shortcuts portlet. However, I still can't edit the name of any links unless it seems I added the link to the Shortcuts portlet. Is there a way around this? Am I doing something wrong?

Is there a way to have the sender email in a saved search equal a field in the results?

Hello, does anyone here know if it is possible to use a SAML login with the NetSuite ODBC Connector?

got it. what has anyone done to use the ODBC Connector with multiple users?

It depends upon how you want to use it. We use it with SQL Server, defining a Linked Server that makes use of the ODBC connection to NetSuite. We then use either our local AD or SQL Server permission to control who can access the Linked Server. However, everyone who has access to that linked server gets the same effective access, since they are being authenticated to NetSuite using a single role. We use multiple roles and a separate ODBC profile & linked server for each role to establish different kinds of access. Keep in mind, regardless of the role used, all ODBC access is read-only.

Another way is to use an ETL process to download data on a scheduled basis from NetSuite, then use local permissions to control who can access different tables. The downside of that is that the data may not be up to date.

thats what I am concerned about. the only people that will be using the ODBC connection is our accounting team

if the accounting team all has the same role, you can make a copy of their role, with the added SuiteAnalytics Connect permission, and SAML disabled, and use that for the ODBC connection. Then everyone using that ODBC connection will be restricted to the data available to that ODBC role.

You will need to use a shared integration user. for example, make an Accounting ODBC employee record, and that will be the user for all ODBC access.

got it. Can I make it web services only so it can not login through the UI?

I haven’t tested that to see if it works. You could try it, but I don’t know if the ODBC driver actually uses web services (SuiteTalk)

I am going to try. our security team wants me to disable UI access

But, you can change the ODBC roles permissions to view only for everything, and also take away anything that is not a list or record permission, so even if someone did use it to log in, they wouldn’t be able to do anything

got it. Thank you Scott

I am curious to know if the web services only works

I will let you know when I try it out

how can I list all the objects/tables in netsuite with SQL query?

@Munish Singla with ODBC you can use the system tables (https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4407755805.html). For SuiteQL probably your best bet is the metadata endpoint (https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1540810174.html)

Hi, does anyone has knowledge is it possible to do project invoicing through salesorder, so that you dont need to complete all the project tasks and create charges before you can invoice?

Hi everyone, Is there anyway to hide these button in Netsuite ?

Maybe by script?

without coding

Hello everybody! Could you please advise if there is possible to push file to NetSuite FTP (file cabinet) from external service?

how to add ALL locations to an item automatically or upon item creation? and vice versa, how to add a newly created location to all items automatically or upon location creation?

Hello! Does anyone have or know where to find the NetSuite Setup requirements to use Ceridian Payroll with NS? I Googled it and checked SuiteAnswers and cannot seem to find anything. Thanks for any assistance! Desperate for answer as we are in holding pattern.🙂

Is there an issue going on with SAML?

anyone experiencing issue logging in NetSuite? UK here and we can't log in

I figured this would be straight forward, but I’m looking to get a list of all roles with a count of users assigned to the role. (trying to create some saved searches that would help cleanup old roles and things like that). Any advice? (When I create the search based on roles, then add user fields - name, it lists my account name as opposed to the names attached to role.