ONESOURCE Determination 2023.6 Release Notes

Release highlights

Published: November, 2023
  • Custom currency rules are now part of the export and import processes.
  • The value in the invoiceNumber of a JSON file for the REST tax calculation web service is now visible in the
    contentId
    column of the Unified Logging page.
  • A new document rounding logic is available for transactions where both the gross amount and the tax rates can be positive or negative.

New features

The topics below describe features added with this release.
Fee On Capacity - New Calculation Method (992924)
This release introduces an alternate calculation method for a rule that uses the
Fee On Capacity
calculation method. This alternate calculation method is followed only when the
Fee on Capacity Alternate Calculation
company admin option is set to
Yes
. You can find this option for a company under the Company Admin Options section on the Tax Logic & Company Admin page.
The steps for the alternate calculation method include:
  1. Capacity
    passed in the transaction invoice line
    * Fee
    set for the authority rule.
  2. The value obtained as a result of this is rounded based on the third decimal value being 5 or above. This is considered as the fee charged for the capacity in transaction.
  3. The rounded value obtained from above
    * Quantity
    passed in the transaction invoice line equals the tax charged for the authority.
Custom Currency Rules
Customers can now create custom currency rules in ONESOURCE Determination using the Currency Rules feature (click
Configuration
,
Currency Data
then
Currency Rules
to access) when the defined currency rules per tax regulations are unavailable. Currently, the Currency Rules page in ONESOURCE Determination displays the system level currency definitions for rounding rules, rounding precision and the minimum accountable unit for currencies. The customer can add a custom currency rule for a specific company by defining the rounding rule, rounding precision, minimum accountable unit, and the duration for which it will be active. The
Filter
drop-down list allows the customer to filter data based on multiple selection criteria, such as company, currency, start date and rounding precision. The
View in Excel
functionality can be used to export data displayed on the page to an Excel spreadsheet.
Unified Logging - Invoice Number as Content ID (963170)
The value in the invoiceNumber of a JSON file for the REST tax calculation web service is now visible in the
contentId
column of the Unified Logging page (select
Tools
,
Tax Tools
then
Unified Logging
to access). On this page, you can search using the invoiceNumber as a filter to obtain a specific request or response file.
New Rounding Logic for Invoices with Both Negative and Positive Gross Amounts and Tax Rates (938908)
A new document rounding logic is available for transactions where both the gross amount and the tax rates can be positive or negative. The tax engine applies the following steps:
  1. The tax engine sums all unrounded tax amounts for each line regardless of the gross amount, authority rigger or tax rate applied.
  2. The sum of the unrounded tax amounts is rounded based on your specified rounding precision.
  3. The rounded amount is compared to the sum of the rounded tax amounts of all tax lines.
  4. If there is any penny difference, the penny is adjusted to match the highest rounded tax amount value regardless of its sign.
OSS Scheme for Domestic Electronic Interface Transactions (478483)
The One Stop Shop (OSS) Union scheme is now applicable to domestic intra-country transactions for goods that meet the following conditions:
  • The supply of goods is facilitated using an electronic interface.
  • The supplier is not established in the EU (Seller Primary = non-EU country).
  • The transport of goods occurs in one EU country (Ship From = Ship To = EU country).
For these transactions, the OSS elected authority must be registered. To support this, the new
Electronic Interface
authority option was added for relevant authorities tied to the international tax data content. You can add this as an option for any applicable authority using the Authority Options page (select
Configuration
,
Authorities
then
Authority Options
to access).
Addition of India Tax for B2B ES International Transactions (941761)
For B2B cross-border Electronic Services (ES) transactions to India (from, for example, the U.S. or the United Kingdom) that are sale transactions (Seller is the company role), ONESOURCE Determination now provides the India tax block (as NL tax type) in addition to the existing seller country tax block (also as NL tax type). The India tax block has a DPI code of INSSIGST4 and a direction of O (for Output).
In addition, both the buyer and seller registration numbers are available in the response (output) from the tax engine. This is audited and available for reporting purposes.
Export and Import of Custom Application Message (960331)
As part of the 2023.4 release, support for custom application messages was enabled. The custom data created is now a part of the company export and import process (select
Tools
,
Administration
then
Export and Import
to access). This allows the custom data to also be a part of of a company’s data migration process within the Cloud environment.
Export and Import Includes Tenant ID (960331)
Multi-tenant environment support was enabled with the 2023.4 release. With the same company name being allowed in multiple tenants, there was no indication in the export file (created using the export and import process) as to which tenant the data was exported from.
The ID of the tenant from which the export occurred is now included in the export file.
Brazil – PMC as Taxable Basis for ICMS-ST in SP State - Pharma Segment (918610, 952861 and 567479)
For the pharma segment, the ICMS-ST calculation can now use the PMC value as the taxable basis for operations in SP state.
When the PMPF type
None
is used for the pharma segment, the law published by Sao Paulo State establishes that the PMC must have the greatest value when comparing between the IVA and PMC values for taxation. Furthermore, no other value can be greater that the PMC for it to be used as the taxable basis for ICMS-ST.
Legislation that supports this requirement includes:
  • Resposta à Consulta RC 24315/2021
  • Portaria SRE 116/2022

