Skip to main content

SuiteAnalytics Updates in NetSuite 2021.1

2021.1 SuiteAnalytics |

This release note was updated May 12, 2021. Calculated Measures Now Available in SuiteAnalytics

Workbook

You can now enhance your pivot tables and charts by creating calculated measures. Calculated measures are custom measures that you define by creating a calculation from existing measures and basic operators. The following example shows how to calculate the profit percentage: % Profit = Est. Gross Profit (Sum) / Amount (Sum) You can create as many calculated measures as you need with the fields available in the connected dataset. You can use your calculated measures only in the pivot table and chart where you created them. For more information about creating calculated measures, see the help topic Calculated Measures. Conditional Formatting Now Available in SuiteAnalytics

Workbook

You can now apply conditional formatting to your workbook table view and pivot table results. Conditional formatting highlights results based on rules that you define, so that you can quickly analyze your company data. Depending on the conditions you set up, you can apply conditional formatting to groups of results or individual results. You can define conditional formatting using any fields containing NUMBER or STRING values, including custom formula fields and calculated measures. For more information, see the help topic Conditional Formatting

NetSuite IP Addresses and SuiteAnalytics Connect

The IP addresses of SuiteAnalytics Connect servers are changing. Therefore, you should not use IP addresses in your firewall configurations to access the Connect Service. If you use IP addresses in your configurations, you will be unable to access the Connect Service after the IP addresses change. The use of NetSuite IP addresses to manage access to any NetSuite services is not supported. Make sure that you do not rely on methods that require explicit reference to any NetSuite IP address. To manage access to the Connect Service, you can use the domain name in your configurations instead of the IP address. The domain name does not change, even if the account is moved to a different data center. Over the next several releases, the IP addresses of SuiteAnalytics Connect servers may change frequently, at any time, and without notice. To avoid issues each time the IP addresses change, you should make sure that you are not using IP addresses in your configurations. For more information about NetSuite IP addresses and firewall configurations for SuiteAnalytics Connect, see the help topics NetSuite IP Addresses and Third-Party Application Access.

Removal of Some Connect Tables and Columns

Removal of some tables and columns from the Connect schema is targeted for upcoming releases, starting in 2021.1. This gradual process is designed to allow you time to make any needed adjustments to your queries. Note: This removal applies only to the schema available through NetSuite.com. The following tables and columns are affected by the upcoming removal process:

Targeted Release Table or Column To Be Removed Alternative Table or Column

2021.1 Table name: notes_system Table name: system_notes 2021.1 Table name: notes_system_custom Table name: system_notes_custom 2021.2 Column name: date_last_modified Column name: date_last_modified_gmt

Targeted Release Table or Column To Be Removed Alternative Table or Column

Available in transaction_lines table Available in transaction_lines table

The removal process is scheduled as follows:

  • As of 2021.1, the notes_system and notes_system_custom tables are permanently removed. Since 2017, the Connect Browser has included a warning that these tables should not be used. Any queries that still include these tables will fail as of 2021.1. You can use the system_notes and system_notes_custom tables instead. See the Connect Browser for descriptions of the columns available for each table, then make adjustments to your existing queries as needed.
  • As of 2021.2, the date_last_modified column will be permanently removed from the transaction_lines table. The Connect Browser has included a description that this column may return inaccurate values and that you should use the date_last_modified_gmt column instead. Note that 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.

These changes are effective when your account is upgraded to the corresponding release. However, the

Connect Browser is not upgraded at the same time, so it will not show these changes at the time of your

account upgrade. These changes are visible in the Connect Browser when it is released at a later date. You should check your existing queries and make any adjustments before these tables and this column are permanently removed. Note: Before you modify your queries, you should refer to the Connect Browser to check the descriptions of available tables and columns. For more information about the tables available in the Connect Schema, see the help topic Connect Schema. Changes to Phone Number Length in SuiteAnalytics

Connect Columns

SuiteAnalytics Connect changes the maximum length attribute for values that return phone numbers in some columns. The length changes to 100 characters. Note: This update applies to the NetSuite.com data source only. If you work with the NetSuite.com data source and you are using the column attributes in your configuration, review them and make adjustments as needed. To avoid error or discrepancies, your configuration must match the column values listed in the Connect Browser. The length of the following columns changes to 100 characters:

Column Name Previous Length Updated Length

Column Name Previous Length Updated Length

This change is effective as of 2021.1, but the current version of the Connect Browser does not show the updated values yet. This change is visible in the 2021.1 Connect Browser when it is released at a later date. For information about the column attributes, see the help topic Table Summary. Removal of Password Custom Fields from SuiteAnalytics

Connect

As of 2021.1, password custom fields have been removed from the Connect Schema. Password custom fields are fields that are created using the Password field type. For more information about custom field types, see Table of Custom Field Type Descriptions. Note: This change applies to the schema available through the NetSuite.com data source. The removal of password custom fields from the Connect Schema is effective as of 2021.1. If you are using these fields in queries that were created before 2021.1, remove them from your existing queries and make any adjustments as needed. For more information about the tables and columns available in the Connect Schema, see the help topic Connect Schema. Translation Collections for User-Defined Text Supported in

Workbook

Strings and collections for translation are now automatically created when you create and save a dataset

or workbook visualization, such as a dataset description or pivot name. You can manage your translation strings and collections on the Manage Translations page. For a list of customizable objects added in the 2021.1 release, see Minor Updates to Custom Objects. For more information about Translation Collections, see the help topic Introduction to Manage Translations. 2021.1 Connect Browser The 2021.1 version of the Connect Browser is now available. The following table has been exposed: Assembly Bill of Materials. You can find the links to all Connect tables in the Connect Schema topic. Note: The notes_system and notes_system_custom tables have been removed as part of the removal process that started in 2021.1. For more information, see Removal of Password Custom Fields from SuiteAnalytics Connect. For more information about how to work with the Connect Browser, see the help topic Working with the Connect Browser.

Supported Cipher Suites for SuiteAnalytics Connect

As a best practice, you should remove any cipher suites specified in your connection URL. If your connection URL does not include a cipher suite, the JDBC server automatically selects the appropriate cipher suite for authentication. As of February 2021, the list of supported cipher suites for access to NetSuite has changed. For more information, see Unsupported Cipher Suite for SuiteAnalytics Connect. Deletion Tracking Support for Records That Use the New

Analytics Data Source

For some records, when the record is deleted, NetSuite retains some general data about it. This data

includes the record name and type, when the record was deleted, and the name of the user who deleted the record. Deletion tracking now supports records that use the new analytics data source that was designed for SuiteAnalytics Workbook. For more information, see Deletion Tracking Support for Records That Use the New Analytics Data Source. CSV Import Newly Supported Record Types for CSV Import Record Type Newly Exposed Notes or Updated Bonus Import Newly Exposed You can now import bonus-related data into NetSuite using the CSV Import assistant. This way you can update bonus information for a large number of employees in one action. To import bonus-related data with the CSV Import Assistant you must enable the Compensation Tracking feature and you must have the Import CSV File permission.

Planning Item Newly Exposed Planning Item Categories help you organize and display items in a hierarchy. Due

Category to the volume of data involved in supply planning, this hierarchy helps you to

Import aggregate and inspect items. To learn more, see the help topic Supply Planning Prerequisites.

Planning Item Newly Exposed A Planning Item Group provides a reusable (across different plans) method for

Group Import specifying a set of items to be planned together. This enables planners to specify which items are in a plan at the item category or item level. To learn more, see the help topic Supply Planning Process.

Planning Rule Newly Exposed Planning Rule Groups enable planners to create rules that govern the supply

Group Import planning process to define how items and item categories are replenished. These rules only apply to transfer orders. For example, you can define where to source supply for an item when it is required at a specified location. To learn more, see the help topic Supply Planning Process. Record Type Newly Exposed Notes or Updated

Supply Plan Newly Exposed Supply Plan Definition enables planners to establish the criteria to be used for

Definition supply planning. The plan definition provides the information that drives the

Import supply planning process, such as planning horizon and planning scope. For

example: you can run supply planning at multiple facilities at one time. A supply plan definition provides a permanent holding place for your planning criteria and planning results. To learn more, see the help topic Creating a Supply Planning Definition and Schedule.

Referencing Custom List Entries by Script ID

You can use Script ID as a reference type to map a column of the imported CSV file to a NetSuite field that can have one or more custom list or custom record values. For example, you create a custom list and each value has a script ID. Later, you add to a Sales Order a custom field of the type List/Record, referencing the custom list you created. Now you can reference each value by its script ID when you import a Sales Order with the CSV Import Assistant. For more information on reference types, see the help topic Select Reference Types.

SuiteScript

This release note was updated June 9, 2021. Refer to the following sections for details on SuiteScript updates for NetSuite 2021.1:

  • Map/Reduce Scripting – Change to the Character Limits for Keys
  • Upload a SuiteScript 2.1 Client Script to the File Cabinet
  • Secrets Management
  • SuiteScript 2.1 Debugger
  • Changes to the Workbook API (Beta)
  • CurrentRecord.getSubrecord Behavior Change
  • New N/suiteAppInfo Module
  • EmaiI Send Security Update
  • Asynchronous Server-Side Support
  • Support for Copying Files Using the N/file Module
  • Support for Formatting Locales and Indian Number Formatting
  • New Built-in Functions for SuiteQL
  • New Methods to Check Password Fields
  • Advance Notice: Upcoming Removal of MD5 and SHA1 Hash Algorithms
  • Deprecation of RESTlet Authentication Through User Credentials
  • Deletion Tracking Support for Records That Use the New Analytics Data Source
  • New SuiteScript Actions and Macros
  • 2021.1 SuiteScript Record Exposures
  • 2021.1 SuiteScript Records Browser Map/Reduce Scripting – Change to the Character Limits for

Keys

As of June 10, 2021, the character limit for keys in map/reduce scripts (specifically, in mapContext or reduceContext objects) is reduced to 3,000 characters. The previous character limit for keys was 4,000 characters. In addition, error messages are returned when a key is longer than 3,000 characters or a value is larger than 10 MB. Keys longer than 3,000 characters will return the error KEY_LENGTH_IS_OVER_3000_BYTES. Values larger than 10 MB will return the error VALUE_LENGTH_IS_OVER_10_MB. If you have map/reduce scripts that use the mapContext.write(options) or reduceContext.write(options) methods, make sure that key strings are shorter than 3,000 characters and value strings are smaller than 10 MB. Make sure that you consider the potential length of any dynamically generated strings, which may exceed these limits. You should also avoid using keys, instead of values, to pass your data.

Upload a SuiteScript 2.1 Client Script to the File Cabinet

NetSuite 2021.1 adds the ability to upload a SuiteScript 2.1 client script that includes ES6+ syntax to the File Cabinet. However, SuiteScript 2.1 client scripts are not supported in the Scriptable Cart.

For considerations when using SuiteScript 2.1 client scripts, see the help topic Executing Scripts Using

SuiteScript 2.1. For more information on SuiteScript 2.1, see the help topic SuiteScript 2.1. For more

information on the Scriptable Cart, see the help topic SuiteScript for Scriptable Cart.

Secrets Management

SuiteScript 2.x now includes the ability to store, access, and manage API secrets. API secrets include

hashes, passwords, keys, and other secrets for managing digital authentication credentials. You can use

API secrets management to store these values, preventing the need for plaintext secrets in scripts and

allowing secure integration to third-party systems. Secrets up to 4,000 characters are accepted. Secret owners can set criteria to limit access for other users or allow access for a specific SuiteApp. To view and create API secrets, administrators and other users with the appropriate permission can go to Setup > Company > Preferences > API Secrets. To ensure the decrypted secret is never displayed, you can limit the secret to a specific script or locked SuiteApp. Only certain SuiteScript 2.x APIs can reference secrets. A new permission is available to manage role access to the API Secrets page. You can add the Secrets Management permission to a role to enable that role to access the API Secrets page in the UI. For more information, see the help topic Secrets Management.

SuiteScript 2.1 Debugger

The SuiteScript 2.1 Debugger is now available. You can use this debugger to debug SuiteScript 2.1 scripts, and it supports on-demand debugging and debugging of scheduled scripts, Suitelets, and user event scripts. The SuiteScript 2.1 Debugger uses the Chrome DevTools API to let you debug SuiteScript 2.1 scripts using similar functionality available when debugging JavaScript in the Chrome browser. In our effort to offer a modern coding experience to our developers, the SuiteScript 2.1 Debugger uses the Chrome DevTools API. The Chrome DevTools API allows users to debug SuiteScript 2.1 scripts using similar functionality available when debugging JavaScript in the Chrome browser. The SuiteScript 2.1 Debugger is designed for use with NetSuite in the Chrome browser. Other browsers, such as Firefox, Safari, and Microsoft Edge, have limited support.

On-Demand Debugging

To debug code on demand, enter your code in the debugger window, select 2.1 in the Version field, and click Debug. A second browser tab for Chrome DevTools automatically opens. Execution of the script pauses waiting for you to perform actions that trigger your script. You can then debug your script using breakpoints, watches, and other tools available in Chrome DevTools.

Scheduled Scripts and Suitelets

To debug scheduled scripts and Suitelets, select a scheduled script or Suitelet from a list of SuiteScript 2.1 scripts and click Debug. A second browser tab for Chrome DevTools automatically opens, and execution of the script pauses waiting for you to perform actions that trigger your script. You can then debug your script using breakpoints, watches, and other tools available in Chrome DevTools.

User Event Scripts

You can debug user event scripts that include a single entry point or multiple entry points all within the same Chrome session. Your debugging session automatically pauses between entry points, which lets you to restart debugging at the exact desired entry point when you are ready. To debug user event scripts, select a user event script from a list of SuiteScript 2.1 user event scripts and click Debug. A second browser tab for Chrome DevTools opens, and execution of the script pauses waiting for you to perform actions that trigger your script. You can then debug your script using breakpoints, watches, and other tools available in Chrome DevTools. If your user event script includes more than one entry point, such as beforeLoad and beforeSubmit, you can debug the beforeLoad entry point first. After that entry point is complete, the debugger pauses to let you debug the beforeSubmit entry point.

Changes to the Workbook API (Beta)

specify. For more information about conditional formatting, see Conditional Formatting Now Available in SuiteAnalytics Workbook.

  • Translation support — Use localized datasets and workbooks to analyze your data in your preferred language. For more information about translation support, see Translation Collections for User- Defined Text Supported in Workbook.
  • Calculated measures — Use new objects (workbook.DataMeasure and workbook.CalculatedMeasure) to create measures using basic and complex calculations. For more information about calculated measures, see Calculated Measures Now Available in SuiteAnalytics Workbook. For more information, see the help topic Workbook API (Beta).

