1,941 results total
Browse the knowledge base by search, topic, audience, and difficulty.
Answer
To convert a numeric value to English words in NetSuite, use the TO_CHAR(TO_DATE({your_field}, 'j'), 'jsp') formula. For handling cents, a more complex formula involving INITCAP, TRUNC, and CASE…
Read answer→Answer
To copy a non-stored field value to a stored field in NetSuite Workflow, use a button to transition to a second state. Configure 'Set Field Value' actions in…
Read answer→Answer
To ensure the item description from a sales order is used on a purchase order for a drop ship transaction in NetSuite, enable the 'Copy from Sales Order'…
Read answer→Answer
A non-zero Intercompany Receivable/Payable balance in a closed period occurs when the Intercompany Elimination Journal Entry lacks its linked Reversal Journal Entry for the next month's first day.…
Read answer→Answer
To correct fixed asset errors, first delete associated posting journals and depreciation history records. Invalid assets can then be deleted. For valid assets, manually reset the Net Book…
Read answer→Answer
To correct an incorrect tax account GL impact in NetSuite, either re-save the transaction after updating its tax code (effective only for open accounting periods) or create a…
Read answer→Answer
To correct inflated sums in NetSuite saved searches caused by duplicated transaction line data, apply a specific DISTINCT formula. This formula uniquely identifies and sums each location's quantity…
Read answer→Answer
When NetSuite incorrectly creates an Expense account for a Tax Control Account, manually create a new Tax Control Account. NetSuite will then correctly generate an Other Current Asset…
Read answer→Answer
To correct 'Subaccount of' assignments on the NetSuite Chart of Accounts, the field must first be programmatically set to NULL. Following this initial update, a subsequent programmatic update…
Read answer→Answer
To correct an incorrect company name on NetSuite PDF forms, navigate to Setup > Company > Printing & Fax Preferences. Locate and uncheck the 'Use Location Address on…
Read answer→Answer
In NetSuite, project custom fields are classified as 'entity fields' rather than 'CRM fields'. This distinction is vital for administrators when creating, locating, or managing custom fields associated…
Read answer→Answer
In NetSuite 2.0, comparing datetime field values directly using `getValue()` will always return false because it retrieves an object. To perform accurate comparisons, use `getText()` instead. This method…
Read answer→No answers match those filters.
We use only optional tools to measure site usage and manage HubSpot forms. You can accept, reject, or choose category by category.
Optional tools are off by default. You can change your choice at any time.
Always on. These only remember your consent choice and support site security. No analytics or marketing tool runs in this category.