SuiteAnalytics Updates in NetSuite 2021.2

Dataset Linking in SuiteAnalytics Workbook

Link datasets to analyze metrics from two datasets in a single visualization, based on a link that you define

using common field data from each dataset. Unlike joining record types, you can link datasets even if they are based on record types that do not have predefined common keys in the analytics data source.

Change

Additionally, with linked datasets you can compare data that exists on two different levels of aggregation, such as the sum of individual transactions versus a monthly budget. In 2021.2, you can define your own linked datasets using the N/datasetLink module in SuiteScript. You currently cannot view or edit how datasets are linked from the Workbook user interface. However, you can save and share workbooks that are based on linked datasets or create new visualizations within them.

Link definitions are also associated with the workbooks where they are created. This association means

that you can use linked datasets in multiple visualizations, but only in the workbook where they were linked. For more information, see the following topics:

• Dataset Linking in SuiteAnalytics Workbook
• N/datasetLink Module
• Linking Datasets

Cached Data in Datasets

In previous releases, data in datasets was loaded in real time whenever you accessed a dataset. With the

Cached Data in Datasets feature enabled in your account, you can use Cached Response mode to load

cached data in your datasets. The load time of your datasets and any workbooks or portlets that use the dataset is improved when data is loaded from cached data. All cached data is refreshed automatically every 60 minutes. For more information, see the help topic Cached Data in Datasets.

CSV Export Option Available in Pivot Tables

In workbooks, you can now export your pivot tables as CSV files. Prior to 2021.2, you could only export table views and charts as CSV files. Now, the export option is available in all workbook visualizations: table views, charts, and pivot tables. For more information, see the help topic Pivot Tab.

Analytics Portlet Names Available as Translatable Fields

SuiteAnalytics Workbook now supports the translation of Analytics portlet names using Manage Translations.

Strings and collections for translation are automatically created when you enter the portlet name in the

new translatable field of your workbook visualizations. To enable the translation, a Translation Collection stores translation strings with their translations in NetSuite. For more information about how to set up translatable portlet names, see the help topic Adding Translatable Analytics Portlet Names. For more information about how to use translation collections, see the help topic Working with Translation Collection Strings. Icons Added to SuiteAnalytics Workbook Conditional

Formatting

In addition to colors, you can now apply icons to your workbook table view and pivot table results using conditional formatting. Depending on the conditions you set up, you can apply conditional formatting to

Change

groups of results or individual results. You can also apply conditional formatting to any fields containing number or string values, including custom formula fields and calculated measures. For more information, see the help topic Conditional Formatting.

Changes to Return Values in Some Connect Columns

In SuiteAnalytics Connect, the maximum length for return values in some columns has changed. Note: This update applies to the NetSuite.com data source only. The following table shows the list of columns with length changes for return values:

Column Name Previous Length Updated Length

If you work with the NetSuite.com data source and you are using column attributes in your configuration, review these changes and make adjustments as needed. To avoid error or discrepancies, your configuration must match the column values listed in the Connect Browser. This change is effective as of 2021.2, but the current version of the Connect Browser does not show the updated values yet. This change will be visible in the 2021.2 Connect Browser when it is released at a later date. For information about the column attributes, see the help topic Table Summary. Removal of the Connect transaction_lines.date_last_modified Column The date_last_modified column is permanently removed from the transaction_lines table. In previous releases, the Connect Browser included a description that this column may return inaccurate values and that you should use the date_last_modified_gmt column instead. Note: This change applies to the NetSuite.com data source only. The date_last_modified_gmt column returns results in the Coordinated Universal Time (Greenwich Mean Time). You should consider the time zone when you review your queries and make any adjustments as needed. This change is effective as of 2021.2, but the Connect Browser is not upgraded at the same time. The column is visible in the current version of the Connect Browser, but it does not return any results. The column will no longer appear when the 2021.2 Connect Browser is released at a later date. For more information about the tables and columns available in the Connect Schema, see the help topic Connect Schema. Change 2021.2 Connect Browser The 2021.2 version of the Connect Browser is not yet available. SuiteApps (Bundles) Released by NetSuite Accounting SuiteApps Following are the 2021.2 accounting enhancements to SuiteApps:

SuiteApprovals Enhancements

With SuiteApprovals version 6.01, you can now perform project-based approvals. When you enable the Projects and Project Management features in your account, project managers can approve project-based records and documents.

• Addition of Project Manager as an Approver Type – When creating an approval rule with a custom approval chain, you can select Project Manager from the Approver Type dropdown list. You do not need to select a specific project manager under the Approver column of the approval matrix. When the approval rule is used, the SuiteApp automatically retrieves the name of the approving project manager from the Primary Information section of the project record. The reference project record is the one linked to the document for approval.
• Supported Record Types for Project-Based Approvals – Project managers can approve purchase orders, expense reports, and vendor bills that are linked to projects. Project managers can approve documents through the NetSuite UI and by email. For more information, see the help topic SuiteApprovals SuiteApp. Inventory Management SuiteApps

Following are the 2021.2 inventory management enhancements to SuiteApps:

• Certificate of Analysis in Quality Management

Change

• SCM Mobile Customization and Printing Enhancements

Certificate of Analysis in Quality Management

Certificate Of Analysis (COA) is a document that is issued by Quality Assurance to confirm that a regulated

item meets its quality specification. A COA includes the inspection results from tests that were performed as part of your organization’s quality control. In Quality Management SuiteApp, a COA is generated after a sales order is fulfilled and the item leaves the location. As part of the fulfillment process, a COA document can be generated for the items being shipped. Your administrator can configure their preferences to generate a COA in a format that best suits your organization’s needs.

SCM Mobile Customization and Printing Enhancements

Note: SCM Mobile is shared with the following NetSuite features and SuiteApps: Warehouse Management, Manufacturing Mobile, and Pack Station. For more information, see the help topic SCM Mobile. dynamic messages for page elements of custom mobile processes. For more information about dynamic messages, see the help topic Custom Message Setup for Custom Mobile Processes.

• Mobile Printing Updates – You can now add a print button to any standard or custom NetSuite record. You can configure mobile printing even for records not used in the NetSuite WMS and Pack Station processes.

For NetSuite WMS , you can print pallet labels for assembly builds from your mobile device. Also, the

new Print pick carton labels? rule enables you to print pick carton labels when you use cartons for order picking. See the help topic Building Assembly Items for a Work Order or Tally Scanning Updates and New System Rules. Localization SuiteApps

Following are the 2021.2 localization enhancements to SuiteApps:

• ANZ Localization Enhancements
• Brazil Certification Tax Authorities
• E-Document Certification Service
• India Localization SuiteTax Engine Enhancements
• Japan Fixed Assets Reports
• Norway Tax Reports Enhancements
• Philippines Localization Support for BIR Simplified System Registration for CAS Users ANZ Localization Enhancements

Change

• ANZ Localization Preferences Setup
• ABN and NZBN Verification Warning
• Australia Taxable Payments Annual Report (TPAR) Enhancements
• Australia Payment Times Report (PTR) Small Business Supplier Identification
• Supplier ABN List Report

AU Report Subtab Update

In ANZ Localization version 1.1.0, the AU Report subtab is renamed to AUS Reporting subtab. This subtab is added to Australia vendor records and transaction (vendor bill and bill payment) records for an Australia vendor.

ANZ Localization Preferences Setup

ANZ Localization version 1.1.0 includes the new ANZ Localization Preferences page. On this page, you

can set up your company preferences for Australia and New Zealand customer and vendor records. If you are an administrator, you can access this page at Setup > ANZ Localization > Preferences. For non- administrator roles, go to Setup > Other Setup > ANZ Preference. For more information about the ANZ Localization Preferences page, see the help topic Setting Up ANZ Localization Preferences.

ABN and NZBN Verification Warning

ANZ Localization version 1.1.0 adds the ABN Verification Warnings preference on the ANZ Localization

Preferences and Set Preferences pages. Use this field to set up a warning banner to prevent invalid

ABNs and NZBNs from being entered on customer and vendor records. Read about setting up the ABN

Verification Warnings as a company preference on the help topic ABN and NZBN Verification Warning and as a user preference on Setting Up Australia-specific User Preferences. Australia Taxable Payments Annual Report (TPAR) Enhancements

Report (TPAR) for Australia:

• Export - PDF icon - You now have the option to view and download your TPAR as a PDF.
• Summary Report – You can now view a list of all your TPAR reportable bill payments per Payee and export it to a spreadsheet. For more information, see the help topic Viewing the TPAR Summary Report.
• Detailed Report – When you view the Summary Report, you can drill down to the bill payment and view all the reported bills. You can also export this report to a spreadsheet. For more information, see the help topic Viewing the TPAR Detailed Report. To learn more about the TPAR, see the help topic Taxable Payments Annual Report. Australia Payment Times Report (PTR) Small Business Supplier

Identification

In preparation for Payment Times Reporting, ANZ Localization version 1.1.0 adds the Small Business box on the AUS Reporting subtab for Australian vendor records. You can check this box to identify vendors as small business suppliers and reportable for PTR. For more information, see the help topic Identifying Small Business Suppliers for Payment Times Reporting. Change

Supplier ABN List Report

ANZ Localization version 1.1.0 includes the new Supplier ABN List Report page. You can use this page

to generate a list of your vendors’ ABNs, export it to a CSV file, and run it through the SBI Tool for small business identification. You can then check the Small Business boxes of the identified small businesses to include it for Payment Times Reporting. If you are an administrator, you can access this page at Setup

ANZ Localization > Supplier List. For non-administrator roles, go to Setup > Other Setup > ANZ Supplier List. For more information about the Supplier ABN List Report page, see the help topic Supplier ABN List Report.

Brazil Certification Tax Authorities

Brazil Certification Tax Authorities SuiteApp version 1.2.0 enables you to send e-documents to several Brazilian tax authorities. This SuiteApp is generally available and can be installed from the NetSuite SuiteApp Marketplace (Application ID: com.netsuite.brazilcertificationtaxauth). It is a public and managed SuiteApp. To use this SuiteApp, you must also install the E-Document Certification Service SuiteApp. The Brazil Certification Tax Authorities SuiteApp provides the following features and capabilities:

• E-Document Template Files – You can leverage the predefined e-document template files to create e-document template records for several Brazilian tax authorities. For more information, see the help topic Finding the Predefined E-Document Template Files for Brazil. The SuiteApp provides predefined files for e-documents such as:
  • Nota Fiscal de Produtos Eletrônica (NF-e)
  • Nota Fiscal de Serviços Eletrônica (NFS-e)
  • Manifesto do Destinatário Eletrônico (MDF-e)
  • Guia Nacional de Recolhimento de Tributos Estaduais (GNRE) tax collection form
  • Escrituração Fiscal Digital de Retenções e Outras Informações Fiscais (EFD-Reinf) report
• Tax Authority Plug-ins and Records – To send the e-documents for certification, you need to have a tax authority certification service set up in your account. When you install the Brazil Certification

Tax Authorities SuiteApp in your account, NetSuite creates the tax authority plug-ins and records

for several Brazilian tax authorities. For more information, see the help topic Brazil Certification Tax Authorities Overview.

E-Document Certification Service

The E-Document Certification Service SuiteApp version 1.2.0 enables you to send e-documents to tax authorities and manage their responses. The SuiteApp is generally available and can be installed from the NetSuite SuiteApp Marketplace (Application ID: com.netsuite.edoccertificationservice). It is a public and managed SuiteApp. The E-Document Certification Service SuiteApp provides the following features and capabilities:

• Tax Authority Implementation – You can set up secure connections with tax authorities that oversee the certification of e-documents generated in NetSuite. For more information, see the help topic Certification Tax Authority Implementation.
• E-Document Signature – From your e-document, you can define which tags NetSuite should sign and in which order to sign them. The SuiteApp also provides a standard e-document signature plug-in. For more information, see the help topics E-Document Digital Signature and Adding Digital Signature Tags.

Change

• E-Document Certification Priorities – You can define priority levels according to the e-document category, operation, or subsidiary. The priority determines the order in which NetSuite sends the e- document for certification. For more information, see the help topic Defining E-Document Certification Priorities.
• E-Document Certification Portlet – You can add a portlet to your dashboard to monitor the e- document certification process. For more information, see the help topic Adding the E-Document Certification Monitor Portlet to a Dashboard. India Localization SuiteTax Engine Enhancements item types.
• Ability to generate E-Way Bill using the Invoice Reference Number (IRN).
• Addition of Permanent Account Number (PAN) and Aadhar Number fields to customer records. For more information, see the help topic Electronic Invoicing for India.

Japan Fixed Assets Reports

Japan Fixed Assets Reports is a new SuiteApp that generates reports for depreciable fixed assets and

corresponding tax reports. With this SuiteApp, you can apply depreciation rates from the tax agency and depreciation methods to the depreciable asset tax reports. The reports comply with requirements of municipal tax agencies in Japan. The SuiteApp is available from the SuiteApp Marketplace. The SuiteApp generates two reports:

• Depreciable Asset All Asset Report – Detailed report of all individual depreciable assets under a Municipal in a Reporting Year.
• Depreciable Asset Tax Report – Summary of all depreciable assets per Depreciable Asset Type under a Municipal in a Reporting Year. Depreciable assets are grouped into Acquired Before Last Year, Retired Last Year, and Acquired Last Year. The reports should be generated yearly for Japan subsidiaries with specified Depreciable Asset Tax Reporting information and depreciable asset records. Japan Fixed Assets Reports requires the Fixed Assets Management (FAM) SuiteApp. Asset records in FAM are used to create depreciable asset records. Note: The version of FAM must be from the same release period as the version of Japan Fixed

