Sunday, June 30, 2019

Behavior of Vendor Field when Printing 1099 Forms

When printing 1099 Reports, Vendor Name that will display in the print out would be the information found in the Legal Name field (found in the Financial tab) of the Vendor record - if available.

If the Vendor Type is Individual and the Legal Name and Company Name are blank, Vendor ID and Vendor Name will be the ones which will display in the Form 1099 printout.

If Vendor Type is Company, the printout will default to the Company Name, but in any case when the Company Name is different than the Legal Name, it is the Legal Name which will be used.

 

This is the hierarchy which will be followed:

1. Legal Name

2. Company Name

3. Vendor ID :  Vendor Name (for Individual Type only since Company Name is mandatory for Company Type)

Note:Users can access the 1099 Reports in Reports > Sales Tax US > Form 1099-MISC.

 

 

                                                                                                  

 

Adding Partners to Customer Records via CSV Import

Creating CSV file for import

1. Navigate to Reports > Saved Searches > All Saved Searches > New > Customer.
2. Populate Search Title.
3. In Criteria subtab add selection criteria for Customers to be updated.
4. In Results subtab add new field: Partner.
5. Save & Run.
6. Click Export – CSV > Export – Microsoft Excel button and save the file.
7. Now open the file in Excel and edit it:
   a. Update Partner column on those rows that should be updated in NetSuite (add Partner name that can be found on Partner record > Partner ID).
   b. Remove all the other rows that should not be updated in NetSuite.
   c. It is good approach to remove all the unnecessary columns and leaving just Internal ID (of the Customer) and the Partner Name.
   d. Save the file into CSV format.

Updating Customers in NetSuite

1. Navigate to Setup > Import/Export > Import CSV Records.
2. Set Import Type: Relationships, Records Type: Customers Only.
3. Select the CSV File that has been created previously and click Next.
4. Select Data Handling: Update and click Next.
5. In Field mapping set this:
   Internal ID <> Internal ID
   Partner <> Partner
6. Do not add any other fields into the mapping. If there are more columns in the source CSV file remove them from mapping.
7. Click Next.
8. Click Run.

Unable to enter Vendor Credits: Notice: SuiteScript Error. Invalid account reference key XX

The error message means that the account used for the vendor credits having an Internal ID:XX is marked inactive.

To verify:

1. Navigate to
Lists > Accounting > Accounts

2. Check the Show Inactives box located at the footer

3. Look for the account with the Internal ID of XX.

Note: Either uncheck the Inactive box of the account or assign an active account.

SuiteFlow FAQs

If I use monthly frequency, can I run it on the last day of the month?
The last date that you can run the monthly frequency is the 28th of each month.

Does a schedule workflow use the user's time zone, or the time zone set for the account?
The user's time zone is always used for scheduled workflows. For example, if an admin creates a scheduled workflow, it will run in the admin's time zone.

How do I access logs for a particular Workflow that has Logging enabled?
If you are an admin, there will be a Log link when viewing Workflow History. You must be an admin to see the logs.

Is there a search type that I can use to create a saved search for workflow logs?
No, saved search does not work on workflow logs.

Do workflow logs count as part of the total size of my account?

Yes, workflow logs are counted as part of the total size of your account. Workflow logs are automatically deleted after 60 days. Once the workflow logs are deleted, they no longer contribute to the total size of your account.

Does the additional information on the workflow logs impact how long the logs are saved for on the database?
No, workflow logs are automatically deleted after 60 days, regardless of additional information.

Is there a way I can delete workflow logs?
No, workflow logs are automatically deleted after 60 days.

Create a Custom Customer Entity Field to Show Total Sales of the Customer

Create a Customer Saved Search:
 
1. Navigate to Lists > Search > Saved Searches > New.
2. Select Customer.
3. Give a name to the Search.
4. Under the Criteria tab > Standard subtab add two fields:
  • Transaction Fields… Type is any of Invoice, Cash Sale.
  • Transaction Fields… Main Line is True.
