My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
Comments
-
Hi @Mikko De La Fuente-Oracle , but In Oracle documentation, scale has the minimum value -84 which is more than -127, nor did I see intermediate values, either -127 or 0+ after data analysis, also didn't find any logic, these values are not so big to round to 127 digits: it looks more like a bug or some default or…
-
fyi @Erick Dela Rosa-Oracle , double-quotes work: SELECT TOP 1 "group" FROM EntityGroupMember
-
not everything is as good as we would like ? SELECT t.level FROM CustomerGroupPricing t works fine, but SELECT t.group FROM CustomerGroupPricing t doesn't work(
-
HI @Erick Dela Rosa-Oracle , this works, thanks so much!
-
Hi Erick, There is no answer in the community. The issue is still exists. Curious why NetSuite does not support a syntax available even in the earliest versions of Oracle?
-
Hi Mikko, yes, I still need assistance on this. Just to add more context: We are implementing a replication service, The connection to Netsuite fails on a big query (eg: transaction_lines with 10M rows). the timeout is not constant, rather looks like a random value, starts from 3 hours, sometimes it can reach up to 10-20…
-
Hi Mikko, yes, sure, we use this code: _command = _connection.CreateCommand(); _command.CommandText = _commandText; _command.CommandTimeout = 0; return await _command.ExecuteReaderAsync(CommandBehavior.SingleResult); Additionally, fetching large data volume will result to timeout due to custom field limitation. See…
-
Hi Mikko, We use our dotNet client (C#) via NetSuite ODBC driver.