ONESOURCE Determination 2023.4 Release Notes

Release highlights

Published: September, 2023
ONESOURCE Determination version 2023.4 includes bug fixes and introduces the following features:
  • ONESOURCE Determination provides the ability to duplicate a company across multiple tenants within the same environment.
  • For the oil and gas industry, additional tax types were added to support the existing motor fuel-related tax types in ONESOURCE Determination.
  • System application messages in the CALCULATION category can be customized.

New Features

The topics below describe features added with this release.
Multi-Tenant Environment Support (458427, 481974, 492912 and 666611)
ONESOURCE Determination - Enterprise Cloud has been updated to provide customers with the ability to duplicate their company - including the company name and other relevant attributes- across multiple tenants within the same environment. Previously, there was a restriction that prevented the creation of the same company name and attributes more than once, but this limitation has now been removed.
This eliminates the need for customers to create dummy companies in order to simulate their setup across different tenants, such as in the UAT (User Acceptance Testing) environment. As a result, it also facilitates the seamless migration of configuration data between tenants. The tenant where the company is created is now treated as a unique attribute, in addition to the merchant's name and ID, when uniquely identifying companies and their associated data.
Oil and Gas - Additional Motor Fuel Tax Types (893212)
Additional Tax Types have been added to support the existing Motor Fuel-related tax types in Determination. The new tax types are:
  • Motor Fuel Export – MFX
  • Motor Fuel No Liability – MNL
  • Motor Fuel Reduced Rate – MFR
  • Motor Fuel Established – MFS
Adding these tax types allows our Tax Research team to create additional standard content regarding motor fuel-related tax transactions. The new tax types also allow our customers to create custom content to drive relevant tax results.
Oil and Gas - Copy Custom OLTM (896804)
Related to tax exemptions that can be applied as part of Motor Fuel or Movement transactions, Determination now supports creating custom content for Operating License Types, one of them being custom Operating License Type Mapping (OLTM) tied to an authority.
Additional support is now provided that allows copying an existing custom OLTM record so that its data can be used as a basis for creating a new record. Note that the new record can't be an exact copy of the old one, or of an existing record, since each record created within a date range must be unique.
As a part of this support, there's a new
More
drop-down list. The
Copy
and
Delete
buttons were moved under the More menu.
Custom Application Messages (865097)
Customers can now customize system application messages (select
Configuration
,
Advanced Setup
then
Application Messages
to access) in the CALCULATION category. On the Application Messages page, select
OVERRIDE
to customize the
Title, Severity, Description, Cause, and Required Action
fields for a message.
Override capability must be set up for each company (parent and child company) because these messages don't follow the application’s auto-inheritance policy.
Brazil – To Inform the Values Excluded from PIS COFINS Taxable Basis in XML OUT - BR Regulations (871126, 874571 and 894136)
To comply with a legal requirement to fill a fiscal book obligation called SPED Contribuições, the ICMS/ICMS-DIFAL/ICMS-FCEP amounts, when calculated and excluded from PIS and Cofins taxable basis, must be informed in the XML Out under the PIS and COFINS tax group.
A new tag,
<EXCLUDED_PIS_COFINS_AMOUNT>
, was added to the output under the line level tax summary block for SOAP 2011, 2020 and REST services and XML output. It is populated with the amount that was excluded from the taxable amount of PIS and COFINS when the following company options are set:
  • Brazil PIS and COFINS taxable basis:
    <EXCLUDED PIS COFINS AMOUNT> = ICMS
  • Brazil alternative taxable basis:
    <EXCLUDED PIS COFINS AMOUNT> = sum of the ICMS, ICMS-DIFAL, ICMS-FCEP
When none of the above company options are set for changing PIS and COFINS basis, this tag will not be added to the line level tax summary block. The tag also does not appear when the company option value is set to exclude for a role that does not match with the one in transaction.
When TE is configured with INCLUDE_ICMS = True, this tag will not be added to the line level tax summary block as well.
When ICMS DESONERADO is triggered, the following validation occurs:
  • If DESONERADO is
  • (QUALIFIER)