CurrentRecord.getSubrecord Behavior Change

As of 2021.1, if a script uses the CurrentRecord.getSubrecord(options) to get a subrecord that does not exist, a new subrecord is created and returned. With this change in behavior, it is no longer possible to use this method to check whether a record has an existing subrecord. Use the CurrentRecord.hasSubrecord(options) method to determine if the field contains a subrecord.

New N/suiteAppInfo Module

A new N/suiteAppInfo module is available. The N/suiteAppInfo module includes methods that let you access information about installed bundles and SuiteApps. These methods let you determine if a bundle or SuiteApp is installed, retrieve a list of all installed bundles and SuiteApps, or retrieve a list of bundles and SuiteApps that contain certain scripts. For more information, see the help topic N/suiteAppInfo Module.

EmaiI Send Security Update

NetSuite 2021.1 introduces a new Vicarious Emails permission that lets users send email on behalf of another user. This new permission allows a role to define an author (sender) that is different from the current user. This permission is automatically added to existing roles in your account to prevent disruption to current email sent from known users via SuiteScript. However, this permission is not automatically added to roles that can indirectly execute scripts. If these types of roles indirectly execute a script that sends email on behalf of another user, a warning is logged in the script execution log. When you create a new custom role in your NetSuite account that needs to send email on behalf of another user, you should now include the Vicarious Emails permission. You need to take action to address these warnings before August 1, 2021. As of August 2021, these exceptions will no longer simply log the warning message but will throw an error. To avoid this issue, you must update script deployments that have this warning in the script execution log to run as roles that have the Vicarious Emails permission. Do not use the Current Role selection in the Execute As Role field on script deployments for scripts that have this error or warning. You can identify suspect scripts by reviewing the script execution logs for these Emergency log messages: “Action Required: Email on behalf of other than currently logged in entity was sent by script {the script id}.“ For more information, see the following topics:

  • N/email Module; also available as SuiteAnswers ID 43736, https://netsuite.custhelp.com/app/answers/ detail/a_id/43736
  • Customizing and Creating Roles; also available as SuiteAnswers ID 91073, https:// netsuite.custhelp.com/app/answers/detail/a_id/91073

Asynchronous Server-Side Support

SuiteScript 2.1 now fully supports non-blocking asynchronous server-side promises. Server-side promises

are expressed using the asnyc, await, and promise keywords. This change continues our support for

ECMAScript 2019 (ES2019) language features in SuiteScript. It lets you upload and deploy SuiteScript 2.1

scripts that include the async, await, and promise keywords. For this initial release, the following modules are supported:

  • N/http Module
  • N/https Module
  • N/query Module
  • N/search Module
  • N/transaction Module Note that for this release, a subset of promise methods in each module is supported.

There are a few items to consider when using server-side promises in SuiteScript:

  • This capability is not for bulk processing use cases where an out-of-band solution, such as a work queue, may suffice.
  • This capability is mainly for in-process and distinct operations, such as business functions on a list of transactions when ordering does not matter. For more information about the asynchronous server-side support in SuiteScript 2.1, see the following help topics:

Asynchronous Capability Help Topic

Async and await keywords SuiteScript 2.1 Language Examples Promise methods in the N/http Module. http.delete.promise(options) http.get.promise(options) http.post.promise(options) http.put.promise(options) http.request.promise(options) Promise methods in the N/https Module. https.delete.promise(options) https.get.promise(options) https.post.promise(options), https.put.promise(options) https.put.promise(options) Promise methods in the N/query Module. query.load.promise(options) Query.run.promise() Query.runPaged.promise() Promise methods in the N/search Module. search.create.promise(options) search.delete.promise(options) search.duplicates.promise(options) search.global.promise(options) search.load.promise(options) search.lookupFields.promise(options) Search.runPaged.promise(options) Asynchronous Capability Help Topic

Search.save.promise()

Promise method in the N/transaction Module. transaction.void.promise(options)

For more information on asynchronous JavaScript programming, see https://developer.mozilla.org/en-US/ docs/Learn/JavaScript/Asynchronous.

Support for Copying Files Using the N/file Module

You can now use the N/file module to copy files in the File Cabinet. A new method, file.copy(options), is available and lets you copy an existing file in the File Cabinet. This method returns a file.File object, which you can use to work with the copied file in your scripts. When you use this method to copy a file, the copied file has the same permissions and other attributes as the original file. For example, if the original file is available without login, the copied file is also available without login. The file.copy(options) method supports conflict resolution when copying a file. If a file with the same name already exists in the location to which you are copying a file, a conflict occurs. You can use the new file.NameConflictResolution enum to determine how conflicts are handled. You can specify that the copy operation should fail without copying the file, overwrite the existing file, or rename the copied file to use a unique name. For more information, see the help topic N/file Module. Support for Formatting Locales and Indian Number

Formatting

You can now specify the locale when you use certain methods in the N/format/i18n module. The format.getCurrencyFormatter(options) and format.getNumberFormatter(options) methods now accept a locale parameter that you can use to specify the locale for which to get the currency format or number format. To specify a locale, you can provide a partial or full locale string. A full locale string represents a complete locale, such as en_US (American English) and fr_FR (French). A partial locale string represents some information about a locale but is not complete, such as en_aa (English but not associated with a particular region). If you provide a partial locale string, some locale properties are inferred automatically based on the string, and other locale properties are set using default values. For more information and examples, see the help topics CurrencyFormatter.locale and NumberFormatter.locale. For a list of common locales, see the help topic translation.Locale. The N/format/i18n module also now supports Indian number formatting. This format uses a different comma separation pattern than other formats. For example, consider the number 123,500. When using Indian number formatting, this number is formatted as 1,23,500. For more information, see the help topic N/format/i18n Module.

New Built-in Functions for SuiteQL

New built-in functions are available for you to use in SuiteQL queries. These new functions use the

BUILTIN_RESULT prefix and let you specify the result type of a SuiteQL expression. For example, you can

use the BUILTIN_RESULT.TYPE_DATE() function to specify that the expression result is a date. For a full list of built-in functions, see the help topic Using SuiteQL with the N/query Module in SuiteScript.

New Methods to Check Password Fields

A new method for checking a user-entered password is available in this release for both SuiteScript 1.0 and SuiteScript 2.x. With this new method, you can check whether a password in a record corresponds to the password entered by the user. The new SuiteScript 1.0 method is nlapiCheckPassword(type, id, value, field, sublist, line). The new SuiteScript 2.x method is crypto.checkPasswordField(options), included in the N/crypto module. For more information, see the help topics nlapiCheckPasswordField(type, id, value, field, sublist, line) and crypto.checkPasswordField(options). In NetSuite 2021.2, the usage of the SuiteScript 1.0 nlapiEncrypt(s, algorithm, key) function to check custom password field values will no longer be supported and usage of the SuiteScript 2.x record.getValue(options) or currentRecord.getValue(options) methods to check custom password field values will no longer be recommended. Instead, scripts should be updated to use the new SuiteScript 1.0 function or the new SuiteScript 2.x method to check custom password field values. For more information on this change, see Upcoming Changes to Supported APIs for Checking Custom Password Fields.

Ability to Lock and Unlock Certificates and Keys

Certificates and Keys can now be locked and unlocked using SuiteScript 2.x. Locked certificates

and keys cannot be edited. Lock and unlock certificates with certificateControl.lock(options) and certificateControl.unlock(options). Lock and unlock keys with keyControl.lock(options) and keyControl.unlock(options). You can see if a certificate is locked using the UI at Setup > Company > Certificates. You can see if a key is locked at Setup > Company > Keys. Advance Notice: Upcoming Removal of MD5 and SHA1

Hash Algorithms

Support for the MD5 and SHA1 hash algorithms in SuiteScript 1.0 and SuiteScript 2.x will be completely

removed as of NetSuite 2021.2. This change will affect the following SuiteScript 1.0 and SuiteScript 2.0 APIs: API API Impacts nlobjCredentialBuilder The md5() and sha1() functions will be removed. The hmac(context, credential, algorithm) function will work only if the last parameter is sha256 or sha512: for example, nlobjCredentialBuilder(data, domain).hmac(nlapiGetContext(), ‘my secret key’, ‘sha256’)). certificate.HashAlg The SHA1 value for certificate.HashAlg will be removed. This change will affect the options.algorithm parameter of the certificate.createSigner(options), certificate.createVerifier(options), and certificate.signXml(options) methods. crypto.HashAlg The MD5 and SHA1 values for crypto.HashAlg will be removed. This change will affect the options.algorithm parameter of the crypto.createCipher(options), crypto.createDecipher(options), crypto.createHash(options), and crypto.createHmac(options) methods.

API API Impacts

https.HashAlg The MD5 and SHA1 values for https.HashAlg will be removed. This change will affect the options.algorithm parameter of the SecureString.hash(options) and SecureString.hmac(options) methods. Scripts that use MD5 or SHA1 as the hash algorithm must be updated to use a different hash algorithm, such as SHA256 or SHA512, to ensure these scripts continue to work as expected after the upgrade to 2021.2. If you have additional questions or require assistance, please contact NetSuite Customer Support. Deprecation of RESTlet Authentication Through User

Credentials

User credentials authentication for newly created RESTlets is no longer supported. Any RESTlets created

after January 1, 2021 with user credentials authentication will stop working after the account is upgraded to 2021.1. This change is effective as of January 1, 2021, but it goes into effect when your account is upgraded to 2021.1. If you attempt to use user credentials to authenticate a new RESTlet after your account is upgraded, an HTTP error response is returned. This change does not affect RESTlets created before January 1, 2021, except for RESTlets included in bundles or SuiteApps that are installed into target accounts on or after January 1, 2021. You must ensure that RESTlet integrations created on or after January 1, 2021 use an alternative authentication method, such as token-based authentication (TBA) or OAuth 2.0. You also must ensure that RESTlets included in bundles or SuiteApps use TBA or OAuth 2.0 for authentication. This change applies to all RESTlets included in bundles or SuiteApps, not only to RESTlets created on or after January 1, 2021. Installing bundles or SuiteApps changes the creation date of script records. For this reason, you must ensure that all RESTlets in a bundle or SuiteApp are updated to use TBA or OAuth 2.0. For information about setting up TBA for RESTlets, see the help topic Setting up Token-based Authentication for a RESTlet integration. For information about using OAuth 2.0 for RESTlets, see the help topic Using OAuth 2.0 for RESTlet Authentication. Deletion Tracking Support for Records That Use the New

Analytics Data Source

For some records, when the record is deleted, NetSuite retains some general data about it. This data

includes the record name and type, when the record was deleted, and the name of the user who deleted the record. Deletion tracking now supports records that use the new analytics data source that was designed for SuiteAnalytics Workbook. For more information, see Deletion Tracking Support for Records That Use the New Analytics Data Source.

New SuiteScript Actions and Macros

The following SuiteScript actions are newly supported as of NetSuite 2021.1:

Record Type Action ID UI Button Label Notes

Time retract Retract Retracts pending timebill with the specified ID. Weekly Timesheet retract Retract Retracts pending timebills on the timesheet with the specified ID. The following SuiteScript macros are newly supported as of NetSuite 2021.1:

Record Type Macro ID UI Button Label Notes

Charge clearBudgetAmounts Clear Values Sets amounts to empty value for all selected lines. Charge distributeBudgetTotalAmount Distribute Total Splits a total amount into all calendar months for all selected lines. Charge selectAllBudgetLines Mark All Checks all enabled check boxes in the Select column. Charge setBudgetAmountsToCalculated Set to Calculated Replaces amounts with calculated values for all selected lines. Charge unselectAllBudgetLines Unmark All Unchecks all enabled check boxes in the Select column. 2021.1 SuiteScript Record Exposures Record Type Newly Exposed or Notes

Updated

Sales Channel Newly Exposed The sales channel record is available when the Sales Channel Allocation feature is enabled. The sales channel record is scriptable in both server and client SuiteScript. The sales channel record cannot be transformed. Order Reservation Newly Exposed The order reservation record is available when the Sales Channel Allocation feature is enabled. The order reservation record is scriptable in both server and client SuiteScript. The order reservation record cannot be transformed.

Automated Clearing Newly Exposed The automated clearing house record is available when the

House Payment Instruments feature is enabled and you have created an instance of the ACH type payment method. The automated clearing house record is scriptable in both client and server SuiteScript. The automated clearing house record cannot be transformed. Subscription Term Newly Exposed The subscription term record is available when the Subscription Billing feature is enabled. The subscription term record is scriptable in both client and server SuiteScript. Record Type Newly Exposed or Notes

Updated

The subscription term record cannot be transformed. Price Plan Newly Exposed The price plan record is available when the Subscription Billing feature is enabled. The price plan record is scriptable in both client and server SuiteScript. The price plan record cannot be transformed. 2021.1 SuiteScript Records Browser The 2021.1 version of the SuiteScript Records Browser is now available. You can find links to the SuiteScript Records Browser in several places, including the following:

  • The help topic titled Working with the SuiteScript Records Browser.
  • The reference page for each supported record in the SuiteScript Records Guide. The SuiteScript Records Guide is available in the NetSuite Help Center and can be downloaded as a PDF from the User Guides topic.

SuiteTalk Web Services Integration

This release note was updated April 28, 2021.

  • Fully Supported Record Types for REST Web Services in 2021.1
  • Asynchronous Request Execution in REST Web Services (Beta)
  • Body Field Selection on Single Resources in REST Web Services
  • Changes in the Returned Format of Enumerator Field Values
  • Removal of Main Record IDs from SuiteBilling Subrecords
  • REST Query Service
    • Support for Formula Field Names in Datasets
    • Support for Paging in Dataset Lists
  • REST Web Services
    • New Option for Integration Record to Support OAUTH2 Authorization Flow
    • Changes in Error Codes Returned in REST Web Services
  • SOAP Web Services
    • New Default Value of Available Without Login Field for File Cabinet Uploads
    • Deprecation of the Inbound Single Sign-on Feature
    • Changes for Name and Display Name Fields on Account Record
    • SOAP Web Services Version 2021.1
    • Araxis Merge Diff File for the 2021.1 Endpoint
    • 2021.1 SOAP Schema Browser Fully Supported Record Types for REST Web Services in 2021.1 The following table lists the record types that are fully supported as of 2021.1.

Record Type Notes

Cash Sale There are no prerequisites for using this record through REST web services. The record ID for a cash sale REST record is cashsale. Customer The create operation is not supported for the campaigns and contactroles elements. The record ID for the customer REST record is customer.

Customer Subsidiary You must either use NetSuite OneWorld or have the Subsidiaries hidden feature enabled

Relationship before you can use this record through REST web services. The record ID for the subsidiary REST record is customerSubsidiaryRelationship.

