Monday, January 20, 2020

An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag to all relative anchors

An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag to all relative anchors such as <a href="#top">Back to top</a>.  

i.e. The email message includes a "Back to Top of Page" link and clicking it should return the user to the top of the page. This looks like:

<a name=top></a>

<a href="#top">Back to top</a>

The "Back to top" link now has a URL of The link opens a new page when clicked from within Outlook. 

To make sure isn't appended to any of the anchor tags, open the template file in Mircrosoft FrontPage and configure the anchor tag urls and copy/paste the html into the template record in NetSuite. This method ensures no additional html is added to the template and anchor links work as expected. 

Wednesday, July 17, 2019

Save / approve transaction (Bill, Cash Sales, Sales Order, Expense Report) > Error: The currency on the transaction, xxxx is different from yyyy, the currency of the entity, zzzz on this transaction


        Save / approve transaction (i.e. Vendor Bill, Invoice, SalesOrder, Credit Memo, Cash Sale, Expense Report)

        Error: The currency on the transaction,xxxx is different from yyyy, the currency of the entity, zzzz on thistransaction

Example: The currency on the transaction, GBP isdifferent from USD, the currency of the entity, {Employee Name} on thistransaction."


        The error is derived from amismatch between the transactioncurrency and the entity's availablecurrencies in the entity record's Financial tab > Currencies subtab or

        The employee record'scurrency and its transaction(s) are different from the base currency of itssubsidiary



        Verify that the EntityRecord (customer, project, vendor) has the same currency asthe Sales/Purchase transaction (Invoice, Sales Order, Vendor Bill,Purchase Order)

        If there is a mismatchbetween the two (entity and transaction), user has the option of either:

1.   Adding the Currencyin the entity record's Financial tab > Currencies sub tab or

2.   Choosing another entityfor that transaction with the same currency as the transaction


        Verify that the Employee record's currency and its transaction(s)are the same as its subsidiary

1.   Delete the transaction(i.e. Expense Report)

2.   Edit the Employee record tomatch the employee's currency to the base currency of its subsidiary

3.   Re-create the transactionfor that employee with the correct currency

Tuesday, July 16, 2019

Tax Rate is incorrect in Check/Credit Card transaction created from Reconciliation's New Charges/New Deposit


·        User has default Tax Codewith rate other than zero under Setup > Accounting> Set Up Taxes

·        User navigated to Transactions> Bank > Reconcile Bank Statement / Credit Card Statement

·        User entered an Other Chargein the New Charges tab

·        User opened the Check/Credit Cardvia Transactions > Bank > WriteCheck/Use Credit Card > List

·        Tax Rate for the Tax Code is zero



·        Bank Reconciliation is only concern with the bank account part of a transaction andnot the tax computation of a transaction

·        Adding Tax Code in Bank Reconciliation is still an enhancement (133497)


·        NetSuite is not designed to split the amount entered in the Account line in the New Charges tab between the account and the Tax Code account (using the TaxCode's Tax Rate)


·        NetSuite will enter in the full amount to the account specified in the NewCharge tab and a zero Tax Ratein the transaction


·        NetSuite will use a zero Tax Ratebecause it will be misleading to end users who will view the transaction ifthere is a non-zero Tax Rate but zero Tax Amount in the transaction.


·        The same is true with the amount and Tax Code from Deposit/ CCard Refund created via Bank/Credit Card Reconciliation'sNew Deposits/New Credits

Custom Role tagged to a subsidiary > Open Tax / Financial Report > An unexpected error has occurred or This Period is not defined for this fiscal calendar


Certain subsidiary is getting unexpected error whenpulling up financial reports:

·        User enabled Multiple Calendars under Setup > Company > Enable Features> Accounting tab

·        User created a new Fiscal Calendar under Setup > Accounting > FiscalCalendars

·        User assigned the Fiscal Calendar to a subsidiary

·        User restricted arole that has access to financial reports/tax reports to just that subsidiary

·        User logged inusing that role

·        User navigated to Reports > Financial and opened any Financial Report or Reports >VAT/GST > open any Tax Report

·        User got theunexpected error:

This Period > is not defined for this fiscalcalendar. Go to 'Setup > Accounting > Manage Tax Periods'and set up orassign the period you need



·        The error is causedby:

·        Home > Set Preferences > Analytics > Report by Period = Financials Only or AllReports

Financial Periods are Period based

Tax Reports are Period based 

·        Periods in ManageAccounting Period/ Manage Tax Period > Fiscal Calendar are unassigned

·        User missed out on assigningthe periods to their respective FiscalYear and Fiscal Quarter

·        Fiscal Period setup/hierarchy is necessary to Tax/Financial Reportsspecially in determining the Retained Earnings (Balance Sheet Report) orInternational Tax Reports



·        User will loginusing Administrator role to checkthe name of the Fiscal Calendarassigned to their role's subsidiary (Setup> Company > Subsidiaries > view subsidiary >(Tax) Fiscal Calendar)

·        User will navigateto Setup > Accounting > Manage(Tax) Accounting Periods > choose FiscalCalendar and either click Set UpFull Year or enter in the New YearOnly and New Quarter Only one byone

Add Item on a Sales Transaction: Sales Description and Item Price Do Not Populate

Cannot add an item on a Sales Transaction like Sales Order, Cash Sale or Invoice. The item shows up on the list of items that can be added but when the user clicks on it, the sales description and price do not populate.
When the user clicks the Add button, the item is not added on the line.

1. On the Item record, navigate to the Sales/Pricing tab > Sales description field : there is a backslash or reverse slash "/" character at the end of the sales description.
2. Remove the  backslash or reverse slash "/" character
3. Click  Save 

After removing the  backslash or reverse slash "/"  from the sales description, the user is now able to add the item on a sales transaction. The Sales description and Price automatically populate on the line item.

Void Journal Entry Permission for Custom Role

To be able to void Journal Entries, the user must have at least Create level of access for Make Journal Entry permission.


Here are the steps to resolve this :

  1. Navigate to Setup > Users/Roles > Manage Roles. 
  2. Edit the role of the User.
  3. Under the Permissions tab > Transactions subtab > Make Journal Entry = Create.
  4. Click Save.

Expose Currency Revaluation Search Amount for Exhange Rate Variance Account Same as the Net Variance of the Currency Revaluation Record

The values in the Amount column, are calculated based on the Consolidated Exchange Rate set in the Results tab of the Transaction Saved Search. If users would like the amount to be the same as the net variance shown on the Currency Revaluation Record, they can perform the following:

1) Edit Search

2) Under Results tab > Consolidated Exchange Rate = None

3) Click Save & Run


Reason Why UPS Shipping Items Appearing in FedEx/More List

If UPS Shipping Items appear in the Shipping Method dropdown after FedEx/More is selected as the Shipping Carrier check to see if the Shipping Item is integrated with UPS.

1. Any Shipping Items not integrated with UPS/FedEx will appear in the More section. These shipping items will all appear in the FedEx/More Carrier dropdown.

2. All Flat rate Shipping Items will also be in the More section and will appear in the FedEx/More Carrier Dropdown.

3. Only UPS Shipping Items using UPS Real-Time Rates will appear in the UPS Carrier dropdown.
-Check this by navigating to Lists> Accounting> Shipping Items> View the Shipping Item>  In the Shipping Rate tab> check if UPS Real-Time Rate is selected.

4. To use the Shipping Items not using UPS Real-Time Rate the Shipping Carrier field needs to be set to FedEx/More.


Find the Date when Vendor Bill is Fully Paid

There is no field on the Vendor bill record that gives the information on when a vendor bill is fully paid directly on the UI.

1) On a Vendor bill record, if you click on the Related Records tab, under the payments sub tab you will see the link to the bill payments that have been applied to set the status of the Bill to Paid in Full. The date when the bill is paid in Full is the link that has the latest date. The Related Records tab is available on Standard Vendor Bill form. If you use a custom form, please ensure to have this sub tab enabled on the form.

