Journal Entry Import Mapping > Custom Field not available

First, we Check if the Custom Field is applied to Journal Entries Using the Administrator role, navigate to Customization > Lists, Records, & Fields > Field Type (e.g. Transaction Body Field)1. Custom Field: Click Edit2. Click Applies to tab3. Enter Checkmark for the transaction type(s) where you want the field to be available4. Click Display… Continue reading Journal Entry Import Mapping > Custom Field not available

The transaction currency does not match the currency of the name

Scenario: Saving a Journal Entry throws an error message: ‘The transaction currency does not match the currency of the name.’ Solution Edit the Vendor or Customer record and add the secondary currencies. Users will not be allowed to save the Journal Entry without adding the secondary currencies in the above scenario. Navigate to Transactions >… Continue reading The transaction currency does not match the currency of the name

Creation of Tax Nexuses

Role: Administrator Go to Setup > Accounting > Taxes > Nexuses > New In the Country field, select the country In the Description field, enter a name for this nexus as it should appear on the Set Up Taxes page. Click Save.

CSV Import of journal entry error message: The amounts of this journal entry must balance by location.

There are two possible reasons why a CSV results to an error: “The amounts of this journal entry must balance by location”. Enable the preference Allow Non-Balancing Classifications in Setup > Accounting >  Preferences > Accounting Preferences > General Tab >  Classifications. Checking this box means that the user prefers NetSuite to not require Journal Entries to balance… Continue reading CSV Import of journal entry error message: The amounts of this journal entry must balance by location.

Sales Order (Auto-Generated Numbers) does not follow Standard Pattern

Scenario: Order #(ID: Tran ID) does not follow standard pattern of Auto-Generated Numbers on SO. Using an Administrator Role. Navigate Setup> Company> Auto-Generated Numbers> Document Number tab > Sales order. Please check the following. Value of Initial NumberValue of Current NumberAllow Override checkbox = T When you create a new SO: The Order# field (ID:… Continue reading Sales Order (Auto-Generated Numbers) does not follow Standard Pattern

Tax code displays “Not Taxable” import in Sales Order Csv

Scenario: We imported Sales Order Via CSV import, Tax column shows that transaction was Not Taxable even through there were no issues in during the import. In the Global Search, type the customer’s name or number of the customer record. Click Edit Button. Go to the Address Tab. Make sure that the Customer record has… Continue reading Tax code displays “Not Taxable” import in Sales Order Csv

Forecast by Status Summary Report

The Forecast by Status Summary report shows the calculated forecast for each customer status. If we use Advanced Forecasting, the calculated forecast amounts for each forecast category are shown for each status. To view the Forecast by Status Summary report: Go to Reports > Forecast > Forecast by Status Summary. A message appears indicating that our… Continue reading Forecast by Status Summary Report