Finance Utilities

Finance Utilities - Release notes - Archive

Return to main page
-->

Release notes - Archive

This document describes the features that are either new or changed in the release version mentioned.

Release 10.0.29.20230131

Build 10.0.29.202301317

Release date: 17 April 2023

Bug fixes

Number Functionality Description
13788 Bank reconciliation Modified fix for 13592 to use Accounting currency instead of Reporting currency.

Build 10.0.29.202301316

Release date: 30 March 2023

Bug fixes

Number Functionality Description
13592 Bank reconciliation Exchange rate issue when using Mark as new and Offset account type is set to Vendor. When the currency differs to the legal entity, and the posted vendor transaction is selected to be used in settlement, the transaction’s amount doesn’t update the Settlement balance.
13620 Vendor bank account approval From 10.32 MS has introduced their own Vendor bank account approval. MS used the same method name processChangesForApproval as we used for Finance utilities functionality. We’ve updated ours to avoid compile issues from 10.0.32.

Build 10.0.29.202301315

Release date: 3 March 2023

Bug fixes

Number Functionality Description
11505 Reconciliation matching rules Bank reconciliation: When running multiple Reconciliation matching rules with Action set to Mark new transactions and Offset account type set to Customer, errored with ‘No statement lines have been marked. The match has an imbalance of %amount%’.
12801 Reconciliation matching rules Bank reconciliation: When running Reconciliation matching rules with Action set to Mark new transactions and Offset account type set to Customer and Auto-post customer payment journal set to Yes, and there was an issue with posting the customer payment journal (for example customer is stopped) the bank statement transactions were still matched.

Build 10.0.29.202301314

Release date: 27 February 2023

New features

Number Functionality Description
12934 Bank statement import Support DXC X++ replacement for XSLT depreciation

Build 10.0.29.202301313

Release date: 22 February 2023

Bug fixes

Number Functionality Description
N/A DXC Encryption Update to DXC encryption. Resolve error: Module ‘DXCEncryption’ is missing the following dependencies: ‘ApplicationFoundationFormAdaptor’

Build 10.0.29.202301312

Release date: 14 February 2023

Number Functionality Description
12825 DXC Encryption Remove unwanted model references

Build 10.0.29.202301311

Release date: 31 January 2023

New features

Number Functionality Description
11653 Encryption / Decryption New model DXC Encryption.
Encryption/decryption options added to following Finance utilities functionality:
• Encrypt option on Electronic reporting export connections to send encrypted GER Vendor EFT files
• Decrypt option on Financial utilities connection to decrypt a bank statement file imported using periodic task Import bank statements via financial utilities connection.
User guide
12119 Financial utilities connection Log ability added to all connection types. Ability to set Logging level and Retention period. This provides users the ability to set Custom alerts. For example if a connection can’t connect a log with level Error can be created.
Log
12353 Reconciliation matching rules Ability to use invoice to find the D365 customer account.
Applicable to Offset account type set to Customer and where Offset account and Offset account bank statement field are both blank.
When running the Reconciliation matching rule, the field mapped to Settle transaction bank statement field (D365 invoice number) will be used to find the D365 customer account, to create the Customer payment journal line.
User guide
Reconciliation matching rules
10419 Data entity - Bank accounts Added following field to entity ‘Bank accounts’:
• Financial utilities connections
10425 Data entity - Vendor payment method Added following field to entity ‘Vendor payment method’:
• Sundry method of payment
• Auto payment reference number
• BPAY method of payment
N/A License manager License manager version 10.8.32.10156.
Help includes links to applicable GitHub user guide page/s
Help

Bug fixes

Number Functionality Description
12324 Bank statement import When a custom bank statement format was used and the file contained a bank account that isn’t setup for advanced bank reconciliation, the bank statement headers were created for the bank accounts setup with advanced bank reconciliation, but no bank statement lines were created.
The fix now creates the bank statement lines for the bank accounts setup as advanced.
Note: Std GER doesn’t import any bank statements where the file contains a bank account not setup as advanced bank reconciliation.

