Version 24.5 for Sparkrock 365 2024 release wave 1 release notes Published November 19, 2024

These release notes include supplemental information about version 22.7 for Sparkrock 365 2023 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.

Platform

Finance and Procurement

HR Management

Payroll Administration

Payroll has been updated to version 24.40.0.1

New features and changes

Version 24.5 for Sparkrock 365 2024 release wave 1 introduces exciting new features and enhancements to existing functionality.

Platform

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:

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.

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.

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.PD-4596,PD-4593,PD-4597,PD-4598,PD-4615

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.PD-4594,

Finance and Procurement

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 list includes information about the customer facing changes in this release to the bank deposit functionality in Sparkrock 365:

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.
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.
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.
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.
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.
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..
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.PD-4643
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.PD-4643
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.
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.
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.
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
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, go to Create bank deposits, Bank deposit attachments, Cash receipts and bank deposits, Create a charitable receipt for a cash receipt, Create a charitable receipt for a bank deposit, Bank deposit lines import, and Set up account set validation. PD-3918,PD-3925,PD-4181,PD-3927,PD-4042,PD-4043,PD-4187,PD-4196,PD-4161,PD-4180,PD-4324,PD-4580,PD-4579,PD-4574,PD-4537,PD-4525,PD-4514

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.
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.PD-4281,PD-4051,PD-4279,PD-4291,PD-4425

HR Management

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.PD-4793

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.PD-4817

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.PD-4112

New fields on the HR Request-Leave page

In preparation for enhancements to HR request leave processing in a future release, 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.PD-4111

Payroll Administration

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.

Platform

Case Number	Description
108692	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.PD-5004
106618	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.PD-4719

Finance and Procurement

Case Number	Description
107533	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.PD-4835
Not applicable	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.PD-4979
107813	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.PD-4904
103467	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.PD-4943

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.

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.PD-446

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.

Platform

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:
1. Select the extension that you want to update, and then on the action bar, choose Manage > Uninstall.
  The Extension Uninstallation page opens.
2. Choose Uninstall.
  A dialog box appears and displays text that indicates the extension was successfully uninstalled.
3. To close the dialog box, choose OK.
4. Select the extension that you want to update, and then on the action bar, choose Manage > Install.
  The Extension Installation page opens.
5. Choose Next.
  The page refreshes and you are requested to review extension information before installation.
6. To proceed, turn on I accept the terms and conditions.
7. Choose Install.
  The extension is updated to the latest version.

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

Finance and Procurement

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.PD-1555

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.23146

Payroll Administration

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.13953

Feedback

To send feedback about this page, select the following link:

feedback-product-docs@sparkrock.com

Search Results for

Version 24.5 for Sparkrock 365 2024 release wave 1 release notes Published November 19, 2024

Video

Highlights

New features and changes

Microsoft Dynamics 365 Business Central 24

Analysis mode

Productivity enhancements

Modern action bar

Actionable errors

Show related record details from lookups

Search company data from Tell Me

Finance enhancements

Purchase and sales order navigation

General journal approvals

Allow lines with amounts of zero on recurring general journals

Reverse ledger entry with realized gain or loss

Financial consolidation run enhancements

Excel report layouts

Allocation accounts enhancements

Statistical accounts enhancements

Bank deposit enhancements

Bank reconciliation enhancements

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

New fields on the HR Request-Leave page

Payroll has been updated to version 24.40.0.1

Fixed problems

Update considerations

Transfer of open bank reconciliation worksheets

Note

Transfer of open deposits

Note

Pending approvals

Missing permissions

Note

Known problems

mySparkrock users cannot view data sets

Workaround

Connectivity issue with APIs and other services or integrations

Workaround

Alternate workaround

Re-open button is missing for a submitted expense claim in mySparkrock

Workaround

Electronic Funds Transfer (EFT) errors

Workaround

Transaction cannot be completed because it will cause inconsistencies in the G/L Entry table error

Workaround

Alternate workaround

Cannot open links in sent emails

Workaround

Payroll Employee or Payroll Processing pages may fail to open

Workaround

See also

Feedback