-
How to connect Netsuite to Microsoft SQL Studio
Hello How would you connect NetSuite to MS SQL Studio via ODBC. IS it even possible to do so to enquire on tables? Thanks Paul
-
Joining VendorBill/Expenses to the Payment using SQL
Hello I want to report on how long it takes to pay invoices in Netsuite from either when they are approved or when they are created on the system. If i look at expense reports for example, I know on the transaction table there is a type ExpRept and VendPymt but i can see how you can link the 2 on the transaction table. IS…
-
Tieing an Item Receipt TransLine to the Original Line of the Transfer Order.
I am trying to create a SQL query to pull in all transaction lines on a transfer. I am trying to get the received field but it looks like it is calculated behind the scenes and not easily accessible from the normal fields on a TL. The 'quantityshiprecv' field will always show the same amount that was picked on the order. I…
-
ODBC SQL bug? nextline filter is not filtering
I work with Netsuite2.com ODBC Suite Analytics Connect I run the following SQL Query select ptll.linktype, ptll.nextdoc, ptll.nextline, ptll.previousdoc, ptll.previousline from PreviousTransactionLineLink ptll where nexttype = 'VendPymt' and linktype = 'Payment' and previoustype = 'VendBill' and ptll.nextline >1 But it…
-
How to add invoice fields to the project saved search?
Hi all, I am trying to add invoice date, amount, number etc. to the project saved search, however, when I define field as Transaction : Invoice Number in the results subtab, saved search displays not only invoices and corresponding numbers, but if project is not invoiced, is displays bills' numbers, POs' numbers etc. Also,…
-
SQL Suite talk
Hello. I need show a custom field from item file. I am using suite talk with this Querry: {"q":"SELECT * FRom item where id = 19"} The problem is that the custom.item is not showing in the result of the querry. What is the reason? Thanks.
-
Set Field Value based on other fields using formula
CONTEXT: For each of the customer at our company, we want to populate a "revenue target" field which depends on other fields the end-user is inputting (e.g. if the customer is a national chain, which services we are providing to them). For the more simple calculations, I have been using a workflow and set field value…
-
Script is generating a leading space, what is wrong?
I am combining the contents of two fields to create a URL Component. The problem is that the script seems to yield a leading space in the result. I don't really understand what I have done wrong and I don't understand the logic of the syntax. I have tried the tutorials but they don't seem to help. This is my script…
-
Adding Results of Multiple Case When SQL Statements
Apologies in advance for the probably obvious answer to my question below. I am trying to add the results of multiple Case When statements in my saved search. We have multiple complexities which is making our 1099 reporting difficult which requires these formulas. When I create these 8 formulas separately (first…
-
In NetSuite Analytics, is it possible to calculate minutes or hours between two date/time fields?
In a NetSuite Analytics Dataset, I'm trying to create a calculated field to display the time in minutes between two date/time fields. Nothing I've tried has worked. Is it really not possible to do this? Here are the formulas I've tried. Some were pretty desparate attempts: ({enddatetime} - {startdatetime}) * 24 * 60 ****…