Assets Reports. You must upgrade the FAM version to its 2021.2 release to be compatible with this

release of Japan Fixed Assets Reports version 1.0. Every time a new version of FAM is released, a compatible version of Japan Fixed Assets Reports will also be released.

Norway Tax Reports Enhancements

The latest version of Norway Tax Reports SuiteApp contains the following major enhancements:

• Income Statement Close Support
• Display Employees as Suppliers
• Minor Enhancements to Norway Tax Reports Change

Income Statement Close Support

When the Period End Journal feature is enabled in your NetSuite account, you can include period end journals in the opening balance calculations and general ledger entries of the Norway Standard Audit File for Tax (SAF-T). To do this, you need to enable the Income Statement Closing Entries preference for the Norway nexus on the Country Tax Report Preferences page. This preference is available on the Tax Audit Files Data Filters subtab of the Norway nexus. If you leave the Income Statement Closing Entries box cleared, the dynamic close is used instead. Opening balances of Profit and Loss accounts at the beginning of every accounting year are moved to the Retained earnings account. Note: The dynamic close is not supported if the Multi-book Accounting feature is enabled in your NetSuite account.

Display Employees as Suppliers

Usually, the SAF-T report sources the SupplierID tag from the vendor record. However, some transaction

types applied to A/P accounts and linked to an employee (like expense reports or journal entries) are being sourced from the employee record instead. In the latest version of the Norway Tax Reports

SuiteApp, you now have the option to display such employee data in the SAF-T report. To do this, click the

Setup Norway SAF-T button on the Country Tax Reports page, and in the Allow displaying employees as suppliers dropdown list, select Yes.

Minor Enhancements to Norway Tax Reports

The latest version also contains the following minor enhancements for the Norway Tax Reports SuiteApp:

• SupplierID and CustomerID tags are only populated and exported on account payable and account receivable type accounts.
• Non-posting and statistical account type accounts are no longer exported and used in the audit file.
• Tax groups containing one tax code are supported. If you assign a tax group (instead of a tax code) that contains a single tax code to a transaction, this one code is shown in the report. However, if you use a group with multiple tax codes, the value in the audit file is NA (not applicable).
• For accounts with no mapping, the StandardAccountID tag (under General Ledger Accounts) is populated with NA (not applicable).
• Sourcing for the description tags AccountDescription (under General Ledger Accounts) and

TaxCodeDetails > Description (under Tax Table) has been adjusted. Descriptions from the customer

accounts and tax codes in NetSuite are now used, instead of the standard (tax authority) descriptions.

• The Master Files section of the report now includes the tax codes based on their validity dates. For more information, see the help topic Norway Tax Reports SuiteApp. Philippines Localization Support for BIR Simplified System

Registration for CAS Users

Starting 2021, the Bureau Internal Revenue (BIR) will issue an Acknowledgement Certificate to companies or businesses that registered and submitted complete documentary requirements for using Computerized Accounting Systems (CAS). This change is supported by the invoicing features of the Philippines Localization SuiteApp. In version 2.0.0, you can select the CAS document issued to your company by the BIR in the new Philippines

Change

Localization Setup page. The CAS document selected will be indicated in the footer details of your

transactions that use Philippines invoicing templates. In the BIR Document Issued field, you can select PTU for Permit To Use or AC for Acknowledgement Certificate. You can also enter details such as the AC control or PTU number, date issued, and valid until date for the CAS document that you selected. For more information, see the help topics Philippines Localization Setup and Simplified System Registration for Computerized Accounting System (CAS) Users. Manufacturing SuiteApps Following are the 2021.2 manufacturing enhancements to SuiteApps:

Serial Numbers Reporting in Manufacturing Mobile

Manufacturing Mobile SuiteApp enables you to use the mobile scanner interface to report serial numbers

for assembly items produced and components consumed. Serial numbers can be lengthy and prone to errors when entered manually, so using a scanner helps to reduce the probability of errors. Checks and balances have been incorporated into the scanner flow to identify duplicate scanned serial numbers. Non-Profit SuiteApps Following are the 2021.2 non-profit enhancements to SuiteApps:

NFP SuiteApps Update Verification Now Available

