Version 24.5 for Sparkrock 365 2024 release wave 1 release notes Published November 19, 2024
These release notes include supplemental information about version 24.5 for Sparkrock 365 2024 release wave 1.
Video
The following video includes information about the new features and enhancements in version 24.5 for Sparkrock 365 2024 release wave 1.
Highlights
The following sections highlight the major accomplishments in this release.
Employee benefits processing enhancements for a transfer HR request
Employee benefits processing enhancements for an additional assignment HR request
Retain employee information when reversing a new hire HR request
Processing enhancements for leave change HR request date changes
Register employee certifications for Employment Data & Analysis System (EDAS) reporting
Social Security Number (SSN) format and validation enhancements
New features and changes
Version 24.5 for Sparkrock 365 2024 release wave 1 introduces exciting new features and enhancements to existing functionality.
Microsoft Dynamics 365 Business Central 24
The base Microsoft Dynamics 365 Business Central platform that powers Sparkrock 365, has been updated from 22.5 to 24.5.
For more information about Microsoft Dynamics 365 Business Central releases since 22.5, select the following links:
What's new and planned for Dynamics 365 Business Central 2024 release wave 1 (24)
Update 24.5 for Microsoft Dynamics 365 Business Central online 2024 release wave 1
Update 24.4 for Microsoft Dynamics 365 Business Central online 2024 release wave 1
Update 24.3 for Microsoft Dynamics 365 Business Central online 2024 release wave 1
Update 24.2 for Microsoft Dynamics 365 Business Central online 2024 release wave 1
Update 24.1 for Microsoft Dynamics 365 Business Central online 2024 release wave 1
What's new and planned for Dynamics 365 Business Central 2023 release wave 2 (23)
Update 23.5 for Microsoft Dynamics 365 Business Central online 2023 release wave 2
Update 23.4 for Microsoft Dynamics 365 Business Central online 2023 release wave 2
Update 23.3 for Microsoft Dynamics 365 Business Central online 2023 release wave 2
Update 23.2 for Microsoft Dynamics 365 Business Central online 2023 release wave 2
Update 23.1 for Microsoft Dynamics 365 Business Central online 2023 release wave 2
To view a detailed list of cumulative platform fixes that are available from Microsoft, see Update history for Microsoft Dynamics 365 Business Central.
Analysis mode
Sparkrock 365 now includes the capability for you to analyze data directly from Sparkrock 365 pages, without having to run a report or open another application, such as Microsoft Excel. The feature provides an interactive and versatile way to calculate, summarize, and examine data. Instead of running reports using different options and filters, you can add multiple tabs that represent different tasks or views on the data.
For more information, see Analyze list data using data analysis mode.
Productivity enhancements
The following sections describe some of the productivity enhancements in this release.
Modern action bar
To help users become more proficient, this release introduces enhancements to the action bar. You can customize the action bar to meet the requirements of your organization, or yourself. You can add actions that you want to make available in a discoverable and consistent way across Sparkrock 365.
For more information, go to Modern Action Bar and Personalize your workspace.
Actionable errors
To assist users in resolving errors more effectively, this release enhances the Sparkrock 365 error handling framework to include promoted actions in both error dialogs and validation errors.
For more information, go to Actionable errors.
Show related record details from lookups
To help users access information about related records, this release introduces a Show Details button on lookups.
For more information, go to Show related record details from lookup.
Search company data from Tell Me
This release introduces the capability for you to search company data from Tell Me.
The search results include the top results in the tables to which you have access.
Sparkrock 365 does not search all tables. To view or set up the list of tables that Sparkrock 365 searches, choose Set up where to search.
When you choose Set up where to search, Sparkrock 365 opens the Enable lists for searching page.
For more information, go to Get to data search from anywhere in Business Central and Search for a Record in Your Data.
Finance enhancements
The following sections describe some of the platform finance related enhancements in this release.
Purchase and sales order navigation
To provide insight into the documents that are associated with purchase and sales orders, this release introduces the capability to more quickly access information for posted documents directly from an order or return.
For example:
- From sales order lines, you can drill down in the Qty. Shipped and Qty. Invoice fields.
- From purchase order lines, you can drill down in the Qty. Received and Qty. Invoiced fields.
- From sales return lines, you can drill down in the Return Qty. Received and Qty. Invoiced fields.
- From purchase return lines, you can drill down in the Return Qty. Shipped and Qty. Invoiced fields.
For more information, go to Navigate easier between order, receipt, and invoice documents.
General journal approvals
When you send a general journal batch or specific general journal lines for approval, Sparkrock 365 prevents users from making changes to the batch or lines until the batch or lines are approved. Because mistakes happen, this release introduces actionable inline errors to make the correction workflow easier.
For example, after a user submits a general journal batch for approval, an accounting manager notices that the wrong General Ledger (G/L) account is specified. If the accounting manager tries to change the G/L account, Sparkrock 365 now displays an inline validation error message and provides two actions that the accounting manager can take to fix the mistake. The accounting manager can choose Show Comments, and then add a comment to document what changes are necessary. Also, the accounting manager can choose Reject approval to return the general journal batch to the submitter.
For more information, go to More control over general journal approvals.
Allow lines with amounts of zero on recurring general journals
This release introduces changes that make it easier to maintain recurring general journals that have zero amount lines in some runs. During posting, Sparkrock 365 now ignores the lines that have a zero amount and doesn't post these lines. Sparkrock 365 no longer prompts you to add an amount or delete these zero amount lines. This feature saves you from having to delete the lines, and then add the lines again in a future run. The lines remain in the journal for the next run, where you can update the amounts as required.
For more information, go to Allow lines with amounts of zero on recurring general journals and Work with general journals.
Reverse ledger entry with realized gain or loss
Starting with this release, you can use the Reverse transaction action to reverse payments that were applied to entries that originated in foreign currencies and were adjusted using the Exchange Rate Adjustment batch job.
This feature works for both purchases and sales.
The following list is a simple scenario that illustrates how this feature works:
- Post a sales invoice for a customer using a foreign currency.
- Adjust the exchange rate for that currency.
- Post a payment applied to the invoice.
- Unapply and reverse the payment transaction, for example, from the Customer Ledger Entries page.
For more information, go to Reverse a customer and vendor ledger entry with a realized gain or loss entry and Update currency exchange rates.
Financial consolidation run enhancements
When you run consolidation for business units that use a foreign currency, you must pay attention to the exchange rates that various parts of the process use, and even more so when you redo a consolidation.
To more easily track these exchange rates, starting with this release, you can use the Setup Business Unit Currencies page.
When you run a consolidation, the Setup Business Unit Currencies page provides the last rates that were entered for average, closing, and last closing rate. Also, you can look up the exchange rates in the currency exchange rate table, which makes it easier to validate. To modify the rates that are used for the current run, you can enter the values or copy the values from previous runs.
The Setup Business Unit Currencies page is particularly valuable when you want to rerun a previous consolidation, where you must use the closing rate of the consolidation run previous to the earliest of such runs. This setup is required to correctly revaluate your balance sheet items. To find the relevant last run to copy values from, or just look up the rates that were used when you're troubleshooting, you can use the Select from previous consolidations action. Sparkrock 365 displays only the runs for the specified business unit.
For more information, go to Set up financial consolidation runs more efficiently and Set up company consolidation.
Excel report layouts
This release introduces new Excel reports and report layouts that let you interactively generate analysis and present learnings about key aspects of your business, such as finance, sales, and purchases.
You now have more ways to create your own Excel layouts for reports because not only do you get the reports, but also data from the report request pages and data for translations of a layout. If the data comes from multiple tables, the report layouts show the data in multiple worksheets, This design is intended to help you understand where the data originated. The reports are flexible, and you can use the reports in the way that best fits your requirements.
For example, you can perform the following tasks:
- Use the reports as-is to get insight about your organization.
- Use pivot tables to slice and dice data for analysis.
- Use the reports as a template to create your own Excel layouts for the same data.
On the Report Layouts page, you can create your own copies of the report layouts.
For more information, go to Use new Excel layouts for selected reports and Working with Microsoft Excel layouts.
Allocation accounts enhancements
Sparkrock is enhancing the Business Central allocation accounts feature. While the enhancements are in progress, you cannot use this feature. This feature will be available in a future release.
Statistical accounts enhancements
Sparkrock is enhancing the Business Central statistical accounts feature. While the enhancements are in progress, you cannot use this feature. This feature will be available in a future release.
Bank deposit enhancements
This release introduces several architectural changes to the bank deposit functionality in Sparkrock 365. These changes are necessary because Microsoft implemented changes to the bank deposit functionality in Business Central. For more information about the Business Central changes, go to Standardizing the bank reconciliation process in North American versions. For the most part, the bank deposit functionality in Sparkrock 365 works the same as previous releases.
The following sections include information about the customer facing changes in this release to the bank deposit functionality in Sparkrock 365.
New Bank Deposits page
The Deposits page has been replaced with a Bank Deposits page.
When you update to this release, all data that appeared on the Deposits page in the previous release now appears on the Bank Deposits page.
New Posted Bank Deposits page
The Posted Deposits page has been replaced with a Posted Bank Deposits page.
All data that appeared on the Posted Deposits page in previous releases continues to appear on the Posted Deposits page in this release. Starting with this release, new posted bank deposits appear on the Posted Bank Deposits page.
New Bank Deposit page
The Deposit page has been replaced with a Bank Deposit page.
When you update to this release, all data that appeared on the Deposit page in the previous release now appears on the Bank Deposit page.
For more information, go to Create bank deposits.
New Posted Bank Deposit page
The Posted Deposit page has been replaced with a Posted Bank Deposit page.
When you update to this release, all data that appeared on the Posted Deposit page in the previous release now appears on the Posted Bank Deposit page.
For more information, go to Create bank deposits.
Post as lump sum
On the new Bank Deposit page, there is a Post as Lump Sum field.
When Post as Lump Sum is turned on, Sparkrock 365 posts the bank deposit as a single bank account ledger entry with the total amount. Also, all lines must have the same value for Document No. as the bank deposit.
For more information, go to Create bank deposits.
Cash receipts integration with the new Bank Deposit and Posted Bank Deposit pages
To integrate the Sparkrock 365 cash receipts functionality from previous releases with the new Bank Deposit and Posted Bank Deposit pages in this release, this release includes the following changes to the base Business Central functionality:
On the Cash Receipt Batch Card page, there is a new Transfer to Deposit action.
When you choose the Transfer to Deposit action, Sparkrock 365 transfers the cash receipt data to the bank deposit. On the bank deposit, Sparkrock 365 automatically populates the values of Cash Receipt No. and Cash Receipt Line No.. On the cash receipt, Sparkrock 365 automatically populates the value of Bank Deposit No. and updates the Status to Transferred to Deposit.
On the Cash Receipt Batch Card page, there is a new No. of Transferred to Deposit field.
The No. of Transferred to Deposit field displays the total number of cash receipts that have been transferred to a bank deposit. When you select the link that appears for the field value, Sparkrock 365 opens the Cash Receipts page where you can view the cash receipts that have been transferred to a bank deposit.
On the Cash Receipts and Cash Receipt Card pages, there is a new Status of Transferred to Deposit.
When you choose the Transfer to Deposit action, after Sparkrock 365 completes the transfer, Sparkrock 365 updates the Status on the respective cash receipt lines to Transferred to Deposit. If deposit lines are removed, Sparkrock 365 reverts the Status to Open.
On the Cash Receipt Card page, on the Lines FastTab, there is a new Bank Deposit action.
You can use the Bank Deposit action to open the respective Bank Deposit or Posted Bank Deposit pages.
When you post a deposit that is associated with a cash receipt, on the Cash Receipt Card page, on the Lines FastTab, Sparkrock 365 automatically updates the Status to Deposit Posted and assigns a value to Posted Bank Deposit No..
For more information, go to Cash receipts and bank deposits.
Accounting Manage role center enhancements
On the Accounting Manager role center, in the Cash Management section, this release renames the Deposits link to Bank Deposits. The Bank Deposits link opens the Bank Deposits page. In the Posted Documents section, this release renames the Posted Deposits link to Posted Bank Deposits. The Posted Bank Deposits link opens the Posted Bank Deposits page.
Accounts Receivable Administrator role center enhancements
On the Accounts Receivable Administrator role center, in the Home section, this release renames the Deposits link to Bank Deposits. The Bank Deposits link opens the Bank Deposits page. In the Posted Documents section, this release renames the Posted Deposits link to Posted Bank Deposits. The Posted Bank Deposits link now opens the Posted Bank Deposits page.
Charitable receipts integration with the new Bank Deposit and Posted Bank Deposit pages
To integrate the Sparkrock 365 charitable receipts functionality from previous releases with the new Bank Deposit and Posted Bank Deposit pages in this release, this release includes the following changes to the base Business Central functionality:
On the Bank Deposit page, on the Lines FastTab, this release adds the following Sparkrock 365 charitable donation specific fields to the base Business Central functionality:
Account Set Code: Specifies the code that represents the respective account set of the charitable donation. When you specify a value for Account Set Code, Sparkrock 365 automatically populates the Account Type, Account No., and Description fields on the same line.
Donation Description: Specifies a description of the charitable donation.
Charitable Donation: Specifies whether this bank deposit line is a charitable donation.
Name: Specifies the name of the charitable donation donor.
Address: Specifies the address of the charitable donation donor.
Address 2: Specifies the address line 2 of the charitable donation donor.
City: Specifies the city of the charitable donation donor.
State: Specifies the state of the charitable donation donor.
ZIP Code: Specifies the ZIP code of the charitable donation donor.
Country Code: Specifies the country code of the charitable donation donor.
Cash: Specifies whether the charitable donation is cash.
Contact No.: Specifies the number that represents the contact of the charitable donation donor.
When you post a bank deposit that has the Charitable Donation checkbox selected, Sparkrock 365 performs the following tasks:
- Populates the Posted Bank Deposit page with the charitable donation specific fields that appear on the Bank Deposit page, except for Account Set Code.
- Copies the values for Account Set Code to the respective General Ledger (G/L) entries.
- Populates the Charitable Receipts page with the charitable donation specific fields that appears on the Bank Deposit page, as well as details from the posted deposit lines.
- Populates the value of the Charitable Receipt No. field on the Charitable Receipts page.
When you post a bank deposit that has the Charitable Donation checkbox selected, and then you run a related Charitable Receipts report, Sparkrock 365 automatically populates the report with the charitable donation specific fields that appear on the Bank Deposit page, except for Account Set Code and Cash.
For more information, go to Create a charitable receipt for a bank deposit and Create a charitable receipt for a cash receipt.
New Charitable Receipt Archives list and report pages
To provide the capability for you to manage charitable receipts that were created before the update to version 24.5 for Sparkrock 365 2024 release wave 1, this release introduces Charitable Receipt Archives list and report pages.
The Charitable Receipt Archives list and report pages are available from Tell Me.
From the Charitable Receipt Archives page, you can perform the following tasks for charitable receipts that were created before the update to version 24.5 for Sparkrock 365 2024 release wave 1:
View details for charitable receipts.
Edit the name or address on charitable receipts.
Print charitable receipts.
For more information, go to View a charitable receipt that was created before the update to version 24.5 for Sparkrock 365 2024 release wave 1, Edit a charitable receipt that was created before the update to version 24.5 for Sparkrock 365 2024 release wave 1, and Print a charitable receipt that was created before the update to version 24.5 for Sparkrock 365 2024 release wave 1.
Edit dimension set entries from the new Bank Deposit page
On the Bank Deposit page, on the Lines FastTab action bar, you can choose Line > Dimensions to open the respective Edit Dimension Set Entries page and make changes as required.
After you post the bank deposit, on the Posted Bank Deposit page, on the Lines FastTab action bar, you can choose Line > Dimensions to open the respective Dimension Set Entries page and view the associated dimensions.
Manage attachments from the new Bank Deposit page
On the Bank Deposit page, you can manage attachments at the bank deposit level and at the bank deposit line level as required. To manage attachments at the bank deposit level, you can use the Attachments FactBox.
During posting, Sparkrock 365 copies attachments that appear in the Attachments FactBox to the respective posted bank deposit and General Ledger (G/L) entries.
To manage attachments at the bank deposit line level, you can select the line, and then on the Lines FastTab action bar, you can choose Related Information > Attachments.
When you choose the Attachments action, Sparkrock 365 opens the Attached Documents page where you can manage attachments for the line as required.
During posting, Sparkrock 365 copies attachments at the bank deposit line level to the posted bank deposit lines.
For more information, go to Bank deposit attachments.
Deposit import integration with the new Bank Deposit page
To integrate the Sparkrock 365 deposit import functionality from previous releases with the new Bank Deposit page in this release, on the Bank Deposit page, this release adds an Import from Excel action to the base Business Central functionality.
You can use the Import from Excel action to import bank deposit data into Sparkrock 365 from a new enhanced Excel template. To download the new Excel template file, select the following link:
Import bank deposit lines from Excel template
For more information, go to Bank deposit lines import.
Dimension validation setup integration with the new Bank Deposit and Bank Deposits pages
To integrate the Sparkrock 365 dimension validation setup functionality from previous releases with the new Bank Deposit page in this release, on the Bank Deposits page, this release adds the following changes to the base Business Central functionality:
Error handling that is based on the setup of the Dimension Validation Setup page.
On the action bar, you can choose the Document Warnings action to open the Document Warnings page, and then view the document warnings that are related to the dimension validation setup.
For more information, see Set up account set validation.
Bank reconciliation enhancements
Before this release, depending on your environment setup, bank reconciliations could be performed through the Bank Acc. Reconciliation page or the Bank Rec. Worksheet page. The Bank Rec. Worksheet page was missing some features that exist on the Bank Acc. Reconciliation page. To standardize the bank reconciliation process, Microsoft removed the Bank Rec. Worksheet page from Business Central and enhanced the Bank Acc. Reconciliation page.
The following list describes some of the enhancements to the Bank Acc. Reconciliation page:
- This release adds the capability for users to reconcile deposits.
- The header and footer fields ensure that users have the same overview of outstanding checks and payments that existed in previous releases on the Bank Rec. Worksheet page.
- The Bank Statement report displays more detailed information on the General Ledger (G/L) balance and outstanding checks and payments.
- The standard side-by-side bank view provides the capability for users to import bank statements (.csv files), use automatic matching, post and reconcile deposits, and get a better overview of related data during bank reconciliation through on-page information, such as a test report as well as a more audit-friendly report for posted bank reconciliations.
For more information about the Business Central changes, go to Standardizing the bank reconciliation process in North American versions.
The following list includes information about the customer facing changes in this release to the bank reconciliation functionality in Sparkrock 365:
On the Bank Account Reconciliations page, when you choose the New action to create a bank account reconciliation, Sparkrock 365 now opens the Bank Acc. Reconciliation page, instead of the Bank Rec. Worksheet page.
You no longer have the option to use the Bank Rec. Worksheet page based on the setup of the General Ledger Setup page.
To integrate the Sparkrock 365 bank account reconciliation functionality from previous releases with the base Business Central bank account reconciliations changes in this release, this release adds the following changes to the base Business Central functionality:
On the Bank Acc. Reconciliation page, in the Bank Account Ledger Entries section, there is a new Date Cleared field.
The Date Cleared field specifies the date on which the bank account ledger entry cleared.
On the Bank Account Ledger Entries page, there is a new Date Cleared field.
On the Bank Acc. Reconciliation page, when you choose the Post action, Sparkrock 365 performs the following steps:
- Searches for records where the Applied checkbox is selected for a bank account ledger entry and performs validations on the bank account reconciliation, for example, verifies that a value is populated for Statement Date, and that the value of Statement Ending Balance is the same as the value for Total Balance.
- Creates the respective bank account statement.
- On the Bank Acc. Reconciliation, Bank Account Ledger Entries, and Check Ledger Entries pages, updates the Cleared field with the Statement Date value from the Bank Acc. Reconciliation page.
For bank account ledger entries, Sparkrock 365 only updates records where the Document No. is the same on the Bank Acc. Reconciliation and Bank Account Ledger Entries pages.
For check ledger entries, Sparkrock 365 only updates records where the Document No. on the Bank Acc. Reconciliation page is the same as the Check No. on the Check Ledger Entries page.
- Searches for records where the Applied checkbox is selected for a bank account ledger entry and performs validations on the bank account reconciliation, for example, verifies that a value is populated for Statement Date, and that the value of Statement Ending Balance is the same as the value for Total Balance.
This release removes the Import Bank Statement action from the following role centers:
- Accounting Manager
- Accounts Payable Coordinator
The import bank statement functionality is only available on the Bank Acc. Reconciliation page.
This release removes the Import Bank Statement task from the Tell Me search results.
The import bank statement functionality is only available on the Bank Acc. Reconciliation page.
For more information, go to Manage and reconcile your bank accounts, Bank statement import, and Bank account reconciliation date cleared.
Control whether mySparkrock users can receive purchase orders
In preparation for a future mySparkrock release, this release introduces the capability for you to control whether mySparkrock users can receive purchase orders on mySparkrock. This new functionality is available on the user and user profile levels.
The following sections include information about the customer facing changes in this release to support this feature.
New Receive Purchase Orders on mySparkrock field on the mySparkrock User Setup Card page
On the mySparkrock User Setup Card page, this release introduces a Receive Purchase Orders on mySparkrock field.
To specify that a user can receive purchase orders on mySparkrock, on the respective mySparkrock User Setup Card page, turn on Receive Purchase Orders on mySparkrock. Alternatively, to prevent a user from receiving purchase orders on mySparkrock, turn off Receive Purchase Orders on mySparkrock.
New Receive Purchase Orders on mySparkrock field on the mySparkrock User Profile Card page
On the mySparkrock User Profile Card page, this release introduces a Receive Purchase Orders on mySparkrock field.
To specify that users who are assigned to a user profile can receive purchase orders on mySparkrock, on the respective mySparkrock User Profile Card page, turn on Receive Purchase Orders on mySparkrock. Alternatively, to prevent users who are assigned to a user profile from receiving purchase orders on mySparkrock, turn off Receive Purchase Orders on mySparkrock.
Employee benefits processing enhancements for a transfer HR request
Starting with this release, when you process an HR request to transfer an employee to a new assignment, Sparkrock 365 makes changes to the employee's Employee Benefits page as follows:
If the benefit plan of the new assignment is the same as the previous assignment, Sparkrock 365 does not make any changes to the employee's Employee Benefits page. In other words, the employee's benefit plan code remains the same.
If the benefit plan of the new assignment is different than the previous assignment, and the effective date of the transfer is less than or equal to today, Sparkrock 365 updates the employee's Employee Benefits page to have the new benefit plan code.
If the benefit plan of the new assignment is different than the previous assignment, and the effective date of the transfer is in the future, Sparkrock 365 does not update the employee's Employee Benefits page to have the new benefit plan code until the effective date of the transfer is reached.
For more information, go to Transfer employees to new assignments.
Employee benefits processing enhancements for an additional assignment HR request
Starting with this release, when you process an additional assignment HR request, Sparkrock 365 makes changes to the employee's Employee Benefits page as follows:
If the benefit plan of the new assignment is the same as the existing assignment, Sparkrock 365 does not make any changes to the employee's Employee Benefits page. In other words, the employee's benefit plan code remains the same.
If the benefit plan of the new assignment is different than the existing assignment, and on the employee's Employee Benefits page there are one or more existing records, Sparkrock 365 retains the one or more existing records. In other words, Sparkrock 365 does not delete any records.
If the benefit plan of the new assignment is different than the existing assignment, and on the employee's Employee Benefits page, no records exist, Sparkrock 365 updates the employee's Employee Benefits page to have the new benefit plan code. For this scenario, if the effective date is less than or equal to today, Sparkrock 365 performs the update immediately. Otherwise, if the effective date is in the future, Sparkrock 365 does not update the employee's Employee Benefits page to have the new benefit plan code until the effective date is reached.
For more information, go to Add additional employee assignments.
Retain employee information when reversing a new hire HR request
This release introduces the capability for you to choose whether you want to retain the employee information when reversing a new hire HR request.
After you choose the Reverse action on a new hire HR request, Sparkrock 365 now displays a prompt that asks you whether you want to keep the employee number.
If you choose Yes, Sparkrock 365 retains the employee information and you can view the details on the Employee Card page. Alternatively, if you choose No, Sparkrock 365 deletes the employee information.
For more information, go to Reverse HR requests.
New fields on the HR Request-Leave page
On the HR Request-Leave page, this release introduces the following new fields:
- Calculation Start Date: Specifies the start date for HR request calculations.
- Calculation End Date: Specifies the end date for HR request calculations.
- Assignment Start Date: Specifies the start date of an assignment that is associated with this HR request.
- Assignment End Date: Specifies the end date of an assignment that is associated with this HR request.
These fields are visible when you create an HR request that has an HR Reason Code of 37-LEAVE CHANGE, and then choose the Details action. For more information, go to Change leave details.
Processing enhancements for leave change HR request date changes
This release introduces processing enhancements for leave change HR requests where there are changes to the Calculation Start Date, Calculation End Date, Assignment Start Date, or Assignment End Date.
Changes to start dates
The following sections describe the enhancements to leave change HR request processing for changes to start dates.
Leave change calculation start date or assignment start date is greater than the on leave calculation start date or assignment start date
When processing a leave change HR request, and the Calculation Start Date or Assignment Start Date is greater than the Calculation Start Date or Assignment Start Date on the related on leave assignment, Sparkrock 365 performs the following steps:
- Updates the Calculation End Date or Assignment End Date on the original active assignment to be one day less than the Calculation Start Date or Assignment Start Date on the leave change HR request.
- Cancels the on leave assignment.
- Creates an assignment based on the data that is specified in the leave change HR request.
Example
Below is an example to illustrate how Sparkrock 365 processes a leave change HR request where the calculation start date or assignment start date is greater than the on leave calculation start date or assignment start date.
The following table describes how assignment records appear before Sparkrock 365 processes the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date |
|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 |
| 37-LEAVE CHANGE | July 16, 2024 | September 30, 2024 |
For this scenario, Sparkrock 365 performs the following steps:
- Updates the Calculation End Date or Assignment End Date on the original active assignment to July 15, 2024.
- Cancels the existing on leave assignment.
- Creates an assignment with the details from the leave change HR request.
The following table describes how the assignment records appear after Sparkrock 365 processes the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | July 15, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Cancelled |
| 37-LEAVE CHANGE | July 16, 2024 | September 30, 2024 | Assignment |
Leave change calculation start date or assignment start date is less than the on leave calculation start date or assignment start date
When processing a leave change HR request, and the Calculation Start Date or Assignment Start Date is less than the Calculation Start Date or Assignment Start Date on the related on leave HR assignment, Sparkrock 365 performs the following steps:
- Updates the Calculation End Date or Assignment End Date on the original active assignment to be one day less than the Calculation Start Date or Assignment Start Date on the leave change HR request.
- Cancels the on leave assignment.
- Creates an assignment based on the data that is specified in the leave change HR request.
Example
Below is an example to illustrate how Sparkrock 365 processes a leave change HR request where the calculation start date or assignment start date is less than the on leave calculation start date or assignment start date.
The following table describes how assignment records appear before Sparkrock 365 processes the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date |
|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 |
| 37-LEAVE CHANGE | June 15, 2024 | September 30, 2024 |
For this scenario, Sparkrock 365 performs the following steps:
- Updates the Calculation End Date or Assignment End Date on the original active assignment to June 14, 2024.
- Cancels the existing on leave assignment.
- Creates an assignment with the details from the leave change HR request.
The following table describes how the assignment records appear after Sparkrock 365 processes the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 14, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Cancelled |
| 37-LEAVE CHANGE | June 15, 2024 | September 30, 2024 | Assignment |
Changes to end dates
The following sections describe the enhancements to leave change HR request processing for changes to end dates.
Leave change calculation end date or assignment end date is greater than the on leave calculation end date or assignment end date
When processing a leave change HR request, and the Calculation End Date or Assignment End Date is greater than the Calculation End Date or Assignment End Date on the related on leave assignment, Sparkrock 365 performs the following steps:
- Retains the original active assignment.
- Cancels the on leave assignment.
- Creates an assignment based on the data that is specified in the leave change HR request.
Example
Below is an example to illustrate how Sparkrock 365 processes a leave change HR request where the calculation end date or assignment end date is greater than the on leave calculation end date or assignment end date.
The following table describes how assignment records appear before Sparkrock 365 processes the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date |
|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 |
| 37-LEAVE CHANGE | July 1, 2024 | October 15, 2024 |
For this scenario, Sparkrock 365 performs the following steps:
- Retains the original active assignment.
- Cancels the on leave assignment.
- Creates an assignment with the details from the leave change HR request.
The following table describes how the assignment records appear after Sparkrock 365 processes the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Cancelled |
| 37-LEAVE CHANGE | July 1, 2024 | October 15, 2024 | Assignment |
Leave change calculation end date or assignment end date is less than the on leave calculation end date or assignment end date
When processing a leave change HR request, and the Calculation End Date or Assignment End Date is less than the Calculation End Date or Assignment End Date on the related on leave assignment, Sparkrock 365 performs the following steps:
- Retains the original active assignment.
- Cancels the on leave assignment.
- Creates an assignment based on the data that is specified in the leave change HR request.
Example
Below is an example to illustrate how Sparkrock 365 processes a leave change HR request where the calculation end date or assignment end date is less than the on leave calculation end date or assignment end date.
The following table describes how assignment records appear before Sparkrock 365 processes the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date |
|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 |
| 37-LEAVE CHANGE | July 1, 2024 | September 15, 2024 |
For this scenario, Sparkrock 365 performs the following steps:
- Retains the original active assignment.
- Cancels the on leave assignment.
- Creates an assignment with the details from the leave change HR request.
The following table describes how the assignment records appear after Sparkrock 365 processes the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Cancelled |
| 37-LEAVE CHANGE | July 1, 2024 | September 15, 2024 | Assignment |
Changes to start dates reversal processing
The following sections describe the enhancements to leave change HR request reversal processing for changes to start dates.
Leave change calculation start date or assignment start date is greater than the on leave calculation start date or assignment start date
When processing a reversal of a leave change HR request, and the Calculation Start Date or Assignment Start Date is greater than the Calculation Start Date or Assignment Start Date on the related on leave assignment, Sparkrock 365 performs the following steps:
- Adjusts the Calculation End Date or Assignment End Date on the original assignment to be one day less than the Calculation Start Date or Assignment Start Date of the on leave assignment.
- Restores the on leave assignment.
- Cancels the assignment that was created based on the data that was specified in the leave change HR request.
Example
Below is an example to illustrate how Sparkrock 365 processes a reversal of a leave change HR request where the calculation start date or assignment start date is greater than the on leave calculation start date or assignment start date.
The following table describes how assignment records appear before Sparkrock 365 processes the reversal of the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | July 15, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Cancelled |
| 37-LEAVE CHANGE | July 16, 2024 | September 30, 2024 | Assignment |
For this scenario, Sparkrock 365 performs the following steps:
- Adjusts the Calculation End Date or Assignment End Date on the original assignment to be June 30, 2024.
- Restores the on leave assignment.
- Cancels the assignment that was created based on the data that was specified in the leave change HR request.
The following table describes how the assignment records appear after Sparkrock 365 processes the reversal of the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Assignment |
| 37-LEAVE CHANGE | July 16, 2024 | September 30, 2024 | Cancelled |
Leave change calculation start date or assignment start date is less than the on leave calculation start date or assignment start date
When processing a reversal of a leave change HR request, and the Calculation Start Date or Assignment Start Date is less than the Calculation Start Date or Assignment Start Date on the related on leave assignment, Sparkrock 365 performs the following steps:
- Adjusts the Calculation End Date or Assignment End Date on the original assignment to be one day less than the Calculation Start Date or Assignment Start Date of the on leave assignment.
- Restores the on leave assignment.
- Cancels the assignment that was created based on the data that was specified in the leave change HR request.
Example
Below is an example to illustrate how Sparkrock 365 processes a reversal of a leave change HR request where the calculation start date or assignment start date is less than the on leave calculation start date or assignment start date.
The following table describes how assignment records appear before Sparkrock 365 processes the reversal of the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 14, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Cancelled |
| 37-LEAVE CHANGE | June 15, 2024 | September 30, 2024 | Assignment |
For this scenario, Sparkrock 365 performs the following steps:
- Adjusts the Calculation End Date or Assignment End Date on the original assignment to be June 30, 2024.
- Restores the on leave assignment.
- Cancels the assignment that was created based on the data that was specified in the leave change HR request.
The following table describes how the assignment records appear after Sparkrock 365 processes the reversal of the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Assignment |
| 37-LEAVE CHANGE | June 15, 2024 | September 30, 2024 | Cancelled |
Changes to end dates reversal processing
The following sections describe the enhancements to leave change HR request reversal processing for changes to end dates.
Leave change calculation end date or assignment end date is greater than the on leave calculation end date or assignment end date
When processing a reversal of a leave change HR request, and the Calculation End Date or Assignment End Date is greater than the Calculation End Date or Assignment End Date on the related on leave HR assignment, Sparkrock 365 performs the following steps:
- Restores the original assignment.
- Restores the on leave assignment.
- Cancels the assignment that was created based on the data that was specified in the leave change HR request.
Example
Below is an example to illustrate how Sparkrock 365 processes a reversal of a leave change HR request where the calculation end date or assignment end date is greater than the on leave calculation end date or assignment end date.
The following table describes how assignment records appear before Sparkrock 365 processes the reversal of the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Cancelled |
| 37-LEAVE CHANGE | July 1, 2024 | October 15, 2024 | Assignment |
For this scenario, Sparkrock 365 performs the following steps:
- Restores the original assignment.
- Restores the on leave assignment.
- Cancels the assignment that was created based on the data that was specified in the leave change HR request.
The following table describes how the assignment records appear after Sparkrock 365 processes the reversal of the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Assignment |
| 37-LEAVE CHANGE | July 1, 2024 | October 15, 2024 | Cancelled |
Leave change calculation end date or assignment end date is less than the on leave calculation end date or assignment end date
When processing a reversal of a leave change HR request, and the Calculation End Date or Assignment End Date is less than the Calculation End Date or Assignment End Date on the related on leave assignment, Sparkrock 365 performs the following steps:
- Restores the original assignment.
- Restores the on leave assignment.
- Cancels the assignment that was created based on the data that was specified in the leave change HR request.
Example
Below is an example to illustrate how Sparkrock 365 processes a reversal of a leave change HR request where the calculation end date or assignment end date is less than the on leave calculation end date or assignment end date.
The following table describes how assignment records appear before Sparkrock 365 processes the reversal of the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Cancelled |
| 37-LEAVE CHANGE | July 1, 2024 | September 15, 2024 | Assignment |
For this scenario, Sparkrock 365 performs the following steps:
- Restores the original assignment.
- Restores the on leave assignment.
- Cancels the assignment that was created based on the data that was specified in the leave change HR request.
The following table describes how the assignment records appear after Sparkrock 365 processes the reversal of the change leave HR request.
| HR Reason Code | Calculation Start Date or Assignment Start Date | Calculation End Date or Assignment End Date | Entry Type |
|---|---|---|---|
| 15-NEW HIRE | January 1, 2024 | June 30, 2024 | Assignment |
| 35-ON LEAVE | July 1, 2024 | September 30, 2024 | Assignment |
| 37-LEAVE CHANGE | July 1, 2024 | September 15, 2024 | Cancelled |
For more information, go to Change leave details.
Register employee certifications for Employment Data & Analysis System (EDAS) reporting
This release introduces enhancements regarding registering employee certifications for Employment Data & Analysis System (EDAS) reporting. The functionality supports registering certification data for the Teacher Regulation Branch (TRB) and Teacher Qualification Service (TQS).
For more information, go to Set up British Columbia certifications and Set up a British Columbia certification for an employee association.
The following sections include information about the customer facing changes in this release to support this feature.
New British Columbia Certifications page
To provide the capability for you to register employee British Columbia certifications for Employment Data & Analysis System (EDAS) reporting, this release introduces a British Columbia Certifications page.
On the British Columbia Certifications page, you can specify the certifications that are to be associated with employee associations.
The page includes the following fields:
Certificate ID: Specifies the ID of the certification.
Certificate Group: Specifies the group of the certification.
Certificate Term: Specifies the term of the certification.
Certificate Type: Specifies the type of certification.
EDAS Code: Specifies the EDAS code of the certification.
For more information, go to Set up British Columbia certifications.
Employee Associations page enhancements
To support Employment Data & Analysis System (EDAS) reporting requirements, on the Employee Associations page, this release introduces several fields.
The following list includes information about the new fields:
Certificate ID: Specifies the ID of the certificate.
Certificate Type: Specifies the type of certification.
Category: Specifies the Teacher Qualification Service (TQS) category of the certification.
EDAS Code: Specifies the EDAS code of the certification.
Also, you can now add an attachment to an employee association record.
For more information, go to Set up a British Columbia certification for an employee association.
Changes to 22 BCCT Certification field on the EDAS Setup page
On the EDAS Setup page, this releases makes changes to the 22 BCCT Certification field. The field now specifies the employee association that Sparkrock 365 is to use to obtain data for Employment Data & Analysis System (EDAS) reporting.
Changes for column 22 of the Employment Data & Analysis System (EDAS) report
Starting with this release, to determine the value of column 22 of the Employment Data & Analysis System (EDAS) report, Sparkrock 365 uses the first letter of the EDAS Code field from the Employee Associations page for the respective employee. To determine the employee association, Sparkrock 365 uses the setup in the 22 BCCT Certification field on the EDAS Setup page. If the value of the EDAS Code field is blank, Sparkrock 365 does not report a value in column 22.
For more information, go to Employment Data & Analysis System (EDAS) report column mapping, calculations, and validations.
Removal of the BCCT Certification field from the Qualifications page
Due to the changes in this release for column 22 for Employment Data & Analysis System (EDAS) reporting, this release removes the BCCT Certification field from the Qualifications page.
Exclude an HR pay code from retro pay calculations
This release introduces the capability for you to exclude an HR pay code from retro pay calculations. To exclude an HR pay code from retro pay calculations, on the HR Pay Codes page, on the row of the HR pay code that you want to exclude from retro pay calculations, select the Exclude from Retro Pay checkbox.
As part of this feature, this release introduces changes to the load retro pay lines functionality that is available from the Retro Pay Worksheet page. When you open the Load Retro Pay Lines page, and in Cause of Retro Pay, you specify Grid Change, Assignment Change, or New Assignment, and then proceed with loading lines, Sparkrock 365 excludes HR pay codes that have the Exclude from Retro Pay checkbox selected from worksheet line calculations. In other words, during the loading of retro pay worksheet lines, Sparkrock 365 excludes assignments, compensation ledger entries, or both, that are associated with the excluded HR pay code. Alternatively, for any HR pay codes for which the Exclude from Retro Pay checkbox is clear, Sparkrock 365 includes the HR pay codes in retro pay worksheet line calculations in the same manner as previous releases.
For more information, go to Retro pay.
Social Security Number (SSN) format and validation enhancements
This release introduces format enhancements to the Social Security No. field that appears on new hire and rehire HR requests as well as on the Employee Card and Payroll Employee Card pages.
Now, when you specify a 9 digit number in the Social Security No. field, and then exit the field, Sparkrock 365 automatically adds dashes. For example, if you specify 789123654, and then exit the field, Sparkrock 365 automatically updates the format to be 789-12-3654.
Also, starting with this release, Sparkrock 365 validates that the value specified in the Social Security No. field is 9 digits in length. If you specify a value that is not equal to 9 digits in length, Sparkrock 365 displays the following error:
Social Security No. must be in format XXX-XX-XXXX. If you enter 9 digits, value is auto-formatted.
OECTA worksheet enhancements
On the OECTA Worksheet page, this release introduces enhancements to the Annual Actual Salary and Annual Grid Salary fields. When you load lines, Sparkrock 365 now calculates for each employee, the sum of the Yearly Amount for all active assignments during the reporting period, and then populates the sum in the Annual Actual Salary and Annual Grid Salary fields.
For more information, see Load Ontario English Catholic Teachers Association (OECTA) export file data into the OECTA worksheet.
Payroll has been updated to version 24.40.0.1
To stay current with the latest payroll updates and fixes, payroll has been updated to 24.40.0.1.
For more information, see Payroll release notes version 24.40.0.0 through 24.40.0.1.
Fixed problems
Version 24.5 for Sparkrock 365 2024 release wave 1 resolves the following problems.
| Description | |
|---|---|
| When your Language is set to French (Canada), and then you try to open a financial report, Sparkrock 365 may display an unnecessary error about excessive string length. |
|
| In environments that use Azure Blob Storage, when you are creating an email for a purchase order and you choose Add file from source document, Sparkrock 365 opens the Related Attachments page, but displays an unnecessary error after you select an attachment, and then choose OK. |
| Description | |
|---|---|
| When an approver who has the Finance Department Manager role receives an e-mail to approve a purchase order, the link in the e-mail directs the user to an incorrect page. |
|
| When you process a purchase requisition, if you modify the Document No. value, and then choose the Renumber Document Numbers action while consuming inventory, records may have an incorrect Journal Document No. value on the Lines FastTab of the Purchase Requisition page. |
|
| On the Requests Sent for Approval and Requests to Approve pages, the amounts in the Details column display 0.00, instead of the purchase order amount. |
|
| When you create one or more item journal lines to consume inventory from a purchase requisition, Sparkrock 365 populates the Document No. value with the purchase requisition number, instead of populating the value based on the item journal batch number series. This issue results in Sparkrock 365 displaying an error during posting. |
Update considerations
Consider the following information before updating to version 24.5 for Sparkrock 365 2024 release wave 1.
Transfer of open bank reconciliation worksheets
When you update to this release, open bank reconciliations are transferred to standard bank reconciliations one by one.
- All cleared entries in the Payments, Deposits, and Checks sections are transferred to statement lines and are auto-matched to bank ledger entries when possible.
- All non-cleared entries in the Payments and Checks sections are not transferred to standard bank reconciliation.
- All entries in the Adjustments section are transferred to statement lines, but are not auto-matched. You can complete the bank reconciliations by filling in any entries that weren't transferred and match entries that weren't auto-matched. In the standard bank reconciliation, you must post such differences to a general journal before you post the reconciliation. To learn more about posting a standard bank reconciliation, go to To create missing ledger entries to match bank statement lines. You can complete the bank reconciliations, and fill in any entries that weren't transferred and match entries that weren't auto-matched.
You can still review bank reconciliations that you did using the bank reconciliation worksheet. To review earlier bank reconciliations, use Tell Me to open the Bank Account page, and then choose the Posted Reconciliation Worksheets action.
Note
Note:
To avoid any issues with the transfer, Sparkrock recommends that you complete all open reconciliations before the update.
Transfer of open deposits
When you update to this release, open deposits are transferred to new bank deposits on a line-by-line basis. On the Bank Deposits page, you can find the new bank deposits, complete the registration, and post the deposits. To learn more about bank deposits, go to Create bank deposits.
You can still review deposits that you made using the deprecated deposits feature. To review earlier bank deposits, open the Posted Deposits page using Tell Me, and then open the respective deposit.
Note
Note:
To avoid any issues with the transfer, Sparkrock recommends that you complete all open deposits before the update.
Notification Entry Dispatcher job as a recurring job
When you update to this release, the following job is no longer required to be set up as a recurring job:
Object Type To Run is equal to Codeunit.
Object ID to Run is equal to 1509.
Object Caption to Run is equal to Notification Entry Dispatcher.
User ID is equal to MYSPARKROCK
PD-3410 .
Pending approvals
Before updating to this version from Sparkrock 2016, it is recommended that you update the approval status of any documents that are in a pending approval or in progress state to an approved or open state.
Missing permissions
When you update to this version, users may encounter permission related errors. The following table describes the Sparkrock 365 pages where these errors may appear, the error, and the permission setup that is necessary to prevent the error.
| Permission Setup To Prevent Error | |||||||
|---|---|---|---|---|---|---|---|
| Page | Error | Object ID | Object Name | Read Permission | Insert Permission | Modify Permission | Delete Permission |
| Purchase Invoice | Sorry, the current permissions prevented the action. (TableData VAT Setup Tax Setup Read: Base Application). | 189 | VAT Setup | Yes | |||
| Purchase Credit Memo | Sorry, the current permissions prevented the action. (TableData Purch. Cr. Memo Entity Buffer Insert: Base Application). | 5508 | Purch. Cr. Memo Entity Buffer | Yes | Yes | Yes | Yes |
Note
Note:
Sparkrock recommends that you add these permissions to a permission set to which the user is already assigned.
For information about how to assign permissions to users and groups, see Assign permissions to users and groups.
Known problems
The following sections include information about the known problems in version 24.5 for Sparkrock 365 2024 release wave 1.
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.24.5 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.
See also
New for Sparkrock 365
Payroll releases
Feedback
To send feedback about this page, select the following link: