-
NSC Poll: What contents would you like to see in the NetSuite Support Community?
The NetSuite Support Community would like to continue curating contents to improve your NetSuite experience. Please participate in this poll for us to know what content types matter to your business. What content type would like to see more in the NetSuite Support Community? If there are specific NetSuite products or…
-
Information Gathering from Clients
Hi guys! I am in the Workshops phase with a client using Opportunities, Estimates, SOs, Proejcts etc. and I am wondering, is there any handout in Partner Assets or elsewhere, with the fields of Standard NetSuite Forms, for each record (containing field type, description, if its mandatory or not, etc.) to share with the…
-
Open Customer Deposit Report
Hi, We need a report just like the A/R Aging Detail that shows "open" Customer Deposits for a specific date back in time, that are not applied yet. I can find such report. When I run the Customer deposit register, navigating from the chart of account, and check "Open" tickbox, the register still include all customer…
-
Advanced Revenue Recognition
Dear Gurus, our customer has bought the Advanced Revenue Recognition license 2 years ago when the implementation took place. During the implementation of the project, all their Sales Items were marked as Direct Revenue Posting. Now the customer wants those Items to run on Revenue Recognition Rules, and the revenue to start…
-
Consolidation Currency Conversion Discrepancy
Hello All, A Journal Entry of INR 100 was posted in November 2023. However, on the Consolidated Income Statement, it is translated to USD 8,336.00. This appears to be an inverse currency conversion, as the USD value should be lower than the INR amount, not higher. The transaction currency is INR, while the parent…
-
On Hand Value show negative value on Inventory Valuation Summary report.
The Inventory Valuation Summary report is showing a negative On Hand Value, even though the item's current Quantity on Hand is 0. Could you please help me identify the root cause of this negative inventory value? and What is the recommended and accounting-safe way to correct the negative value and bring it back to a…
-
show translation amount in PnL report
Hi expert, i want to see in PnL report, translation amount, from base amount to last exchange rate table. let say: Desc | amount base | Translation amount in USD Expense A | IDR 1.000.000 | 55,55 $55,55 was result from : IDR 1000.000 / last exchange rate (let say IDR 18.000) how to achieve it?
-
too many Negative QTY
Hi expert, currently i'm encountering my qty position is in Negative QTY, so that accountant complain this condition. in Netsuite how to protect QTY to not negative? i'm using menus: sales invoice SO IF item adjustment (reduce stock) WO i don't see any setup. need advice regards agus
-
SuiteCloud IDE Plugin
Is the following url for webstorm plugin correct? https://system.netsuite.com/download/suitecloud-sdk/ideplugin/webstorm/26.2/updatePlugins.xml
-
Saved Search of Item Receipts that are not billed
Here's my situation. We switched from using expense categories to items, and both are still available. And my Item receipt search broke. And this is a big reason I'm getting partial results now. I've looks in different areas of SuiteAnswers and google/AI to get answers and nothing works completely. Some say use the…
-
Center associated with a custom role not recognized
Hello, I maintain several dashboards for various roles, which use different centers. Up until last week's update, I was able to update the dashboards with the center-corresponding role. This week, however, the list of published dashboards is only visible under my admin role and when I try to publish/update a dashboard…
-
Kit member "Special Work Order Item" - SO never generates the linked WO, line stays perm backordered
We have an assembly item flagged Special Work Order Item on its item record. This item is a component of several non-printed kit/package items ("Print Items" unchecked on the kit). When the kit is sold on a Sales Order and this component is short on stock, the kit line shows the shortfall as backordered - expected. But we…
-
Can subsidiary field of a Sales Order be set using a script?
The company is restructuring so they want a different subsidiary for the Sales Orders created by specific Customers. Customers are assigned multiple subsidiaries so when using UI selecting a subsidiary during an order creation is not a problem. However, we mostly use integrations that do not send subsidiary with the order,…
-
ACH payments for Expense Reports
We are trying to pay our Employee's Expense reports via ACH. Our Payroll is not handled through NetSuite. We need our employees to maintain their own bank information. The problem is when I set the permissions for Bank details to create, an employee can create a bank record on a different employees file. It does not…
-
SDF Custom Role XML Definitions
Is Employee Center type role supported? If yes then what should be entered in this tag <centertype>EMPLOYEE</centertype>, as EMPLOYEE is not acceptable Out the following possible values, which one pertains to Employee Center?
-
Updation of Master data, after addition of a new subsidiary in a one world account
My client wants to create a new Subsidiary on the a account, after implementing successfully for 6 subsidiaries. As this subsidiary will be the child of an existing parent subsidiary, will it be linked on the existing master data which we have in the system? like vendor, customers, items etc. If not, what are the ways with…
-
Is it possible to set a custom item price when adding an item to the cart in SCA?
Is there a way to change the item price when adding an item to the cart in SCA? I’ve tried a few things, but nothing seems to work. For example: cart.on("beforeAddLine", function() { // ... }); and: Application.on("before:LiveOrder.addLines", function(model, lines) { // ... }); I tried modifying the price in these events,…
-
2FA verification failed
Hi All One Administrator User 2FA keeps failing despite entering the correct number after he changed his password. Please advise what is the correct procedure?
-
Inventory Profitability Report Timing Out When "Show Zeros" Is Unchecked
I have a NetSuite account with a large volume of transactional data. The standard Inventory Profitability Report loads within a few minutes and performs reasonably well. However, when I customize the report and disable the "Show Zeros" option, the report takes an excessively long time to load. I also attempted to generate…
-
Why Work Orders Included in the Inventory Cost Revaluation
I have an issue with the Inventory Cost Revaluation. I created the ICR on June 18, 2026, with a transaction date of May 1, 2026, and included the cost components. However, in the Work Orders subtab, the system included Work Orders that were created before the ICR, going back as far as 2023. It included not only Work Orders…
-
Error installing AI Connector SuiteApp (nsaicompanion) - "Invalid starttime reference key 1145"
Hi Experts, During installation of com.suitesuccess.nsaicompanion (2.0.8) SuiteApp in my account, deployment fails with the following error: *** ERROR *** An error occurred during custom object creation. Details: Invalid starttime reference key 1145. File: ~/Objects/customscripts/customscript_atlas_aicomp_role_sync.xml…
-
How to filter the Account of Parent Subsidiary?
Hi Guys, Now I need to create a saved search for Trial Balance Revenue. Here is my saved search Here is the running result: The account in the result are a parent subsidiary. My question: How to filer the Account of Parent Subsidiary? Does anyone know how to deal with this? Many Thanks Jet
-
India banking Cannot Use Undeposited Funds Account?
One of my clients just learned that the Undeposited Funds account won't work for India. Is there an explanation as to why? Is there a system workaround that doesn't require customization?
-
Tax exempt
Hi expert, I have scenario in purchase, i receive supplier invoice: subtotal $1000 VAT $ 100 total $1100 in this supplier invoice, the VAT amount my expectation journal should be: Dr-Expense $1000 Dr-VAT $ 100 Cr-Acct Payable $1100 Cr-VAT $100 Total of payable is only $1000 to be paid VAT is must registered $100 in…
-
Name in same column on Income Statement Report for Invoices and JEs
Hi All, Does anyone know of any way to get the Name from both Invoices and Journal Entries to appear in the same column on the Income Statement? Right now the stock Name column is populated for Invoices but blank for JEs. We then have to add the Entity (line) field to get the Name from Journal Entries. We then have to…
-
amount column side by side
Hi expert, i want to ask about income statement report standard. My requirement is: my base currency = IDR i want to show "Side by side" amount column in Base & Amount column in USD how to customize this report? regards agus
-
How can a Quality Inspection be triggered for Assembly Item Components?
I want to trigger a Quality Inspection for component items used in a Work Order. Although the Item Receipt (IR) inspection has already been completed, if the component items are used after a long period of time, they should undergo a re-inspection. Therefore, I need a way to trigger a Quality Inspection for the component…
-
Partner Center Licenses Not Available to Assign
Hi there! Several weeks ago we purchased 2 more partner center licenses. We had one before for our main NetSuite integrator, but I never assigned that license. Oracle did that. Now our account manager sent me instructions for how to add partners and assign the licenses. I have added the two partners but when I try to…
-
Inventory Worksheet not showing any items
Hi NetSuite Community, I am trying to create an Inventory Worksheet and I cannot see any items no matter what Adjustment Account, Subsidiary or Location I set: I am using an Admin role. Can someone guide me with this for I need to reverse a Work Order Issue posted on a Closed Period using this transaction. Thank you!
-
Search that produces one line per transaction is producing multiple lines on export
I have searches that pull all transactions referencing certain sales orders. This is accomplished through a custom field on the header and on the line of transactions called "related SO". Originally I had this pulling mostly bills but I am now pulling lots of credit card transactions as well. Since I added those credit…