R 26 September 2024 release notes
Feature enhancements
Unsaved changes alert
This alert helps to protect your work by alerting you when you have unsaved changes in an open browser tab. If you accidentally attempt to close the tab or the entire browser, you'll get a
'Leave site?'
notification. From this notification window, you can either leave the tab or cancel the action and return to save your calculations. This ensures that you won't lose any unsaved changes by mistake.- ChooseLeaveto close the browser tab or window.
- ChooseCancelto cancel the action and do any of the following:
- Save and Closethe calculation.
- Closethe calculation without saving.
- Cancelto refresh and continue working on your calculation.
Insert rows and insert columns in bulk
- We've addedInsert RowsandInsert Columnsto the menu items so that you can insert more than 1 row or column in bulk.
- You can choose a number of rows or columns to insert.
- You can use theInsertmenu or the right-click menu.
- You can insert a maximum of 1,000 rows at a time.
- Validation messages will tell you if you're inserting rows where you can only insert columns and vice versa.
Update sheet type in bulk
To use this new function, select
Tools
, Sheet Settings
, then Update Sheet Type
. Use it to update the sheet type for multiple sheets simultaneously. For example, to change between a Computation Sheet
and Working Paper
. This also creates an audit entry in the calculation history for the sheet type change.Save parameters for batch reports
You can now save parameters for re-use and easily run batch reports. These parameters include values for filters to apply to a report.
Delete exchange rates
You can now delete an already configured exchange rate. This will delete the exchange rate and clear its associated usage.
New keyboard shortcut to paste values
There's a new keyboard shortcut
Ctrl + Shift + V
to paste values. This is a shortcut for right-click, Paste
, then Value
.Highlight XBRL facts
You can now use the
Review
function for XBRL Facts.- Highlight cells with XBRL properties in yellow for quick review.
- Clear this highlighting when needed.
- The menu indicates whether you're currently highlighting or clearing and what you're highlighting.
- Use theReviewbutton on the toolbar to open a new browser tab to show a list of all cells in the calculation with associated XBRL details.
Entities API
- A new API helps you add, edit, and delete entity hierarchy.
- Create,edit, andgetend points have a newaggregateMemberEntityparameter. Use this to mark an entity as an Aggregate Member Entity.
- Edit entities end pointhas a newactiveparameter to mark an entity an active entity or make it inactive by setting tofalse.
note
For more details on how to use Entities API, refer to the ONESOURCE Corporate Tax Master Data API page on the developer portal.
Datasets API
- Thetypeparameter in the period section (period type) is now an optional parameter for thecreate datasetend point. The dataset creation routine disregards the value for this parameter even when included.
- TheperiodTypeparameter in theget datasetsend point is updated to reflect the period length of the dataset based on the start and end dates used in creating a dataset. The possible values are: Weekly, Monthly, Quarterly, Annual, and Custom.
note
For more details on how to use the Datasets API, refer to the ONESOURCE Corporate Tax Datasets API page on the developer portal.
Notable changes
Roll forward datasets with client templates
We've turned off
Roll Fwd
on the toolbar for Datasets with client templates.We recommend the following way to create client templates for the subsequent year.
- Copy the dataset which has the client template to the next year.noteThe client template will still be associated with the same year/version template after this step.
- Upgrade the client template to the next year template.
- Customize and save it.
Notable defects remediated
Calculations
- Right-click on a cell and paste value intermittently pasted the wrong values.
- Users with no permission were allowed to override imported / brought forward values.
- Import overrideon text cells gave errors.
- Users couldn't delete their own attachments unless they had theEnhanced accesspermission.
- Save to Excelwas failing to generate valid Excel files when the client, dataset, or calculation name included a comma.
- Changes to sheet references were reset to what was defined in the template during a template upgrade.
- While building a formula, pressingReturncompletes the formula creation and returns to the cell being edited as expected. However, pressingEnteron the numeric keypad doesn't complete the formula in the same way.
- Flat viewoption didn’t show the sheets in alphabetical order according to the sheet reference when viewing hidden sheets.
Edit datasets
Refreshing entities while editing a dataset didn’t show the up-to-date entity hierarchy according to the Entity Manager.
Import
- The map didn't open when the import included large decimal numbers.
- Drill-down on the imported values didn't work on a few sheets when the import was done by a target-based import.
Print
- Notes added with multiple lines in the calculation were causing the print to fail.
- ThePrintroutine intermittently failed with a'Formula contains a reference to a cell which is beyond the boundaries of the spreadsheet'error when forms were included.
- Notes with special symbols (words wrapped with double quotes in the middle of a note) were printing with incorrect alignment.
Issues for remediation in a future release
Mapping
We're continuing to analyse mapping issues reported where line items are renamed or duplicated and assessing their implications on the import process.
We recommend that you don't duplicate line items by using identical text or variations only in letter case. We also advise that you don't add line items with names the same as standard or default line items.
Rolling forward calculations to client templates
We've noticed issues with rolling forward calculations to the client templates where a few of the optional multi-instance sheets are duplicated (for example,
Business – Trade or property
and Accounting period
sheets in UK templates).A solution is to review and delete the duplicate sheet.
Batch report editing
We've identified an issue with batch reports. When attempting to edit a batch report by removing an existing report from its definition, the reports are not successfully deleted. However, adding additional reports to the batch report definition works as expected.