ONESOURCE Determination 2023.2 Release Notes
Release highlights
Published: March, 2023
- For the oil and gas industry, the ability to create custom operating license types
- Brazil Desonerado calculations
- Brazil ICMS Pauta authority for consumer goods
New Features
The topics below describe features added with this release.
Oil and Gas - Custom Operating License Type (371452)
If you participate in Motor Fuel Excise Tax (MF) within the oil and gas industry, you can now create a custom operating license type within the Determination system. This license type is used to obtain a tax exemption when applied to a motor fuel or movement transaction (like exemption certificates for sales and use tax).
Setting up a custom operating license type provides you with flexibility because it allows data to be created and managed on top of the standard Motor Fuel Excise Tax content. The custom record takes precedence over the standard record and applies only to the company it is set up under (like any other custom data record created in the Determination system).
Select
Configuration
, Reference Data
then Operating License Types
to access and add a custom operating license type. User roles control whether a user can view, edit and delete records.Oil and Gas - Operating License Number for Custom Operating License Type (371458)
Originally, an operating license type in the standard content could be assigned with an operating license number based on the entity being a company customer or vendor. This set up was completed on the Operating License Types page (accessed by selecting
Configuration
, Reference Data
then Operating License Types
). With the addition of the custom operating license type, you can now assign an operating license number to a custom operating license type on the same page.
Oil and Gas - Custom Operating License Type Mapping (371393)
Within a U.S. motor fuel authority, the Operating License Type Mapping (OLTM) option on the
MOTOR FUEL MAPPING
tab dictates the tax logic results for a Motor Fuel Excise (MF), Motor Fuel Exempt (MFE) or Motor Fuel Discount (MFD) transaction related to mid-downstream operations in the oil and gas industry (Transaction Type of Motor Fuels or Movement). This was managed as part of the standard tax content. Beginning with this release, you can create a custom OLTM related to an authority with the Determination application. The custom OLTM takes precedence over the standard OLTM and applies only to the company it is set up under (like any other custom data record created in the system).
The following fields are available for creating a custom OLTM:
- Commodity Code - This is an optional field. It applies specifically to the commodity (if one is set up).
- Buyer License - This is a required field. It defines the buyer side of the operating license type. A standard or custom operating license type can be selected.
- Seller License - This is a required field. If defines the seller side of the operating license type. A standard or custom operating license type can be selected.
- JE Mapping - This is a required field. It defines the transaction logic path to determine taxation.
- Tax Type - This is a required field. It is the type of taxation to apply for the above record combination.
- Legal Citation/Notes - This is an optional field. It allows you to enter notes for why the record is being added.
- Is Cascading- This is a required field. The selections include:
- No- Applies only to the authority.
- Yes- Applies to all authorities that are a zone level below the authority. This means the record does not need to be created or repeated for all applicable lower-level zone authorities.
- Start Date- This is a required field.
- End Date- This is an optional field.
In addition to standard motor fuel authorities, templates are now available for creating custom motor fuel authorities. These can be expanded to make use of the custom OLTM feature (along with custom rate and rules, for example).
Oil and Gas - Flat Fee on Net Quantity (735245)
The new
Flat Fee on Net Quantity
calculation method is now available under Rules. This also allows a basis percentage of 100 (the default) or any other value. The calculation is as follows:- Basis percentage of net quantity (provided withing a transaction line level).
- Compare this result with the value set up for a rate or tier (graduated or tiered) level.
- The appropriate value is applied as a flat fee to the authority tax result.
Brazil - Desonerado for Intrastate and Interstate Scenarios with Brazil - Alternative Taxable Basis Company Admin Option (512296, 512298, 512297, 715102, 493127, 660361, 752140 and 814237)
This feature covers Desonerado calculations for the
Brazil - Alternative Taxable Basis
company admin option for interstate and intrastate operations.The Brazil ICMS Desonerado authority amount is composed by the sum of the authorities’ tax amount determined according to the type at the QUALIFIER level in the rule under the Brazil ICMS Desonerado authority. The table below shows the qualifier structure.
The total tax value generated by the Brazil ICMS Desonerado authority is reduced from the net amount given in the scenario and a new net amount is generated. The new net amount is the taxable base amount for the other taxes applied to the operation, such as ICMS, FCEP, FCEP II, DIFAL (only when they do not compose the ICMS Desonerado), IPI and ICMS- ST.
For the taxable basis for Brazil PIS and Brazil COFINS authorities, the system must start the calculation from the new net amount found after the Desonerado reduction. If the
Brazil - Alternative Taxable Basis
company admin option is not set, the taxable basis is the new net amount. If the Brazil - Alternative Taxable Basis
company admin option is set, the existing logic of some other authority reduction is kept unless the authority is part of the Desonerado composition. Otherwise, a duplicate deduction is generated.- For Desonerado Type 1, the system cannot deduct ICMS and FCEP again.
- For Desonerado Type 2, the system cannot deduct ICMS again.
- For Desonerado Type 3, the system cannot deduct ICMS/FCEP and DIFAL again.
- For Desonerado Type 4, the system cannot deduct ICMS and DIFAL again.
- For Desonerado Type 5, the system cannot deduct DIFAL and FCEP again.
- For Desonerado Type 6, the system cannot deduct DIFAL again.
For interstate operations with the Pharma segment combined with the Brazil ICMS Desonerado authority, if the Brazil ICMS Repasse all states authority is triggered then the Brazil ICMS Desonerado is calculated considering the new net amount given after the Brazil ICMS Repasse discount.
The following table shows the Brazil ICMS Desonerado authority qualifier, the composition of it, and how the new net amount is generated after the Desonerado discount is deducted:
Brazil ICMS Desonerado (Qualifier) | Description | Net Amount Given | New Net Amount Must Be Considered for (After Deducting Desonerado Discount) |
|---|---|---|---|
DESONERADO_TYPE1 | ICMS and FCEP II must compose ICMS Desonerado amount. | Intrastate: ICMS, FCEP II | Intrastate: IPI, PIS, COFINS |
DESONERADO_TYPE2 | Only ICMS must compose ICMS Desonerado amount. |
|
|
DESONERADO_TYPE3 | ICMS, DIFAL and FCEP must compose ICMS Desonerado amount. | Only Interstate: ICMS , ICMS-DIFAL, FCEP | Only Interstate: IPI, PIS, COFINS |
DESONERADO_TYPE4 | ICMS and DIFAL must compose ICMS Desonerado amount. | Only Interstate: ICMS, ICMS-DIFAL | Only Interstate: FCEP, IPI, PIS, COFINS |
DESONERADO_TYPE5 | DIFAL and FCEP must compose ICMS Desonerado amount. | Only Interstate: ICMS , FCEP | Only Interstate: ICMS-DIFAL, IPI, PIS, COFINS |
DESONERADO_TYPE6 | Only DIFAL must compose the ICMS Desonerado amount. | Only Interstate: ICMS-DIFAL | Only Interstate: ICMS, FCEP, IPI, PIS, COFINS |
Brazil - Introducing ICMS Pauta Authority for Consumer Goods
This release introduces the Brazil ICMS Pauta authority, which taxes consumer goods. Content supporting the Brazil ICMS Pauta authority and the rules for bringing the Pauta unit price for commodities as published by the Brazilian government will follow. The Pauta price is a value determined by the government and is used to calculate ICMS.
Brazil Pauta - New Jurisdiction Eligibility Classes for Pauta (667747, 803658 and 667081)
The Brazil ICMS Pauta authority was added under all states in Brazil. To support this, the following Jurisdiction Eligibility (JE) classes were added for sales and purchases:
- BrazilBuyerIcmsPautaGoodsJe(5.13.10.0)
- BrazilSellerIcmsPautaGoodsJe(5.13.10.0)
The new JE classes were added to exclude both sell-side and buy-side interstate scenarios to the end consumer (the business supply flag is set to No).
Brazil - Pauta User Interface Changes (667752 and 689815)
The Product Unit Price field is available under Rules for the Pauta authority.
The
Tax Calc Type
drop-down list is available on the Rules pages for the Pauta authority. Use this drop-down list to select the Pauta type. The selections currently include:- None
- Type 1
Each selection in the drop-down list drives a different taxability in the Pauta calculation.
Brazil Pauta - Calculations per the Pauta Types and Company Admin Options (800271, 800193, 800197, 800212, 494929 and 668249)
The Pauta authority directly impacts the determination of the Brazil ICMS (ship from) taxable basis and FCEP II taxable basis. The system uses the Pauta product price informed under the rule then multiplies by the quantity provided in the request sent from the source system (ERP). The Pauta type under TaxCalcType (or selected in the Tax Calc Type drop-down list) is applied as follows:
- When None is selected, the system uses the Pauta product unit price multiplied by the quantity as ICMS (ship from) taxable basis.
- Brazil ICMS (ship from) taxable basis = Pauta product unit price x quantity x ICMS (ship from) basis percent
- Brazil ICMS FCEP II taxable basis = Pauta product unit price x quantity x FCEP II basis percent
- When Type 1 is selected, the system checks if the gross amount is lower than the Pauta total value (product unit price multiplied by quantity) then uses the Pauta total value as the ICMS (ship from) taxable basis if not the gross amount is used as ICMS taxable basis. If the operation value (gross amount) is lower than the Pauta total value, the logic is:
- Brazil ICMS (ship from) taxable basis = Pauta product unit price x quantity x ICMS (ship from) basis percent
- Brazil ICMS FCEP II basis = Pauta product unit price x quantity x FCEP II basis percent
Otherwise, the system uses the operation value (gross amount) as follows:- Brazil ICMS (ship from) taxable basis = gross amount x ICMS (ship from) basis percent
- Brazil ICMS FCEP II basis = gross amount x FCEP II basis percent
The value between the gross amount and the Pauta total value amount that the system chooses to calculate for the ICMS (ship from) taxable basis is sent in the response under the CALC_BASIS_MODE element.
If a rule with the None Pauta type is triggered then the value of the CALC_BASIS_MODE tag is PAUTA. If a rule with the Type 1 Pauta type is triggered, then the value of the CALC_BASIS_MODE element is either VALOR DA OPERACAO or PAUTA based on the comparison logic detailed above.
CALC_BASIS_MODE is an optional element added under ICMS tax block in output. It holds a string value in the 2020 and 2011 SOAP services and REST services.
Currently, the system supports both the inclusive and standard type calculation across both the
Brazil - Alternative Taxable Basis
and the Brazil - PIS and CONFINS Taxable Basis
company admin options.As part of this release, the Pauta taxability was addressed along with the
Brazil - Alternative Taxable Basis
and the Brazil - PIS and CONFINS Taxable Basis
company admin options only. When none of the two options are selected, Pauta authority tax block and CALC_BASIS MODE is not present in the response from Determination.Pakistan - Provincial Sales Tax on Services (478485 and 755057)
The following regions are now supported in Determination for the Pakistan provincial sales tax:
- Sindh
- Punjab
- Khyber Pakhtunkhwa
- Baluchistan
- Islamabad
A Transaction Type of Default Services is used for all provinces except Islamabad. For Islamabad, the Transaction Type of Physical Performance is used.
Incoterms (Delivery Terms) for 2020 (812997)
Determination now supports two new Incoterms (delivery terms) published for 2020:
- DAP (Delivered At Place)
- DPU (Delivered named Place Unloaded)
note
The DPU Incoterms replaces the DAT (Delivered at Terminal) Incoterms, which was issued in 2010. DAT will continue to be supported within the system.
Support of Mixed Debit and Credit Transactions in Vendor Charged Tax (337338, 663875, 741312, 817353 and 822848)
The Vendor Charged Tax Verification (VCTV) process now supports mixed transactions where the invoice consists of rows with positive and negative amounts at the line level.
<VCT_TOLERANCE_AMOUNT> and <VCT_TOLERANCE_PERCENTAGE> Exposed for Use in Integration Request Side (501368)
The Vendor Charged Tax (VCT) tolerance amount and percentage fields are exposed for input or for use in the request side. The fields can be used via integration to override the configurations at transaction time.
Belarus Currency Update from BYR to BYN (731478)
The Belarus currency code was updated from BYR to BYN.
Fixes
The topics below describe previously known issues fixed with this release.
Oil and Gas - Tax Date Determination Evaluation for Operating License Type Mapping (821569 and 817122)
For oil and gas transactions with a Transaction Type of Motor Fuels or Movement, although the system works as expected for tax determination date logic, the Tax Date Determination (TDD) was not considered by the Operating License Type Mapping (OLTM) records (the Operating License Type Mapping option on the
MOTOR FUEL MAPPING
tab for a U.S. motor fuel authority). This was corrected. The tax engine now considers the OLTM and JE start and end date range to compare with the TDD before the application of an appropriate tax type (MF, MFE, MFD and NL).The TDD can be custom-created for a company from the Date Logic and Date Rules. Alternatively, the TDD can be set up from by selecting
Company Configuration
then Movement Date
.Oil and Gas - OLTM and JE Mapping Records Display (755005, 822618 and 821475)
Under the
MOTOR FUEL MAPPING
tab for a U.S. motor fuel authority, the records displayed on the pages for OTLM and JE Mappings was incorrect. This is now corrected. Only active records based on the authority's Authority Logic Mapping (JD and JE) start and end date are displayed.Brazil - Enhancement Related to ICMS_NonTaxpayer Field when Province Level VAT Registration for Buyer Is Provided (778396)
The system now considers the ICMS_Nontaxpayer flag in non-taxpayer scenarios and disregards the buyer registration if this flag is set. The correct standard rule for the ICMS authority was picked based on the operation from the standard content.
Brazil - Negative Postings Error Message Did Not Display for FECP-ST Authority in System Messages in the QA Environment (818276)
The following error message did not display in the QA environment: "Negative postings of the FCP-ST authority are not supported. Brazil ICMS-FCEP-ST Sao Paulo". This issue is fixed.
Line Level versus Invoice Level Exemption – Invalid Customer (689923)
As part of the 2021.6 release, a feature was introduced that allows a customer to request the tax engine to evaluate exemptions at the invoice level, but only if the exempt certificate at the line level does not qualify for exemptions. This was possible by setting the
Consider for Invoice Exemptions
company admin option to Yes
.An issue was identified where the tax engine did not follow the invoice level exemption check if the customer number provided in the line level is invalid. This is now corrected. The invoice level exemption process is followed even if the line level customer number is invalid but if the
Consider for Invoice Exemptions
company admin option to Yes
.Changes in EU Goods Logic for Destination or DDP Results (467673)
In accordance with the EU VAT Directive, a valid VAT registration number of the customer in another member state is required to receive a 0% Intra-Community Dispatch. Since the tax engine does not evaluate the buyer’s registration when the Point of Title Transfer (POTT) is Destination (or Delivery Terms=DDP), the logic for the following scenarios was adjusted so the tax engine could return “Output VAT in Ship From location” instead of "Intra-Community Dispatch in Ship From location:"
- Inter EU sales when POTT is D and buyer registration is null.
- Inter EU sales when POTT is D and buyer registered in ship from location.
Union OSS - Registration Number Not in System Messages (755877)
For Union One Stop Shop (OSS) transactions, when the Transaction Type is Electronic Services, the registration number used for the transaction was not recorded in the tax result system messages. This is now fixed. The applicable registration number is now included in those logs.
Error Saving TransEditor (746190)
The following error occurred in certain cases when a TransEditor action was saved:
“Error communicating with Determination: The call to Determination did not complete.”
This error was due to a 250-character limitation issue. This is now fixed. Any characters above the 250-character limit are trimmed when saving the record in the database.
Performance Improvement on ERP Code Mappings List Page (797483)
High response times on the ERP Code Mappings list page were reduced significantly after a new search and filter box was implemented. This box allows for faster loading and reduced response times when interacting with the user interface. Additionally, the last searched filter tags and results are maintained in the grid, which allows you to view your preferred filtered records when you return to the page from another page or tab, or when or when you sign in after signing out.
Performance Improvement on Exemption Certificate Customers List Page (815777 and 810642)
High response times on the Exemption Certificate Customers list page were reduced significantly after a new search and filter box was implemented. This box allows for faster loading and reduced response time when interacting with the user interface. Additionally, the last searched filter tags and results are maintained in the grid, which allows you to view your preferred filtered records when you return to the page from another page or tab, or when you sign in after signing out.
Performance Improvement on Exemption Certificate Certificates List Page (815778 and 811246)
High response times on the Exemption Certificate Certificates list page were reduced significantly after a new search and filter box was implemented. This box allows for faster loading and reduced response times when interacting with the user interface. Additionally, the last searched filter tags and results are maintained in the grid, which allows you to view your preferred filtered records when you return to the page from another page or tab, or when signing in after signing out.
Performance Improvement on Users and Roles List Page (804017, 819517 and 819532)
High response times on the Users and Roles list page were reduced significantly after a new search and filter box was implemented. This box allows for faster loading and reduced response times when interacting with the user interface. Additionally, the last searched filter tags and results are maintained in the grid, which allows you to view your preferred filtered records when you return to the page from another page or tab, or when you sign in after signing out.
Performance Improvement on Lookup Lists Page (810631)
High response times on the Lookup Lists list page were reduced significantly after a new search and filter box was implemented. This box allows for faster loading and reduced response times when interacting with the user interface. Additionally, the last searched filter tags and results are maintained in the grid, which allows you to view your preferred filtered records when you return to the page from another page or tab, or when you sign in after signing out.
Performance Improvement on Vendors List Page (810679)
High response times on the Vendors list page were reduced significantly after a new search and filter box was implemented. This box allows for faster loading and reduced response times when interacting with the user interface. Additionally, the last searched filter tags and results are maintained in the grid, which allows you to view your preferred filtered records when you return to the page from another page or tab or when you sign in after signing out.
Performance Improvement on Locations List Page (810633)
High response times on the Locations list page were reduced significantly after a new search and filter box was implemented. This box allows for faster loading and reduced response times when interacting with the user interface. Additionally, the last searched filter tags and results are maintained in the grid, which allows you to view your preferred filtered records when you return to the page from another page or tab, or when you sign in after signing out.
Performance Improvement on Locations Sets List Page (815763, 810634, 798703 and 460363)
High response times on the Location Sets list page were reduced after a new search and filter box was implemented. This box will allows for faster loading and reduced response times when interacting with the user interface. Additionally, the last searched filter tags and results are maintained in the grid, which allows you to view your preferred filtered records when you return to a page from another page or tab, or when you sign in after signing out.
Performance Improvement on Pages for Adding and Editing Standard Mappings (822832, 822833, 815782, 708773, 746748 and 815779)
High response times on the pages for adding and editing standard mappings were reduced significantly after optimizing the code and the API calls associated with these pages. As part of this performance improvement implementation, the workflow was modified to allow a faster response time while adding or editing product mappings. When adding or editing product mappings, you must save your changes before attempting to sort, filter or change the Total Mapped Product Categories area. This ensured that the recent changes are maintained and are included in the sorting, filtering, or pagination results. All mandatory fields should be completed before attempting to sort, filter or change the pages in the Total Mapped Product Categories area.
Adding Companies Help Topic - Review and Update of the "Setting Tax Logic Preferences and Company Admin Options" Section (691560)
The “Setting Tax Logic Preferences And Company Admin Options” section of the Adding Companies help topic was reviewed and updated to provide descriptive information of the options available in the user interface, the option functionality, and how the option selections affect the company configuration.
Standard Mappings Add Group Pop-Up Window Displays by Pressing ENTER Key (709009)
A fix was implemented to prevent the Add Group pop-up window from displaying after pressing ENTER while navigating in the pages for adding or editing standard mappings. The Add Group pop-up window now displays only when
Add Group
is selected for the Settings
button associated with the Products and Services Mapping Group.Standard Mappings Save Changes Pop-up Window Displays by Changing the Default Product Group Selection (709048)
A fix was implemented to prevent the Save Changes pop-up window from displaying when the product group is changed from the default selection (the active mapping group) to any other existing mapping group for the selected company while navigating the pages for adding or editing pages standard mappings.
Standard Mappings Start and End Dates Copy and Paste Capabilities (811268)
A fix was implemented to allow copying and pasting the values in the Start Date and End Date fields in the Total Mapped Product Categories area on the pages for adding and editing standard mappings. This implementation allows you to add or edit the dates of mapped products using keyboard or mouse commands to copy and paste data. This capability was also added to the Start Date and End Date filters.
Conditional Mappings - No Conditional Mappings Returned while Applying Filters on an Empty or a Failed State Scenario (852625)
Any valid search made on an Empty (no previous filters applied) or a Failed (no records returned in the grid) state scenario does not work and no Conditional Mapping records are returned. The filters work when there are existing records in the grid. The Company filter is the only filter that works regardless of the state scenario.
Workaround
- To display the records in the grid for the filters that were applied, navigate to either the Custom Products or Standard Mappings tabs then return to Conditional Mappings.Model Scenario Add Line Button Triggered by Copy Keyboard Shortcut (688667)
A fix was implemented to prevent the copy keyboard shortcut from triggering the Add line button on the Document Line Information page in the Model Scenario Details tab. When the cursor was placed in any non drop-down field and CTRL+C was pressed, a new line was added to the bottom of the Document Line Information page. The fix allows you to use the copy keyboard shortcut to trigger only the copy action without adding new line items on this tab.
Locations List Page Export Button to Download All Search Results (338074)
A fix was implemented to correct the number of items exported from the Locations list page when selecting View in Excel. This fix ensures that all records displayed in the grid are exported successfully to an Excel file. The number of items displayed in the grid varies depending on the filtered results.
Typo for Exemption Certificate Exemption Rate Option (338074)
This release includes a correction to the typo in the Fully Exempt exemption rate option.
Performance Improvements on Dashboard and TransEditor Pages (667446, 667462, 714364, 741313, 746133, 746142, 746145, 746146, 746149, 746153, 746154, 746391, 746422, 746432, and 818633)
The TransEditor main and edit pages now have a faster response time. Better performance occurs with respect to the check in and check out function on the TransEditor page. The Dashboard page also has a faster response time.
Search and Filter Box on Application Message and Operating Licenses (803027, 803029, 811124, 811125, 816458, 816646, 817543 and 819640)
To improve the user experience and enhance performance, a new search and filter box was added to the Application Messages and Operating Licenses list pages. These options allow you to search and filter the records by creating filter tags. You can search and filter the records based on multiple company selections.
To perform a search and filter:
- Select your search-by criteria (for example, Company, Message Number or Severity) from the first drop-down list then enter your search term in the field. For each search term, a filter tag is created and displays below the search and filter box. A filter tag is a combination of the search-by criteria and the search term.
- SelectSearchto display the records. Applied filter tags display in dark gray and unapplied filter tags display in light gray.
To remove a search and filter tag, select the cross sign shown in the filter tag. Each time an applied filter tag is removed, the records in the main grid are refreshed. There are no changes to the records displayed in the main grid when an unapplied filter tag is removed.
Search and Filter Box on TransEditor List Page (746148, 746152 and 818273)
To view the list of TransEditor Groups, you must select the specific company from the drop-down list. The grid displays filtered records based on the search criteria. The performance of the page will be better.
Rates and Fees - Incorrect Total Page Records (792059)
The accurate number of records per page now displays on the Rates and Fees page, which matches the page count.
Allocations - Intermittent Pop-up Window Displays while Deleting an Allocation from List Page (812449)
No pop-up windows display while deleting an allocation from the Allocations list page.
Error, "ACTIVE_IOSS_AUTHORITY: Testing Netherlands," in Production (836484)
You cannot select severe in the Severity field in the application messages when trying to override an application message. This is a temporary fix. A permanent fix will be implemented in an upcoming release.
Unable to Save Establishments on Tax Jurisdictions Page (334761, 580177, 662012 and 811457)
So you do not receive error 412 in the future, if you were facing issues, you should be restablished from the user interface by the Professional Services team after de-establishing from the user interface for all states.
Fees - Telecom Regulatory Fee Available in Certificate Manger and Not in Exemption Certificate
You can now select the Telecom Regulatory fee authority type for exemption certificates.
Exemption Certificate Issues (810871, 810872, 810873, 820672 and 820674)
The following fixes apply to exemption certificates:
- You can filter the records on the Exemption Certificate page based on the Certificate Use filter.
- You cannot save limited use certificates that include a blank or a space as limited use criteria.
- You can update the Certificate Use field from the user interface and Save is enabled.
- Inactive certificates do not display on the list page. The status shows as Inactive on the list page and the pages for adding and editing certificates.
- Certificate use criteria is not updated when a change is made to the effective date range for a certificate.
Known Issues
There are no known issues in this release.
Related Content
-
Determination
Format:
Article,
1 min read