User_U1JVS

Thanks much for your help. Yes I am using the - REST Query Service yes we do have Manage Authentication section > OAuth 2.0 - is checked when I try OAuth 2.0 Client Credentials Setup - and create new client credentials mapping - i found my entity name and role = administrator - but application pull down is blank? Q what do…

in REST API and Beta Version Comment by User_U1JVS Jan 24, 2022 10:02PM

Hi, you asked : Are you using OAuth 2.0? Q1 - I may be but not sure... can you let me know how to check and also how to move to OAuth 2.0 if I am not yet using it? Q2 - Also - can you point me to how to use use the REST Query Service rather than what I am currently using I think is REST API?

in REST API and Beta Version Comment by User_U1JVS Jan 24, 2022 8:17PM

Ok thanks for the input.

in SuiteQL Query Tool questions Comment by User_U1JVS Jan 19, 2022 8:58PM

Hi using the REST API I do get tranid so that should be the one that the invoice creator made - correct? Also sometimes I see externalid also - can you describe the difference between them?

in Where can we find the vendors document identifier / invoice number? Comment by User_U1JVS Jan 19, 2022 8:57PM

Thanks - I was told I need access to create the “Detailed AP Aging Report.” (a basic and common accounting report).

in How can I search for "Balance Due"? Comment by User_U1JVS Jan 13, 2022 10:28PM

THANKS SO MUCH!!!!

in Curious about a status field with - Paid in full Comment by User_U1JVS Jan 12, 2022 11:30PM

Hi Mikko, you said... Hi @User_U1JVS , you can check the Records Catalog by navigating on Setup -> Records Catalog. Under Transaction, you can check the status field on the tooltip of the column type. A sample for Paid in Full status is on Invoice record. I went where you said - to Transaction ... - but then I had to click…

in Curious about a status field with - Paid in full Comment by User_U1JVS Jan 11, 2022 10:16PM

Hi Erick, I did find the field called: linesequencenumber but do not yet see this: transactionline.id Can you help me find it ? Thanks - dave

in Looking for the Line ID field table Comment by User_U1JVS Dec 21, 2021 8:49PM

Thanks Erick

in Trying to match a Netsuite search export count to rest api query count Comment by User_U1JVS Dec 15, 2021 9:43PM

this would be for REST API table list...

in Trying to match a Netsuite search export count to rest api query count Comment by User_U1JVS Dec 9, 2021 11:06PM

BTW: I was looking for tables here - but now gone where is the link for the new tables browser? https://netsuite.custhelp.com/app/answers/detail/a_id/92152/kw/Analytics%20Browser

in Trying to match a Netsuite search export count to rest api query count Comment by User_U1JVS Dec 9, 2021 10:50PM

THANKS SO MUCH ERICK!!! I will check it out right now.

in Trying to match a Netsuite search export count to rest api query count Comment by User_U1JVS Dec 9, 2021 10:42PM

THANKS SO MUCH ERICK!

in How can I get the account number from these tables? Comment by User_U1JVS Nov 30, 2021 1:23AM

BTW: if I try the query this way it gets lots of duplicates... Q 1: Is there a better way to write this so I do not get duplicates? { "q": "SELECT * FROM transaction t LEFT JOIN transactionline tl ON t.id = tl.transaction LEFT JOIN transactionaccountingline tal ON t.id = tal.transaction LEFT JOIN account ac ON ac.id =…

in How can I get the account number from these tables? Comment by User_U1JVS Nov 29, 2021 9:24PM

Thanks so much Erik - I will give this a try!

in transactionline uniquekey and duplicate associations with multiple account acctnumbers Comment by User_U1JVS Oct 19, 2021 8:49PM

no I have not - can you give me links to try that q: do you have a link to saved search? and how to create a fresh query Q: also I want to get all the fields I need for various tables - how do I choose the fields for the varied tables?

in transactionline uniquekey and duplicate associations with multiple account acctnumbers Comment by User_U1JVS Oct 18, 2021 10:56PM

Thanks Erik, also this... for rest api... 5 - *** --> So what is the best way to get the GL credit and debits which we need with REST API? we need -transaction date -account number - unique value (like transactionline uniquekey) -credit debit - amount -other related fields now we are trying: transaction - account -…

in rest api - How do we query transactionlines table to obtain transaction credit and debit amounts Comment by User_U1JVS Oct 17, 2021 12:20AM

Hi looks like this never got an answer - i am still interested in this Any help is appreciated

in REST API and SQL Join Tables. Comment by User_U1JVS Oct 16, 2021 11:43PM

well my link above was wrong - it's for odbc 4 - So what is the difference between transactionaccountingline and transactionline ? 5 - *** --> So what is the best way to get the GL credit and debits which we need with REST API? So how do I do this with REST API version? I see this now…

in rest api - How do we query transactionlines table to obtain transaction credit and debit amounts Comment by User_U1JVS Oct 15, 2021 8:31PM

More... 1 Ask more: the connect browser seems to have changed? 2 The transactionaccountingline is gone ? where is it now? 3 the transactionaccountingline seemed to have the credit and debits which we need? 4 - So what is the difference between transactionaccountingline and transactionline ? 5 - *** --> So what is the best…

in rest api - How do we query transactionlines table to obtain transaction credit and debit amounts Comment by User_U1JVS Oct 15, 2021 7:21PM

hi, I have: employee edit > access my Role set as admin permissions > setup i see SuiteAnalytics Connection and "full" on right my config role id says = 3 - is that admin role? NOTE: service datasource says config = netsuite2.com = this fails in windows test connect but netsuite.com = success How can i have success with…

in AE: ODBC Permissions Issue Comment by User_U1JVS Oct 7, 2021 9:21PM

Thanks much!

in ODBC / Netsuite Getting Started Comment by User_U1JVS Oct 7, 2021 5:13AM

Hi Erick, Thanks for the help. Unfortunately I am still confused. If you can would you mind answering Questions #1 and #2 and #3 and #4? On the existing report: https://xxx.app.netsuite.com/app/common/search/search.nl?cu=T&e=T&id=1219 --- #1 Question: how can I figure out the underlying tables that these transaction search…

in I could use some help with Saved Transaction Search and underlying Tables Comment by User_U1JVS Sep 23, 2021 9:44PM

Thanks a lot!

in REST API - Getting back too many records - more than needed Comment by User_U1JVS Sep 22, 2021 12:05AM

Nice thanks!

in Rest API - choosing the right tables for Cost of Goods Account Comment by User_U1JVS Sep 22, 2021 12:04AM

hi am are confused by the various tables: account - subsidiary - customer - vendor etc. Can you shed any light on the differences of these?

in Rest API - choosing the right tables for Cost of Goods Account Comment by User_U1JVS Sep 21, 2021 8:24PM

Yes thanks

in REST API search queries with OFFSET Comment by User_U1JVS Sep 21, 2021 8:22PM

Hi Thanks - the client is unsure of the correct tables - Is there some way I can find out myself what tables they are using?

in REST API - Getting back too many records - more than needed Comment by User_U1JVS Sep 21, 2021 8:20PM

Hi - Curious if anyone can help with this issue?

in Rest API - choosing the right tables for Cost of Goods Account Comment by User_U1JVS Sep 10, 2021 4:46PM

Sorry for the delay - very helpful!

in How to Manage updated transaction and transactionline records with rest api? Comment by User_U1JVS Sep 9, 2021 8:36PM

MFA for Oracle Community

User_U1JVS Green Ribbon

Comments