The NFP SuiteApps Update Verification SuiteApp version 1.0.0 helps you verify and update customizations after an NFP SuiteApp update. This SuiteApp provides a list of verifications that you must comply with to update to the latest version of an NFP SuiteApp. When an update is blocked, the SuiteApp sends an email notification to the account administrator. For more information, read NFP SuiteApps Update Verification. Order Management SuiteApps

Following are the 2021.2 order management enhancements to SuiteApps:

• Electronic Bank Payments Enhancements
• Subscription Billing Bulk Change Orders
• Pack Station Enhancements Electronic Bank Payments Enhancements Change

Payment File Administration Rollback for In-Transit Payments

In Electronic Bank Payments SuiteApp version 2021.2, Payment File Administration (PFA) for in-transit payments can now be rolled back using the new Roll Back button on the Payment File Administration page. Company Bank and Entity Bank Details Processed Using

SuiteScript 2.0

In Electronic Bank Payments SuiteApp version 2021.2, company bank and entity bank details are processed using SuiteScript 2.0. To avoid changes to the existing behavior of the SuiteApp, any customizations performed using SuiteScript 1.0 must be repeated using SuiteScript 2.0. Refer to the following table for the changes to the script names: SuiteScript 1.0 SuiteScript 2.0 customscript_2663_entity_ue customscript_14552_entity_ue customscript_2663_entity_details_cs customscript_14552_entity_details_cs customscript_2663_bank_details_cs customscript_14552_bank_details_cs customscript_2663_field_validator_cs customscript_14552_field_validator_cs

Aggregate By Payee Preference Update

In Electronic Bank Payments SuiteApp version 2021.2, you can clear the Aggregate By Payee box on the Electronic Payments Preference page to turn off the aggregate by payee settings.

Subscription Billing Bulk Change Orders

Note: SuiteBilling Enhancements version 21.2 is available on accounts running on NetSuite 2021.2. In SuiteBilling Enhancements version 21.2, you can process subscription change orders in bulk. A new Bulk Process Change Order page is available through Transactions > Subscriptions > Process Bulk

Change Orders. On this page, you can do the following:

• Process Multiple Records for a Bulk Change Order – Search for and select multiple subscriptions or subscription lines to include in a bulk change order. For each bulk change order processed, the system generates an audit trail record that you can access through the Bulk Operations Summary page.
• Customize Search Filters and Sublist Columns – Use predefined filters to search for records or customize the filters that you want to be available for searching. Available predefined filters include customer, billing account, subscription plan, start date, and end date. You can also customize the columns that you want to show in search results.
• Specify the Status Change and Change Order Details – Apply any of the following status changes to subscriptions or subscription lines:
  • Draft to Pending Activation
  • Draft to Active

Change

• Pending Activation to Draft
• Pending Activation to Active
• Active to Suspend
• Suspend to Reactivate

For status changes related to activation, suspend, or reactivate change orders, you must specify

the details of the change order such as effective date, requester, modification type, and memo. For activation, you can request an off-cycle invoice for advanced charges. using mass update:

• Void Records for Usage – Previously, a Delete Records mass update action was available for deleting erroneous or obsolete usage records. Starting version 21.2, the Delete Records action is changed to Void Records, and the processed records are now voided instead of deleted.
• Void Records for Change Order – Subscription change order records have always been voided instead of deleted when using the Delete Records mass update action. Starting version 21.2, the Delete Records action is renamed to Void Records to accurately reflect what goes on in the system. Note: Audit trails showing Delete Records actions for usage and change order records prior to version 21.2 remain unchanged. For more information, see the help topic Subscription Billing Bulk Operations.

Pack Station Enhancements

Note: Use of the Pack Station SuiteApp requires that you first install the SCM Mobile SuiteApp. The Pack Station mobile app extends order fulfillment processing in your warehouse or in any location that uses a kiosk device. It supports multilevel packing that lets you pack items into cartons, and then transfer packed cartons onto pallets. The Pack Station mobile app is available in the Pack Station SuiteApp, which is shared with accounts that use NetSuite WMS. For non-WMS accounts, ask your NetSuite account manager about licensing requirements. In NetSuite 2021.2, you can reuse pallets in another packing session, until you ship them. Orders on the same pallet must have the same shipping method and carrier. On the new Packing Details page, you can view the packed carton and pallet details. If you use the Warehouse Management feature, you can switch to the NetSuite WMS mobile app to ship your packed pallets. If you configure your DUNS number for the UCC company prefix, you can now generate GS1 linear bar codes for serial shipping container codes (SSCC-18). You can print them in carton and pallet lists.

Pack Station provides new system rules, as follows:

• Allow real-time packing updates to fulfillments – Lets you update fulfillment records and custom fields on order transactions in real time. You can specify a limit, from 1 to 75 fulfillment lines, to replace the default limit of 25 lines. When you submit orders for packing, real-time updates apply to fulfillments that do not exceed the limit.
• Autogenerate carton and pallet IDs – Enables you to autogenerate carton and pallet IDs based on a format that you define or the order number. On a kiosk device, you can view the autogenerated ID of a new carton or pallet. This rule does not apply to items that ship individually or ship as is, which have autogenerated IDs by default. Change Projects SuiteApps Following are the 2021.2 projects enhancements to SuiteApps:

Purchase to Project Now Available

Purchase to Project version 1.00.0 is now available for installation from the SuiteApp Marketplace as

a public and managed SuiteApp. This SuiteApp lets project managers create and manage purchase transactions related to projects and project tasks. It provides a unified project purchasing experience with insight into project purchases and single-click creation of purchase orders from the project or project task.

Project managers can perform the following tasks using this SuiteApp:

• View purchase orders and vendor bills entered for a project or project task.
• Initiate purchase orders from a project or project task.
• Allow or prevent creation of purchase orders and vendor bills for a project or project task.
• Designate approved project vendors for project-related purchase orders.
• View the total invoiced amount from billable items and expenses for a project. For more information, see the help topic Purchase to Project SuiteApp. SuiteAnalytics SuiteApps Following are the 2021.2 SuiteAnalytics enhancements to SuiteApps:

Dashboard Tiles Enhancements

With Dashboard Tiles SuiteApp version 1.06.3, you can now do the following for individual dashboard tiles:

• Specify a font size for the tile KPI and label.
• Specify a wrapping for the tile KPI text.
• Remove the tile KPI and label.

These changes let you manage the dashboard tile texts, so they fit into the tile. Previously, you can

customize the font size, KPI, and label settings for all tiles on the dashboard only from the dashboard tiles portlet. The following preferences are now available for each dashboard tile:

• KPI Font Size (PT) – Enter a font size for the tile KPI from 0 to 18 points. If you leave this field blank, the default KPI font size is 13. If you enter 0, the tile KPI is removed.
• Label Font Size (PT) – Enter a font size for the tile label from 0 to 16 points. If you leave this field blank, the default label font size is 10. If you enter 0, the tile label is removed.
• KPI Wrapping – Select a wrapping option for the tile KPI text. The following options are available:
  • None – No wrapping is applied.
  • Word Wrap – This option wraps overflowing text into a new line without breaking words.
  • Word Break –This option maximizes the tile width and may result in breaking of words.

These preferences are available on the Appearance subtab of the Dashboard Tile page. Note that the

dashboard tile settings take precedence over the dashboard tiles portlet settings.

Change

For more information, see the help topic Modifying the Appearance of a Dashboard Tile. SuitePeople SuiteApps Following are the 2021.2 SuitePeople enhancements to SuiteApps:

Calendar Event Creation

Time-Off Tracking SuiteApp version 1.10.1 now supports automatic creation of time-off calendar events. The time-off requester and the requester’s supervisor can now see approved time-offs in the NetSuite calendar. Taxation SuiteApps

Following are the 2021.2 taxation enhancements to SuiteApps:

• SuiteTax SuiteApps
  • SuiteQL Support and Country Tax Reports Page Enhancements in Tax Reporting Framework
• Legacy Tax SuiteApps
  • International Tax Reports Enhancements ▬ Ireland Postponed Accounting for VAT on Imported Goods ▬ EU VAT One Stop Shop Tax Code Provisioning
  • International Tax Reports Issue Fixes ▬ International Tax Reports 3.120.0 Issue Fixes
  • Tax Audit Files Enhancements ▬ Enhancements to Period End Journal Entries for France FEC ▬ Period End Journals Support
  • Tax Audit Files Issue Fixes ▬ Tax Audit Files 1.83 Issue Fixes

SuiteTax SuiteApps

Important: The SuiteTax enhancements in this section are applicable only to NetSuite production and Sandbox accounts where the SuiteTax feature is enabled. For NetSuite accounts without SuiteTax, see Legacy Tax SuiteApps. SuiteQL Support and Country Tax Reports Page Enhancements in Tax

Reporting Framework

tax information and in generating tax audit file reports. SuiteQL is a query language that provides enhanced capabilities in accessing NetSuite records and data. For more information on SuiteQL, see the help topic SuiteQL.

• Country Tax Reports page enhancements - On the Report Generation Log subtab of the Country Tax Reports generation page, the columns are rearranged for quick access to

Change

the View and Download links for the created reports. For more information, see the help topics Viewing a Generated Country Tax Report and Exporting a Country Tax Report