Fixes

The topics below describe previously known issues that have been fixed with this release.
Tax Amount Rounding Issues for Reverse from Tax Calculations (936926)
For reverse from tax calculations, the input includes the gross amount and tax amount elements and ONESOURCE Determination recalculates the invoice total gross amount and total tax amount based on those input elements. An issue was identified where the input line tax amount and the recalculated invoice total tax amount did not match due to rounding. This issue was corrected for U.S., Canada and Brazil calculations that follow the penny pitching algorithm within the invoice line level.
Italy Document Rounding Issue (938838)
An issue was identified with rounding reverse charge transactions in Italy. The issue is resolved now. The rounding logic was enhanced for scenarios that trigger tax types with dual directions (where the direction input and output tax amounts offset each other in the tax result). Some examples of such tax types are reverse charge, import and acquisition.
When an invoice has only reverse charge tax type (or any other tax types that trigger input and output direction) lines:
  1. The tax engine sums up the gross amounts (A) and multiples the applicable tax rate (B) to calculate the unrounded total tax amount for the invoice (C). This is expressed as:
    C = A * B%
  2. The tax engine then rounds it as per the rounding specification of the authority (D). This is expressed as:
    D = C Rounded
  3. The tax engine then totals all the rounded tax amounts at each line. This includes both input and output amounts (E).
  4. The tax engine then compares D and E. Any penny difference between A and B is then adjusted to the line with the highest gross amount.
  5. The penny adjustment is made to both input and output amounts so that the line input and output amounts offset each other, and the total input and output tax amounts of the invoice also offset each other.