Employee You must enable the Advanced Employee Permissions feature, the Employee Record, the

Perform Search, the SuiteAnalytics Workbook, and SuiteScript before you can use this record through REST web services. The record ID for the employee REST record is employee. Event The event record is not a subrecord and has three subrecords. The record ID for the event REST record is calendarevent.

Inventory Item An inventory item REST record does not show Quantity Pricing Discount/Levels

(quantitypricingdiscount, quantitypricinglevel) or the Item Translations subtab (translations). The record ID for the journal entry REST record is inventoryItem. Invoice There are no prerequisites for using this record through REST web services. The record ID for an invoice REST record is invoice. Item Fulfillment The item fulfillment record is not a subrecord. The record ID for the journal entry REST record is ItemFulfillment. Message The record ID for the message REST record is Message. All fields on the message record are read-only. Non-Inventory Sale The record ID for the journal entry REST record is noninventorySaleItem.

Item

Phone Call The phone call record is not a subrecord and has one subrecord. The record ID for the phone call REST record is phonecall.

Purchase Order The record ID for a purchase order REST record is purchaseOrder

You must enable the Purchase Orders feature before you can use this record through REST web services. Sales Order The record ID for a sales order REST record is salesorder. You must enable Unified Pricing before you can use this record through REST web services.

Record Type Notes

Change Order The record ID for the change order REST record is subscriptionChangeOrder. The change order record is available if SuiteBilling features are enabled. For more information, see the help topic Enabling SuiteBilling Features. Subscription Term The record ID for a subscription term REST record is subscriptionterm. The subscription term record is available if SuiteBilling features are enabled. For more information, see the help topic Enabling SuiteBilling Features. Task The task record is not a subrecord and has three subrecords. The record ID for the task REST record is task.

Vendor Subsidiary You must either use NetSuite OneWorld or have the Subsidiaries hidden feature enabled

Relationship before you can use this record through REST web services. The record ID for the vendor subsidiary relationship REST record is vendorSubsidiaryRelationship. For a list of every fully supported record, see the help topic REST Web Services Supported Records.

Except for fully supported records, all records listed in the REST API Browser are available as beta records

in REST web services if the REST Record Service (Beta) feature is enabled. For more information about working with the browser, see the help topic The REST API Browser. Asynchronous Request Execution in REST Web Services (Beta)

Warning: Asynchronous request execution is a beta feature. The contents of this feature

are preliminary and may be changed or discontinued without prior notice. Any changes may impact the feature’s operation with the NetSuite application. NetSuite warranties and product service levels shall not apply to the feature or to the impact of the feature on other portions of the NetSuite application. NetSuite may review and monitor the performance and use of this feature. The documentation for this feature is also considered a beta version and is subject to revision. Please review Beta Software Legal Notices. Oracle Confidential. For authorized use only. Do not distribute to third parties. Note: To access this beta feature, you must complete the Oracle NetSuite Umbrella Beta

access the Recruitment form through Oracle SSO. On the Recruitment form, you are required to identify an authorized user who can sign to accept the Oracle Cloud Services Beta Trial License

Agreement. After this Agreement is fully executed by an authorized user through completion of

this form, the requested feature is available for enablement on the Enable Features page. For more information, see Accessing Oracle NetSuite Umbrella Beta Program Features. As of 2021.1, you can execute requests asynchronously in REST web services. The asynchronous execution of requests is useful for long-running requests. Asynchronous processing is available for the REST records service. It is not available for the REST query service. When you send an asynchronous request, the request is sent to REST web services, where it is placed in a processing queue and handled asynchronously with other requests. Your client application does not wait for a response. After a job is submitted, a job Id is returned in the REST web services response. The job ID is used by the client application to check the status and result of the request. Asynchronous processing can be useful if you expect your connection to NetSuite to be slow or unstable. For more information, see the help topic REST Web Services Request Processing. Body Field Selection on Single Resources in REST Web

Services

As of 2021.1, you can retrieve specific body fields of a record by using the GET method. You can use a request similar to the following to specify the list of fields you want to retrieve:

GET https://demo123.suitetalk.api.netsuite.com/record/v1/customer/107?fields=companyName,email,entityId

The response contains only the fields you specify in the request. You can selectively retrieve body fields, but the selective retrieval of sublist and subrecord fields is not supported. For more information, see the help topic Getting Body Fields on a Record Instance. Changes in the Returned Format of Enumerator Field

Values

Prior to 2021.1, the values of enumerator fields were returned in an enumeration-key format, and the internal ID of the enumerator field was used in the REST response. As of 2021.1, both the internal ID and the UI label of enumerator fields are returned by default. You can use the simpleEnumFormat query parameter in REST web services to control the format in which enumerator field values are returned. If the simpleEnumFormat parameter is not used, enumerator field values are returned in the new format. If the simpleEnumFormat parameter is set to true, only the internal ID of the enumerator field is returned. The following example shows a response returned in the new format: GET /record/v1/contact/81 { “globalSubscriptionStatus”: { “id”: “2”, “refName”: “Soft Opt-Out” } }

Additionally, when you use the POST, PATCH, and PUT operations, you can use internal IDs and reference

names to specify enumerator field values in the REST request body in both formats. Prior to 2021.1, the field values could only be changed by using internal IDs. It is recommended that you start using the new format in 2021.1. For more information, see the help topic Format of Enumeration Values.

Removal of Main Record IDs from SuiteBilling Subrecords

As of 2021.1, the subrecords of the subscription, subscription plan, price book, and price plan records no longer include fields that are IDs of the main record. For example, the SubscriptionPlan.SubscriptionPlanMember.subscriptionPlan field is being discontinued because it is the same as SubscriptionPlan.id. The following table contains the discontinued SuiteBilling fields and the equivalent fields that you should use instead: Discontinued Field Equivalent Field subscription.priceInterval.subscription subscription.id subscription.subscriptionLine.subscription subscription.id subscriptionPlan.member.subscriptionPlan subscriptionPlan.id priceBook.priceInterval.priceBook priceBook.id pricePlan.priceTiers.pricePlan pricePlan.id If you are using a discontinued field, change your integration to use the equivalent field instead as outlined in the preceding table. For more information about working with these record types, see the following help topics:

  • Price Book
  • Price Plan
  • Subscription
  • Subscription Plan

Support for Formula Field Names in Datasets

Prior to 2021.1, if you used formulas in datasets, the formula field was returned in the REST response as the field ID instead of the evaluated formula expression. As of 2021.1, when you execute a dataset in REST, the user-defined name of the formula field is returned as the field ID for the formula field. You can define formula field names when you define a dataset in the SuiteAnalytics Workbook UI. For information about defining datasets, see the help topic Defining a Dataset. For information about creating formula fields, see the help topic Creating Formula Fields in SuiteAnalytics Workbook. For information about working with datasets in REST web services, see the help topic Working with SuiteAnalytics Datasets in REST Web Services (Beta).

Support for Paging in Dataset Lists

As of 2021.1, you can use collection paging when you list all datasets. To list all existing datasets and page through the results, send a GET request similar to the following:

GET https://demo123.suitetalk.api.netsuite.com/services/rest/query/v1/dataset/?limit=10&offset=10

The request returns 10 items on the list, starting from the second page of the results, from the 11th item. For more information about working with datasets in REST web services, see the help topic Getting a List of Datasets Through REST Web Services. For information about paging, see the help topic Collection Paging. New Option for Integration Record to Support OAUTH2

Authorization Flow

When you work with REST services or RESTlets, you can now use public clients in the OAuth 2.0

Authorization Code Grant flow for integration records. To do so, check the Public Clients box when you

edit or create the integration record in the UI. For more information, see PKCE for Public Clients.

Changes in Error Codes Returned in REST Web Services

As of 2021.1, the following changes have been introduced in the error codes returned by REST web services:

  • Instead of certain INVALID_VALUE error codes, a more precise NONEXISTENT_FIELD error code is returned.
  • Instead of certain NONEXISTENT_ID error codes, a more precise NONEXISTENT_EXTERNAL_ID error code is returned.
  • Instead of certain INVALID_PARAMETER error codes, a more precise INVALID_HEADER error code is returned. For more information about error codes, see the help topic Error Handling in REST Web Services. New Default Value of Available Without Login Field for File

Cabinet Uploads

As of the 2021.1 endpoint, the default value for the Available Without Login field when uploading images and web site hosting files to the File Cabinet is set to false. For endpoints prior to 2021.1, the default value is true. For more information, see Change to Default Setting for Available Without Login.

Deprecation of the Inbound Single Sign-on Feature

As of the NetSuite 2021.1 release, the ssoLogin and mapSso operations are no longer available. This affects all endpoints, and even though the SOAP schema remains for older endpoints, the methods are not working. For more information about the deprecation, see Deprecation of the NetSuite Inbound Single Sign-on Feature and the Help topic Inbound Single Sign-on. Changes for Name and Display Name Fields on Account

Record

In the NetSuite 2021.1 release, the account record’s Name field and its localized versions no longer display their associated account number. Instead, only the Display Name field displays the account number if you set the Use Account Numbers preference. This change affects the Name field behavior also for the 2020.2 endpoint. When the Use Account

Numbers preference is set to true, the Name field only includes the account name, and not the account

number. When Use Account Numbers is false, both the Name and DisplayName fields display the account name only. The following table summarizes the behavior of Name and Display Name in the affected SOAP endpoints:

SOAP Endpoint Version Name DisplayName

2021.1 Account Name Account Number + Account Name 2020.2 Account Name Account Number + Account Name 2020.1 and older Account Number + Account Name N/A Endpoints 2020.1 and earlier will not be affected. Important: If you use a SOAP-based integration with the 2020.2 endpoint, you should review and update your integration for this change or upgrade to the 2021.1 endpoint. For more information, see Changes to Name and Display Name Fields on Account Record.

SOAP Web Services Version 2021.1

SOAP web services version 2021.1 is available. When your implementation is upgraded to 2021.1, the 2021.1 WSDL becomes available in your production account. You do not need to upgrade your WSDL when the new version is generally available. NetSuite supports each endpoint for three years. For information about the supported generally available versions, see the help topic Support for Existing WSDL Versions.

Araxis Merge Diff File for the 2021.1 Endpoint

The Araxis Merge diff file highlights the schema changes between the 2020.2 and 2021.1 endpoints.

  • About the Araxis Merge Diff File
  • Using the Araxis Merge Diff File

About the Araxis Merge Diff File

NetSuite publishes an Araxis Merge diff file for every new endpoint. Depending on the scope of the release, changes described in the Araxis Merge diff file may include:

  • New record types
  • Elements (fields) that have been added, removed, or changed
  • New sublists (lists)
  • New joins
  • New search filters and search return columns
  • New platform operations Using the Araxis Merge Diff File Important: The screenshots in this section are for illustrative purposes only. They do not reflect changes related to any specific endpoint. The Araxis Merge diff file is generated using Araxis Merge. When you click the Araxis Merge diff file link (when it is available), a page appears that offers an overview of all schema changes. The following screenshot shows how this summary page looks. In this example, the highlighted rows indicate that an XSD has been modified. The integers at the center indicate the number of changed lines in the file. To see the exact differences, click the report link in the column on the right, or click the name of the file in either column. When you click any of these links, the Araxis Merge diff file shows a page with two columns. The previous version of the file is displayed on the left, and the new version is displayed on the right. Changed elements are highlighted. For example, the following screenshot shows an excerpt from the report on platform.commonTypes.xsd. Notice the addition of two values to the PermissionCode enumeration: _accessPaymentAuditLog and _advancedPDFHTMLTemplates. The Araxis Merge diff file also shows changes to data types. The following screenshot is a snapshot of transactions.sales.xsd. Notice that the chargeType element changed from an enumeration to a RecordRef. 2021.1 SOAP Schema Browser The 2021.1 version of the SOAP Schema Browser is now available. You can find links to the SOAP Schema

Browser in several places, including the following:

  • The help topic titled SOAP Schema Browser.
  • The reference page for each supported record in the SOAP Web Services Records Guide. The SuiteTalk SOAP Web Services Records Guide is available in the NetSuite Help Center and can be downloaded as a PDF from the User Guides topic.

SuiteCloud SDK

SuiteCloud Software Development Kit (SuiteCloud SDK) is a set of tools you can use to develop SuiteCloud

Development Framework (SDF) projects. These tools are the SuiteCloud IDE plug-ins and command-line interfaces (SuiteCloud CLI). 2021.1 SuiteCloud CLI for Node.js Is Now Available SuiteCloud CLI for Node.js is now available for download. To install it, see the help topic Installing CLI for Node.js.

CLI for Node.js is a tool that you can use as a stand-alone application, or in combination with your

preferred code editor, to develop SDF projects. This CLI is optimized for the end-user experience. It is interactive and guides you through all the steps of the communication between your local project and your account. For more information about CLI for Node.js, see the help topic CLI for Node.js Guide. Each version of CLI for Node.js in npm works optimally with a specific NetSuite version. In the following table, check the npm version for NetSuite 2021.1: Version in npm Version in NetSuite 2.0.X 2021.1 SuiteCloud CLI for Node.js is an open-source project published in the npm Registry. To get the latest changes, see SuiteCloud CLI for Node.js. 2021.1 SuiteCloud CLI for Java Is Now Available SuiteCloud CLI for Java is now available for download. To install it, see the help topic Installing CLI for Java.

CLI for Java is a tool that you can use as a stand-alone application, or in combination with your preferred

code editor, to develop SDF projects. You can also create batch and shell scripts that use CLI commands to automate your project validation and deployment processes. When used with your own IDE, CLI for Java acts as an alternative to SuiteCloud IDE plug-ins. For more information about CLI for Java, see the help topic CLI for Java Guide. CLI for Java is supported on Windows, Linux, and Mac OS X. For more information, see the help topic CLI for Java Installation Prerequisites. 2021.1 SuiteCloud IDE Plug-in for WebStorm Is Now

Available

SuiteCloud IDE plug-in for WebStorm is now available for download. For more information, see the help topic Update SuiteCloud IDE Plug-in for WebStorm. Important: When your account is upgraded to 2021.1, your IDE plug-in for WebStorm is not updated automatically to the 2021.1 version. After your account upgrade, you must manually update the IDE plug-in for WebStorm. 2021.1 SuiteCloud IDE Plug-in for Eclipse Is Now Available SuiteCloud IDE plug–in for Eclipse is now available for download. For more information, see the help topic Updating Eclipse for Use with SuiteCloud IDE Plug-in. Important: When your account is upgraded to 2021.1, your IDE plug-in for Eclipse is not updated automatically to the 2021.1 version. After your account upgrade, you must manually update the IDE plug-in for Eclipse. New dryrun Option for the project:deploy Command in