Legacy Tax SuiteApps

Important: The legacy tax enhancements in this section are applicable only to NetSuite accounts without the SuiteTax feature. For NetSuite accounts with SuiteTax, see SuiteTax SuiteApps. International Tax Reports Enhancements

Ireland Postponed Accounting for VAT on Imported Goods

International Tax Reports version 3.120.0 includes support for postponed accounting for VAT on imported

goods from Great Britain and countries outside the European Union. The update includes automatic provisioning of the following import tax codes to newly created Ireland subsidiaries or nexuses: Tax Code Description Tax Properties IPA1-IE Postponed import VAT on goods purchased from Great ■ Rate of 0%

Britain and non-EU countries

• Effective from January 1, 2021
• Reverse Charge Code
• Notional Rate Derived from S-IE (23%)
• Import
• Available on Purchase transactions IPA2-IE Postponed import VAT on goods purchased from Great ■ Rate of 0%

Britain and non-EU countries

• Effective from January 1, 2021
• Reverse Charge Code
• Notional Rate Derived from R-IE (13.5%)
• Reduced Rate
• Import
• Available on Purchase transactions IPA3-IE Postponed import VAT on goods purchased from Great ■ Rate of 0%

Britain and non-EU countries

• Effective from January 1, 2021
• Reverse Charge Code
• Notional Rate Derived from SR-IE (9%)
• Special Reduced Rate
• Import
• Available on Purchase transactions IPA4-IE Postponed import VAT on goods purchased from Great ■ Rate of 0%

Britain and non-EU countries

• Effective from January 1, 2021
• Reverse Charge Code

Change

Tax Code Description Tax Properties

• Notional Rate Derived from S-IE (0%)
• Import
• Available on Purchase transactions International Tax Reports version 3.120.0 also includes automatic provisioning of the following tax codes to newly created Ireland subsidiaries or nexuses:

Tax Codes Description Tax Properties

EE-IE Exempt tax code for intra-community transactions ■ Rate of 0%

• Effective from January 1, 2021
• EC Code
• Exempt
• Notional Rate Derived from E-IE (0%)
• Available on both Sale and Purchase transactions EZ-IE Zero rated sales tax code for intra-community ■ Rate of 0% transactions
• Effective from January 1, 2021
• EC Code
• Notional Rate Derived from Z-IE (0%)
• Available on both Sale and Purchase transactions

LR-IE Livestock rate ■ Rate of 4.8%

• Effective from January 1, 2021
• Available on both Sale and Purchase transactions

FR-IE Flat-rate compensation percentage for farmers ■ Rate of 5.6%

• Effective from January 1, 2021
• Available on both Sale and Purchase transactions

ELR-IE Livestock rate for intra-community transactions ■ Rate of 0%

• Effective from January 1, 2021
• EC Code
• Notional Rate Derived from LR-IE (4.8%)
• Available on both Sale and Purchase transactions EFR-IE Flat-rate compensation percentage for farmers (intra- ■ Rate of 0% community)
• Effective from January 1, 2021
• EC Code
• Notional Rate Derived from FR-IE (5.6%)
• Available on both Sale and Purchase transactions The Ireland VAT report is also updated to version 2021 to properly report the import and other tax codes in the following boxes accordingly:

Change

• Box T1: VAT on Sales
• Box T2: VAT on Purchases
• Box E1: Value of Goods Sent to other EU Countries
• Box E2: Value of Goods Received from other EU Countries
• (New) Box PA: Postponed Accounting To learn more about Ireland’s new tax codes and VAT form update, see the help topics Ireland Tax Codes and What goes into each box – Ireland VAT 3 report.

EU VAT One Stop Shop Tax Code Provisioning

Effective July 1, 2021, EU Mini One Stop Shop (MOSS) will be extended to become One Stop Shop (OSS), covering a wider range of supplies. International Tax Reports version 3.120.0 is enhanced to support tax codes provisioning for OSS. When you enable OSS and select an OSS nexus on subsidiary record, the

SuiteApp automatically creates an OSS tax control account and tax type and provisions OSS tax codes. To

learn more about OSS tax code provisioning and OSS tax code details, read the help topics EU One Stop Shop Tax Code Provisioning and OSS Tax Code Provisioning for Regular NetSuite Accounts. International Tax Reports Issue Fixes

International Tax Reports 3.120.0 Issue Fixes