Release 10.0.29.20221130

Build 10.0.29.202211301

Release date: 30 Nov 2022

New features

Number Functionality Description
11749 Data entity ‘Reconciliation matching rules’ Removed unused fields from data entity ‘Reconciliation matching rules’:
• DFUACCOUNTTYPE
• DFULEDGERDIMENSIONDISPLAYVALUE

Bug fixes

Number Functionality Description
12204 Bank statement import Error importing GER bank statement with bank accounts with same Bank account id and same Statement Id across multiple companies.
Error: “Cannot edit a record in Bank statement account statement (BankStmtISOAccountStatement). Update operations are not allowed across companies. Please use the changecompany keyword to change the current company before updating the record.”

Release 10.0.29.20221019 & 10.0.27.20221019

Build 10.0.29.202210192

Release date: 24/10/2022

New features

Number Functionality Description
11598 Reconciliation matching rules Ability to set Field format for Offset account bank statement field and Settle transaction bank statement field. This assists in obtaining the D365 customer account and Invoice number from bank statement fields for creating the customer payment journal.
For setup information and examples click here
Reconcilation matching rules
Reconcilation matching rules example

Bug fixes

Number Functionality Description
11623 Customer bank account entity Related to version 10.0.27.202209162.
Error when importing data entity Customer bank accounts: Field ‘Reference’ must be filled in’
11632 Security Related to version 10.0.27.202209162.
Fixed security on Proposed changes for Customer approval.
New privilege DFUCustChangeProposal added to following duties:
• Approve customer change proposals
• Maintain customer master

Build 10.0.27.202210191

Release date: 19/10/2022

DXC Finance Utilities 10.0.27 runs on the following Microsoft releases

Base Version Release
Microsoft Dynamics 365 application 10.0.27 What’s new or changed in Dynamics 365 application version 10.0.27
Microsoft Dynamics 365 application 10.0.28 What’s new or changed in Dynamics 365 application version 10.0.28

Same as 10.0.29.202210191 version, but excludes change that isn’t backwards compatible for D365 versions earlier than 10.0.29:

Number Functionality Description
11568 Bank statement periodic import Due to a change in MS code in 10.0.29.
Periodic import created the Bank statement(s), but:
• File was moved to Error folder (instead of Archive folder)
• Document not attached to Bank statement(s)
• ‘Imported via financial connection’ not set to Yes.

Also fixes issue for ‘Reconcile after import’ (manual import and via periodic import)

Release 10.0.29.20220927

Build 10.0.29.202209271

Release date: 29/09/2022

Number Functionality Description
11568 Bank statement periodic import Due to a change in MS code in 10.0.29.
Periodic import created the Bank statement(s), but:
• File was moved to Error folder (instead of Archive folder)
• Document not attached to Bank statement(s)
• ‘Imported via financial connection’ not set to Yes.

Also fixes issue for ‘Reconcile after import’ (manual import and via periodic import)

Release 10.0.27.20220916

Build 10.0.27.202209162

Release date: 16/09/2022

DXC Finance Utilities 10.0.27 runs on the following Microsoft releases

Number Functionality Description
10814 Customer approval Accounts receivable > Setup > Accounts receivable parameters
Ability to select the following Customer bank account fields in Customer Approval:
• Bank groups
• BSB number
• Bank account number
• SWIFT code
• IBAN
Ability to select the following Customer account fields in Customer Approval:
• Allow on account
• Unlimited credit limit
• Exclude from credit management
• Invoicing and delivery on hold (blocked)
• Charges group
• Customer rebate group
• Commission group
• Payment schedule
Proposed changes will contain all fields that requires approval, split into a tab for customer and a tab for each bank account with changes.
Note: Using Discard all changes on Proposed changes will discard changes on all tabs.
Customer approval
Proposed changes
10607 Reconciliation matching rules New Copy matching rule button provides the ability to copy an existing rule, edit and activate.
Copy matching rule
10859 Bank statement format When setting up a custom format, and creating the Date field statement line, field Date format is now mandatory.
Mandatory date format
10468 Financial utilities parameters About tab removed. Support info now availabe in workspace Organization administration > Workspaces > DXC support.

