The Consolidated Exchange Rates table includes three consolidated exchange rate types. Current, Average, and Historical. The consolidated exchange rate types and the types of accounts that use them are as follows: Average – The weighted average of the currency exchange rates for all transactions posted during the period to accounts with a rate type of Average.… Continue reading Consolidated Exchange Rates
Author: Salini R
How to Hide Mandatory Fields from Displaying On Transactions
The mandatory fields are un-checkable (cannot hide). Using Purchase order as an example, fields like Item, amount, tax code, tax rate and gross amounts are mandatory, and we cannot simply uncheck them. Form edit mode: mandatory fields are dim and checkboxes cannot be unchecked. To hide the field on a particular transaction form, i.e. Amount,… Continue reading How to Hide Mandatory Fields from Displaying On Transactions
Moving Existing Items To Bin Locations
If you have existing items in your NetSuite account and you want to associate them with bins, you can move those items to their storage bin locations using the Bin Put away Worksheet. To move existing items to bin locations: Transactions > Inventory > Bin Putaway worksheet Item Name Putaway Quantity Serial/Lot Number (if required) … Continue reading Moving Existing Items To Bin Locations
Foreign Currency Variance Mapping feature
When a payment is applied to close a transaction, NS automatically calculates the variance amounts due to the exchange rate variation and posts to the Realized gain or loss account. The variance posts by default to the Realized Gain/Loss account. As standard, Loss will be posted to debit of Realized Gain/Loss account and Gain will be… Continue reading Foreign Currency Variance Mapping feature
Trial balance report for Balance sheet accounts
To effectively customize the Standard Trial Balance Report to include balance sheet accounts, users can follow these steps: Navigate to Reports > Financial > Trial Balance Click Customize Click Filters Expand Trial Balance folder Click Account Type subfolder Pull out Is Balance Sheet filterNote: Use this instead of the filter found on the Account by Type folder Set Equal = T Click Preview/Save Using the Is Balance Sheet filter found on the Account by Type… Continue reading Trial balance report for Balance sheet accounts
Retained Earnings in the Trial Balance Report
As of NetSuite standard functionality, Retained Earnings will be auto calculated by the system.Retained earnings are reported in the Trial balance report as the sum of cumulative Net Income and amounts posted directly to the retained earnings account through Journal entries.The cumulative Net Income is a calculated reporting value which will not be recorded in the… Continue reading Retained Earnings in the Trial Balance Report
Work orders created from intercompany sales orders
While creating a work order from an Intercompany Sales Order it is just a regular non-intercompany transaction. There is a chance of getting error while saving that work order. For resolving the error and to build a Work order record from the Intercompany Sales Order created from Intercompany Purchase Orders: 1. Edit Intercompany Sales Order 2. Under Items tab >… Continue reading Work orders created from intercompany sales orders
Setting default invoice transaction form for invoices creating from Invoice Sales Orders page
We can set a specific Custom Form for Invoices that are created via the Invoice Sales Order page using Workflow. Navigate to Customization > Workflow > Workflows > New Basic Information: Name: Enter Name Record Type: Select Transaction Sub-Type: Select Invoice Execute As Admin: Enter Checkmark Release Status: Select Released Keep Instance and History: Select… Continue reading Setting default invoice transaction form for invoices creating from Invoice Sales Orders page
Disabled mandatory checkbox of custom fields
Upon customizing a custom transaction form, the Mandatory checkbox of custom fields is disabled or grayed out. This happens when the custom field is set as mandatory on the Custom Transaction Body Field Settings. Solution Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields Click Custom Transaction Body Field Click Validation & Defaulting Mandatory:… Continue reading Disabled mandatory checkbox of custom fields
Quality Management Process
A quality management process is defined by its inspections and specifications. NetSuite defines a quality specification as a collection of related inspections. These inspections and specifications determine the level of quality measured against shop floor processes and incoming and outgoing shipments. Quality inspections define data fields and associated standards to examine, measure, compare, or test product… Continue reading Quality Management Process