2) This date when a vendor bill is paid in full can be retrieved by using dateclosed field on the saved search where transaction type is vendor bill. In order to use dateclosed field:

- Navigate to Reports > Saved Searches > All Saved Searches > New

- Select Transaction link

-  Set the following under Criteria Tab > Standard Subtab:

         Type =Vendor Bill


Under Results Tab > Columns Subtab, add following fields(choose other based on your preference)

               - dateclosed.



Translation for Item Option Label not Displaying on the Web Store

The value set in Customization > Lists,Records, & Fields > Transaction Item Options > ItemOption Display tab > LABEL FOR INPUT will override all languagetranslations set on the Translation sub tab.

To ensure that translations for itemoptions are used, leave the Labelfor Input field blank andjust enter the preferred translations under Translation > Language > Label (Customization > Lists,Records, & Fields > Transaction Item Options > ItemOption).

Note as well that when LABEL FOR INPUT field (under Display tab) is blank, name of the custom field displayed in the Web Store will follow the LABEL field (Main area) value.

Change Payment Terms on Invoice Sourced from Sales Order Instead of Billing Schedule via CSV

When the Billing Schedule attached to a Sales Order has Payment Terms assigned, the Invoice created will follow the terms set on the Billing Schedule instead of the Sales Order, which populates from the Customer Record.

If you want to change Invoices already created to use the terms from the Sales Order instead a search can be created to find the affected Order and you can use the search to do a CSV Import to update the terms on the Invoices.

1. Create a search to find affected Invoices and the terms set on the Sales Order:
    a) Navigate to Reports> Saved Searches> All Saved Searches> New: Select Transaction
    b) Rename the search
    c) In the Criteria tab:
           Type = Invoice
           Applied to Transaction fields... then select Billing Schedule 
    d) In the Results tab:
        Applied to Transactions fields...
then select Terms
    e) Save and Run
    f) Export as CSV
    g) Save CSV file

2. CSV Import to Update Invoices with the Terms from the Sales Order:
    a) Navigate to Setup > Import/Export > Import CSV Records and set the following:

1.     Import Type: Transactions

2.    Record Type: Invoice

3.   Browse the file from the computer and click Next.

     b) In the Data Handling, choose Update.

     c)  Map the following in the Field Mapping page:

1.     Number – Number (Invoice folder)

2.   Terms - Terms (Invoice folder)

      d) Click Next
      e) Enter an Import Map Name and click Save & Run.


Search Saved to Show Profitability Per Transaction

To create this search please follow the steps below:


1) Navigate to Reports > New Search > Transaction

2) Under Criteria tab:

-- Add Type is Sales Order

-- Add Main Line is False

3) Under  Results tab:

-- Add Sales Rep -- Summary Type is Group

-- Add Number (this is the SO number) -- Summary Type is Group
-- Add Amount -- Summary Type is Sum
-- Add Item  
-- Add Quantity
-- Add Item Fields...Purchase Price (this is the cost of the item)-- Summary Type is Sum -- Label is Cost
-- Add Formula (Numeric) = {quantity}*{item.cost} -- Summary Type is Sum -- Label is Total Cost

-- Add Formula (Numeric) = {amount}-({quantity}*{item.cost}) -- Summary Type is Sum -- Label is Profit

4) Create Saved Search

5) Rename Search

6) Click Save & Run

Transaction Search for Sales Orders with Items Without Class

  1. Navigate to Reports > Saved Search > All Saved Searches > New.
  2. Click on Transactions
  3. Under Criteria tab > Standard subtab, add the following:

        - Type: is Sales Order

        - Item Fields...: Class: any of None.

     4. On Results tab, there are pre-populated fields to show the sales order information. You may add/remove any fields you want to see the results differently.

   5. If you want to see the results with just the Sales Orders in each line (without line items displayed), you can set the following on Criteria > Standard subtab:

        - Main Line=True

  6. Changing the value to False/Remove Main Line field will show you the line items of the sales orders. You may add the following field in the results tab if you prefer to see the name of the items:

        - Item Fields...: Name