Bug fixes

Number Name Description
11305 Generic electronic Import format Fix issue with importing GER bank statement formats. Supports Advanced bank reconciliation statement model (ABR) and Bank statement model GER formats.
10927 Bank statement import Fix to incorrect log when importing bank statements for banks across multiple legal entities. Error: ‘No matching bank account found’ for bank accounts in the different legal entity.
11262 Bank reconciliation Can’t select Offset company in Matched transactions when manually marking a bank statement transaction as new in Bank reconciliation Worksheet.
Only an issue for FinU release 10.0.25 & 10.0.27.202207142
11307 Bank reconciliation Fix to financial dimensions posted for manually marked as new bank statement transactions. Bank account’s transaction incorrectly posting without financial dimensions (10.0.25 & 10.0.27.202207142).

Updated logic when user selects Mark as new and the records are moved to Matched transactions:
• Account (Bank)’s financial dimensions will be populated from the Bank account.
• When user enters Offset account number, the offset account’s financial dimension will be populated from their master accounts (for example customer’s financial dimension), except ledger since it is populated in Offset account number. If this would result in a blank value it will be populated with Account (Bank)’s financial dimensions.
• If Account (Bank)’s financial dimensions are blank, Offset account’s financial dimensions will be used to populate Account (Bank)’s financial dimensions.
10422 Vendor method of payment Lodgement reference Payment attribute displaying as blank. Std’s D365 last record in Attributes (Belgian structured payment ID) is region based and resulted in any records after it displaying blank.
Payment attributes

Release 10.0.25 & 10.0.27.202207142

Build 10.0.25.202207142

Release date: 14/07/2022

Number Functionality Reason
10367 Reconciliation matching rule Ability to set Account’s Financial dimensions on Reconciliation matching rules with Action Mark new transactions.
Reconciliation matching rules
New posting logic for financial dimensions:
• Account is Bank
• Offset account is Ledger, Customer, Vendor or Bank. Posting logic
When new bank statement transactions with Offset account type Ledger, Vendor or Bank’s are matched by using Reconciliation matching rules, the calculated financial dimensions for Account and Offset account are populated on the Matched transaction’s Financial dimensions tab and can be overriden prior ‘Mark as reconciled’.
Offset account type Customer creates customer receipt journal(s) with the calculated financial dimensions for Account and Offset account.
10511 Vendor payments - Generate payments Current vendor payment journal line’s Method of payment and Bank account used to populate fields on Generate payments dialog.

Bug fixes

Number Name Description
10511 Vendor payments - Generate payments Electronic reporting format: User id and File name updated if Bank account is changed on Generate payments dialog.
Generate payments
10603 Bank reconciliation Where a bank deposit slip has been cancelled the MS calculated totals are incorrect and resulted in an unmatched amount. Financial utilities unmatched amount calculation has been updated to avoid this issue.
Unmatched amount

Build 10.0.27.202207142

Release date: 14/07/2022

Same as 10.0.25.202207142, and includes the fix for Payment advice V2 required from 10.0.27:

Number Functionality Reason
10284 Eclipse Payment advice V2 Resolves the breaking change with Microsoft introduced new 10.0.27 features when Enable batch processing for bank payment advice reports is enabled.

Release 10.0.25 & 10.0.27.20220617

Build 10.0.25.202206171

Release date: 17/06/2022

Number Functionality Reason
10241 Bank statement import - Document handling New field File attachment document type added to Financial utilities parameters. When Type has been selected, the import file will be attached to the created bank statement(s). This applies to bank statements created with manual or periodic job import.
10293 Financial utilities connections - Validate connection New button Validate connection added to Financial utilities connections. Validates:
• Connection details
• Import path
• Import archive path
• Import error path
10363 Only match posted statement lines New field Only match posted statement lines added to Financial utilities parameters. For example mark as new bank reconciliation rule finds three records in the bank statement, but only two of the customers exist and thus won’t balance since only two lines were posted as customer payment journal lines. This option only applies to where the mark as new bank reconciliation creates and posts new customer payment journals.