5. Under the Results tab > Columns subtab add one field :
  • Transaction Fields… Amount.
  • Summary Type = Sum.
6. In the main area of the Results tab select Transaction : Amount from the Sort By drop down menu.
7. Under the Available Filters tab add one filter:
  • Internal ID.
8. Click Save.
 
Create a Custom Entity Field:
 
1. Navigate to Customization > Lists, Records, & Fields  > Entity Fields > New.
2. In the Label field, enter the label of the field. E.g. Total Sales.
3. Uncheck the Store Value checkbox.
4. Under the Applies To tab.
  • Check Customer.
5. Under the Display tab.
  • In the Subtab field, select the tab where the field will be placed or select Main to show it in the customer form main area.
6. Under the Validation & Defaulting tab.
  • In the Search field, select the Saved Search created before.
7. Click Save.

Customer Saved Search for the number of Customers created last month per Sales Rep who has a Sales Order/s the current month

1)    Go to Reports > Saved Searches > All Saved Searches > New

2)    Click the Customer link

3)    Enter your desired Saved Search title

4)    Results tab > Columns sub tab > set the following Field and corresponding Summary Type:

-- Sales Rep | Group

 

-- Formula (Text) | Count

    Formula : Case When TO_CHAR({datecreated}, 'MM YYYY') = TO_CHAR(ADD_MONTHS({today}, -1), 'MM YYYY') then {internalid} end

    Custom Label : Customers created last Month

    Summary Label : Customers created last Month

-- Formula (Text) | Count
    Formula : Case When TO_CHAR({datecreated}, 'MM YYYY') = TO_CHAR(ADD_MONTHS({today}, -1), 'MM YYYY') and {transaction.type} = 'Sales Order' then {internalid} end
    Custom Label : With SO
    Summary Label : With SO

5)   Click Save & Run

Transaction PDF Layout> Change Tax Total label that shows on the printed form

Scenario: Customer would like to change the description that prints for the Tax Total in their Sales Order where for US Customers it shows a different label added instead of showing Tax Total on the PDF layout

Steps to Reproduce:
1. Open Sales Order Record (Transactions > Sales > Enter Sales Orders > List).
2. Click Print.
3. Tax Total label shows a different label instead of tax total.

To resolve this:

1. Navigate to Setup> Accounting> Set Up Taxes.

2. Select United States tab and on the Print/Email Tax Label Format, change the value of the label to Tax Total.

3. Open the Sales Order and print to show Tax Total on the PDF.

Customer Saved Search for Yearly Comparison of Sales Orders

1)  Navigate to Reports > Saved Searches > All Saved Searches > New
2)  Click on the Customers link
3)  Criteria tab > Standard sub tab > set the following Filters with their corresponding Description:
      -- Transaction:Type | is Sales Order
      
     
-- Transaction:Date | is on or after 11/20/2012

4)  Results tab > Columns sub tab> set the following Fields with their corresponding Summary Type:
      -- Name | Group

      -- Formula(Currency) | Sum
          Formula : CASE WHEN {transaction.trandate} > TO_DATE('11/20/2012', 'MM/DD/YYYY') AND {transaction.trandate} < TO_DATE('01/31/2013', 'MM/DD/YYYY') THEN {transaction.amount} END
          Custom Label : 11/20/12 - 01/30/13

      -- Formula(Currency) | Sum
          Formula : CASE WHEN {transaction.trandate} > TO_DATE('12/01/2013', 'MM/DD/YYYY') THEN {transaction.amount} END
          Custom Label = 12/01/13 YTD

5) Click Save & Run

Transaction Saved Search for Percentage of the Number of Sales Orders under $100 for Sales Reps

1)  Navigate to Lists > Search > Saved Searches > New
2)  Click Transactions link
3)  Enter your desired Saved Search Title
4)  On the Criteria tab > Standard sub tab > Filters column, set the following:

    --  Type: is Sales Order

    -- Date Created: is within - set required date/s

    -- Main Line: is True

    -- Status: is none of
        Sales Order: Pending Approval
        Sales Order: Cancelled
        Sales Order: Closed

5)  Results tab > set the following fields with the corresponding Summary Type:

    --  Sales Rep | Group

    --  Date 

    --  Number | Count

    -- Amount | Sum

    -- Formula (Numeric) | Count
        Formula : COUNT(DISTINCT(Case When {amount} < 100 then {number} end))

    -- Formula (Percent) | Sum
       Function : Round to Hundredths
       Formula : COUNT(DISTINCT(Case When {amount} < 100 then {number} end))/nullif(COUNT({number}),0) 

6)  Click Save & Run

Be able to set a Class in the Item Fulfillment page>Primary Information field

1. Navigate to Customization> Lists, Records, & Fields > Transaction Body Fields>New.

2. Set the following:

  • Label : Descriptive Name
  • Type: List /Record
  • List/Record: Class

3. Mark the Store Value and Show in List checkbox

4. Under the Applies To  subtab, mark Item Fulfillment checkbox.

5. Save.

6. Customize the Item Fulfillment form.

7. Click on Move Element between Subtabs button.

8. Under the Move Transaction Form Element page, click on Custom subtab.

9. Mark the Select checkbox for the Body Field the user created and select Main as the Subtab.

10.Hit Save.

11. Under the Edit Custom Transaction Form page, click Screen Fields>Main subtab.

12. Set the Field Group of the Body Field to Primary Information.

13. Hit Save.

Note:

This solution is for the user to have the ability to set a different Class in the Item Fulfilment that will apply to the whole Item Fulfilment Transaction.

The Class assigned on the Custom Body Field will not be reflected in the GL Impact

 

SandBox Refresh Impact on OneWorld Upgraded SandBox

As per Process, it is highly recommended to customers who wish to OneWorld Upgrade to have it tested in SandBox account. This is to eliminate or reduce the risk of any adverse and/or unwanted effect of having the feature enabled.

A SandBox refresh completely overwrites the SandBox environment so that it mirrors the production environment. In that regard, if the SandBox is upgraded to OneWorld while it is not yet upgraded in the Production environment, then the feature will also be removed from the SandBox. If the Production environment is upgraded to OneWorld, then the SandBox will remain in OneWorld. 

In cases where the OneWorld has been removed in SandBox due to refresh and the customer needs to have the feature turned On again, then they have to request it from Support.

Creating Currency Exchange Rate Saved Search to Show Base Currency and Translation Currency in their Currency Symbol/Name Instead of Internal ID

The Currency Exchange Rate Type Search is not available when you go to the List of Search types under Lists>Search>Saved Search>New. However, the search can be created by navigating to Lists>Accounting> Currency Exchange Rates> New> Click on the Search Link on the upper left of the page>Click on Create Search button.

 

Enter the Criteria you wish to have to narrow down the information accordingly.

 

On the results Page: Replace the Base Currency field and the Transaction field as with the formula customized as follows:

 

Formula Field = CASE WHEN {basecurrency} = '1' then '[currency symbol of Currency with Internal ID = 1]' when {basecurrency} = '2' then '[currency symbol of Currency with Internal ID = 2]' when {basecurrency} = '3' then '[currency symbol of Currency with Internal ID = 3]' else null end

 

For example:

 

For the Base Currency:

 

Field= Formula Text

 

Formula Field = CASE WHEN {basecurrency} = '1' then 'USD' when {basecurrency} = '2' then 'GBP' when {basecurrency} = '3' then 'CAD' else null end

 

Column Label = base Currency

 

For the Transaction Currency:

 

Field= Formula Text

 

Formula Field = CASE WHEN {transactioncurrency} = '1' then 'USD' when {transactioncurrency} = '2' then 'GBP' when {transactioncurrency} = '3' then 'CAD' else null end

 

Column Label = Transaction Currency


 

Continue the Logic of the search based on the number of Currency records you may have. After running the search, it should allow see the exchange rates on a segmented single browser Page. It is also possible to export the result easier.

Create a List of Item Receipts from a Specific Vendor for a Specific Month

Need a list of Item Receipts from a Specific Vendor for a specific month.

1. Navigate to Reports > Saved Searches > All Saved Searches > New.
2. Select Transaction from the list.
3. In Criteria > Standard > Filter:
    a. Choose Type from the dropdown and in the popup select Item Receipt
    b. Choose Created From Fields… from the dropdown and in the popup select Type. In the new popup box, choose Purchase Order
    c. Choose Main Line from the dropdown and in the popup select No
    d. Choose Quantity from the dropdown and in the popup, select greater than and enter 0 in the Value field
    e. Choose Item Fields... from the dropdown and in the popup select Type. In the new popup, choose Assmebly/Bill of Materials and Inventory Item
4. In Results > Columns > Field:
    a. Click on Remove All button
    b. Add Number, Item, Quantity, Date and Amount
    c. Add Vendor Fields... and in the popup choose Name/ID
    d. Add other fields as necessary
5. In Available Filters:
    a. Add Date and check the box under Show in Footer
    b. Add Vendor Fields... and in the popup choose Name/ID. Check the box under Show in Footer
6. Rename the Saved Search.
7. Click Save & Run.

Adaptive Insights: Mac > Sheets > Dropdown Selectors not Loading

This article is intended for accounts integrated with Adaptive Insights, NetSuite's partner in delivering financial management solutions.


This happens when in Adaptive Insights while using Mac with the Firefox browser dropdown selectors on sheets "flash" open and then close. There is a bug that was introduced in version Java 7 Update 21 and greater that sometimes causes this behaviour to occur for Mac users using Mac OS X 10.7. Adaptive Insights is actively working with Oracle to find a permanent solution for this issue.

 

Alternative Solutions:

1. If you are viewing a Cube sheet, you can use the Change Dimensions button to adjust any dimension on the sheet.

2. Upgrade to Mac OS X to 10.8. We have verified that this behaviour does not occur with this Operating System.

Elimination Journal Entry created only eliminates the Intercompany Accounts Receivable against the CTA-E account and did not consider the Intercompany Accounts Payable.

An intercompany transaction affecting the intercompany accounts receivable and payable will normally eliminates with the following GL Impact:

Debit: Intercompany Payable------------xx


Credit: Intercompany Receivable-----------------xx


Dr/Cr: CTA-E--------------------------------------------xx


When the elimination journal entry has the following impact or vice versa, we just need to check the status of the intercompany bill or invoice. If the status is set to Paid-in-full, then only the open transaction will be eliminated as the intercompany payable or receivable has already been closed on the payment transaction.


Debit: Intercompany Payable------------xx


Credit: CTA-E------------------------------------------xx


 

 

Accounting Period System Notes

Historical changes made to an Accounting Period may be accessed in two different
ways as follows:

1. Via the Period record

    --Navigate to Setup > Accounting > Manage G/L > Manage Accounting Periods
    --Click on a Period
    --On the Edit Base Period, go to Notes > System Notes sub tab

2. Via the Period Close Checklist

    --Navigate to Setup > Accounting > Manage G/L > Manage Accounting Periods
    --Click on a Period Close Checklist icon
    --On the Period Close Checklist page, click on the Notes link
    --On the Accounting Period page, click on the Notes tab then view the System Notes sub tab

Number Prefix for Department, Class and Location

There is an Enhancement Request for Department, Class and Location to have Auto-Generated Prefix Number -

 

Enhancement 146453: Setup > Company > Auto-Generated Numbers > Transactions; Be able to have a check box for Department, Class and Location.

 

As an alternative solution you may add the Numbers manually before the name.

1.) Navigate to Setup > Company > Departments

2.) Click Edit on the department to be edited

3.) Add the number before the name of the department

4.) Click Save.

For example:
100 Marketing
200 Accounting
300 Logistics

This will affect the Transactions created and to be created.

 

Create a List of Customers with a Campaign Response of Opened for a Range of Campaign IDs to Create a New Target Group

After sending an Email Marketing Campaign, the best practice is to make a follow up  with Customers who opened the campaign. It will be the advantage of the business if the assigned Sales Rep to have the list of these Customers.

To Create a list of Customers with a Campaign Response of Opened for a range of Campaign IDs  for the purpose of creating a new target Group or a guide for call backs and Task creation:

1. Navigate to Lists > Search > Saved Searches > New.
2. Search Type=Customer.
3. In the Criteria sub-tab, add the filters:



4. In the Results sub-tab, add preferred fields.
5. Click Save & Run.

GST34 worksheet : Where does the system gets the value for Sales/Purchases GST adjustment ( Box 104 and 107)

GST34 Worksheet sales/purchases tax adjustment box 104 and 107 values are sourced from non- sales /purchases transaction that hits the GST ledger accounts but do not have tax code associated with it ( for example Journal entries).


-- To verify the amount on GST34 worksheet box 104 and 107, Create a non sales/purchase transaction save search:


1.List> Search> Save Searches> New


2. Select Transaction


3. On Criteria tab, set the following filters:

Type = Journal (or include any non sales / purchase records)

Date = select a the same date range selected on GST34 worksheet

( For OneWorld account : add Subsidiary = Canada Subsidiary )

Account = Select the GST/HST ledger accounts


4. On results column, ensure you have the following columns results

Amount Debit

Amount Credit

Account


5. Rename search


6. Save and run

Total net amount posting to GST Sales/Purchase ledger accounts from the saved search match the amount showing on GST34 worksheet Box 104 and box 107 value.


To avoid values showing on these boxes for GST34 worksheet, enter adjustment entries through sales /purchases record and assign appropriate tax code to calculate the tax amount to post on GST ledgers







Determine the Source of Revaluation Amounts and Variables


Image

Currency Revaluations are computed based on the Foreign Currency amount outstanding as of the Period/Date selected on the revaluation page.

To compute for the Foreign Currency Amount used as the basis for the computation of the Revaluation Gain or Loss:

1. Navigate to Reports > Financial > Balance Sheet.

2. Click on the Amount beside the account that user is referencing.

3. On the Balance Sheet Detail page, click on Customize.

4. Under the Financial Report Builder>Edit Columns link, expand the Financial Folder.

5. Select Amount (Foreign Currency)

6. Look for the Currency subfolder and select Name.

7. Click Preview.

8. On the Custom Balance Sheet Detailed Report, set the Date Range from the first Period/Date of the Company up to the Date/Period that revaluation was ran.

9. As a result, all transactions in the account selected will be exposed together with the Foreign Currency equivalent and the Name of the Foreign Currency.

10. Export the Report to Excel.

11. Manipulate the data by setting a filter on each column.

12. After setting the filter, select the transactions that are in Foreign Currency using the Name filter.

Note: The sum of the transactions in Foreign Currency only is the basis of the Currency Revaluation.

 

 

 

 

 

Create a Saved Search to Display invoices with Different Ship to Address and "End User" Ship to Address

1.    Navigate to Reports> Saved Searches > All Saved Searches> New

2.    Choose Search Type "Transaction"

3.    At the Criteria tab, set the following:

Filter

Description

Formula

Type

Is Invoice

Main Line

Is true

Formula (Numeric)

Is 1

Case When {shipaddress} != {custbody_end_user_default_ship_address} then 1 else 0 end

Date

Depends on the date range that the users need for the report.

4.    At The Results tab, there are already default fields. However, users may add other Results fields needed for their report. Add the following:

o End User Default Shipping Address (Custom)

o Shipping Address

Note: This report is useful for Avatax purposes if users need to export to Microsoft Excel the End User Ship to Address found in the Invoice.

Budget Income Statement > Contra Revenue Account Amounts were Added Instead of Being Deducted to Total Sales