Composition of DESONERADO
  • COMP. OP. BRAZIL ALTERNATIVE
  • <EXCLUDED-ICMS_FROM_PIS_AND_COFINS> =
  • COMP. OPT BRAZIL PIS AND COFINS
  • <EXCLUDED-ICMS_FROM_PIS_AND_COFINS> =
DESONERADO - TYPE 1
ICMS + FCEP II
Exclusion value = zero/empty
Exclusion value = zero/empty
DESONERADO - TYPE 2
ICMS
Exclusion value = DIFAL + FCEP
Exclusion value = zero/empty
DESONERADO - TYPE 3
ICMS + DIFAL + FCEP
Exclusion value = zero/empty
Exclusion value = zero/empty
DESONERADO - TYPE 4
ICMS + + DIFAL
Exclusion value = FCEP
Exclusion value = zero/empty
DESONERADO - TYPE 5
DIFAL + FCEP
Exclusion value = ICMS
Exclusion value = ICMS
DESONERADO - TYPE 6
DIFAL
Exclusion value = ICMS + FCEP
Exclusion value = ICMS
Brazil - Desonerado for Intrastate and Interstate Scenarios with Company Option – Brazil PIS/COFINS Taxable Basis (828711, 544689, 467666, 544692 and 544697)
This feature covers Desonerado calculations for Brazil PIS/COFINS taxable basis company option, Interstate, and Intrastate. The ‘Brazil ICMS Desonerado’ authority will be composed by the sum of the authorities’ tax amount determined according to the Type informed in QUALIFIER level into the rule under the ‘Brazil ICMS Desonerado’ authority. The table below shows the qualifier structure.
The tax value generated by the 'Brazil ICMS Desonerado' authority will be deducted from the net amount provided in the scenario. This deduction will result in a new net amount, which will serve as the taxable base for other taxes applicable to the operation. These taxes include ICMS, FCEP, FCEP II, DIFAL (excluding cases where they are part of ICMS Desonerado), IPI, and ICMS-ST.
For Brazil PIS and Brazil COFINS authorities, for the taxable basis, the system starts the calculation from the new net amount found after ‘Desonerado’ reduction.
  • If DESONERADO is
  • (QUALIFIER)
Composition of DESONERADO
  • COMP. OP. BRAZIL ALTERNATIVE
  • <EXCLUDED-ICMS_FROM_PIS_AND_COFINS> =
  • COMP. OPT BRAZIL PIS AND COFINS
  • <EXCLUDED-ICMS_FROM_PIS_AND_COFINS> =
Type 1
ICMS and FCEP II must compose ICMS Desonarado Amount.
Intrastate: ICMS, FCEP II
Intrastate: IPI, PIS, COFINS, ICMS-ST, FCEP ST
Type 2
Only ICMS must compose ICMS Desonarado Amount.
  • Intrastate operation: ICMS
  • Interstate operation: ICMS
  • Intrastate operation: FCEP II, IPI, PIS, COFINS, ICMS-ST and FECP ST
  • Interstate operation: ICMS-DIFAL, FCEP, ICMS-ST, FCEP-ST, IPI, PIS and COFINS
