Discussion List

• 
  How to pull datas in Custom Records using SuiteQL?

  Accepted Answer kjulian 151 views 6 comments 0 reactions Most recent by kjulian Mar 28, 2023 3:56AMAsk A Guru
• 
  What Permission is needed to access the Transaction Status table via SuiteQL?

  Accepted Answer Closed kees.netsuiteadmin 484 views 4 comments 0 reactions Most recent by Jack Daryl Espiel-Oracle Mar 21, 2023 2:14AMAsk A Guru
• 
  Is it possible to retrieve values of custom fields with Store Value checkbox unticked using SuiteQL?

  Open kees.netsuiteadmin 512 views 3 comments 0 reactions Most recent by Francesca Nicole Mendoza-Oracle Mar 20, 2023 3:34PMAsk A Guru
• 
  Why CData component returns duplicate and missing records in SuiteQL?

  Open Closed User_I763M 163 views 5 comments 0 reactions Most recent by Richard James Uri-Oracle Mar 13, 2023 6:48PMAsk A Guru
• 
  How to Access Built and Quantity Fields in Work Order with SuiteQL?

  Accepted Answer Closed Ron Mc 146 views 5 comments 0 reactions Most recent by Richard James Uri-Oracle Mar 10, 2023 9:00PMAsk A Guru
• 
  Can SuiteQL be used with the customer portal to display queried data?

  Accepted Answer Closed Vernita 12 views 2 comments 0 reactions Most recent by Richard James Uri-Oracle Mar 3, 2023 8:37PMAsk A Guru
• 
  How to programmatically pull the balance sheet report data?

  Open Johann Granados 143 views 5 comments 0 reactions Most recent by Richard James Uri-Oracle Feb 3, 2023 6:49PMAsk A Guru
• 
  How to retrieve data from Customer list with netsuite script ?

  Accepted Answer Closed User_1J19L 81 views 4 comments 0 reactions Most recent by User_1J19L Jan 23, 2023 5:41PMAsk A Guru
• 
  Which table should I query to list all credit memos using SuiteQL?

  Accepted Answer Closed User_VDX5O 313 views 8 comments 0 reactions Most recent by User_VDX5O Jan 22, 2023 6:11AMAsk A Guru
• 
  How to return the full date/time object in SuiteQL?

  Accepted Answer User_VDX5O 615 views 4 comments 0 reactions Most recent by Richard James Uri-Oracle Jan 18, 2023 7:26PMAsk A Guru
• 
  How to show locationaveragecost, lastpurchaseprice via Query?

  Accepted Answer Closed George Mihaylov 82 views 3 comments 0 reactions Most recent by Richard James Uri-Oracle Dec 20, 2022 5:58PMAsk A Guru
• 
  How to use BUILTIN.PERIOD in SuiteQL?

  Open Closed ssilveri777 123 views 5 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Nov 17, 2022 11:55AMAsk A Guru
• 
  Is there a max limit on the number of rows a SuiteQL can return in a script?

  Accepted Answer Closed ssilveri777 72 views 2 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Oct 31, 2022 8:40PMAsk A Guru
• 
  How to Show Fulfillable value on all transaction lines (including Kits) using SuiteQL query?

  Accepted Answer George Mihaylov 81 views 4 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Oct 25, 2022 4:01PMAsk A Guru
• 
  Querying Custom Records with REST API

  Open Closed User_AVFW0 472 views 2 comments 0 reactions Most recent by User_AVFW0 Sep 30, 2022 4:26PMAsk A Guru
• 
  SuiteQL query error only for one user (same role)

  Open Closed User_VUSFS 11 views 3 comments 0 reactions Most recent by User_VUSFS Aug 30, 2022 10:03PMAsk A Guru
• 
  Currency Revaluation Transactions through SuiteQL Queries.

  Accepted Answer Closed Prtk 102 views 3 comments 0 reactions Most recent by Prtk Aug 25, 2022 12:05PMSuiteAnalytics Workbook
• 
  How to Join transaction/transaction line to account Table.

  Open Closed User_3BTAC 63 views 4 comments 0 reactions Most recent by User_3BTAC Aug 19, 2022 1:10PMAsk A Guru
• 
  How to use SuiteQL to retrieve information

  Accepted Answer Closed Benjamin Paul - USA 61 views 13 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Aug 19, 2022 1:26AMAsk A Guru
• 
  How to use Suiteql

  Open Closed Matan Shachaf 21 views 3 comments 0 reactions Most recent by Jack Daryl Espiel-Oracle Jul 13, 2022 5:03PMAsk A Guru
• 
  How to pass variables to SuiteQL Suitelet

  Accepted Answer Vernita 61 views 5 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Jul 1, 2022 7:55PMAsk A Guru
• 
  Querying password expiration date using SuiteQL / SuiteScript

  Open Closed User_XUX5V 11 views 2 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Mar 16, 2022 2:37PMAsk A Guru
• 
  Querying roles for partners / customers with login access

  Open User_XUX5V 21 views 4 comments 0 reactions Most recent by User_XUX5V Mar 16, 2022 9:22AMAsk A Guru
• 
  AE:Partial results in SuiteQL query for system notes

  Open User_XUX5V 81 views 7 comments 0 reactions Most recent by User_XUX5V Mar 6, 2022 8:43AMAsk A Guru
• 
  SuiteQL - accessing QuantityOnOrder and QuantityAvailable fields with Multiple Locations Enabled

  Accepted Answer 3ric 253 views 6 comments 0 reactions Most recent by 3ric Nov 15, 2021 6:30PMAsk A Guru
• 
  Missing "Time of Day" fields in custom record table suiteQL query?

  Open Closed Cory Weiner 93 views 3 comments 0 reactions Most recent by [Deleted User] Oct 28, 2021 9:54PMAsk A Guru
• 
  SuiteQL query with ORDER BY clause returns no data

  Accepted Answer Closed Johann Granados 221 views 3 comments 0 reactions Most recent by [Deleted User] Sep 16, 2021 6:04PMAsk A Guru
• 
  Is SuiteQL still BETA?

  Accepted Answer George Mihaylov 31 views 4 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Sep 8, 2021 9:52PMAsk A Guru
• 
  How to generate CSV Response Link for CSV Import Task in SS 2.X

  Accepted Answer George Mihaylov 32 views 2 comments 0 reactions Most recent by [Deleted User] Aug 12, 2021 1:08AMAsk A Guru
• 
  Workbook Purchase Order Line Tax Amount/Gross Amount

  Open Igor Povolotski 75 views 2 comments 0 reactions Most recent by Dominica Sevilla-Oracle Jun 29, 2021 2:34PMAsk A Guru