Tapendra Singh · Full-Stack Wizard · Gold Medal

Unfortunately, chandradeepkumarraj, NetSuite doesn't give us an option for this. There's no undo or recycle bin, so once a record is hard-deleted from Account, it's gone. Recovery means rebuilding it from surviving traces, then re-entering it. Use the Deleted Record search and Audit Trail to see what was deleted and by…

We are now closing today’s session. We hope to see you in the next #AskAnExpertLive! I hope the tips I provided will be helpful for you. 😊 Be sure to follow the AskAnExprtLive tag for updates. To help us improve this program, feel free to share your feedback with us. Have a good one, everyone! 🎉

chandradeepkumarraj Happy to connect with you. DM me if you have any questions.

Good one, GauravAgrawal. I was expecting this one to come up. The Event Subscriber type is currently on hold and unavailable (SuiteAnswers ID 1047388). So this is forward-looking for now. As per document the key difference is timing. User Event and Workflow Action run during the save, synchronously. Event Subscriber runs…

Tip 3: On the REST Record API, know how sublists get replaced before an update surprises you A common gotcha with REST integrations: people assume an update only touches the fields they send. It doesn't always work that way with sublists. On a PATCH, keyed sublists merge on their keys (matching lines update, the rest…

Dan Garcia For ad hoc querying, my go-to is the free SuiteQL Query Tool SuiteApp (Tim Dietrich's ). A UI right inside NetSuite to write, run, and export SuiteQL, no code, no Postman. Best place to prototype. From there it depends on the goal: inside SuiteScript, use the N/query module (query.runSuiteQL()). For an external…

Tip 2: Inline HTML fields won't render in view mode, so use a beforeLoad iframe for record dashboards If you've tried to put a chart or custom widget on a record using an Inline HTML field, you've probably seen it work in edit mode and then disappear in view mode. On top of that, NetSuite strips your JavaScript for…

Good question, M.Lisa I started as a developer, so early in my career I was biased toward scripting everything. It took me a while to learn you don't use a sledgehammer to crack a nut. Native features often do the job. Here's how I decide which approach to use, based on what I'm trying to do: Changing Data: Use SuiteScript…

Tip 1: SuiteQL doesn't support CTEs, and window functions can mislead you on tied dates Two things that catch people out. A WITH clause just errors in SuiteQL, so any CTE has to be rewritten as a nested subquery in the FROM. The subtler one: if you compute a running or prior-period value with a window function and multiple…

Thanks, Divya Unnikrishnan, good one to dig into. If I were responsible for the transition, I would recommend the following approach: Scope of effort: 2.0 to 2.1 is a config change (set @NApiVersion to 2 .1), same API. 1.0 to 2.x is a full rewrite, so budget time and testing accordingly. Treat it as a chance to improve,…

Happy to take this, @Chelsea Jacobs REST is the intended successor, and a few things make it the right one. Authentication is the big one. REST uses OAuth 2.0, the current standard, so token handling is cleaner than SOAP's older TBA/OAuth 1.0 flow. Then there's SuiteQL. You can run SQL-like queries directly through the…

Welcome, everyone. I am delighted to be here today and look forward to meeting each of you. Please feel free to direct any questions you may have to me.

D

Hi @Tom Dalton, As per my understanding, this can be achieved with a Suitelet deployed as Available Without Login, which can display your saved search results on a shareable URL. Just note that NetSuite has made changes to Available Without Login Suitelets , including updates to external URL handling and…

Hi @User_9V660, You can update the Location field using Lists > Mass Update > Mass Updates > General Updates > Transactions and then select the specific transaction type (Sales Order, Invoice, Vendor Bill, etc.). Add criteria to identify the transactions with a blank Location, then under Mass Update Fields select Location…

Hi @HBrown, I don't see any documentation that specifically excludes Caretaker accounts from using the NetSuite AI Connector Service. The connector authenticates against a NetSuite account using OAuth and role-based permissions, so the key question is whether your Caretaker environment supports the required features,…

Hi Agus (@User_Q1DPO), You could also consider a custom Suitelet + SuiteQL solution. The Suitelet can let users select a bank account and date range, while SuiteQL calculates: Opening Balance (before start date) Debit Credit Running Balance all in the bank account's original currency (USD). This approach avoids the…

Hi @User_Q1DPO, Not a promotion, just sharing an alternative option. If your requirement is to add subsequent CIP/acquisition costs to an existing fixed asset, you may want to evaluate NetAsset by Netgain: Alternatively, this could also be addressed through a custom NetSuite solution using SuiteScript and custom records to…

Hi @Nilesh.Gupta, Before Bill Capture can be enabled, the account must be provisioned with the NetSuite AP Automation module, as Bill Capture is a component of AP Automation. Once the module is provisioned, you can complete the required setup, permissions, and related SuiteApp configuration. Oracle documentation for Bill…

Hi @User_RUQ2X, since it's open you can just delete it and the revaluation will go with it. Any issue deleting it on your end?

A

Hi @Luis G, The PDF I shared was made with a small custom traveler (a Suitelet) that reuses the SuiteApp's own routing instructions process and adds the one step it leaves out, converting the newline to <br/> at render. You keep entering instructions the same way (just press Enter for each line) and they render on separate…

Hi Ed Doherty, This appears to be a server-side error. Could you open your browser's Developer Tools, go to the Network tab, and then click the Save button again? You may find additional details there. Please check the response of the POST request and share any relevant error messages or response details.

Hi Jebin Varghese-Oracle, I ran a test on this. I created a Purchase Order via REST Web Services, and the SuiteApprovals flow did not trigger at the point of creation. Looking at the System Notes on the PO, all the fields were set by the REST create, but the SuiteApprovals Map/Reduce script did not run at that time. It…

Hi @Luis G, You need line break on Traveler pdf ? like this

Hi @Nilesh.Gupta, Could you please confirm if you are working with Scriptable Email template.

B

@Ckirk for me its working fine and my bookkeeper role have Financial History view permission.

Hi @Ckirk, Could you please share the screenshot of your custom role with all the permissions you have granted so that i can try to replicate and find the solution in my development account.

Hi @Adinath_Bodakhe, Another way to handle this is with a client script. I've put together a small one that runs whenever the transaction date on the journal entry is changed. It looks up the exchange rate for the new date and fills it in automatically. If there's no rate set up for that date, it leaves the existing rate…