Type 3
ICMS, DIFAL and FCEP must compose ICMS Desonarado Amount.
Only Interstate: ICMS, ICMS-DIFAL, FCEP
Only Interstate: FCEP, IPI, PIS, COFINS
Type 4
ICMS and DIFAL must compose ICMS Desonarado Amount.
Only Interstate: ICMS, ICMS-DIFAL
Only Interstate: FCEP, IPI, PIS, COFINS
Type 5
DIFAL and FCEP must compose ICMS Desonarado Amount.
Only Interstate: ICMS, FCEP
Only Interstate: ICMS-DIFAL, IPI, PIS, COFINS
Type 6
Only DIFAL must compose ICMS Desonarado Amount.
Only Interstate operation: ICMS-DIFAL
Only Interstate: ICMS, FCEP, IPI, PIS and COFINS
Custom Application Messages - Calculation Category (865550)
You can now override system application messages for the calculation category. (Select
Configuration
,
Advanced Setup
then
Application Messages
to access.) On the Application Messages page, select
OVERRIDE
to customize the
Title, Severity, Description, Cause and Required Action
fields for a message.
Override capability must be set up for each company (parent and child company) because these messages do not follow the ONESOURCE Determination auto-inheritance logic.
Currency Rounding (836321)
A new feature, which was part of the On-Premises/Legacy version of ONESOURCE Determination, was ported on to ONESOURCE Determination - Enterprise Cloud. The feature available in the On-Premises/Legacy version is named Document Rounding. In the Enterprise Cloud version, the feature is renamed to Currency Rounding.
You can now enable or disable rounding logic at the country level for a specific company. The next release of ONESOURCE Determination, the list of countries will include Brazil, Canada and the United States.

Fixes

