Hey all, I'm working on a few different NetSuite AI projects and wanted to reach out to the group. Wondering if anyone has any ideas, hopes, dreams, or issues they would love NetSuite AI to solve. Would love what hear people are thinking and I can try to build at some point. Thanks all (#C05DWU284G1)

Anyone else seeing suitescript errors related to Bank Feeds today?

When I save the sales order it takes 'forever'. I see that we have a lot of User Event and Workflow. Is there's 'something' that will show me the time to execute each workflows / scripts ?

Hi everyone, through this query, I am getting the output as shown in the screenshot. For journal entries like JE000072 and JE000208, both debit and credit lines are being displayed for the particular vendor, which aligns with what’s in the system. Similarly, for JE003150, only the debit line is shown (which is correct), and for JE001283, the credit line is correctly displayed for the respective vendor. However, my requirement is this: In cases where a journal entry (JV) has both debit and credit lines for the same vendor, I want to display only one line — specifically, the credit line — in the results. Could you please guide me on how to achieve this? Your help would be greatly appreciated.

SELECT

BUILTIN.DF(TL.entity) AS entity,

T.TranDate AS trandate,

T.Type AS type,

T.TranID AS tranid,

T.Memo AS memo,

BUILTIN.DF(TAL.account) AS account,

SUM(TAL.debit) AS debit,

SUM(TAL.credit) AS credit

FROM

Transaction T

INNER JOIN

TransactionLine TL ON TL.Transaction = T.ID

INNER JOIN

TransactionAccountingLine TAL ON TAL.Transaction = T.ID

AND TAL.TransactionLine = TL.ID

WHERE

TL.entity = 2590

AND T.Posting = 'T'

AND T.type != 'ItemRcpt'

AND T.Trandate BETWEEN '01/01/2024' AND '31/12/2024'

AND  (

T.Type != 'VPrep'

OR (T.Type = 'VPrep' AND TAL.debit IS NOT NULL AND TAL.credit IS NULL)

)

AND  (

T.Type != 'VendPymt'

OR (T.Type = 'VendPymt' AND TAL.debit IS NOT NULL AND TAL.credit IS NULL)

)

GROUP BY

BUILTIN.DF(TL.entity),

T.TranDate,

T.Type,

T.TranID,

T.Memo,

BUILTIN.DF(TAL.account)

ORDER BY

T.TranDate ASC;

Looking for a way on a saved search to filter out the following scenario This will return only Sales Orders where the Last Modified Date is different from the Created Date — in other words, orders that have been updated since creation. Trying with a formula numeric and its not working. Any ideas? CASE WHEN {createddate} != {lastmodifieddate} THEN 1 ELSE 0 END

Anyone else having an issue where there is stock but nothing is being committed?

Can anyone confirm netsuite advanced manufacturing does not do forward flushing of components prior to routing steps? Only can backflush at completion of each step or in total

on my Item Fulfilment page I have sublist under items called BoL. Where can I go to move the Freight Class field?

anyone know why when using some location on IF it not showing GL impact

Does Tim's SuiteQL Query Tool allow downloading of the results?

Hi all, having an issue with serial/lot numbers and availability. We have an item with no transaction history except for 2 serial numbers being import (#1 and #2 let's say) being imported from the old system on an Inventory Adjustment, and a sales orders processed on which #1 has been chosen under inventory detail. Under Inventory Numbers on the item record, both #1 and #2 are showing On Hand 1, Available 0. I believe there might've been an SO processed then voided/deleted that involved #2 but it seems like the item hasn't been released/uncommitted. Anyone encountered this before? Item is showing 1 Committed, 1 Available under the Locations tab on the Item record, but not on the Inventory Numbers...

Is it possible to create a saved search showing the list of actual transactions created from memorized transactions whether as a reminder, template or automatic?

Hi all ,having an issue when I'm trying to create a new inventory item using netsuite standard api. why the below error is coming ?

note: I'm already added the tax Schedule

anyone know why when using some location on IF it not showing GL impact when the SO is fulfilled and check GL it empty

Hi NetSuite Pros, I'm researching the biggest gaps in the NetSuite implementation process. Beyond the usual scope creep, what's the one 'invisible' thing that most often derails a NetSuite project? Is it bad data, ghosting stakeholders, or something else entirely? Trying to pinpoint the real 'hair on fire' problem that spreadsheets and status meetings don't solve. Your feedback is greatly appreciated!

Wanted to shared our latest development aim at helping admin and Netsuite consultants

I need to mass update my Company Bank Details. Is this possible via .csv? At the least, can I enable line edits to the Bank account number and routing numbers (and others). Seems like this was a custom solution and not native to NS. Is it possible to do a .csv for custom records? Thanks!

Admins who have gone through a transition to OneWorld - would you be willing to share some wisdom and insight on things to test or be mindful of post go-live? Things I am currently considering are: • Updating all actively utilized user roles to allow multi subsidiary viewing • Reports/Saved Searches are any permissions or subsid access changes needed? • Items, Vendors, Customers, Transactions, Do you need to manually assign subsidiary field retroactively via CSV Import?

Whipped up another quick video on how our (Cauzzy.ai) AI Agents provide immediate solutions so you can level-up with your CEO and/or Board:

Hi everyone 👋 I’m having some difficulty pulling COGS and Sales data from NetSuite backend tables using ODBC in Power BI. I’m not sure which tables contain the COGS details, and I’m also struggling to understand how to join the right tables to get both sales and COGS data together in a report. Has anyone worked on something similar? Any guidance on the table structure, or best practices for joins in this case, would be really appreciated!

Hi, I am very new to Netsuite, I am trying to add a custom field so that when I get invoices with Netsuite SOAP API, it gives me the real customer if the linked customer is a project. Any pointers? Do I need scripting?

Hi everyone - curious whether any has experience going from Premium Support to Basic Support - or vice versa - and has any feedback to share. For budgetary reasons we're considering dropping Premium and are wondering what how response time differs. Our use of Support has not been for P1 issues but those and we have rarely, if ever, phoned Support. But we're not sure what difference in response time or knowledge and persistence to expect. Thanks!

If we schedule a workflow to

start today

and run

every 30 minutos

, when does it start? Lets say I setup and save the workflow at 10:12 am... is the next run at 10:30 am of today?

the record most definitely has not been deleted lmfao

Hi all, quick (hopefully!) question. I'm looking to create an allocation schedule to reallocate expenses from one Class to another, but want to run once a Q based on that Qs data. My test seems to only want to pull one month of data even though I pick the schedule as Quarterly. Is this possible?

We were able to create intercompany PO but when we try to generate SO its showing this message: "For intercompany inventory transfers, disable the Use Item Cost as Transfer Cost preference.". But the thing is, we can't uncheck this feature because customers needs transfer price coming from the item. any ideas ?

Anyone upgrade to Avalara AvaTax OneWorld to 8.8 yet? Just got an email saying it will take longer than normal to update. Want to make sure there are no issues with this release. Slack Conversation

alert NetSuite is phasing out SOAP Web Services. Starting with release 2026.1, no new SOAP endpoints will be included by default. The last scheduled endpoint is 2025.2, with support ending 3 years later. Source: https://teknuro.com/netsuite-soap-web-services-deprecation-what-the-2026-1-change-means-for-you/