My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Explore NetSuite Next with Free Training!
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
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.