The topics below describe previously known issues that have been fixed with this release.
Oil and Gas - OLT and JE Mapping Records Display (907970)
An issue was identified in the release of ONESOURCE Determination 2023.2, where the Operating License Type Mapping (OLTM) and Jurisdiction Eligibility (JE) Mapping data display logic were updated. However, this caused an issue where most of the valid records were filtered out and therefore did not appear on the screen.
This issue has been corrected so that all the standard tax content data will display. Note that there is a filter column available to sort between active and inactive records.
CSV File Import Issues (908621)
Issues with importing commodity codes and other data using the CSV file (to access, select
Tools
,
Administration
then
Export and Import
) were reported that blocked the import process from completing. This issue is now fixed.
Custom Fields Causing Tax Calculation Error (895105)
ONESOURCE Determination supports the use of custom fields that can help you control the behavior of the tax engine based on the values provided. There was an issue with the tax engine where, if the custom fields supplied exceeded 200 characters, then the transaction invoice was rejected with the following error for audited transactions:
To address this issue, the tax engine now truncates any value beyond the two hundredth character so that the transaction invoice does not error and the tax is calculated.
Custom UOM Conversion Factor (859016)
A defect was identified where, if Unit of Measure (UoM) Conversion Factor was set for a company as custom data (to access, select Configuration, Reference Data, Units of Measure, Custom tab then Conversion Factors), it was not recognized and converted against the UoM set within a standard Authority. It only worked when set for a custom Authority. This issue was fixed so that if you need to use a custom UoM Conversion Factor to convert transaction UoM against the standard authority UoM (present within rates and fees) then the tax engine recognizes and uses this custom configuration.
Taxable Basis Issue with Contributing Authority (897818)
An issue was reported where the Tax Amount would change every time the same invoice is recalculated. The expectation is for the tax amount to remain the same regardless of repeated processing of an invoice, given that all other parameters remain the same. This issue was caused by Contributing Authorities overriding the tax amount of a jurisdiction authority, especially when Self-Contributing Authorities are in play. The issue is now fixed so that the tax amount stays consistent, thereby the tax amount is also consistent when processing an invoice repeatedly.
Rounding Issue with Reverse From Tax Calculation (892239)
For the Reverse From Tax calculation method, the invoice already includes the line Gross Amount and the line Tax Amount, and Determination is supposed to recalculate the invoice Total Gross Amount and Total Tax Amount based on those input elements.
There was an issue reported, where if the Tax Amount in the transaction is –0.01, then the tax engine was incorrectly returning Total Tax Amount as 0 for the line, instead of matching with the Tax Amount. This is now corrected so that the values match in the case of this specific negative value.
VAT Group Registration Data Pollution (843255)
There was an issue identified, where VAT Registration numbers set up under a VAT GROUP for a company or tenant, if matched with the VAT Registration number set for another company or tenant, then this other Reg # was being used when processing the transaction, resulting in zero taxation incorrectly. This issue is corrected so that the tax engine looks for Reg # within VAT Groups only belonging to the specific merchant, or its tenant, mentioned in the invoice.
Obsolete XML Element – Freight_On_Board (899323)
Freight_On_Board is an outdated request or XML output element that is no longer used (this is unsupported beyond tax content version F). However, if this, along with Delivery_Terms, was present in an invoice, the former was being used instead of the latter, resulting in incorrect tax results. This is now corrected so that the tax engine ignores Freight_On_Board if it is present in the request/input transaction.
Brazil – Displaying Incorrect IVA Adjusted Rate for Buyer Intrastate Resale ICMS-ST TYPE-1 Transaction (886419)
This addressed an enhancement - IVA adjusted, in a scenario with Company Option PIS AND COFINS Taxable Basis, buyer intrastate resale ICMS-ST type1 transaction. The issue was fixed.
Brazil – Update ICMS-RD-ST and FCEP-ST Taxable Basis Formula to Not Double Discount ICMS for Desonerado TYPE-2 (899297)
For the operations with Desonerado type-2, ICMS-RD-ST and FCEP-ST taxable basis formula was discounting ICMS from the new gross, affecting none and both company options for PIS and COFINS. The issue was fixed.
Missing Accrual Amount for VCTV Scenarios for Exempt Lines Issue (900419)
Some integrations look for accrual method and accrual amounts before setting self-assessment or liability flag to ERP. In case of Exempt line processing with tax type of 'EX', they were not getting the accrual amount for respective tax lines. This has been addressed and should be getting the VCTV fields in the same way as other lines.
Certificate Manager Configuration and Portal Admin Console Pages Upgraded to Angular NG (341297 and 341239)
The Certificate Manager Customers and Certificates pages were upgraded to the latest angular version for improved performance, enhanced security, overall stability, and reliability.
Exemption Certificate (860270, 860282 and 860257)
On the Add and List pages in the Exemption Certificate feature, caching for both certificates and customers results in faster response times and an improved user experience.
Certificate Manager Sync Error (834487)
Users no longer receive error messages when creating certificates in Certificate Manager, and the certificates are synchronized.
Certificate Manager Portal Admin Console Issue (583082)
Customers no longer experience issues with downloading the exemption certificate forms and submitting the certificates for approval.
Indirect Tax - New Version Does Not Support Multi-Language Browser (914455)
Customers are now able to create a custom rate using a French-Canada browser. The new version supports a multi-language browser.

Known Issues

The topics below describe known issues in this release.
Tax Calculation Error - COMPANY_NOT_FOUND (940211, 940445 and 941661)
For those customers using SAP 5.2B as a connector for integration, the following error is returned when making tax calculation calls using the XML invoice servlet (not SOAP or REST web services):
Separately, for those company setups that have multiple tenants (in UAT or PROD), the user ID used to make tax calculation calls must be separate for each tenant. The user ID cannot be reused or provided permissions across the tenants. If the user ID is reused across the tenants, a COMPANY_NOT_FOUND error is returned and the tax calculation fails. This is regardless of the integration or the web service protocol used.
Multi-Tenant Support – Oil and Gas Operating License Related Data (896726)
For those customers in the Oil and Gas business using Motor Fuel or Movement as transaction types, the Operating License Type (OLT) and Operating License are a requirement to get tax exemptions. Customers manage the Operating License which is tied to OLT; custom OLT and Mapping can also be created by customers. However, the configuration migration import process will error out when these data elements are part of the exported file.
This is planned to be addressed in the next release of Determination. As a workaround, the above data can be manually excluded from the export file, and this updated file can be used to complete the import process. Please open a Support ticket if you run into this issue.

Related Content