It is important to take note of those accounts we deem as a Contra Revenue Account.

A Contra Revenue Account is one that oppose the normal balance of a relative income account such as Sales Returns and Allowances, and Sales Discount.

When entering budgets via Transactions > Financial > Set Up Budgets, Contra Revenue Accounts must be entered as a negative value in order for the amount to be properly deducted against its relative revenue account on reports.

In NetSuite, Contra Revenue accounts are normally created as an Income Type account similar to that of a normal Revenue account. With this, entering a positive value for a Contra Revenue account on the New Budget page would treat it as an addition to the total amount of the normal Revenue accounts.

Saved Search to Display Combined Open Bills and Open Purchase Orders that Exceeds their Credit Limit

1. Navigate to Transactions > Management > Saved Searches > New.
2. Select Transaction.
3. In the Criteria tab > Standard subtab, set the following filters:
-- Type = is any of Bill, Purchase Order
-- Status = is any of Bill:Open, Purchase Order:Pending Supervisor Approval, Purchase Order:Pending Receipt, Purchase Order:Pending Bill.
-- Main Line = is True
4. In the Criteria tab > Summary subtab, set the formula below:
-- Summary Type = Sum
-- Field = Formula (Numeric)
   Formula = case when ((SUM(case when {type} = 'Bill' then {amount} else 0 end) + SUM(case when {type} = 'Purchase Order' then {amount} else 0 end))) > MAX({vendor.creditlimit}) then 1 else 0 end
   Formula (Numeric) = equal to
   Value = 1
5. In the Results tab > Columns subtab, set the following fields:
-- Name (Summary Type = Group)
-- Document Number
-- Formula (Numeric)
   Summary Type = Sum
   Formula = case when {type} = 'Bill' then {amount} else 0 end
   Custom Label = Total Bills
-- Formula (Numeric)
   Summary Type = Sum
   Formula = case when {type} = 'Purchase Order' then {amount} else 0 end
   Custom Label = Total Purchase Orders
-- Formula (Numeric)
   Summary Type = Sum
   Formula = (sum(case when {type} = 'Bill' then {amount} else 0 end) + sum(case when {type} = 'Purchase Order' then {amount} else 0 end)) - max({vendor.creditlimit})
   Custom Label = Remaining Credit Limit
-- Vendor fields...Credit Limit (Summary Type = Maximum)
6. Click Save & Run.

Saved Search to Pull Up Details of the -None- Category on Bill Payments Report

1. Navigate to Transactions > Management > Saved Searches > New

2. In the Criteria Tab > Standard subtab, set the following filters:

* Type is Bill Credit, Bill Payment
* Main Line is False
* Date is within (the period of the report)

3. In the Results tab > Columns subtab, add:

* Formula (Text) | NVL({vendor.companyname},{name}) | Summary type is Group
* Amount | Summary type is Sum

4. Hit Save or Preview

Saturday, June 29, 2019

Adaptive Insights: Use of Firefox browser results in component failed to load messages error and a red plugin icon is visible on the browsers URL

This article is intended for accounts integrated with Adaptive Insights, NetSuite's partner in delivering financial management solutions.


In Adaptive Insights, using the Firefox browser results in component failed to load messages error and a red plugin icon is visible on the browsers URL. For users running the latest version of Firefox (This is currently 24.0), Java is automatically disabled by Firefox.

 

To load the sheets and the Adaptive Insights applets, the user will need to allow the Java plugin. Note: The plugins can be activated on the Adaptive Insights site without enabling Java on all sites. To do this please follow the steps below:

1. In the Firefox browser click the red plugin icon in the address bar and a message panel will open.

2. In the message panel, click Allow and Remember option for both Java plugins. 

Once the plugins are activated for the Adaptive Planning site, the setting will be remembered the next time the site is accessed.

Ignore CSC Decline while Using Payflow Pro

