R 25 - June 2024

Feature Enhancements

Applying Updates Notification
  • A new notification added to show the percentage progress of the data updates running on a calculation that is being opened.
  • This notification also updates the user with a success message when the data updates are completed.
  • The calculation open routine does not timeout during the data updates, hence, does not throw any errors or red banner messages.
Line Items
  • Line items functionality is now enhanced to support sharing of the line items across the clients (applicable to Client Manager enabled database accounts).
  • Users can select the line items of their choice and mark those to be made available across the clients in a database.
  • “All clients” checkbox provides users a convenience to mark all the line items in one go. These line items are formatted in bold on the “Insert Line Item” screen to differentiate these from other line items (which are local to the current client).
Entity Manager
Entity Reordering/Reparenting
  • Entities can be reordered or reparented within the group easily with drag/drop controls now.
  • When users mouse hover on an entity, there are two types of icons displayed.
  • When it shows double vertical arrow icon, it allows reordering of the entities within/across the groups.
  • When it shows the hand icon, it allows reparenting of the entities within/across the groups.
Export Entity Hierarchy to Excel
Along with the existing functionality of exporting a flat list of entities, we now support exporting the entity hierarchy too.
New Jurisdictions
Jurisdictions list (Configuration>Entity Manager) updated as per ISO 3166-1.
Easier Access to Print PDF
A new menu
Download Latest Print
added to easily access the last printed PDF for the calculation by the current user, no need to move away from the calculation (Calculations>Prints) to be able to fetch the printed PDF.
Print API
A new set of APIs introduced to provide an ability to print calculations using APIs. These APIs allow the users to:
  • Fetch print configuration for a calculation (e.g., print styles, applicable sheets to print etc.)
  • Initiate print on one or more calculations.
  • Get status of a print job.
  • Download print PDF.
Datasets API
The GET Datasets API is enhanced to:
  • Return all datasets (showDatasets=all).
  • Return only active datasets (showDatasets=active). This is also the default option.
  • Return only deleted datasets (showDatasets=deleted).
  • Indicate with a new parameter in the response (deleted=true/false) whether a dataset is a deleted dataset or an active one.
  • Allow searching for a dataset with its name (dsName=”My 2023 Dataset”).
Delete Calculation API
A new API introduced which helps deleting a calculation for an entity in a dataset.
Dataset Status API
A new API introduced to get the status of operations performed on a Dataset. These operations could be the ones initiated from UI or the API or both.
The response for this API includes:
  • Consolidated status of the operations (e.g., it responds with a Fail status if at least one of the operations initiated on a dataset is failed).
  • Status of individual operations such as:
    • Create Dataset
    • Edit Dataset to
      • Rename a dataset
      • Change it’s purpose
      • Add and remove entities
    • Delete calculations
This is a
POST API
and accepts additional filter parameters to bring back the data which is relevant as per the supplied parameters such as:
  • Date filter –
    This is optional, when absent, it looks for the data from last 6 months which is maximum period. Date filter can be included to get fewer records.
  • User filter –
    This is optional, when absent, it brings the data without filtering the records based on who initiated these dataset operations. User filter can be included to fetch only the records for the operations initiated by specific user.
Import API
Import API has been enhanced to support
Round to whole amounts
functionality.
A new parameter
roundToWholeNumbers
added with a default value false.
roundToWholeNumbers
when false, imports the amounts without applying the rounding, when true, it rounds the amounts to whole amounts first and then imports those amounts into the calculation.
Insert Sheets API
A new set of APIs introduced to provide an ability for users to insert sheets into calculations.
These APIs allow the users to:
  • Fetch the insertable sheets according to the template the calculation is created from.
  • Insert one or more sheets into a calculation.
Performance Improvements
  • Enhanced the performance of inserting the sheets into calculation. This will especially benefit large calculations with many sheets.
  • Enhanced the performance of sort (Tools>Sort) functionality. This will especially benefit the large Group/Consol calculations.
