Version 25.3 for Sparkrock 365 2024 release wave 2 release notes Published April 2, 2025
These release notes include supplemental information about version 25.3 for Sparkrock 365 2024 release wave 2.
Video
The following video includes information about the new features and enhancements in version 25.3 for Sparkrock 365 2024 release wave 2.
Highlights
The following sections highlight the major accomplishments in this release.
New features and changes
Version 25.3 for Sparkrock 365 2024 release wave 2 introduces exciting new features and enhancements to existing functionality.
Microsoft Dynamics 365 Business Central 2024 Release Wave 2
The base Microsoft Dynamics 365 Business Central platform that powers Sparkrock 365, has been updated from 24.5 to 25.3.
For more information about Microsoft Dynamics 365 Business Central releases since 24.5, select the following links:
To view a detailed list of cumulative platform fixes that are available from Microsoft, see Update history for Microsoft Dynamics 365 Business Central.
Modern search
This release introduces a modern search option on list pages that focuses exclusively on columns that are enhanced with full-text search capability.
The modern search accelerates the search process and delivers more precise, relevant results, which increases user satisfaction and productivity.
If required, you can still perform a search with the older method. This older method is now referred to as a legacy search. The legacy search searches across all columns, while the modern search only searches in columns that have been optimized for full-text search matching.
The new full-text search is more flexible. For example, consider an item named LONDON Swivel Chair. If you perform a legacy search with the search criteria of London chair, the search results do not display any records because there’s no exact match. However, if you perform a modern search with the same search criteria, the search results display the item.
The modern search also allows users to enclose search terms in quotes to narrow the results, similar to popular search engines. For example, searching for blue chair, returns all items that include blue and chair in any order. Searching for "blue chair" only returns records where the exact phrase blue chair appears.
The modern search feature is currently available on the following Sparkrock 365 list pages:
- Customers
- Contacts
- Items
- Chart of Accounts
If a page isn’t optimized for the modern search, the Use modern search (faster) option does not appear in the search box.
In subsequent updates, you’ll start to notice this feature on more list pages, such as sales and purchase documents, Projects, G/L Entries, Customer Ledger Entries, Vendor Ledger Entries, and Job Ledger Entries.
If you would like to have the modern search experience added to a specific page, contact your Sparkrock 365 representative.
For now, an administrator can use the feature management functionality to control whether the modern search is enabled on list pages. In a future release, the modern search feature will become the default search method.
To learn more about searching in Sparkrock 365, go to Sort, search, and filter data in lists, reports, or XMLports.
New Documents FactBox for attachments
Before this release, to view the attached documents for a Sparkrock 365 record, you had to select the record, and then select the link that appeared in the Attachments FactBox to open the Attached Documents page.
To provide an overview of uploaded files without having to open the Attached Documents page, this release introduces a Documents FactBox.
The Documents FactBox comes with the same set of actions that you can perform from the Attached Documents page.
In addition to base Business Central pages, you can view the new Documents FactBox on the following Sparkrock-developed or extended pages:
- Absence Requests and Absence Request
- Applicants and Applicant
- Bank Deposit and Posted Bank Deposit
- Budget Journal
- Cash Receipt Journals
- Collective Agreements and Collective Agreement Card
- Commitment Entries
- Employees and Employee Card (User must have the Allow User to Access Compensation Data checkbox selected on the User Setup page)
- Employee Appraisals
- Employee Associations
- Employee HR Tasks
- Employee Qualifications
- Encumbrance Entries
- Expense Claim and Expense Claim Archive
- General Journal
- G/L Budget Plans, G/L Budget Sets, G/L Budget Set Card, and G/L Budget Entries
- General Ledger Entries
- Grievances and Grievance Card
- Harassment Complaints
- HR Positions and HR Position Card
- HR Requests and HR Request
- HR Task Types
- Items and Item Card (Except when the user has the Finance Department Manager or HR Department Manager roles)
- mySparkrock Change Entries and mySparkrock Change Card
- Payment Journals
- Payment Request and Payment Request Archive
- Posted Purchase Credit Memos and Posted Purchase Credit Memo
- Purchase Invoices, Posted Purchase Invoices, Posted Purchase Invoice
- Posted Purchase Receipt
- Purchase Lines
- Purchase Orders, Purchase Order, and Purchase Order Archive
- Purchase Receiving
- Purchase Requisition, Purchase Request Lines, and Purchase Requisition Archive
- Unassigned Expenses
- Vendors and Vendor Card (Except when the user has the Finance Department Manager or HR Department Manager roles)
- Vendor Certifications and Vendor Certification Card
To learn more about attachments, go to Manage attachments, links, and notes on cards and documents.
Use drag and drop to attach multiple files at once
This release introduces drag-and-drop functionality, so you can attach multiple files to Sparkrock 365 records at once.
The Select files dialog box is available from the following pages and actions:
Attached Documents page > Attach files action
Documents FactBox > Upload files action
Incoming Documents page > Upload supporting attachments action
To attach multiple files to a Sparkrock 365 record at once, you can select the files, and then drag and drop the files into the Select files dialog. Additionally, you can drag and drop a folder into the Select files dialog to attach the contents to the Sparkrock 365 record.
To learn more about attachments, go to Manage attachments, links, and notes on cards and documents.
Default G/L Account Quantity
When working on document lines, some users prefer to enter a specific quantity, while others prefer a default value that can be overwritten if required.
To accommodate users who prefer a default value, Sparkrock 365 now provides the capability to have a default value of 1 specified on document lines that have a Type of G/L Account.
To enable this feature for sales and receivables documents, on the Sales & Receivables Setup page, turn on Default G/L Account Quantity.
If you do not enable this feature, the Quantity field on sales and receivables documents behaves the same as previous releases.
To enable this feature for purchases and payables documents, on the Purchases & Payables Setup page, turn on Default G/L Account Quantity.
If you do not enable this feature, the Quantity field on purchases and payables documents behaves the same as previous releases.
Bank account reconciliation improvements
To help reduce manual effort during bank account reconciliation, this release introduces several productivity enhancements.
The following sections describe these enhancements in detail.
New Date Cleared on Check Ledger Entry field on the Bank Acc. Reconciliation page
On the Bank Acc. Reconciliation page, this release introduces a Date Cleared on Check Ledger Entry field.
The Date Cleared on Check Ledger Entry field specifies the date on which a check was cleared in the check ledger. Sparkrock 365 automatically populates this field when you perform a Suggest Lines action, using the Date Cleared value for the related Document No. on the Check Ledger Entries page.
You can use the Date Cleared on Check Ledger Entry field to filter bank account reconciliation records by date or to identify records that have not yet cleared.
Date Cleared field and Entry Cleared checkbox on check ledger entries are automatically updated when payment journal lines are posted or a check is voided
Starting with this release, when a payment journal line is posted for a document that has Bank Payment Type set to Electronic Payment, Sparkrock 365 performs the following actions:
Populates the Date Cleared field on the Check Ledger Entries page that is associated with the document, with the Posting Date from the payment journal.
Selects the Entry Cleared checkbox on the same check ledger entry.
PD-5301
If a check is voided on the Check Ledger Entries page, Sparkrock 365 performs the following actions that relate to the Date Cleared field and the Entry Cleared checkbox:
Updates the Date Cleared field with the Void Date from the Do you want to void this check? page.
Clears the Entry Cleared checkbox on the same check ledger entry.
PD-5914, PD-6242
New import functionality to update the Date Cleared field on check ledger entries
This release introduces import functionality that provides the capability for you to update the Date Cleared field on check ledger entries using a .csv file.
To download an import template with example data, select the following link:
Bank Statement Import with Example
To perform an import, use the new Import Cleared Cheques action that appears on the Bank Account Card page.
After you choose the Import Cleared Cheques action, Sparkrock 365 opens the Import Cleared Cheques page where you can specify options, and then choose OK.
After you choose OK, Sparkrock 365 opens the Select a file to import dialog box.
You can then drag your .csv file into the dialog box or browse to the .csv file that you want to import.
After you specify the file, Sparkrock 365 imports the data, and then displays a dialog box that indicates the number of transactions that were cleared or exceptions that were found.
If one or more exceptions are found, Sparkrock 365 creates an exception file and places the file in your browser's downloads folder.
The following screen capture is an example of the exception file.
To learn more, go to Import cleared checks.
Payroll has been updated to version 25.42.1.0
To stay current with the latest payroll updates and fixes, payroll has been updated to 25.42.1.0.
For more information, see Payroll release notes version 25.42.1.0.
Payroll performance improvements
The following sections describe the payroll performance improvements in this release.
New Compensation Journal ID field on the Primo Payday Integration Setup page
To improve payroll performance, this release introduces on the Primo Payday Integration Setup page, on the Sync FastTab, a Compensation Journal ID field.
The Compensation Journal ID field specifies the payroll custom dimension that is used to filter hours details records during payroll processing.
To learn more, go to Set up payroll custom dimensions to improve performance.
Payroll Setup page is updated automatically with the Compensation Journal ID field from the Primo Payday Integration Setup page
When you update the Compensation Journal ID field on the Primo Payday Integration Setup page, Sparkrock 365 automatically updates the respective fields on the Payroll Setup page based on the value that was selected. For example, if you specify Custom Dim. 3, Sparkrock 365 automatically updates the fields as described in the following table.
Field | Value |
---|---|
Custom Payroll Dimension 3 Code | COMP JOURNAL ID |
Custom Dim. 3 Validation Table ID | 23068648 |
Custom Dim. 3 Validation Field ID | 23068816 |
Filter Hours Detail by | Custom Dim. 3 |
To learn more, go to Set up payroll custom dimensions to improve performance.
The Compensation Journal ID is now updated on Hours Details records for custom payroll dimensions 5 to 8
Before this release, when you sent compensation journal lines to payroll, Sparkrock 365 only updated the COMP JNL ID field on the Hours Details page for custom payroll dimension 2 to 4. With this release, the COMP JNL ID field is now updated for custom payroll dimensions 2 through 8.
To learn more, go to Set up payroll custom dimensions to improve performance.
Default filters during payroll batch creation processing
Starting with this release, when you send compensation journal lines to payroll, Sparkrock 365 might, depending on the payroll setup, default the Custom Dimension Filter and remove the payroll employee No. filter during payroll batch creation processing.
When all the following conditions are met, Sparkrock 365 removes filtering by payroll employee numbers and specifies a Custom Dimension Filter:
On the Primo Payday Integration Setup page, the Compensation Journal ID field is synced to a custom payroll dimension.
On the Payroll Setup page, the Filter Hours Details by field is synced to the same custom payroll dimension.
On the Payroll Setup page, the selected custom payroll dimension is configured to use the compensation journal ID.
If any of the above conditions are not met, Sparkrock 365 behaves the same as previous releases and continues to specify payroll employee number filters by default.
To learn more, go to Set up payroll custom dimensions to improve performance.
Update considerations
Consider the following information before updating to version 25.3 for Sparkrock 365 2024 release wave 2.
User groups must be migrated to security groups or permission sets
Important
Important:
User group functionality is no longer available with this release.
If you use user groups, before you update to this version, you must migrate your user groups to security groups or permission sets. To learn more, go to User groups migration.
Known problems
The following sections include information about the known problems in version 25.3 for Sparkrock 365 2024 release wave 2.
Documents Factbox does not display the Upload files option for limited access users
The Documents FactBox does not display the Upload files option for limited access users.
Workaround
To upload files when you are a limited access user, perform the following steps:
In the Documents FactBox, choose Show Details.
The Attached Documents page opens.
Depending on whether there are existing attachments, perform one of the following steps:
No existing attachments: In the Attachment column, choose Attach File(s)….
Existing attachments: To add a line, on the action bar, choose New, and then choose Attach File(s)….
An Attach a document dialog box appears.
Drop a file in the box. Alternatively, browse to the file that you want to attach, and then choose Open.
PD-6052
Error: The Sustainability Setup does not exist. Identification fields and values: Primary Keys=''
Users may encounter the following error:
The Sustainability Setup does not exist. Identification fields and values: Primary Keys=''
Workaround
To resolve this problem, perform the following actions:
Open the Sustainability Setup page. To open the page, choose
, enter sustainability setup, and then choose the related link.
Ensure that affected users have the permission sets that are listed in the table below.
Permission Set Name Type Extension Name SUSTAINABILITY, ADMIN Sustainability - Admin System Sustainability SUSTAINABILITY, EDIT Sustainability - Edit System Sustainability SUSTAINABILITY, READ Sustainability - Read System Sustainability To learn more, go to Assign permissions to users and groups.
mySparkrock users cannot view data sets
mySparkrock users cannot view data sets because the MYSPARKROCK user is missing permission sets.
Workaround
To resolve this problem, perform the following steps:
In Sparkrock 365, choose
, enter microsoft entra applications, and then choose the related link.
The Microsoft Entra Applications page opens.
Select the row that has a Description of mySparkrock, and then on the action bar, choose Manage > Edit.
The Microsoft Entra Application Card page opens.
On the User Permission Sets FastTab, add the records that appear in the following table.
Permission Set Name Type Extension Name SPKFA ANALYSIS, EDIT SR365 Create Fin. Analysis System Financial Analysis SPKFA ANALYSIS, VIEW SR365 View Financial Analysis System Financial Analysis SPKFA DATA SET, EDIT SR365 Create data sets System Financial Analysis SPKFA DATA SET, VIEW SR365 View data sets System Financial Analysis To add a record, choose Manage > New Line, and then specify values for fields as required.
Connectivity issue with APIs and other services or integrations
After updating to this release, you may experience connectivity issues with APIs and other services or integrations.
The following list includes examples of how connectivity issues may become apparent:
API errors
Power BI dashboards may no longer work correctly
Integrations may have trouble communicating with Sparkrock 365
Workaround
To resolve this problem, you must uninstall, and then install the respective extension. To uninstall, and then install the extension, perform the following steps:
In Sparkrock 365, choose
, enter extension management, and then choose the related link.
The Extension Management page opens.
In Search, enter api.
A list of the API extensions are displayed, for example, PS Finance APIs.
You may have to change your view so that you can view the version number for any extension. To view the version number for all extensions, choose
, and then choose List.
For each extension that does not have a version that starts with v.25.3 and Is Installed is selected, perform the following steps to uninstall, and then install the extension:
- Select the extension that you want to update, and then on the action bar, choose Manage > Uninstall.
The Extension Uninstallation page opens. - Choose Uninstall.
A dialog box appears and displays text that indicates the extension was successfully uninstalled. - To close the dialog box, choose OK.
- Select the extension that you want to update, and then on the action bar, choose Manage > Install.
The Extension Installation page opens. - Choose Next.
The page refreshes and you are requested to review extension information before installation. - To proceed, turn on I accept the terms and conditions.
- Choose Install.
The extension is updated to the latest version.
- Select the extension that you want to update, and then on the action bar, choose Manage > Uninstall.
Alternate workaround
It is possible that custom web services may have been deleted during or after the update.
To resolve this problem, you must copy and paste the web services lines from a sandbox environment into your production environment.
To copy and paste one or more web services lines, perform the following steps:
Open a Sparkrock 365 sandbox environment that was created before the update or create a sandbox environment from a backup.
Choose
, enter web services, and then choose the related link.
The Web Services page opens.
Copy the information for the one or more lines that you want to copy.
In your Sparkrock 365 production environment, choose
, enter web services, and then choose the related link.
The Web Services page opens.
Paste the information for the one or more lines that you copied.
Re-open button is missing for a submitted expense claim in mySparkrock
The Re-open button may disappear from a submitted expense claim in mySparkrock. This issue occurs when the MYSPARKROCK user is not set up in Sparkrock 365, on the User Setup page.
Workaround
Perform the following steps:
Choose
, enter user setup, and then choose the related link.
The User Setup page opens.
On the action bar, choose New.
A new row appears.
In User ID, specify MYSPARKROCK.
Assign all permissions to this specific user.
For example, select the checkboxes for the following fields:
- A/P Batch Admin
- Allow A/P Batch Creation
- Allow A/P Batch Auditing
- Allow A/P Batch Deletion
- Allow User to Access Compensation Data
- HR Request Reversal Allowed
Electronic Funds Transfer (EFT) errors
The following setup scenarios may result in an Electronic Funds Transfer (EFT) error:
On the Countries/Regions page, ISO Code and ISO Numeric Code are blank, and on the Field Mapping page of the respective data exchange definition, on the Bank No. row, the Optional checkbox is selected.
For this scenario, Sparkrock 365 may generate an EFT file successfully, but the bank may reject the file.
On the Countries/Regions page, ISO Code and ISO Numeric Code are blank, and on the Field Mapping page of the respective data exchange definition, on the Bank No. row, the Optional checkbox is clear.
For this scenario, when you try to generate an Electronic Funds Transfer (EFT) bank import file, Sparkrock 365 may display an error, for example:
Fin. Institution Transit No. must have a value in ACH RB Detail: Data Exch. Entry No.=3, Data Exch. Line Def Code=DETAIL. It cannot be zero or empty.
Workaround
On the Countries/Regions page, ensure that you have a value specified in ISO Code and ISO Numeric Code.
For Canadian banks, specify the following:
- In ISO Code, specify CA.
- In ISO Number Code, specify 124.
For United States of America banks, specify the following:
- In ISO Code, specify US.
- In ISO Number Code, specify 840.
Transaction cannot be completed because it will cause inconsistencies in the G/L Entry table error
When you try to post a purchase invoice for a vendor that has a foreign trade Currency Code set up, for example, USD, you may receive the following error:
This transaction cannot be completed because it will cause inconsistencies in the G/L Entry table. Check where and how the CONSISTENT function is used in the transaction to find the reason for the error.
Contact your system administrator.
Tables can be marked as inconsistent during comprehensive tasks, such as posting. This prevents data from being updated incorrectly.
Workaround
On the Change Exchange Rate page for the specific invoice, increase the number of decimal places for the value in the Relational Exch. Rate Amount field, for example, from 1.4286 to 1.428571.
Alternate workaround
On the Currency Card page of the respective currency, increase the number of decimal places for the value in the Amount Rounding Precision field, for example, from 0.01 to 0.001.
Cannot open links in sent emails
When you open a sent email from the Sent Emails Last 30 Days page, and then select the link that appears in the body of the email, Sparkrock 365 becomes unresponsive.
Workaround
Open links in the body of sent emails from Gmail or Outlook, instead of from Sparkrock 365.
Payroll Employee or Payroll Processing pages may fail to open
When using the platform security filters on permission sets, the Payroll Employee page, Payroll Processing page, or both pages may fail to open with a something went wrong error message. This is a limitation of the payroll processing module.
Workaround
Remove the permission sets with security filters from the user who must access these pages.
Related information
New for Sparkrock 365
Version 25.3 for mySparkrock 2024 Release Wave 2 Release Notes
Payroll releases
Feedback
To send feedback about this page, select the following link: