Finance Utilities - Release notes - Archive
This document describes the features that are either new or changed in the release version mentioned.
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. |
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. |
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. |
Release date: 27 February 2023
New features
Number | Functionality | Description |
---|---|---|
12934 | Bank statement import | Support DXC X++ replacement for XSLT depreciation |
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’ |
Release date: 14 February 2023
Number | Functionality | Description |
---|---|---|
12825 | DXC Encryption | Remove unwanted model references |
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. |
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 |
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 |
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 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 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 |
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 |
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 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 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. |
10607 | Reconciliation matching rules | New Copy matching rule button provides the ability to copy an existing rule, edit and activate. |
10859 | Bank statement format | When setting up a custom format, and creating the Date field statement line, field Date format is now mandatory. |
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. |
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. New posting logic for financial dimensions: • Account is Bank • Offset account is Ledger, Customer, Vendor or Bank. 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. |
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. |
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 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. |
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. |
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 |
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 |