• Chile VAT report – Boxes 77 and 89 are updated with the correct formula as follows:
  • Box 77 = Box 537 - Box 538 (if Box 537 is greater than or equal to Box 538) or empty (if Box 537 is less than Box 538)
  • Box 89 = Box 538 - Box 537 (if Box 537 is less than Box 538) or empty (if Box 537 is greater than or equal to Box 538) For complete information about these changes, see the help topic What goes into each box - Chile VAT Report.
• Denmark VAT report – The boxes are updated to correctly report the following tax codes:
  • RC-DK is now reported on boxes 1 and 4
  • Z-DK no longer shows on the detailed report of box 4
  • IV-DK’s tax property is corrected to report Import VAT For more information about Denmark’s tax codes and VAT report, see the help topics Denmark Tax Codes and What goes into each box – Denmark VAT Report.
• EU Intrastat Report – The report is updated to support local language. You can now generate the EU

Intrastat Report when you set your local language as preference on Home > Set Preferences. To learn

more about generating the EU Intrastat Report, see the help topic Generating an EU Intrastat Report.

• Finland VAT Report – The report is updated to support the reporting of imported goods from countries outside of the European Union. Tax codes RCF-FI, RCF1-FI, and RCF2-FI are no longer reported on boxes 14 to 16. For more information about the new tax codes used in reporting imported goods, see the help topic Finland Tax Codes. To learn about the boxes where each tax codes are reported, read the help topic What goes into each box – Finland VAT Report.
• Germany Tax Filing Setup and Monthly VAT Return XML File
  • Users who were experiencing issues with saving their VAT registration number (VRN) on the Tax Filing Setup page can now save their VRNs when they setup and generate a tax report displaying

Change

the VRN. For more information about tax filing setup in Germany, see the help topic Setting Up Tax Filing for Germany.

• Germany Monthly/Quarterly VAT XML is updated for report compatibility on the FormularDepotXI e-filing tool. To learn about using FormularDepotXI in submitting Germany monthly VAT return, see the help topic Using FormularDepotXI to Submit German Tax Returns.
• Journal Entry – The record is updated to exclude NOTC checks from the Script Execution Logs.
• Norway VAT Report – The report is updated to support reporting of purchase non-deductible tax amounts. The non-deductible tax amounts of tax codes S-NO, R1-NO, and R2-NO are now reported on the following boxes, accordingly:
  • Box 14: Non-deductible tax amounts of purchases S-NO
  • Box 15: Non-deductible tax amounts of purchases R1-NO
  • Box 16: Non-deductible tax amounts of purchases R2-NO For more information about the values reported on each boxes of the Norway VAT report, see the help topic What goes into each box – Norway VAT Report.
• United Arab Emirates VAT Report – The adjustment boxes of 1a to 1g are updated to accept only negative amount. For more information about the adjustment boxes of the UAE VAT return, see the help topic Making Adjustments on a VAT Return for UAE.
• United Kingdom MTD Fraud Prevention Headers – The following additional headers are now supported as part of UK MTD requirements:
  • Gov-Client-Public-IP-Timestamp
  • Gov-Client-Local-IPs-Timestamp
  • Gov-Vendor-Product-Name
  • Gov-Client-User-IDs that includes the user ID in the HTTP header information To learn more about MTD fraud prevention headers, see the help topic Sending of MTD Anti-Fraud Headers.
• U.K. Intrastat Arrivals – The report is updated to exclude reporting of domestic and U.S. purchases on the report. For more information about the Intrastat Report for United Kingdom, see the help topic United Kingdom Intrastat Report for Dispatches and Arrivals. Tax Audit Files Enhancements

Enhancements to Period End Journal Entries for France FEC

In Tax Audit Files version 1.83, the Balance Sheet Closing Entries box is dimmed for France FEC on the Report Preferences page. This type of period end journal is not used in the France FEC report. For more information, see the help topic Setting Tax Audit File Report Preferences.

Period End Journals Support

Tax Audit Files version 1.80.0 supports the use of period end journal entries in generating France FEC and Mexico Auxiliary Report of Accounts. You can set the following preferences on the Report Preferences page to specify the type of period end journals that will be included in the reports:

Change

• Balance Sheet Closing Entries
• Balance Sheet Opening Entries
• Income Statement Closing Entries For more information, see the help topic Setting Tax Audit File Report Preferences. Tax Audit Files Issue Fixes Tax Audit Files 1.83 Issue Fixes Amending Transactions.
• The Customer ID for Revenue Recognition Journal is now showing when you generate a Portugal SAF- T report.
• Period End Journal balance sheet opening entries are now showing correctly in the Tax Audit File for France FEC.
• The EcritureNum column of France FEC shows the GL number of the balance sheet period end journal entries.