SuiteCloud CLI for Node.js

This release note was updated March 24, 2021. The project:deploy command offers the dryrun option, which runs a preview of your deployment process. For example, suitecloud project:deploy —dryrun. Your project, however, is not actually deployed. The dryrun option is not compatible with interactive mode. To use it, you need to run project:deploy in non-interactive mode. Important: The dryrun and the validate options are mutually exclusive. That is, you can only use one of them at a time. For more information, see the help topic project:deploy. account:ci Command Renamed to account:savetoken in

SuiteCloud CLI for Node.js

The account:ci command has been renamed to account:savetoken in SuiteCloud CLI for Node.js. In addition, the savetoken option has been removed, so to save a TBA token, enter a command similar to the following: suitecloud account:savetoken —authid MyNetSuiteDevRole —tokenid 1234567 —tokensecret 1234567 For more information, see the help topic account:savetoken.

Installation Preferences for SuiteApps in SuiteCloud CLI

The applycontentprotection option has been renamed to applyinstallprefs in SuiteCloud CLI for Java and SuiteCloud CLI for Node.js. Although you can still use the former applycontentprotection option, you should use the applyinstallprefs option starting from 2021.1 SuiteCloud CLI plug–in. This option now includes the configuration set up in the overwriting.xml file, which has been introduced in 2021.1. For more information, see New Installation Preferences Configuration for Script Deployments in SuiteApp Projects. Important: The applycontentprotection will be deprecated in 2021.2. Installation Preferences for SuiteApps in SuiteCloud IDE

Plug-ins

The Apply Content Protection check box has been renamed to Apply Installation Preferences in SuiteCloud IDE plug-in for WebStorm and SuiteCloud IDE plug-in for Eclipse. This check box applies to all the files inside the InstallationPreferences folder. This option now includes the configuration set up in the overwriting.xml file. For more information, see New Installation Preferences Configuration for Script Deployments in SuiteApp Projects.

Overwriting File Included in SuiteApp Projects

When you create a SuiteApp project in SuiteCloud SDK, it includes an overwriting.xml file inside the InstallationPreferences folder. The following is an example of an overwriting.xml file: For more information, see New Installation Preferences Configuration for Script Deployments in SuiteApp Projects. Setup Multiple Accounts with Run/Debug Configurations in

SuiteCloud IDE Plug-in for WebStorm

You can create custom run/debug configurations to work with multiple accounts in SDF projects. In WebStorm, select Run > Edit Configurations… Then, click and select SuiteCloud to display the following window:

These run/debug configurations can be set up for the following actions:

  • Validate
  • Preview
  • Deploy For more information, see the help topic Using Multiple Accounts with Run/Debug Configurations in SuiteCloud IDE Plug-in for WebStorm.

SuiteCloud Development Framework

SuiteCloud Development Framework (SDF) is a development framework and deployment mechanism.

Customers and partners can use SDF to create customization projects for internal use within their

organizations or for commercial distribution. For more information about SDF, see the help topic SuiteCloud Development Framework Overview. For a complete list of custom records and customizations that are supported by SDF, see the help topic Customizations Supported by SuiteCloud Development Framework. New Installation Preferences Configuration for Script

Deployments in SuiteApp Projects

You can now configure the behavior you want to apply to fields customized in script deployments. You can preserve your fields and their values, or you can overwrite them with updates from the SuiteApp they belong to. The new overwriting.xml file in the InstallationPreferences folder in SuiteApp projects lets you set up the preferences you want to apply for script deployments. The following options are available:

  • OVERWRITE — The fields configured in your SuiteApp project are overwritten by the changes introduced with updates from the SuiteApp.
  • PRESERVE — The fields configured in your SuiteApp project are preserved and are not overwritten by the changes introduced with updates from the SuiteApp. Note: You can validate and deploy your SuiteApp project even if your project does not include the overwriting.xml file. See the following overwriting.xml file example:
In the scriptdeployments tag, you can use the defaultAction attribute to set up the behavior you want to apply to all script deployments in your SuiteApp project. Inside the scriptdeployments tag, you can add script deployments in individual scriptdeployment tags to apply a specific behavior to that particular script deployment with the action attribute. For example, you can use this approach if you want to overwrite all your script deployment customizations, but you need to keep the customizations defined in a specific script deployment. For more information, see the following topics: - Script Deployment - Viewing Script Deployments Feature Dependency Enhancements For SDF Custom ## Objects ## Your users can now fully install an SDF SuiteApp when some of its NetSuite features are not enabled in the target account. If the account administrator later enables those features, the relevant custom objects become available to your SuiteApp’s users. This functionality is available for a limited subset of SDF custom objects, which you can include in your SDF SuiteApp. Your users can install such SDF SuiteApps without encountering warnings or errors about missing features. For the list of custom objects that support this feature dependency enhancement, see the help topic Enhanced Feature Dependencies for SDF Custom Objects. Note the following information when including custom objects in your SDF SuiteApp that support this enhancement: - SDF SuiteApp installation succeeds without any messaging to the user installing the SDF SuiteApp. - SDF SuiteApp deployment succeeds without any log entries outputted to the console of SuiteCloud IDE or the SDF CLI. - Validating an SDF project in SuiteCloud IDE or the SDF CLI does not notify you about features when they are not enabled in the target account. - During SDF SuiteApp installation, SDF custom objects for features (that are not enabled in the target account) are created in that target account, but those objects are not visible until the feature is later enabled. Uninstalling an SDF SuteApp also removes those SDF custom objects from the account, even when those objects were not visible. - You can still make the feature required for the target account by setting the feature’s required attribute to true in the manifest. That attribute value ensures that the SDF SuiteApp installation fails when the feature is not enabled in the target account. The same functionality is also available for account customization projects (ACP) that contain supported ## SDF custom objects. The projects can be deployed to a target account that does not have the required features enabled. If the features are later enabled on that account, the SDF custom objects relying on those features will become available to that account’s users. ## For all other SDF custom objects, the existing feature dependency behavior remains true. For more information about feature dependencies for custom objects, see the help topic Feature Dependencies for SDF Custom Objects. ## Translatable Fields Enhancements You can now reuse a Translation Collection string in multiple translatable fields within your SDF SuiteApp. Reusing translation strings reduces development time and avoids duplicating manual work. ## Consider the following information when reusing translation strings for translatable fields: - Multiple SDF custom objects within the same SuiteApp can reference the same translation string. SDF custom objects in other SuiteApps cannot reference that same translation string. - Multiple fields within the same SDF custom object can reference the same translation string. For more information about working with translatable fields in SDF custom objects, see the help topic Translatable Fields on Custom Objects. ## Minor Updates to Custom Objects This release note was updated March 3, 2021. ## Note the following information about updates to SDF support for custom objects: ## Object Field Type Notes addressForm name single-select list Now a translatable field. For field: label single-select list Now a translatable field. For fieldGroup: label single-select list Now a translatable field. bundleinstallationscript description single-select list Now a translatable field. bankstatementparserplugin description single-select list Now a translatable field. name single-select list Now a translatable field. centercategory linklabel single-select list Now a translatable field. centerlink New custom object. For the list of fields, see the help topic centerlink. clientscript description single-select list Now a translatable field. name single-select list Now a translatable field. customglplugin description single-select list Now a translatable field. name single-select list Now a translatable field. customrecordactionscript description single-select list Now a translatable field. name single-select list Now a translatable field. For scriptdeployment: boolean New field. showbutton The default value is F. For scriptdeployment: actionlabel single-select list New field. dataset name single-select list Now a translatable field. datasetbuilderplugin description single-select list Now a translatable field. name single-select list Now a translatable field. emailcaptureplugin description single-select list Now a translatable field. name single-select list Now a translatable field. entryForm name single-select list Now a translatable field. For field: label single-select list Now a translatable field. For fieldGroup: label single-select list Now a translatable field. For subList: label single-select list Now a translatable field. For subTab: label single-select list Now a translatable field. Object Field Type Notes For tab: label single-select list Now a translatable field. ficonnectivityplugin description single-select list Now a translatable field. name single-select list Now a translatable field. fiparserplugin description single-select list Now a translatable field. name single-select list Now a translatable field. kpiscorecard description single-select list Now a translatable field. name single-select list Now a translatable field. For kpi: label single-select list Now a translatable field. For range: label single-select list Now a translatable field. mapreducescript description single-select list Now a translatable field. name single-select list Now a translatable field. massupdatescript description single-select list Now a translatable field. name single-select list Now a translatable field. pluginimplementation description single-select list Now a translatable field. name single-select list Now a translatable field. plugintype description single-select list Now a translatable field. name single-select list Now a translatable field. portlet description single-select list Now a translatable field. name single-select list Now a translatable field. promotionsplugin description single-select list Now a translatable field. name single-select list Now a translatable field. publisheddashboard enhsnapshots field group New dashboard portlet field group. lastlogin field group New dashboard portlet field group. name single-select list Now a translatable field. notes single-select list Now a translatable field. customportlet field group New parameters field group restlet description single-select list Now a translatable field. name single-select list Now a translatable field. role employeeselectionunrestricted boolean New field. issinglesignononly boolean New field. issuerole string New field. Object Field Type Notes name single-select list Now a translatable field. subsidiaryviewingallowed boolean New field. subsidiaryoption single-select list New field. tfaduration single-select list New field. tfarequired single-select list New field. scheduledscript description single-select list Now a translatable field. name single-select list Now a translatable field. sdfinstallationscript description single-select list Now a translatable field. name single-select list Now a translatable field. secret New custom object. For the list of fields, see the help topic secret. suitelet description single-select list Now a translatable field. name single-select list Now a translatable field. transactionForm name single-select list Now a translatable field. For column:label single-select list Now a translatable field. For field: label single-select list Now a translatable field. For fieldGroup: label single-select list Now a translatable field. For subList: label single-select list Now a translatable field. For subTab: label single-select list Now a translatable field. For tab: label single-select list Now a translatable field. For totalBoxField: label single-select list Now a translatable field. usereventscript description single-select list Now a translatable field. name single-select list Now a translatable field. workbook name single-select list Now a translatable field. workbookbuilderplugin description single-select list Now a translatable field. name single-select list Now a translatable field. workflowactionscript description single-select list Now a translatable field. name single-select list Now a translatable field. For more information about SDF custom object fields, see the help topic SuiteCloud Development Framework XML Reference. SuiteApps (Bundles) Released by NetSuite ## Accounting SuiteApps This release note was updated May 5, 2021. ## Following are the 2021.1 accounting enhancements to SuiteApps: - Multi-Language Support for Sequential Liability - Fixed Assets Management Enhancements - Expense Commitments and Budget Validation - SuiteApprovals Enhancements ## Multi-Language Support for Sequential Liability ## Sequential Liability SuiteApp version 1.00.4 is now available in the following languages: - Chinese (Simplified) - Chinese (Traditional) - Czech - Danish - Dutch - English - Finnish - French - French (Canada) - German - Italian - Indonesian - Japanese - Korean - Latin American Spanish - Norwegian - Portuguese (Brazil) - Russian - Spanish - Swedish - Thai - Turkish - Vietnamese To set the language preference, you must enable the Multi-Language feature in your account. For more information, see Multi-Language Support for Sequential Liability. Sequential Liability SuiteApp provides a unified view of accounts payable, accounts receivable, projects, and cash balances, which enables financial controllers to pay vendors confidently. This SuiteApp helps effectively manage cash flow for transactions where payment to vendors is linked to receipt from customers. To search and install this SuiteApp, use the following information: Bundle Name: Sequential Liability ## Bundle ID: 301860 For more information about this SuiteApp, see the help topic Sequential Liability SuiteApp. ## Fixed Assets Management Enhancements The following enhancements are available in Fixed Assets Management (FAM) SuiteApp version 21.1: - User Interface Updates - Fixed Assets Scripts Updates ## User Interface Updates The following are changes made to the Fixed Assets Management SuiteApp user interface in version 21.1: - The Tax Methods subtab is removed from the Asset Record page. The FAM Alternate Depreciation methods is now available in the Depreciation History subtab. For more information, see the help topic Depreciation History Subtab. - The My Reports page no longer shows failed reports. - Saved search names now spell out abbreviated words, as shown in the following table: ## Saved Search Column Old Custom Label New Custom Label FAM Disposals Quantity Quant Quantity Quantity Disposed Quant Dspsd Quantity Disposed Disposal Date Dspsl Date Disposal Date Disposal Item Dspsl Item Disposal Item ## Disposal Type Dspsl Type Disposal Type FAM Depreciation Monthly Transaction Amount Depr Amt Depreciation Amount ## Report FAM Asset List Formula (Currency) Depr To Date Depreciation To Date Asset Values: Last Depreciation Last Depr Date Last Depreciation Date Date Asset Values: Last Depreciation Last Depr Period Last Depreciation Period ## Period FAM Additions Asset: Depreciation Start Date Depr Start Depreciation Start Fixed Assets Scripts Updates or on a schedule using the Trigger Reports Cleanup scheduled script. You can view the status of the report cleanup from the FAM Process Status page. For more information, see the help topic Managing Fixed Assets Scripts. ## Expense Commitments and Budget Validation The Expense Commitments and Budget Validation SuiteApp enables you to: - Create budgets for specific account, segment, and period combinations. - Validate the purchase orders, purchase request, and vendor bills against the budget. The SuiteApp provides provision to budget for accounting periods and lets you maintain multiple versions of a budget for the same period. You can also set warnings when budgets exceed the account and segment combination. year and the second column displays the month. Important: After the update to version 1.0.3, you must set the preferences on the Budget Preferences page again. For more information, read the help topic Expense Commitments and Budget Validation. ## 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. ## Administration SuiteApps This release note was updated April 21, 2021. Following are the 2021.1 administration enhancements to SuiteApps: Application Performance Management (APM) Enhancements ## APM 2.0.0 Available in the SuiteApp Marketplace Application Performance Management version 2.0.0 is now available for installation from the SuiteApp APM. To open APM from the SuiteApp Marketplace, go to Customization > Performance. To open APM from the Search & Install Bundles page, go to Customization > Performance (SuiteBundler). - New REST Web Services Analysis feature - This feature lets you monitor the performance of REST- based web services. For more information, see New REST Web Services Analysis Feature. - Web Services Analysis feature changes - Web Services Analysis feature links and pages are renamed to SOAP Web Services Analysis. This feature focuses on monitoring the performance of SOAP-based web services. To access this feature, go to Customization > Performance > SOAP Web Services Analysis. ## APM version 2.0.0 and future releases are available only from the SuiteApp Marketplace. APM SuiteApp versions installed from the Search & Install Bundles page are not upgraded automatically. If you have ## APM version 1.12.3, you should upgrade to APM version 2.0.0 to get the latest features. To install the SuiteApp and find out about the next steps, see the help topic Installing the Application Performance Management SuiteApp. To understand the differences between APM from the SuiteApp Marketplace and APM from the Search & Install Bundles page, see the help topic Differences Between APM from the SuiteApp Marketplace and from the SuiteBundler. For more information about APM version 2.0.0, see the help topic Application Performance Management (APM). ## New REST Web Services Analysis Feature With Application Performance Management (APM) SuiteApp version 2.0.0, you can access and use the new REST Web Services Analysis feature. REST Web Services Analysis lets you monitor the performance of REST web services operations. It provides information about top REST web services operations, users, requests, error statistics, and execution timings. To start using the feature, go to Customization > Performance > REST Web Services Analysis. For more information, see the following topics: - Analyzing Web Services Performance - REST Web Services Analysis Overview - Using REST Web Services Analysis ## Navigation Label Change In Application Performance Management (APM) SuiteApp version 1.12.3, the label of the navigation link to open APM is changed from Performance to Performance (SuiteBundler). To open APM after upgrading to APM 1.12.3, go to Customization > Performance (SuiteBundler). This change is in preparation for your installation of the APM SuiteApp version 2.0.0 from the SuiteApp Marketplace. For more information, see APM 2.0.0 Available in the SuiteApp Marketplace. ## New Help Links Available in APM Tools With Application Performance Management (APM) SuiteApp version 1.12.2, information icons that link to relevant help topics are available on the following tools: - Performance Health Dashboard - Record Pages Monitor - Page Time Summary - Page Time Details - SuiteScript Analysis - SuiteCloud Processors Monitor - SuiteCloud Processor Job Details - Web Services Analysis - Concurrency Monitor - Search Performance Analysis - Search Performance Details - Profiler Details ## Treatment of Null Values in Record Pages Monitor With Application Performance Management (APM) SuiteApp version 1.12.2, null values that appear in charts in the Record Pages Monitor tool are represented with 0. This update ensures that the charts will be shown fully and without errors on the page. ## Banking SuiteApps This release note was updated July 28, 2021. ## Following are the 2021.1 banking enhancements to SuiteApps: - Bank Feeds SuiteApp Enhancements - CSV Parser Plug-in Now Available in Bank Statement Parsers Bank Feeds SuiteApp Enhancements ## Global Bank Feeds Integration Services In version 21.1.1, Bank Feeds SuiteApp expands its support through multiple financial institutions in Australia, New Zealand, Switzerland, and some parts of Asia. ## Version 21.1.1 automatically provisions your account with two new format profile records: - Connect to Accounts in Other Countries – This new format profile is exclusive to bank feeds integration with financial institutions that operate in the following countries: - Australia - Hong Kong - Indonesia - Malaysia - New Zealand - Philippines - Singapore - Thailand - Connect to Non-PSD2 Europe Accounts – This new format profile is exclusive to bank feeds integration with financial institutions that are not compliant with PSD2 (Revised Payment Services Directive) regulation in Europe. Note: As of version 21.1.1, the format profile supports only financial institutions operating in Switzerland that are non-PSD2 regulated. The latest version of Bank Feeds SuiteApp also extends its support to financial institutions that are not country–specific. These financial institutions can now be set up using the Connect to Europe Accounts and Connect to Accounts in Other Countries format profiles. ## Support for Partial Success of U.S. and Canada Bank Feeds Data Import Previously, when at least one of your US or Canada financial institution accounts encounters an error, the bank data import status fails and no transactions are imported into NetSuite. This limitation prevents you from completing your bank reconciliation tasks for your other accounts. In version 21.1.1, Bank Feeds SuiteApp lets you proceed with the bank data import even if one of your financial institution accounts encounters an error. On the Banking Import History page, the bank data import status is set to Partially Completed when at least one of your associated accounts fails the bank data import because of errors. ## On your format profile configuration, bank and credit card accounts that fail to connect are shown with warning icons. Each failed account connection is provided with a failure reason to help you resolve the error. Support for Financial Institution Connections with Multiple Login ## Accounts In version 21.1.1, the SuiteApp lets you connect to a financial institution using multiple login accounts. Connection ID is a new column added to the Connections and Accounts subtab of your format profile. This column serves as a unique identifier when you have the same financial institution connection with different users or credentials setup. Connection ID helps you identify which bank and credit card accounts are associated with which financial institution. This feature enables you to manage connections with the same financial institution independently. ## Removal of Waiting Period During Installation Previously, when installing the SuiteApp, a 30-minute waiting period is required before you can set up your bank feeds in NetSuite. In the latest version of the Bank Feeds SuiteApp, all necessary components are added immediately during installation from the SuiteApp Marketplace. Improvements to U.S. and Canada Bank Feeds Integration configure U.S. and Canada financial institution connections in NetSuite. - Managing U.S. and Canada Financial Institution Connections – In previous versions, you can only add a new financial institution or exclude an account from your U.S. and Canada bank feeds integration. Starting version 20.2.2, you can manage your connections and associated accounts on the Connect to U.S. and Canada (Link Bank Accounts) Format Profile page. You can perform the following actions on this page: - Rebuild Connection - Update MFA (Multi-Factor Authentication) - Delete Connection - Exclude Account - Configuration for Financial Institution Connections Launches as a Popup Window – To connect a financial institution operating in the United States and Canada, the configuration now launches as a popup window. The popup window replaces the embedded section under the Connectivity Configuration subtab of the format profile. The configuration popup window opens when you perform any of the following actions: - Connect a new financial institution for the first time. - Manage your financial institution connections through the Rebuild Connection and Update MFA actions. ## Bank Feeds Audit Trail The Bank Feeds Audit Trail is a specialized custom record that helps you keep track of your NetSuite account’s bank feeds activities within a 90-day period. You can access this custom record from Customization > Lists, Records, & Fields > Record Types (Administrator). Look for Bank Feeds Audit Trail and then click List to show the audit trail records. Note: The Bank Feeds Audit Trail custom record will not include bank feeds activity data generated before the upgrade to version 20.2.2. For more information, see the help topic Bank Feeds SuiteApp. ## CSV Parser Plug-in Now Available in Bank Statement Parsers In Bank Statement Parsers SuiteApp version 21.2.0, you can now use a CSV parser plug-in to import bank statement files in CSV format into NetSuite. To use the CSV parser plug-in, select CSV Plugin Implementation in the Transaction Parser field of a format profile. When you do so, the following subtabs are shown on the Parser Configuration subtab: - Field Mapping – Map your CSV column headers to the matching NetSuite CSV parser configuration fields. - Formatting Preferences – Set up your preferred data formatting preferences based on your CSV file data. You can download the CSV Bank Statement Template file from the Parser Configuration subtab and use it to format your bank statement files for import. Alternatively, you can use your own CSV file. For more information, see the help topic Bank Statement Parsers SuiteApp. ## Food and Beverage SuiteApps This release note was updated August 11, 2021. ## Following are the 2021.1 food and beverage enhancements to SuiteApps: - FEFO Lot Allocations - Auto Close Back Orders Enhancements - Order Guides Enhancements - Lot Auto Numbering ## FEFO Lot Allocations The FEFO (First Expiry First Out) Lot Allocations SuiteApp allocates lot numbered item inventory to sales order line items on a FEFO basis. The SuiteApp allocates lot numbered items based on customer shelf requirements and minimum order fulfillment needs. The SuiteApp works together with the Supply Allocation feature for lot numbered item types. When using the FEFO Lot Allocations SuiteApp for lot numbered items, do not use order allocation schedule. For addressing item types other than lot items, choose the Select Orders Using a Saved Search option and then select Order Allocation Schedule - Non-Lot Items in the Saved Search list. When using a different saved search, make sure the saved search filters the sales order line items that contain lot numbered items. ## Following are the SuiteApp details: - Bundle name: FEFO Lot Allocations - Bundle ID: 279508 - Version number: 1.00.0 For more details, see the help topic FEFO Lot Allocations. ## Auto Close Back Orders Enhancements this preference, you can decide whether the Auto Close Back Orders script runs on or excludes the items list in the Fill Kill Items page. - The Fill Kill Item Exception page is now called the Fill Kill Items page. - You can now import the list of items to auto close using CSV import. For more information, see the help topic Auto Close Back Orders. Order Guides Enhancements ## Order Guide Creation and Updates Using CSV Import ## Order Guides SuiteApp version 2.03.0 now includes support for creating and updating order guides and order guide templates using the standard CSV Import feature. For more information, see the help topic Creating Order Guides. Order Guide Price Updates Guide Entry popup window. - In the Order Guide Entry popup window of a sales order, the following item filtering criteria are removed: - Items must have a base price or absolute price defined in the default currency of the customer. - For Customer Center role, the absolute price must be in the default currency of the customer. - An item can now be added to the order guide regardless of the price level set for the item in the customer record. For more information, see the help topic Order Guides. ## Lot Auto Numbering The Lot Auto Numbering SuiteApp enables you to do the following: - Define a lot numbering format and assign it to lot items. The lot numbering format automatically determines the lot number in the Inventory Detail popup window of a transaction record. - Configure additional lot details for lot items. You can enter the configured additional lot details in the Inventory Detail popup window of a transaction record. For more information, see the help topic Lot Auto Numbering. ## Integration SuiteApps This release note was updated September 22, 2021. ## Following is the 2021.1 integration enhancement to SuiteApps: - NetSuite Content and Experience Enhancements - NetSuite Connector NetSuite Content and Experience Enhancements ## Multi-Language Support for NetSuite Content and Experience ## NetSuite Content and Experience SuiteApp version 1.00.5 is now available in the following languages: - Chinese (Simplified) - Chinese (Traditional) - Czech - Danish - Dutch - English - Finnish - French - French (Canada) - German - Indonesian - Italian - Japanese - Korean - Norwegian - Portuguese (Brazil) - Russian - Spanish - Spanish (Latin America) - Swedish - Thai - Turkish - Vietnamese To set the language preference, you must enable the Multi-Language feature in your account. For more information, see Setting the Language Preference for NetSuite Content and Experience. Oracle NetSuite Content Cloud Service Renamed to NetSuite ## Content and Experience In version 1.00.4, Oracle NetSuite Content Cloud Service is renamed to NetSuite Content and Experience. Updates to My Documents and Project Documents Portlets ## Documents and Project Documents portlets: - You can access your Oracle Content documents by adding the My Documents portlet in your dashboard as a custom portlet or as a SuiteApp portlet. - You can search for your files using keywords and tags in the My Documents portlet and in the Documents page. - You can add the Project Documents portlet in your dashboard when using the Employee Center role. For more information on this SuiteApp, see the help topic NetSuite Content and Experience. ## NetSuite Connector The FarApp application is now called NetSuite Connector. Also, some of the old FarApp SuiteApps are now managed bundles with new bundle IDs. The following table lists the changes in the SuiteApp names, bundle IDs, and upgrade types. ## Old SuiteApp New SuiteApp ## Bundle ID SuiteApp Name Upgrade Type Bundle ID SuiteApp Name Upgrade Type 283676 FarApp Managed 401685 NetSuite Connector Managed 283682 FarApp Marketplace/ Unmanaged 402043 NetSuite Connector Managed Cart - Item Fields Marketplace/Cart ## Old SuiteApp New SuiteApp ## Bundle ID SuiteApp Name Upgrade Type Bundle ID SuiteApp Name Upgrade Type 283678 FarApp for SuiteSuccess Unmanaged 401819 NetSuite Connector for Managed - Item Fields SuiteSuccess 283686 FarApp Saved Search Unmanaged 402066 NetSuite Connector Managed ## Export Saved Search Export The following SuiteApps have been removed and are replaced by the NetSuite Connector SuiteApps. To get the updates, you should update to the latest SuiteApps. ## SuiteApp Name Bundle ID For more information, see the help topic NetSuite Connector. Inventory Management SuiteApps ## Following are the 2021.1 inventory management enhancements to SuiteApps: - Quality Management Enhancements - New Pack Station Mobile App Quality Management Enhancements ## Field Level Settings ## Quality Management SuiteApp version 2021.1 removes mandatory assignment from inspection records and transfers it to date fields. The fields previously associated with a required inspection will be marked as mandatory. This migration preserves the Quality Management SuiteApp behavior and data requirements. It also enables the inspection and specification definition to be customized for a more efficient tablet experience. ## New Inspection Fields ## Quality Management SuiteApp 2021.1 now includes the Select and URL inspection field types. These field types enhance the setup and execution of inspections on a tablet and provide for more flexibility when capturing data. - Select – This field type provides a predefined list of values for quality engineers and managers to choose from. This ensures that the data entered is consistent and can be used for reporting. - URL – This field type captures an external URL for navigation. The URL can reference supplemental information located in another system. For example, a large image in Dropbox. ## New Pack Station Mobile App Note: Use of the Pack Station mobile app requires that you install the SCM Mobile SuiteApp. See the help topic NetSuite SuiteApps. The new 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 enables you to: - Identify picked items that have the same shipping route and pack them at the same time. - Gain visibility into items and orders packed across multiple cartons or pallets, throughout the packing process. - Print customizable carton labels, pallet labels, bill of lading, and packing lists from a kiosk device. - Capture weights from a weighing scale through your kiosk device. 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. For more information, see the help topic Pack Station. ## Localization SuiteApps This release note was updated September 22, 2021. ## Following are the 2021.1 localization enhancements to SuiteApps: - Advanced Localization Features - ANZ Localization Enhancements - Belgium Localization Tax Reports Enhancements - Belgium Localization Intrastat Reports Updates - China Localization Enhancements - Country-Specific Reports Enhancements - France Localization Enhancements - Germany Localization Chart of Accounts and Financial Statements Enhancements - Germany Localization Tax Reports Enhancements - India Localization SuiteTax Engine Enhancements - Ireland Localization Enhancements - Japan Localization Enhancements - Localization Assistant Features - Netherlands Localization VAT Report Enhancements - Netherlands Localization Intrastat Reports Updates - Norway Tax Reports Enhancements - Philippines Localization Support for BIR Simplified System Registration for CAS Users - Portugal Invoice Certification Enhancements - Portugal SAF-T - Southeast Asia Localization Enhancements - Sweden Tax Reports Enhancements - United Kingdom Localization VAT100 Report and Intrastat Report Updates ## Advanced Localization Features The Advanced Localization Features SuiteApp enables you to create localized printable invoices and credit memos that comply with tax regulations and meet common business needs. With the Advanced Localization Features SuiteApp, you can: - Benefit from two advanced PDF/HTML templates (for invoices and credit memos). - Fill in additional fields added to subsidiary and customer records. The content of these fields is then used on printed transaction forms. - Create transaction bank details records with the content to be used on printed invoices or credit memos. These records can be assigned to subsidiaries, customers, or individual transactions. - Create method of payment records to specify the texts to be printed (at customer or transaction level). - Create tax compliance text records with tax-related texts. - Customize your template’s color scheme and layout. - Replace the default texts with your customized texts (for every supported language). - Set the invoice locking level for each subsidiary. This action prevents users from editing invoices that have already been approved or sent to a customer. For more information, see the help topic Advanced Localization Features. ANZ Localization Enhancements ## 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 Australian vendor records and transaction (vendor bill and bill payment) records for an Australian 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 an alert to warn or block users from entering invalid ABNs and NZBNs 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. ## 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. ## Belgium Localization Tax Reports Enhancements ## Belgium Localization SuiteApp version 1.02.0 provides enhancements to the following tax reports: - Periodic VAT Return 625 – This SuiteTax-based report now supports the inclusion of expenses, billable expenses, and journals. - EU Sales List 723 – The XML export of this SuiteTax-based report now displays the VAT number in the format required by the Belgium tax authority. For more information, see the help topic Belgium Localization. ## Belgium Localization Intrastat Reports Updates Belgium Localization SuiteApp version 1.04.0 includes updates in the SuiteTax-based Intrastat Supplementary Declaration reports to accommodate changes brought by Brexit. The updated reports meet the following conditions: - Only item types classified as goods are displayed in the Intrastat Arrivals and Intrastat Dispatches reports. - For exports to other EU countries including Ireland, only intracommunity sales tax transaction type are included in the Intrastat Dispatches report. - For imports to other EU countries including Ireland, only intracommunity purchases tax transaction type are included in the Intrastat Arrivals report. For more information, see the help topic Belgium Localization. ## China Localization Enhancements added to the China Cash Flow Statement report. The SuiteApp also includes a custom form for vendor prepayment transactions. For more information, see the help topics Setting Up General Company Preferences, Setting Up China Cash Flow Item for Subsidiary, and Override China Cash Flow Item. - Enhancements to China Voucher List – Customer and vendor filters are now available when you generate the China Voucher List. Also, you can now download the China Voucher List report in Excel format. For more information, see the help topic Generating the China Voucher List. - Import VAT Transactions with Remarks – You can now include the Remarks field when you import VAT transactions from China Golden Tax System. For more information, Importing VAT Transactions from the China Golden Tax System - Custom Cash Flow Item Categories – You can now include custom China cash flow item categories in the China Cash Flow Statement report. For more information, see the help topics Customizing China Cash Flow Item and China Cash Flow Statement Report. The following minor enhancements are also included in version 1.00.17: - On the China Income Statement report, the table heading appears on each page if the table has more than 25 lines. - On China VAT Transactions, the VAT Invoice Type is now automatically populated if the VAT Taxpayer Type is General Taxpayer. - Inventory transfer transactions are now displaying correctly on the China Voucher Printing report. ## Country-Specific Reports Enhancements The Country-Specific Reports SuiteApp enables you to create, edit, or view complex financial reports for different countries. It also serves as a framework supporting various localization SuiteApps. For more information, see the help topic Country-Specific Reports. ## Report Link When you create a new report using the Country-Specific Reports SuiteApp, a unique link is automatically assigned to it. The link enables you to display the report directly, without going to the Country-Specific Reports dashboard. You can either click this link to view the report or use the Copy This Link to Clipboard option to store it for later use. ## Report Structure This feature enables you to view the structure of any report created by the Country-Specific Reports ## SuiteApp. Instead of the report itself, you can display an overview of all variables that the selected report contains (with the accounts used by these variables, their numbers, and other additional information). You can also apply several filters to this overview and search out variables using a certain account or accounts of a certain type. The Report Structure feature helps you identify potential issues in your report, such as accounts not included in any of the report variables or accounts included multiple times. To view the structure of a report, go to Reports > Financial > Country-Specific Reports. Select the report that you want to view, then click the View Structure button. To learn more about the Report Structure feature, see the help topic Viewing the report structure. Germany Localization Chart of Accounts and Financial ## Statements Enhancements The following are enhancements for Germany Localization SuiteApp version 0.12: - New Germany Chart of Accounts Page – On the new Installation of Germany Chart of Accounts page, you can download SKR03 or SKR04 templates and import them in CSV format. The page also contains instructions on how to perform this task. - German Financial Statements – When displaying German Balance Sheets or German Income ## Statements, you can check the new Show Individual Accounts box to see the individual accounts under each category. In German Income Statements, you can now also specify the data using the Period To filter. - Generating the VAT report – A new Region field is now available on the Country Tax Reports page. This field enables you to filter out only Periodic VAT return – Ust 1A reports from the selected region of Germany. ## Germany Localization Tax Reports Enhancements In Germany Localization SuiteApp version 0.14, the Tax Reporting Category filter is now available on transaction forms and on the Tax Return Setup page. This filter enables you to further classify goods and services in the VAT report. You can assign a category of Constructed Services or Mobile Devices to an item. 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. ## France Localization Enhancements For more information, see the help topic France Localization. ## France Electronic Bank Payment Templates France Localization SuiteApp version 2.03.0 enables bank payments processing using the provided payment templates in the following formats: - SEPA Credit Transfer (France) - CFONB - FR International CFONB320 - FR International ISO20022 Using these payment templates requires the Electronic Bank Payments SuiteApp. ## New France Financial Reports A new saved report, FR Balance Auxiliaire, is available in version 2.03.0. ## Apart from the France financial saved reports, the France Localization SuiteApp also provides the following financial reports that were built using the Country-Specific Reports SuiteApp: - France Balance Sheet - France Income Statement - France Soldes intermédiaires de gestion (SIG) You can view these reports on the Country-Specific Reports page, which is provided by the Country- Specific Reports SuiteApp. The new version also provides saved search-type Lettrage reports, which list matched transactions by customer and vendor. ## Saved Searches for FEC Compliance To aid in validating transactions, France Localization SuiteApp version 2.03.0 provides saved searches that list transactions that do not conform to the requirements of the Fichier ďEcritures Comptables (FEC). ## France VAT Reports for Cash Basis and Accruals To fulfill the VAT reporting requirement in France, customized VAT reports are provided in version 2.03.0 so that you can declare VAT on accruals or cash basis depending on the nature of the goods sold. ## France DEB Reports Updates In version 2.03.2, the Declaration of Exchange of Goods (DEB) reports have been adjusted to include changes brought by Brexit. Dispatches and arrivals between France and the United Kingdom are now correctly classified for the various obligations. ## Ireland Localization Enhancements ## Ireland Localization SuiteApp version 1.01.0 contains adjustments in the Intrastat report for Ireland because of Brexit. Dispatches and arrivals between Ireland and the United Kingdom are now correctly classified for the various obligations. For more information, see the help topic Ireland Localization. ## Japan Localization Enhancements The following are enhancements included in Japan Localization SuiteApp version 2021.1.0: - Autoupdate of Failed Invoice Summary Generation Jobs - Tax Registration Number on Invoice Summary - Automatic Due Date Calculation on Vendor Credits - Generating Invoice Summary PDF per Customer - Invoice Summary File Name Format ## Autoupdate of Failed Invoice Summary Generation Jobs When the Japan Localization SuiteApp is upgraded to version 2021.1, a script triggers automatic updating of any failed invoice summary generation jobs or those with Error, Hanging or Queued status. The autoupdate involves changes to failed or pending invoice summary generation jobs, to make them compatible with the new feature, Individual Customer PDF Printing. Autoupdate is only triggered for accounts with the Japan Localization SuiteApp already installed (not new installation) and have failed invoice summary generation jobs, whose data will undergo updating. After autoupdate is complete, administrators will receive email notification with the details and results of the process. Successfully updated generation jobs will be restored on the Invoice Summary Generation ## Status page. Then, you can run those generation jobs again on the Generate Invoice Summary page. But if generation jobs failed updating, the administrator will need to run the update script again as a recovery process. This is done by editing the relevant script deployment record and clicking the Save and Execute. Note: This autoupdate will only run in this release or upgrade of the Japan Localization SuiteApp to version 2021.1. Subsequent releases or upgrades will not run the autoupdate process. ## Tax Registration Number on Invoice Summary A new field enables you to specify your company’s tax registration number for inclusion on invoice summaries. The Tax Registration Number field requires 14 characters, beginning with T, followed by the 13-digit Japan corporate number. The field is available on the Japan Localization Setup subtab on Japan subsidiary records for OneWorld accounts. If you do not have a OneWorld account, this field is available on the Company Information page. Starting 2023, the tax registration number that you enter will be included in generated invoice summary PDF files. For more information, see the help topic Including Tax Registration Number on Invoice Summaries ## Automatic Due Date Calculation on Vendor Credits In version 2021.1.0, the payment terms specified for a Japan vendor are automatically applied to and calculated when you enter credits for that vendor. When entering a vendor credit from Transactions > Payables > Enter Vendor Credits, the Due Date field is automatically populated with the date of the payment terms specified on the vendor record. Also, bills created for the vendor will automatically specify the values for Closing Date and Due Date according to the dates specified in the vendor payment terms. If the due date falls on a holiday or weekend, it is automatically adjusted according to the Due Date Adjustment option that you selected on the vendor payment terms. For more information, see the help topics Japanese Billing Cycle and Payment Terms and Setting Up Japanese Payment Terms. ## Generating Invoice Summary PDF per Customer Checking the new Generate Individual PDF for Each Customer box will generate separate invoice summary PDF files per customer. ## For OneWorld accounts, this preference is available on Japan subsidiary records, on the Japan Localization Setup subtab, under Invoice Summary. If you do not have a OneWorld account, this preference is available on the Company Information page. For more information, see the help topic Generating Invoice Summary PDF per Customer. ## Invoice Summary File Name Format In version 2021.1.0, the file name format you prefer for invoice summaries can be selected in the new Invoice Summary File Name dropdown field. ## For OneWorld accounts, this field is available on Japan subsidiary records, on the Japan Localization Setup subtab, under Invoice Summary. If you do not have a OneWorld account, this field is available on the Company Information page. For more information, see the help topic Invoice Summary PDF File Naming. ## Localization Assistant Features The Localization Assistant SuiteApp enables you to identify and install the SuiteApps that are mandatory to a specific location. This SuiteApp also lists recommended NetSuite SuiteApps that are optional based on the best practices in your country of operation. Localization Assistant also supports NetSuite Record Localization Context feature. Currently, this SuiteApp is available only for Mexico. For more information, see the help topic Localization Assistant SuiteApp. ## Netherlands Localization VAT Report Enhancements ## Netherlands Localization SuiteApp version 1.02.0 provides new filters for setting up a compliant Periodic VAT Return OB69. These filters enable you to include expenses, billable expenses, and journals in VAT reporting. You can add these filters to the appropriate report boxes using the Tax Return Setup page provided by the Tax Reporting Framework SuiteApp. These enhancements are applicable only to NetSuite accounts using SuiteTax. For more information, see the help topic Netherlands Localization. ## Netherlands Localization Intrastat Reports Updates Netherlands Localization SuiteApp version 1.03.0 includes updates in the SuiteTax-based Intrastat Supplementary Declaration reports to accommodate changes brought by Brexit. The updated Intrastat reports meet the following conditions: - Only item types classified as goods are displayed in the Intrastat Arrivals and Intrastat Dispatches reports. - For exports to other EU countries including Ireland, only intracommunity sales tax transaction type are included in the Intrastat Dispatches report. - For imports to other EU countries including Ireland, only intracommunity purchases tax transaction type are included in the Intrastat Arrivals report. For more information, see the help topic Netherlands Localization. ## 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 - Set Account Mapping Type - Minor Enhancements to Norway Tax Reports ## 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 balances 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 will be used instead. Opening balances of Profit and Loss accounts at the beginning of every accounting year will then move 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 list, select Yes. ## Set Account Mapping Type Previously, the SAF-T report simultaneously uses two elements to display mapping: Standard Account ID and the combination of Grouping Category and Grouping Code. In the latest version of the Norway Tax Reports SuiteApp, this behavior is changed to reflect the requirements of Norway audit authorities. You can now select the mapping category applicable to your company. To do this, click the Setup Norway ## SAF-T button on the Country Tax Reports page and select a value in the Account Mapping Type list. This setting overrides any account-specific data. The account mapping type that you select determines the mapping category that will be used in the report: - If you select 2-digit Financial Standard Accounts or 4-digit Financial Standard Accounts, the Standard Account ID is used (and the Grouping Category and Grouping Code are not shown). - If you select RF-1167 Income Statement, RF-1175 Income Statement, or RF-1323 Income Statement, the Grouping Category and Grouping Code is used (and the Standard Account ID is not shown). ## Minor Enhancements to Norway Tax Reports The latest version also contains the following minor enhancements for the Norway Tax Reports SuiteApp: - Multi-subsidiary customers, suppliers, and vendors are supported. In addition to generating reports for primary subsidiaries, you can now also generate reports for secondary subsidiaries of customers, suppliers, and vendors. - 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. Also, they are not validated for missing account numbers (which means that you do not need to map these accounts to successfully generate the SAF-T report). - 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 will be shown in the report. However, if you use a group with multiple tax codes, the value in the audit file will be NA (not applicable). - For the tax codes with a notional tax code assigned to them, the VAT rate is based on the tax rate of the notional tax code (instead of the standard tax code). - 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 of 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 ## 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. ## Portugal Invoice Certification Enhancements ## Portugal Invoice Certification SuiteApp version 1.02.0 provides the capability to generate and print a QR code on fiscally relevant documents as required by the Portugal tax and customs authority. The QR code is applied to the following printed documents with a Portugal subsidiary or customer: - Invoice - Sales order - Cash sale - Cash refund - Item fulfillment - Credit memo - Payment The QR code contains specific information, among which are the VAT amounts related to the transaction. To ensure that the QR code contains the correct VAT values and grouping, the SuiteApp enables you to assign properties to Portugal tax codes. The properties define the tax code and determine the correct tax rate that will be applied to each item on a transaction. The SuiteApp also provides PDF layout templates so that the documents are printed with the correct format and placement of certification information. The layout of the PDF templates, which are available for each supported document type, can be copied to your own templates. Formatting your documents with the provided layout templates requires the Advanced PDF/HTML Templates feature to be enabled. For more information, see the help topic Portugal Invoice Certification. ## Portugal SAF-T ## Portugal SAF-T SuiteApp enables you to generate the tax audit file SAF-T PT for Accounting version 1.04_1 that you can submit directly to the Portugal Tax and Customs Authority. The XML schema of the provided SAF-T PT for Accounting file complies with the recent requirements stipulated in Ordinance 302/2016. This SuiteApp works only with NetSuite OneWorld accounts where the SuiteTax feature is disabled. ## Installing the Portugal SAF-T SuiteApp requires the Tax Audit Files SuiteApp, Portugal Invoice Certification SuiteApp, and Tax Reporting Framework SuiteApp. The GL Audit Numbering and the Custom Transactions features must also be enabled. For more information, see the help topic Portugal SAF-T. Southeast Asia Localization Enhancements invoicing features: - Support for BIR Simplified System Registration for CAS Users - Printing Unapproved Billing Statement and Sales Invoice - Enhancement to Initial Number Field ## 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 Philippine invoicing features of the Southeast Asia Localization SuiteApp. In version 3.03.0, you can select the CAS document issued to your company by the BIR in the new field, CAS Document Issued by BIR. You can select Permit To Use (PTU) or Acknowledgement Certificate. If you select Acknowledgement Certificate, you can enter its details in two other new fields, AC Control No. (ACCN) and ACCN Issue Date. For more information, see the help topics Support for Simplified System Registration for CAS Users and Permit To Use (PTU) for Computerized Accounting System (CAS). Printing Unapproved Billing Statement and Sales Invoice invoices with pending approval status: - The status (PENDING APPROVAL) is indicated below the document type name in the header. - A DRAFT watermark is indicated across every page of PDF printouts and in the middle of the document (above the header and transaction body) on HTML printouts. For more information, see the help topics Philippines Transaction Form Mapping and Invoicing Templates and Printing Transactions with Tax Summary and Document Number. ## Enhancement to Initial Number Field The Initial Number field of the Philippine Document Numbering feature can accept any number that you want document numbering to start at. For example, 1 to 999 999 is acceptable. Previously, this field only accepted a minimum of 6 digits, as required by the BIR. With the enhancement, if you enter less than 6 digits in the field, the system automatically adds zeroes from the left to make it 6 digits and meet the BIR requirement. For more information, see the help topic Philippines Document Numbering Setup. ## Sweden Tax Reports Enhancements ## Sweden Tax Reports SuiteApp version 1.01.0 contains adjustments in the Intrastat report for Sweden because of Brexit. Dispatches and arrivals between Sweden and the United Kingdom are now correctly classified for the various obligations. For more information, see the help topic Sweden Tax Reports SuiteApp. United Kingdom Localization VAT100 Report and Intrastat ## Report Updates The United Kingdom Localization SuiteApp version 1.03 now supports two types of report templates for Periodic VAT return – VAT100 and Intrastat reports. One type is for the period before Brexit and the second one for the period after Brexit. ## Use the following report templates for the period before Brexit (earlier than 2021): - Periodic VAT return – VAT100 (pre-2021) - Intrastat – Dispatches (pre-2021) - Intrastat – Arrivals (pre-2021) ## Use the following report templates for the period after Brexit: - Periodic VAT return – VAT100 - Intrastat – Dispatches - Intrastat – Arrivals For more information, see the help topic United Kingdom Localization. Manufacturing SuiteApps Following is the 2021.1 manufacturing enhancement to SuiteApps: ## Routing Work Order Support in Manufacturing Mobile ## Manufacturing Mobile SuiteApp version 2021.1 adds support for work orders with routing. This enhancement enables the Suiteapp to collect data and also process and report work orders with routing using a scanner. You can do the following when routing is enabled in the Manufacturing Mobile SuiteApp: - Select or scan a WIP work order with routing for a work center. - Report work done for an operation step for a WIP work order. The following features are also available when routing is enabled in the Manufacturing Mobile SuiteApp: - Support for ad hoc, real-time, and end-work builds for WIP work orders with routing. - Enhanced saved searches for production managers to include operation step data. - Operation step information in Help menu pages. ## Non-Profit SuiteApps This release note was updated July 28, 2021. ## Following are the 2021.1 non-profit enhancements to SuiteApps: - NFP Financials Enhancement - NFP Constituent Management Enhancement - NFP SuiteApps Update Verification Now Available - Expense Commitments and Budget Validation Enhancements - Social Impact Standard Edition Enhancement ## NFP Financials Enhancement The NFP Financials SuiteApp version 1.01.6 now includes these saved search reports: - LYBUNT (Last Year But Not This Year) – This report lists constituents who donated in the last fiscal year but did not donate again in this fiscal year. - SYBUNT (Some Year But Not This Year) – This report lists constituents who donated before the first day of the last fiscal year but did not donate again in the last or current fiscal year. For more information, read the help topic Non-Profit LYBUNT and SYBUNT Reports. ## NFP Constituent Management Enhancement The NFP Constituent Management SuiteApp version 1.01.5 now includes a soft credits feature. This feature helps nonprofit organizations recognize constituents who helped bring in a donation. With a donation, only the donor constituent who makes the payment is credited for the donation. With soft credits, multiple constituents can be given credit for a donation. Nonprofit organizations can view the soft credit amounts in the giving history and giving pattern of a constituent. For more information, read the help topic Soft Credits. ## 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. Expense Commitments and Budget Validation Enhancements enhancements: - Support for standard budgets – The SuiteApp now works with standard NetSuite budgets that do not have any custom segments. - Budget validation support for projects – If you have the Project Management feature enabled, you can now add Project as a field for budget validation. For more information, see the help topic Expense Commitments and Budget Validation. ## Social Impact Standard Edition Enhancement The NFP development director role is now added to the Social Impact Standard Edition SuiteApp. In nonprofit organizations, a development director's primary responsibility is to oversee fundraising. For more information, see the help topic NFP EM Development Director. ## Order Management SuiteApps This release note was updated April 21, 2021. ## Following are the 2021.1 order management enhancements to SuiteApps: - Dunning Letters Enhancements - Electronic Bank Payments Enhancements - Support for Inbound Custom Data Source in Electronic Invoicing - Same-Store Sales Report - Enhanced Validations and Defaulting Enhancements ## Dunning Letters Enhancements deprecated. However, this subtab is still visible on the Dunning Template record to ensure backward compatibility. - The Email Recipient field on the Dunning subtab is deprecated and is replaced by the following fields. However, this field is still included in the Dunning Letters SuiteApp to ensure backward compatibility. - Dunning Recipient – This multi-select field is used to store the email recipients in the To section of the email. - Dunning Recipient CC – This multi-select field is used to store the email recipients in the CC section of the email. - Add BCC Email to Sales Representative – Check this box to enable sending of email messages to sales representatives through blind carbon copy (BCC). Electronic Bank Payments Enhancements ## Processing of Vendor Prepayment Transactions ## Electronic Bank Payments SuiteApp version 2021.1 now supports processing of vendor prepayment transactions from the Instant Bank File (IBF) page. You can also generate a Positive Pay file for vendor prepayment checks. The SuiteApp generates bank files for vendor prepayment transactions created in NetSuite. You can process vendor prepayments only with Paid status. ## Support for Multi-Subsidiary Customers and Vendors You can now do the following in Electronic Bank Payments SuiteApp version 2021.1: - Use the Subsidiary field to assign a subsidiary to a bank. For accounts with multiple subsidiaries, you can assign one subsidiary to each entity bank. Also, you can assign only one Primary bank to each entity. - Create multiple bank records per entity, based on the account’s base country of operation. - Process transactions for other subsidiaries if the entity bank is set to primary and the bank templates match the subsidiary. Support for Inbound Custom Data Source in Electronic ## Invoicing Electronic Invoicing SuiteApp version 7.0 provides support for custom data source in the inbound process. You can now add custom data sources to an inbound e-document template using a custom plug-in implementation. You must first create a custom plug-in implementation and enable it in NetSuite, then select it as an inbound custom data source on a template record. ## Same-Store Sales Report ## Same-Store Sales Report is a new SuiteApp that enables retail stores and restaurants to compare the sales revenue of a store over specified periods within two different years. This SuiteApp references the sales data of a store, associated with a location record, and then displays the sales data within the compared years under selected metrics. ## Same-Store Sales Report lets you create and import custom calendars for different years. These calendars are referenced by the report or SuiteApp when you specify dates for This Year (TY) and Last Year (LY) reporting periods. This SuiteApp also includes a Same-Store Sales Preferences page where you can define the method of comparison and store settings. For the method of comparison, you can choose to do an entire year comparison or a partial year comparison. You can set the following fields on the Same-Store Sales Report page: - Store Options – Defines the type of stores, whose sales the report will compare at specified periods in two different years. You can select Comparable Stores, Non Comparable Stores, or Both. - Reporting Period – Defines the period in two different years that the report will compare store sales. You can select Day, Week, Period, Quarter, Year, or Custom. - This Year (TY) and Last Year (LY) – The two years being compared, both having Start Date and End Date fields. The date fields can be automatically filled out or manually specified, depending on the selected reporting period. - Metrics – Defines how data will be interpreted and calculated. You can select Net Sales Amount, Net Sales Quantity, Number of Sales, Gross Margin, and Gross Margin %. The report will display sales data under the metrics that you selected. For more information, see the help topic Same-Store Sales Report. Enhanced Validations and Defaulting Enhancements ## Navigation Menu Changes In Enhanced Validations and Defaulting SuiteApp version 1.00.10, the navigation menu Enable Validations/Default Discount is renamed to Enable Validations. ## Negative Inventory Validation Updates In Enhanced Validations and Defaulting SuiteApp version 1.00.10, the following are the updates to negative inventory validation: - The unbilled quantity value in the transaction record is now required to perform negative inventory validation. - When you edit item quantities in a transaction record, negative inventory is validated differently for posting and nonposting transactions. For posting transactions where the original item quantity is immediately fulfilled, the SuiteApp validates only the additional quantity requested. For nonposting transactions where the original item quantity is not immediately fulfilled, the SuiteApp validates the total of the original and additional quantity requested. ## Customer-Specific Fields for Default Discounts In Enhanced Validations and Defaulting SuiteApp version 1.00.10, when you edit a transaction and select a customer without a default discount, the values in the Discount Item and Rate fields are also removed. For more information about this SuiteApp, see the help topic Enhanced Validations and Defaulting. ## Projects SuiteApps This release note was updated August 25, 2021. ## Following are the 2021.1 projects enhancement to SuiteApps: - Purchase to Project Now Available - File Drag and Drop Update - StickyNotes Update ## 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. ## File Drag and Drop Update ## File Drag and Drop SuiteApp works only on records and transactions that use the old NetSuite UI. For its features to work as expected, project records must not be shown in the new NetSuite UI. To show projects in the old NetSuite UI, go to Setup > Company > General Preferences and clear the Show Project In New UI box. For more information about this SuiteApp, see the help topic Uploading Files Using File Drag and Drop. ## StickyNotes Update StickyNotes SuiteApp works only on records and transactions that use the old NetSuite UI. For its features to work as expected, project records must not be shown in the new NetSuite UI. To show projects in the old NetSuite UI, go to Setup > Company > General Preferences and clear the Show Project In New UI box. For more information about this SuiteApp, see the help topic Creating StickyNotes on Record Pages. Restaurant and Hospitality SuiteApps Following is the 2021.1 restaurant and hospitality enhancement to SuiteApps: ## Shelf-to-Sheet Count Enhancements The following are enhancements to Shelf-to-Sheet Count SuiteApp in 2021.1: - Number of Items in the Shelf-to-Sheet Template - Restrictions in Adding Bin, Lot Numbered, and Serialized Items ## Number of Items in the Shelf-to-Sheet Template In Shelf-to-Sheet Count SuiteApp version 1.04.0, a Shelf-to-Sheet template can contain up to 1000 items in total. The Shelf-to-Sheet Count SuiteApp can reference up to 15000 items per NetSuite account. ## Restrictions in Adding Bin, Lot Numbered, and Serialized Items In Shelf-to-Sheet Count SuiteApp version 1.04.0, further restrictions are implemented to prevent users from adding or including Bin, Lot Numbered, and Serialized inventory item types to the Shelf-to-Sheet Count. The same restrictions are also applied to kits, which also must not contain Bin, Lot Numbered, and Serialized items. For more information, see the help topics Limitations of the Shelf-to-Sheet Count SuiteApp and Setting Up the Shelf-to-Sheet Template. ## SuiteAnalytics SuiteApps This release note was updated May 26, 2021. Following is the 2021.1 SuiteAnalytics enhancement 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. For more information, see the help topic Modifying the Appearance of a Dashboard Tile. ## SuitePeople SuiteApps This release note was updated May 5, 2021. ## Following are the 2021.1 SuitePeople enhancements to SuiteApps: - Time-Off Tracking Enhancements - Onboarding and Offboarding Plans Enhancements Time-Off Tracking Enhancements Time-Off Management Updates of employees. - Time-Off Self-Approver – HR generalists can identify selected employees as time-off self-approvers. Employee self-approvers can submit time-off requests that are automatically approved. - Auto-Approval with Threshold – HR generalists now have the ability to set a time-off type that is automatically approved when requested, subject to an approval threshold. For more information, see the help topic Time-Off Management ## 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. ## Onboarding and Offboarding Plans Enhancements portlet. The portlet alerts them of due dates and enables them to visually track and update their completion status. - Welcome Message – HR administrators can customize a welcome message on new employees' onboarding email and plan. - Task and New Hire Alerts – Task assignees can now track their work on the Onboarding portlet. Company employees are now alerted of new hires and can quickly send a welcome email from the portlet. - Email Summary – HR administrators can set up scheduled email summaries of onboarding plan progress. For more information, see the help topic Employee Onboarding and Offboarding Plans. ## Taxation SuiteApps This release note was updated August 25, 2021. ## Following are the 2021.1 taxation enhancements to SuiteApps: - SuiteTax SuiteApps - Tax Reporting Framework Enhancements ▬ EU VAT One Stop Shop Report for Accounts without SuiteTax ▬ Enhanced Support for Accounts without SuiteTax ▬ Support for India SuiteTax Engine SS2 ▬ SuiteQL Support and Country Tax Reports Page Enhancements ▬ Multi-Book Accounting and Adjustment-Only Book Support - Mexico Deferred Taxes - Legacy Tax SuiteApps - 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 ▬ Tax Audit Files 1.83.1 Issue Fixes - Single Line Prompt Payment VAT Discounts for Supplementary Tax Calculation - International Tax Reports Enhancements ▬ Ireland Postponed Accounting for VAT on Imported Goods ▬ EU VAT One Stop Shop Tax Code Provisioning ▬ Belgium Support for Reporting 100% VAT Bill ▬ France Support for Reporting of Imported Services Outside of EU ▬ Germany Monthly/Quarterly VAT Return Form and XML Update ▬ United Kingdom MOSS Tax Code No Longer Provisioned ▬ Finland Support for Reporting of Services Outside of EU ▬ Germany Annual VAT Return Update ▬ United Kingdom Tax Codes, VAT 100 Form, and Intrastat Report Updates - International Tax Reports Issue Fixes ▬ International Tax Reports 3.120.0 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. Tax Reporting Framework Enhancements ## EU VAT One Stop Shop Report for Accounts without SuiteTax Note: On July 1, 2021 the official EU Mini One Stop Shop (MOSS) report was replaced by the EU ## VAT One Stop Shop (OSS) report. The reporting solution of MOSS was replaced to support EU VAT OSS return according to the reporting rules of the applicable OSS scheme. To view help topics related to MOSS, see the help topic MOSS Reporting. ## Tax Reporting Framework SuiteApp version 1.07.0 includes support for EU VAT OSS report in NetSuite select an OSS subsidiary and nexus on the Country Tax Reporting Preferences page. On the EU VAT One Stop Shop subtab, you can select the OSS scheme and enter your VAT identification number. - Import One Stop Shop VAT Return – You can now generate Import OSS VAT return. To generate the report, go to Reports > Tax > Country Tax Reports. After selecting your subsidiary and nexus, select Import One Stop Shop VAT Return in the Report Name list. Currently, only Import OSS scheme is supported by the SuiteApp. For more information, see the help topic EU VAT One Stop Shop Reports for Accounts without SuiteTax. ## Enhanced Support for Accounts without SuiteTax ## Tax Reporting Framework SuiteApp version 1.06.0 enables access to the Country Tax Reporting ## Preferences page in NetSuite accounts without SuiteTax. This page enables you to set your preferences when generating your country tax reports. To access the Country Tax Reports Preferences page, you must install a localization SuiteApp that provides a VAT report. You can configure the following settings on the Country Tax Reports Preferences page: - Period Filters - Tax Audit Files Data Filters See the help topics Setting Up Country Tax Reporting Preferences and Tax Reporting Framework Support For Accounts Without SuiteTax for more information. ## Support for India SuiteTax Engine SS2 ## Tax Reporting Framework SuiteApp version 1.06.0 includes support for India SuiteTax Engine SS2 tax engine. To use this tax engine, you must install the India Localization SuiteTax Engine SuiteApp. ## SuiteQL Support and Country Tax Reports Page Enhancements 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 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 ## Multi-Book Accounting and Adjustment-Only Book Support Tax Reporting Framework now supports Multi-Book Accounting. You can generate tax reports using specific accounting books other than your primary book. To use Multi-Book Accounting and Adjustment-Only Book with the Tax Reporting Framework SuiteApp, you must install a localization SuiteApp that provides localized tax reports that support these features. For more information, see the help topic Multi–Book Accounting and Adjustment-Only Book Support in Tax Reporting Framework. ## Mexico Deferred Taxes ## Mexico Deferred Taxes SuiteApp version 1.00 enables you to record deferred taxes for businesses operating in Mexico in accordance with Mexico tax laws. The SuiteApp is now generally available and can be installed from the NetSuite SuiteApp Marketplace (Application ID: com.netsuite.mexicodeferredtaxes). It is a public and managed SuiteApp. ## Mexico Deferred Taxes SuiteApp provides the following features and capabilities: - Mexico Deferred Taxes Setup – You can configure Mexico deferred taxes and specify target accounts for all deferred tax types. The SuiteApp includes default tax accounts based on the official Mexico SAT (Servicio de Administración Tributaria) Chart of Accounts. For more information, see the help topic Setting Up Mexico Deferred Taxes. - Mexico Deferred Taxes Process – At period end, you can run this process to perform accounting adjustments on your Mexico deferred taxes balances. When you run this process, custom transactions and journal entries are generated to reflect all payments made, and taxes are moved from transitory to target accounts. For more information, see the help topic Running the Mexico Deferred Taxes Process. - Mexico Deferred Taxes Report – You can generate a report to validate the amount of deferred taxes due from your transactions for a particular accounting period and subsidiary. The values obtained from this report can be manually added to the official tax form on the Mexico tax authority (SAT) portal. For more information, see the help topic Generating the Mexico Deferred Taxes 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. 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: - 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. Tax Audit Files 1.83.1 Issue Fixes specific Intra-Community Transaction reports. - France FEC Report - The report now includes Period End Journals (PEJ) balance sheet opening entries if the posting period is within the period range of report generation. - OECD SAF–T Report – The report is updated to successfully convert the XML file to Excel file format. - TAF Report - Primary is now available as an option in the Accounting Book field of the Audit Files report page. Single Line Prompt Payment VAT Discounts for Supplementary Tax ## Calculation ## Supplementary Tax Calculation SuiteApp now supports applying tax discounts as credit memos in a single transaction line for early payments. This is part of the Prompt Payment Discounts feature. Enabling this feature calculates tax discounts that will be displayed as a credit memo in a single line, grouped according to the applied tax code. This is only applicable when Tax Rounding Level is set to Item Line Level in Setup > Accounting > Set up Taxes >Tax Rounding Level. To use this feature, see the help topic Setting Up Prompt Payment Discount Preferences. 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 - 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 ## Tax Codes Description Tax Properties - 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: - 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 a 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. ## Belgium Support for Reporting 100% VAT Bill ## International Tax Reports version 3.119.0 includes support for reporting 100% VAT bill in the Belgium VAT report. The update includes automatic provisioning of the following tax code to newly created Belgium subsidiaries and nexuses: Tax Code Description Tax Properties ## IV-BE 100% VAT bill ■ Rate of 0% - Effective from January 1, 2020 - Import VAT - Available on Purchase transactions The Belgium VAT report is also updated to properly report the IV-BE tax code on Box 57: VAT due on imports. For more information about Belgium tax codes and VAT report, see the help topics Belgium Tax Codes and What goes into each box – Belgium VAT report. ## France Support for Reporting of Imported Services Outside of EU ## International Tax Reports version 3.119.0 includes support for reporting of imported services outside of EU in France. The update includes automatic provisioning of the following tax codes to newly created ## France subsidiaries and nexuses: ## Tax Code Description Tax Properties IS1-FR Purchase of services from outside the EU - standard ■ Rate of 20% rate - Effective from January 1, 2020 - Applies to Service Items - Import - Available on Purchase transactions IS2-FR Purchase of services from outside the EU - reduced ■ Rate of 10% rate (10%) - Effective from January 1, 2020 - Applies to Service Items - Import - Available on Purchase transactions IS3-FR Purchase of services from outside the EU - reduced ■ Rate of 5.5% rate (5.5%) - Effective from January 1, 2020 - Applies to Service Items - Import - Available on Purchase transactions IS4-FR Purchase of services from outside the EU - super ■ Rate of 2.1% reduced rate - Effective from January 1, 2020 ## Tax Code Description Tax Properties - Applies to Service Items - Import - Available on Purchase transactions The France VAT report is also updated to properly report IS1-FR, IS2-FR, IS3-FR, and IS4-FR tax codes in the following boxes accordingly: - Box 0981: Other Taxable Revenue - Box 0207: Normal Rate 20% - Box 0105: Reduced Rate 5.5% - Box 0151: Reduced Rate 10% - Box 0100: Reduced Rate 2.1% To learn more about France’s new tax codes and VAT form update, see the help topics France Tax Codes and What goes into each box – France VAT report. ## Germany Monthly/Quarterly VAT Return Form and XML Update ## International Tax Reports version 3.119.0 includes updates to the Germany Monthly/Quarterly VAT Return to comply with the German tax administration. Two new country forms are now available on the Tax ## Reports (International) page when you choose a 2021 tax period: - Germany (Deutsch) 2021 - Germany (English) 2021 To learn more about the Monthly/Quarterly VAT Return 2021 form, see the help topic What goes into each box – Germany Monthly/Quarterly VAT report. The update also includes enhancements to the XML file of the Germany Monthly/Quarterly VAT Return for compatibility in Küppers Software’s e-filing tool, ElsterTransit. For more information about using ElsterTransit as an e-filing solution, see the help topic Submission of VAT Returns in Germany. ## United Kingdom MOSS Tax Code No Longer Provisioned ## Beginning January 1, 2021, the MOSS scheme no longer applies to United Kingdom. International Tax Reports version 3.119.0 discontinues the provision of the MOSS tax code (S-AT-GB) to United Kingdom subsidiaries and nexuses. ## Finland Support for Reporting of Services Outside of EU International Tax Reports version 3.118.0 includes automatic provisioning of the following reverse charge tax codes to newly created Finland subsidiaries and nexuses: ## Tax Code Description Tax Properties RCIS1-FI Reverse charge for import of services from outside EU ■ Rate of 0% (standard rate) - Effective from January 1, 2020 - Reverse Charge Code - Notional Rate Derived from S-FI - Applies to Service Items - Import - Available on Purchases ## Tax Code Description Tax Properties RCIS2-FI Reverse charge for import of services from outside EU ■ Rate of 0% (reduced rate) - Effective from January 1, 2020 - Reverse Charge Code - Notional Rate Derived from R1-FI - Applies to Service Items - Import - Reduced Rate - Available on Purchases RCIS3-FI Reverse charge for import of services from outside EU ■ Rate of 0% (special reduced rate) - Effective from January 1, 2020 - Reverse Charge Code - Notional Rate Derived from R2-FI - Applies to Service Items - Import - Special Reduced Rate - Available on Purchases The Finland VAT report is also updated to properly report RCIS1-FI, RCIS2-FI and RCIS3-FI tax codes in the following boxes: Box Label Reported Tax Code Tax on domestic sales at 24% tax rate RCIS1-FI Tax on domestic sales at 14% tax rate RCIS2-FI Tax on domestic sales at 10% tax rate RCIS3-FI ## Tax deductible for the tax period RCIS1-FI, RCIS2-FI, RCIS3-FI To learn more about the new tax codes and Finland VAT form update, see the help topics Finland Tax Codes and What goes into each box – Finland VAT Report. ## Germany Annual VAT Return Update ## International Tax Reports version 3.118.0 supports Germany's COVID-19 tax response on annual VAT reporting. The Germany Annual VAT Declaration form is updated to reflect the reduced tax rates in the following boxes: Box Number Box English Label 155 Sales at other tax rates 156 Sales at other tax rates 798 at other tax rate ……. 799 at other tax rate ……. 846 Taxable other services of a company based in other Community zone (§ 13b para. 1 UStG) ........... 847 Taxable other services of a company based in other Community zone (§ 13b para. 1 UStG) ........... Box Number Box English Label 877 Other services (§ 13b Abs. 2 Nr. 1, 2, 4 bis 11 UStG) .... 878 Other services (§ 13b Abs. 2 Nr. 1, 2, 4 bis 11 UStG) .... 320 Input tax amounts from invoices from other companies (§ 15 para. 1 sent. 1 no. 1 UStG) ....... To learn more about Germany’s COVID-19 tax response and Annual VAT form updates, see the help topics Germany COVID-19 Tax Response: Temporary Tax Codes and What goes into each box – Germany Annual VAT Declaration. ## United Kingdom Tax Codes, VAT 100 Form, and Intrastat Report Updates International Tax Reports 3.118.0 supports automatic provisioning of import tax codes for postponed VAT accounting to newly created United Kingdom subsidiaries or nexuses: ## Tax Code Description Tax Properties IPA1-GB Postponed import VAT on goods purchased from EU and ■ Rate of 0% non-EU countries - Effective from January 1, 2021 - Reverse Charge Code - Notional Rate Derived from S-GB - Import VAT - Available on Purchases IPA2-GB Postponed import VAT on goods purchased from EU and ■ Rate of 0% non-EU countries - Effective from January 1, 2021 - Reverse Charge Code - Notional Rate Derived from R-GB - Import VAT - Reduced Rate - Available on Purchases To learn more about United Kingdom tax codes, see the help topic Creating Tax Codes - United Kingdom. The United Kingdom VAT100 Form and Intrastat Report (Arrivals) are also updated to properly report the movement of goods between: Great Britain and the EU, and Northern Ireland and the EU. Included in this update are two country forms for Intrastat Supplementary Declaration Arrivals, namely: Great Britain (English) 2021 and Northern Ireland (English) 2021. For more information about the U.K. VAT100 form and Intrastat Report updates, see the help topics What goes into each box – United Kingdom VAT100 report and Intrastat Report for United Kingdom. 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 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 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. ## Vendors, Purchasing, and Receiving SuiteApps This release note was updated September 8, 2021. Following is the 2021.1 vendors, purchasing, and receiving enhancement to SuiteApps: ## Inbound ASN Automation The Inbound Advance Ship Notice (ASN) Automation SuiteApp automatically creates inbound shipment records from advance ship notices received from the vendor. This SuiteApp enables you to: - Create and manage ASNs. - Import ASNs through CSV and Web Services. - Define tolerance limits for receiving item overages at the item, vendor, and company levels. - Set preferences to create purchase order or edit existing purchase order to receive item overages. - Approve or reject ASNs with item overages. Inbound ASN Automation is a managed SuiteApp and is available for installation from the SuiteApp Marketplace. For more information, read the help topic Inbound ASN Automation. ## Wholesale Distribution SuiteApps This release note was updated September 8, 2021. ## Following is the 2021.1 wholesale distribution enhancement to SuiteApps: - Deduction and Chargeback Management - Support for Custom NMFC Values in Bill of Lading - Increased Limit for Item Fulfillments Search in Bill of Lading ## Deduction and Chargeback Management The Deduction and Chargeback Management SuiteApp enables the A/R Clerk role to efficiently account for customer deductions, chargebacks, and small balances write-offs. Using this SuiteApp, you can do the following: - Automatically identify short payments and apply deductions - Split invoices to apply deduction as well as chargeback to the same invoice - Set limits for small balances write-offs per currency type - Scan invoices at a scheduled interval to write off small balances - View all deduction management records in one place The SuiteApp is available and can be installed from the NetSuite SuiteApp Marketplace. For more information, see the help topic Deduction and Chargeback Management. ## Support for Custom NMFC Values in Bill of Lading ## Bill of Lading SuiteApp version 1.0.103 enables you to use custom National Motor Freight Classification (NMFC) numbers for your items. You can now edit the NMFC list to add custom values, which you can use when assigning NMFC code in item fulfillments. The Value field in the NMFC list accepts alphanumeric and special characters, but you should avoid using the ampersand (&), greater than (>), and less than (<) symbols. Using these characters may cause issues when printing the bill of lading document. For more information, read the help topic Adding an NMFC Custom Value ## Increased Limit for Item Fulfillments Search in Bill of Lading In Bill of Lading SuiteApp version 1.00.4, you can retrieve item fulfillments for sales orders and transfer orders up to the maximum limit allowed in your NetSuite account. Previously, the SuiteApp can process up to a maximum of 4000 item fulfillments only. For more information, read Searching Item Fulfillments on Print Bill of Lading Page.