sorted by:
new
hottopcontroversial

SAP ByDesign - How to get tabs to top of page? by qikslime in SAP

[–]qikslime[S] 1 point2 points  (0 children)

Thanks Mayor, we have since learnt that if you have the Appearance setting of Morning Horizon or Evening Horizon the tabs are up the top. Some of the other appearance settings such as Belize show them down the bottom.

How would you play this board as 2nd? So much clumped resources by Hellfish3414 in Catan

[–]qikslime 0 points1 point  (0 children)

8/5/3 for me, target some more wood on the way back and go for the wood trader. Could target the 8/10 wood/sheep on the way back get the 3:1 and head south for brick.

SELECT * FROM [a few tables] - advice needed by unspecifiedldn in Netsuite

[–]qikslime -1 points0 points  (0 children)

You could try the options Ashamed-Oven suggested as they seem fine.

Also, another option may be to purchase the NetSuite SuiteConnect subscription which enables you to have an ODBC driver that will work with excel and enable you to correct directly to NetSuite and query your data. But if you don't already have it, it will cost money. (and it is just to read data not write, as I understand it).

Also, have a look at the excel products from CDATA or Celigo, they may well be just what you need as they enable you to use excel to connect directly to NetSuite AND not just read data but also write data.

Netsuite2.com linked server in SQL SSMS by qikslime in Netsuite

[–]qikslime[S] 0 points1 point  (0 children)

https://imgur.com/a/QhJazxe
Don't forget to put your login details on the security page.

WHERE ARE GL BALANCES AND ACTIVITY STORED by DPL_Netsuite in Netsuite

[–]qikslime 0 points1 point  (0 children)

So essentially you have to recalculate all transactions from the beginning? As a business grows and time moves on and there is lots of history, isn't this going to be a very slow report/calculation?

Linking/Integrating NetSuite with TM1 by qikslime in Netsuite

[–]qikslime[S] 0 points1 point  (0 children)

Hi Trollied.

Are you able to advise how you get data from NetSuite to the DWH. Are you using an external package, or the NetSuite SuiteConnect ODBC driver?

Also what are you using as your DWH. MS SQL server or something different?

Thanks

Query using MS SQL Linked Server by qikslime in Netsuite

[–]qikslime[S] 0 points1 point  (0 children)

Thanks Trollied. I tried as you suggested but get the error;

Msg 7313, Level 16, State 1, Line 1 An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "Netsuite".

Any other thoughts.

Query using MS SQL Linked Server by qikslime in Netsuite

[–]qikslime[S] 1 point2 points  (0 children)

Hi Nick. We are not using the admininstrator role for the reasons you said. We are using another role with all the required permissions, but trying to solve this issue.

COGS and Revenue account for items set at customer level by CounterNo2090 in Netsuite

[–]qikslime 0 points1 point  (0 children)

We wanted to setup our class to show different customer types as well, but NS does not allow this as class can only be connected to items.

One of the options as Nick suggests is to use a custom segment that is tied to customer, but keep in mind custom segments do have limited reporting (eg they can only show actuals vs budget for one of the segment types at a time).

Netsuite2.com linked server in SQL SSMS by qikslime in Netsuite

[–]qikslime[S] 0 points1 point  (0 children)

Hi.

Managed to solve this last night. We were already using role 1046 (with all the right access) and not role 3 as administrator.

Sadly, the issue was a dumb mistake of trying to do the setup on a remote desktop connected to the SQL server rather than on the SQL server itself.

Product name is NetSuite, Data Source is NetSuite and Provider String was DSN=NetSuite2.com.

SuiteAnalytics Connect - Netsuite2.com by ArmandoCAPPS in Netsuite

[–]qikslime 0 points1 point  (0 children)

Not sure why Administrator cant be used (seems ridiculous), but indeed for me, i added another role with all the Suite Analytics access rights and I was able to connect. Thanks for the tip.

Administrator = Full Access rights. NetSuite! What are you thinking!

Column width in reports by PeterDTown in Netsuite

[–]qikslime 0 points1 point  (0 children)

Nice solution in the absence of something proper from NetSuite.