Currently, there is no option to Ignore CSC decline using Payflow Pro, users can only ignore CSC in NetSuite using CyberSource and Merchant eSolutions. For Payflow Pro transactions, the setting on the Payflow Pro account should prevail. If you ignore it from Payflow Pro then it should go through in NetSuite.

Expense Report does not have correct GL impact after setting an account in "Track Billable Expenses in" field

The Track Billable Expense in field only applies to Expense, Other Expense and Cost of Goods Sold.


Upon creating a new expense report from an employee record (Related Records > Transaction subtab), select the Cost Category and mark the expense as Billable on the line items.

When checking the GL Impact, it still shows the account set in the Cost Category instead of Track Billable Expense in field. This is because the account on Track Billable Expenses in field get entered only when the expense report gets invoiced, not when the expense report is created.

 To test, proceed to create an invoice on Transactions > Sales > Create Invoices:

1. Under Billable Expense, select the expense.

2. Save the Invoice

3. Navigate to Actions > GL Impact.

3. GL impact shows account set as Track Billable Expense  in the cost category account.

Add View GL Impact Link to a Transaction Saved Search

To get the GL impact of a transaction, the user will need to go to More Actions > GL Impact.  A formula field can be created to pull the GL Impact directly from a transaction saved search.  To do this, add this field on the Results tab of your saved search:

Field: Formula (Text)
Formula: '<a href=https://system.netsuite.com/app/accounting/transactions/impact.nl?trantype='||DECODE ({type}, 'Assembly Build', 'build',  'Assembly Unbuild', 'unbuild',  'Bill', 'vendbill',  'Bill Credit', 'vendcred',  'Bill Payment', 'vendpymt',  'Bin Putaway Worksheet', 'binwksht',  'Bin Transfer', 'bintrnfr',  'Cash Refund', 'cashrfnd',  'Cash Sale', 'cashsale',  'Check', 'check',  'Commission', 'commissn',  'Credit Card', 'cardchrg',  'Credit Memo', 'custcred',  'Currency Revaluation', 'fxreval',  'Customer Deposit', 'custdep',  'Customer Refund', 'custrfnd',  'Deposit', 'deposit',  'Deposit Application', 'depappl',  'Estimate', 'estimate',  'Expense Report', 'exprept',  'Inventory Adjusment', 'invadjst',  'Inventory Cost Revaluation', 'invreval',  'Inventory Distribution', 'invdistr',  'Inventory Transfer', 'invtrnfr',  'Inventory Worksheet', 'invwksht',  'Invoice', 'custinvc',  'Item Fulfillment', 'itemship',  'Item Receipt', 'itemrcpt',  'Journal', 'journal',  'Opportunity', 'opprtnty',  'Paycheck', 'paycheck',  'Payment', 'custpymt',  'Payroll Liability Check', 'liabpymt',  'Payroll Adjustment', 'ytdadjst',  'Purchase Order', 'purchord',  'Return Authorization', 'rtnauth',  'Revenue Commitment', 'revcomm',  'Revenue Commitment Reversal', 'revcomrv',  'Sales Order', 'salesord',  'Sales Tax Payment', 'taxpymt',  'Statement Charge', 'custchrg',  'Transfer Order', 'trnfrord',  'Vendor Return Authorization', 'vendauth',  'Work Order', 'workord')||'&searchid=-36&Transaction_INTERNALID='||{internalid}||'&Transaction_INTERNALIDtype=ANYOF&label='||replace({type}, ' ', '+')||'>View GL Impact</a>'
Custom Label: View GL Impact

The formula uses the DECODE function to convert the transaction type to its corresponding URL value, which will be used in the URL for the GL Impact. The REPLACE function replaces the transaction type value, where any space in the transaction type name will be replaced by a plus (+) symbol, which is also needed for the URL.

Note: The formula can still be customized to add any missing transaction types, if there is any, or remove transaction types, if not needed in the search.

Please make a note of the URL used to access your NetSuite account. If the URL has something between "system" and "netsuite.com" (e.g. system.beta.netsuite.com), include that in the formula.