When an invoice includes other tax types as well as a reverse charge (or any other tax type (for example, import or acquisition) with direction input and output), the tax engine uses the steps above to perform separate document rounding for the lines with a reverse charge tax type and the lines without a reverse charge tax type.
Japan - Incorrect Registration Number Consideration (841292)
An issue was identified with Japan transactions where, if the registration number of the company is already setup in ONESOURCE Determination and there is a purchase transaction (or a buyer role), the buyer registration number (which was set up for the company and used from the setting as expected) was also used for the seller side if it was not provided by the vendor. This is now corrected. The registration number setup for the company is correctly used based on the company’s role in that transaction (seller or buyer).
MigrationDefault Customer Group (957076)
ONESOURCE Determination Original customers who are migrated to ONESOURCE Determination - Enterprise Cloud using the Migration Tools utility, would see the customer group (shown in the Customers drop-down list on the company's Groups & Inheritance page) defaulted to MigrationDefault. This was implemented to provide a default customer group name when no active customer group existed for the migrating company in the ONESOURCE Determination Original application. However, this created issues with certain pages. For example, options were not saved on the company's Tax Logic & Company Admin page.
A correction was made so that such companies now have DEFAULT as the customer group name for the specific company. DEFAULT is the default customer group name assigned to a company created directly in the ONESOURCE Determination - Enterprise Cloud application.
Export and Import Pages Upgraded to Angular NG (941546)
The Export and Import pages were upgraded to the latest Angular version for improved performance, enhanced security, overall stability and reliability.
Migration Tools Upgraded to Angular NG (836028)
The Migration Tools pages were upgraded to the latest Angular version for improved performance, enhanced security, overall stability and reliability.
Incorrect Migration of Exemption Certificate Data (820793)
If you used the Exemption Certificate tool before and after migration, you can view all of the migrated certificates.
Essentially, for certificates that were originally created before migration with zone configurations, the selected configurations for the authority type and the specific zones or provinces were missing from the frontend. The certificates worked as if the configurations existed and the backend showed the zone configurations. Incorrect data was shown on the frontend, which was fixed as part of this release.
Export or Download of Multiple Customer Certificates from Reports Certificate Manager (905399)
An error occurred when attempting to download the Certificate Manager report with images in either a .CSV or Excel format. This issue is fixed.
Document for LIKE Operator Wildcard Characters (918751)
Customers can now use the ^ (caret) and % (percent) wildcard characters for the LIKE operator.
Repeat Customer Exemption Error (923783)
Exemption certificate shows Blanket for customer environment but shows Limited on the Backend. This issue was fixed in the previous release.
UAT North Carolina Jurisdiction Setup (938084)
Client was unable to add North Carolina as a jurisdiction. The jurisdiction can be selected but cannot be saved. This issue was fixed. The customer can now add and save North Carolina as a jurisdiction.
Unable to Add Registration Number for Canadian Authorities (939113 and 929674)
Customer is receiving an error when trying to add registration numbers for the following Canadian authorities: Alberta, New Brunswick, Newfoundland, Northwest Territories Fees, Nova Scotia, and Yukon in ONESOURCE Determination. The error message is: "An error occurred while saving tax jurisdiction. Reason(s): Status 412. Message There was an error while data was being saved." The option to add registration for Canada is not working only for a specific company.
Currency Rate End Date Limitations (946819)
Customer migrated from ONESOURCE Determination Original to ONESOURCE Determination - Enterprise Cloud was viewing a restriction on currency rate end dates. This restriction is currently set at 90 days. The restriction on the end date was removed and the issue is resolved.
Tax Amount Rounding Resulting in Incorrect Tax Amount (919621)
Document rounding is not working for Italy if the invoice has both positive and negative amounts. Taxes are rounding at the line level first then rounding at the document level. This issue was fixed as part of the current release.
Issue with Tax Response Filter (962647 and 962505)
The customer is unable to create a tax response filter for a UK company and receives a “Status 400 Message Null” notification. The Issue was intermittent and was fixed.
Canada VCTV (949281 and 946989)
The Vendor Charged Tax Verification (VCTV) for Canada is verifying all authorities and their corresponding taxes, not just PST. This includes GST and HST scenarios, which creates false holds on all VCTV for Canada when the calculated tax does not match the vendor charged tax. This issue is resolved by splitting vendor tax for CANADA PST invoices.
Error Occurred while Setting Tax Exemption in ONESOURCE (964679, 968171 and 965529)
The customer receives the following error when trying to add a certificate in Certificate Manager: “An error occurred while updating the certificate: Reason(s): Error: No record found for Customer number and Group ID. Your certificate has been saved but the sync with Determination has failed.” The issue can occur if the customer’s name is too long and the email in contact information ends with .edu instead of .com. The solution is to create a customer record where the customer number does not have a blank space at the end and is linked to the certificates so that the system can read them properly.
Authorities Cannot Be Turned Off (962274 and 962372)
A customer is forced to select a tax data type when
Configuration
then
Authority Options
was selected. In the UAT environment, the customer can select one (a Country drop-down list displays or a country can be entered). However, in the Production environment, nothing is available for selection (no drop-down list displays and the country cannot be entered). This issue was fixed. The customer is able to make selections from the drop-down list in the Production environment.
Brazil - Incorrect IVA Adjusted Rate Displayed for ICMS-ST Type 2 for Cases where the Destination ICMS Rate Is Not Equal to the ICMS-ST Rate (951304)
The issue was fixed for the Desonerado Type 2 inclusive calculation method.
Brazil – Changed Severity for Message NEGATIVE_ICMS_ST_AMOUNT_CALCULATED (950579)
The severity changed from Error to Warning for the NEGATIVE_ICMS_ST_AMOUNT_CALCULATED message when the ICMS ship from amount is greater than the ICMS ST amount.
Brazil – Add System Messages for PMPF, ICMS-ST and PAUTA (949665)
System messages were added when the mandatory authorities are triggered for a transaction.
The following message block was added under the Authority - ICMS PMPF state tax block:
Brazil - Enhancements Related to Unit of Measure (950637 and 953968)
When there is a mismatched unit of measure (UoM) category for the PMPF tax, the calculation now stops and theMISMATCHED_UOM_CATEGORIES message displays.
When the UoM is excluded in the request and the rule includes a UoM, the calculation stops and the UOM_NOT_SPECIFIED message displays.

Known Issues

There are no known issues in this release.

Related Content