Default Roll forward Period
Period length for a rolling forward dataset will be set to 12 months by default. Users can adjust the period by amending the start / end dates as per their requirement.
E-Filing Manager
E-Filing functionality in Australia now supports TRT submissions in the new .xml format as mandated by Australian Tax Office (ATO).

Notable Defects Remediated

Calculations
  • User added selector formulae (DROPDOWN() or SELECTTICK()) were not editable, couldn’t be deleted. Reset to system cell was the only option to remove these formulae.
  • Decimal format applied (Format>Cells>Decimal Places) was not effective until a refresh.
  • Copying a date from one cell and pasting it in another cell that expects a date was resulting in a “Must be date” error.
  • Inserting analysis sheets for columns was failing especially on wide sheets with many columns.
  • Calculation upgrade was not bringing the page breaks defined in the new version template on to the upgraded calculation.
  • Template selection for the newly added entities in a dataset during roll forward / copy was not being respected, because of this the calculations were being created against undesired templates.
  • There was an intermittent issue where deleting calculation for an entity in a dataset was not working.
  • Fixed a few cases which were causing the workbook service to crash. This was impacting the opening of the calculations.
Import
  • There was an issue where deleting an associated journal does not delete the data from a few sheets in a calculation.
  • There was an issue where the drilldown does not work on the imported data brought through code based imports if both code based and target based imports were run on the same calculation.
  • There was another issue where deleting a journal associated to code based import also deletes the data imported through target based import if both code based and target based imports were run on the same calculation.
  • Re-running an existing import job was stuck in “Pending” state if the entity the import was run for has been renamed in the Entity Manager. Re-run job correctly picks up the updated entity name and updates the status.
  • Round to whole amounts
    functionality during the import was not working. Irrespective of the value given to this setting, the import was always rounding the amounts to whole numbers.
Print Styles
  • Print job initiated with a print style which has a trailing space in its name was failing.
  • Print was failing when printed using a print style with logos configured and marked as “All clients” if attempted from a client where the style was not originally created in. It was only working in the client where it was created.
Mapping
Maps for the deleted datasets were still being shown in the Mapping screen.
Edit Dataset API
  • There was an issue where the Edit Dataset API was not responding with an error message when a duplicate dataset name supplied to it. It incorrectly treated the name as not a duplicate because it was doing a case sensitive comparison on the names.
  • There was an issue where Edit Dataset API was not allowing to add entities and associated calculations using client templates, this is working only with standard templates.
Export Notes/Queries API
This API response includes notes/queries from both active and deleted datasets but there was no indication to specify which ones are from which. A new parameter
isDeletedDataset
included in the response now to help with that.
Import API
Import Status API response was not clear and wasn’t updating when an import job was initiated via API with no data. It is now fixed to show “No data to import” message.

Issues to be remediated in a future release

Mapping
We are continuing our analysis on the mapping issues that have been reported in instances where line items are either renamed or duplicated, and we are assessing their implications on the import process.
Our recommendation is to refrain from duplicating line items based on identical text or with variations in letter casing. Additionally, it is advised to refrain from adding line items with names identical to standard or default line items.
Client Templates
We have noticed issues with rolling forward datasets with client templates. When users roll forward these datasets to create client templates for the subsequent year, and then roll their actual calculations to the rolled forwarded client templates, the brought forward cells in the calculations are being protected.
The recommended way to create client templates for the subsequent year is as follows:
  • Copy the dataset which has the client template to the next year. The client template will still be associated with the same year/version template after this step.
  • Upgrade the client template to the next year template.
  • Do necessary changes to the client template and save it.
E-Filing Manager
In History tab
  • Disabled sorting / filtering on the following column(s) is impacting the performance.
    • Return
    • Submitted Time
  • Disabled Filter by Condition on the following column(s) is impacting the performance. Sort, Filter by Value work on these columns.
    • Amended Return
    • Status
    • Jurisdiction
    • Source
  • Filtering does not work on the following column(s). Sorting still works.
    • Submitted Date/Time
    • Queued Date