any help would be greatly appreciated

Does anyone know how to remove components of assembly items when viewing transaction_lines table?

Hello Guys, How I can show Back Ordered Items Qty using a Sales Order saved search?

Hellow Guys, I want to do SUM() for net amount and Group By tranid for the below query but when I try doing that, it gives me query error! can you please help me in it!

SELECT

BUILTIN_RESULT.TYPE_STRING("TRANSACTION".tranid) AS tranid,

BUILTIN_RESULT.TYPE_CURRENCY(BUILTIN.CONSOLIDATE(transactionLine.netamount, 'INCOME', 'NONE', 'DEFAULT', 0, 0, 'DEFAULT'), BUILTIN.CURRENCY(BUILTIN.CONSOLIDATE(transactionLine.netamount, 'INCOME', 'NONE', 'DEFAULT', 0, 0, 'DEFAULT'))) AS netamount

FROM

"TRANSACTION",

transactionLine

WHERE

"TRANSACTION"."ID" = transactionLine."TRANSACTION"

AND ((UPPER("TRANSACTION"."TYPE") IN ('SALESORD') AND NVL(transactionLine.mainline, 'F') = 'F' AND NVL(transactionLine.taxline, 'F') = 'F'))  ORDER BY TRANSACTION .trandate DESC NULLS LAST

Anyone getting an error when trying to do a testconnect to netsuite2.com datasource? any ideas on how to resolve it? Thanks!

Hello Everyone!! Wondering if someone has any ideas on where to look for my issue I need assistance pulling in information into a saved search. I need to be able to pull in the amount $ from an Item Receipt Transaction into this saved search results but it's not pulling in. Instead I'm getting other amounts that I can't trace back. Any idea why or what criteria I need to add to pull this amount?

FYI - Tactical Connect (saved search based connector - alternative to ODBC) is offering a 30-day trial. I know a lot of people have been experiencing ODBC issues, I would recommend checking them out. We use Tactical Connect over ODBC because it performs really fast on large data sets, is stable and gives us access to all data we need via searches. www.tacticalconnect.com

anyone know the syntax to get the name from user location when viewing a transfer order? So far I have the following, but only can get the location internal id show.

Hello Guys, How can we Summarise the Columns in Dataset so I can use Group or SUM like we do in saved search! I don’t want to use Pivot though! since I’m pulling a query out of the Table which I can’t using Pivot! please help me here!

I have a list of fields that I am trying count if they are (or are not) populated. Is it possible to have a new row for each one of these fields that is populated?

Has anyone ever seen this in a saved search: • Transaction search, type=PO • Base currency of account is CAD • For US sub, amount = empty (null) • For all other subs (including EU subs), amount works fine (aka shows the CAD amount as that is the base currency of account)

How can we fetch Vendor name from RFQ transaction in saved search

Is it possible to connect Excel to the

<http://netsuite2.com|netsuite2.com>

ODBC data source with the new Token Password requirements?

Does SuiteQL support UNION?

I changed the subject line for a scheduled saved search, and it sent the email out again - is this expected? It was about 45 minutes after the scheduled time.

Probably? I am not a big fan of the scheduled emails function because it can be hard to predict

I'm guessing because you fell within the same hour block it presumed you wanted to send it

Tested a subject line change a few minutes ago on another scheduled email that went out at 9am this morning. Just received a new copy of the email. Very bizarre behavior.

Not even close to the timing on this second test. I wonder if it has to do with "Save and Run" as opposed to just "Save" after updating the subject line.

When using SuiteConnect and JDBC to connect to the Netsuite Database i get this error: SQLException: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Failed to retrieve data. Error ticket# kwxfitah1fmn7m3dtcnfh[400]

WORKS: SELECT id from transaction ERROR: SELECT id as test from transaction

Hello Everyone, Can we customize the Balance sheet and just show the parent subsidiary data and not the Children subsidiary data in it? by selecting Consolidated subsidiary in filter! Thanks in adv!

Hi y'all. About to pull my hair out with Netsuite's Bill Multiple PO feature. We frequently have charges to enter where two or more POs are billed on one invoice. In searching & reporting, Netsuite appears to associate all line items with just ONE of the PO numbers rather than the PO they were actually created from. So, essentially, I can't seem to find a way to view the actual charges associated with each Purchase Order. Pics below are of vendor bill and the correct PO per line item, as well as a saved search snapshot showing the wrong PO on the 2nd line. The calculations happening at the IO level are fine (meaning it's applying correct quantites to the correct IO) but reporting and searches are just flat out wrong. Am I missing something??

message has been deleted

Does anyone here encountering the error of Base table:transactiontaxdetail not found is there a permission that we are missing to access the transactiontaxdetail table? I'm using JDBC and netsuite2.com as a datasource

Hello everyone! I’m working on a project that has me totally stumped. I’m trying to create a report or search that ties sales orders and inventory balance together to allow for the determination of which transfer orders need to be prioritized. The difficulty that I’m running into is that the sales orders utilize a child item of the normal stock item. Anybody have any clues on how I can tie these together?

I have a large number of saved searches ( over 4000 ) that I need to manage. One of the current tasks I have is to reassign batches of searches to a new owner. This particular use case includes reassigning over 400 searches from one user to another. I have attempted to script this, but it appears that I cannot set an owner via script and saved searches are not available via mass update. Has anyone been able to successfully update saved search owners via automation?

I have a journal that has one line for a bank charge and then several lines with AP-account on a vendor. These AP-lines/Payments have been applied to one or many vendor transactions. I'd like a search that shows me the total of the AP-lines per journal and also a column for open amount. I have created a search that shows this correctly by individual journal line as I can take the max of the {amount} and subtract the sum of appliedtolinkamount and applyinglinkamount. But when I want to create a total per journal I get into the issue where I can't sum({amount}) as it will sum up the duplicate values that occur since some lines are applied to multiple transactions. Ideally I'd like to "sum(first {amount} based on lineuniquekey)" Any tips?

I made an item search that brings in inventory data from two inventory locations. To get the total available for the two locations, I added "Location Available" and have applied the "Sum" summary type to the field. I want to be able to have another results column that outputs a specific text value if that sum is >= 5 AND some other field (checkbox) is true - but I can't seem to get it to work.

Hi all anyone know how to get location average cost in datasets?