DXC License manager 10.8.32.10131 Improvements to DXC License manager model

Bug fixes

Number Name Description
10449 Eclipse Payment advice V2 - Generate payments for BNZ file Fix Print payment advice via Generate payments for Eclipse Payment advice V2 report when using BNZ Direct Credit Service (NZ) export format on the method of payment.
10292 Customer Bank recon matching rule - Transaction type When reconciliation matching rule creates and posts the customer payment journal, the transaction type was Customer. Transaction type has been fixed and will now be posted as Payment.

Build 10.0.27.202206172

Release date: 29/06/2022

Number Functionality Reason
10341 DXC License manager
10.8.32.10141
New workspace Organization administration > Workspaces > DXC support.
Links for licensed products to:
• User guide
• Release notes
• Contact - email address for support
10284 Eclipse Payment advice V2 Resolves the breaking change with Microsoft introduced new 10.0.27 features when Enable batch processing for bank payment advice reports is enabled.

Release 10.0.22.20220512

Build 10.0.22.202205121

Number Functionality Reason
8461 Bank statement import Ability to automatically import bank statements from ftp, ftps, sftp, Azure blob storage, or SharePoint
10094 Reconciliation matching rule – unique voucher New Financial utilities parameters field called Populate unique voucher for each journal line. When customer payment journal is created using the additional Finance utilities fields on Reconciliation matching rules (for mark as new transactions), this new field provides options if the journal will be created with unique vouchers for each line. If new field is enabled, General ledger parameters’ Allow multiple transactions within one voucher doesn’t need to be enabled.
10274 Reconciliation matching rule – Invoice has been marked by another customer payment journal If Reconciliation matching rule for mark as new transaction are set to settle the customer invoice, and the invoice has already been marked in another open journal, D365 doesn’t allow the invoice to be selected. In this scenario the customer payment journal line will now still be created (previously didn’t) but with no invoice selected for settlement.
10152 GER bank statement format Support importing Bank statement formats using GER (Electronic reporting), and supports setting posting date (for mark as new transactions) to:
• Statement transaction date, or
• Today’s date

Release 10.0.22.20220316

Build 10.0.22.202203161

Number Functionality Reason
9490 ABN search and validation Ability for Australian companies to search and validate ABN for customers and vendors.
9925 Auto-post bank statement When Financial utilities parameter ‘Auto-post bank statement’ is set to Yes, only Bank statement’s with status Reconciled will automatically be posted.
Previously bank statements containing unreconciled lines, Bank statement’s status is Matched, were also automatically posted.
But the unreconciled lines are included in the next bank reconciliation and when users run mark as new matching rule in the next recon, it would error with ‘The bank statement % is posted already and cannot be changed’.
9505 Populate bank transaction document number Populating the document number in bank reconciliation’s bank transactions.
From 10.0.22 MS has removed ‘Turn off reconciliation worksheet performance enhancement’ parameter.
Not required anymore: RemoveLoadReconciliationWorksheetExtensibleFlight_KillSwitch
9688 Reconciliation matching rule (1:1 customer and invoice) Write Bank statement’s Description to Customer receipt journal. Also added the new Finance utilities fields to entities ‘Reconciliation matching rules’ and ‘Financial utilities parameters’

Bug fixes

Number Name Description
9665 Print payment advice Error when feature ‘Enable batch processing for bank payment advice reports’ is enabled and printing the payment advice V2 for an ECL EFT format via Generate payments in the Vendor payment journal.
9986 Compile errors PEAP 10.0.26 Compile errors
Error The Class ‘ERUserParameterDataContract’ is internal and is not accessible from the current module ‘DXC Finance Utilities’. K:\AosService\PackagesLocalDirectory\bin\XppSource\DXC Finance Utilities\AxClass_DFUVendOutPaymHandler.xpp 78
© DXC Technology Company