Version 24.5 for Sparkrock 365 2024 Release Wave 1 Release Notes Scheduled for Q4 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.
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.
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 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.
When you update to this release, all data that appeared on the Posted Deposits page in the previous release now appears 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 also 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.
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.
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 also 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 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.
After you post the bank deposit, except for Account Set Code, these fields appear on the Posted Bank Deposit and Charitable Receipts pages. Also, during posting of the bank deposit, Sparkrock 365 copies the values for Account Set Code to the respective General Ledger (G/L) entries. The Charitable Receipts report also displays these fields, except for Account Set Code and Cash. When you run the Charitable Receipts report, Sparkrock 365 automatically populates the value of the Charitable Receipt No. field on the Charitable Receipts 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.
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 also 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 an 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 also 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.
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 also 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.
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.
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.
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 azure active directory applications, and then choose the related link.
The Azure Active Directory Applications page opens.
Select the row that has a Description of mySparkrock, and then on the action bar, choose Manage > Edit.
The Azure Active Directory 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
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: