User_U1JVS Green Ribbon

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…

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?

Ok thanks for the input.

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?

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

THANKS SO MUCH!!!!

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…

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

Thanks Erick

this would be for REST API table list...

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

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

THANKS SO MUCH ERICK!

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 =…

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

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?

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 -…

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

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…

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…

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…

Thanks much!

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…

Thanks a lot!

Nice thanks!

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

Yes thanks

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

Hi - Curious if anyone can help with this issue?

Sorry for the delay - very helpful!