Release Notes
Dynamics 365 Finance & Operations
Vendor Reconciliation
The Vendor Reconciliation Module is a product developed for Dynamics 365 Finance and Operations. It facilitates a streamlined and effective process for reconciling vendor accounts. Its main features are to import supplier statements and automatically match them to invoices and purchase orders where possible, following configurable matching rule options. The matched records can be reviewed and approved for payment.
Release Schedule
A Vendor Reconciliation version will be available after each Microsoft Dynamics 365 Finance and Operations service update. Requests for latest versions can be done by sending an email to [email protected].
What’s New
September 2024 Release
Enhancement: Adding cash/settlement discount and date to Vendor transaction grid
Internal Azure DevOps Workitem 7990
This enhancement gives users the option to add Cash Discount date (and where possible, the Cash discount amount) to the Vendor transaction section.
Enhancement: View prior recon adjustments
Internal Azure DevOps Workitems 7991
User adjustments from the previous reconciliation are now available to view on new reconciliations. This functionality is parameter driven and can be switched on or off.
Enhancement: Multiple Vendor Recon records select available when creating Payment journals
Internal Azure DevOps Workitem 8400
Multiple vendor recons can be selected during the creation of a payment journal. The payment journal will create lines per vendor recon record. This is only available for vendor recon records that are not yet linked to a payment journal.
Enhancement: Payment journal number reference on Vendor recon
Internal Azure DevOps Workitem 8403
The Payment journal number reference is now available on the Vendor recon record.
Enhancement: Additional validations before submitting to Workflow
Internal Azure DevOps Workitem 8405
Submitting a Vendor recon to Workflow is no longer possible if the Variance is 0, or if there are Reasons missing for the uncleared Vendor transactions.
Enhancement: Workflow status not editable while Active
Internal Azure DevOps Workitem 8406
If there is an Active Vendor recon workflow, the Workflow status column on the Vendor recon is no longer editable.
Fix: Workflow on Vendor reconciliation form blocks Reconcile button
Internal Azure DevOps Workitem 8466
The reconciliation button was not available, even if the Variance is 0.
Fix: Bank account not populated on Vendor Payment journal line
Internal Azure DevOps Workitem 8471
The bank account on the Payment journal is now the most recent Active bank account of the Vendor.
Fix: Reasons and comments setup
Internal Azure DevOps Workitem 8701
Reasons are refreshed during configuration setup when new reasons are added.
Fix: Correction on the Vendor recon report data
Internal Azure DevOps Workitem 8704
The Vendor recon report now displays uncleared vendor transaction, and user adjustment are displaying with the correct transaction type.
June 2024 Release
Enhancement: Bulk update of reasons and comments
Multiple Vendor Reconciliation lines can now be selected to add Reason Codes to. A new button has been added to save Reasons and Comments to selected Vendor Reconciliation lines. These changes have been brought across to the Vendor Reconciliation SSRS report.
Enhancement: Securities
Two new roles added:
Vendor Reconciliation Administrator
- Duties
- Vendor Reconciliation maintenance
- Privileges
- Create payment journal from reconciliation
- Maintain vendor reconciliations
- Maintain vendor statement imports
Vendor Reconciliation Reporting
- Duties
- Vendor Reconciliation enquiries
- Privileges
- User adjustments import view
- View vendor reconciliations
- View vendor statement imports
Enhancement: Vendor Reconciliation parameters grouping
The Vendor Reconciliation parameters on the Accounts Payable parameters form, have been moved to a new tab called Vendor Reconciliation.
Enhancement: Setup button re-labelled to say 'Create Number Sequences'
A label change was made on the Setup button under the Vendor Reconciliation parameters to better show the purpose of the button, which is to create number sequences.
Fix: Completed Vendor Reconciliation should not be editable
Vendor Reconciliation data is no longer editable after completing and posting the Vendor Reconciliation.
Fix: Reconcile button availability when the Variance is zero
The Reconcile button was disabled where the Variance value was zero, even when all uncleared transactions and user adjustments have had Reasons and Comments entered.
Fix: Good received not invoiced defaulting to Cleared
Under the ‘Goods received not invoiced’ section, the transactions are no longer marked as ‘Cleared’ when a new Reconciliation is created.
Fix: Disable Reconcile button until submitted to workflow
After workflow approval, when changes are made to the reconciliation, the Reconcile button should be disabled, because the reconciliation should be submitted to workflow again.
Fix: Manual clearing of Vendor recon not working as expected
The Variance was not being updated when the Cleared option on a Vendor transaction was ticked.
Fix: Import statement matching rules
Modifications to the matching rules were made to account for more lenient rules. Additional parameters were built to account for leniency in days, matching patterns, and lenient differences. Please reach out to [email protected] for more information.
Fix: Variance colour not updating
The Variance colour did not update when the variance was zero under specific conditions.
February 2024 Release
Fix: Balances and related information are now automatically refreshed
Upon clearing or removing adjustments, the balances and related information are automatically refreshed.
About Decision Inc.
Our success is ultimately driven by our entrepreneurial culture, industry exposure, and the passion of our people. We have three key cross-functional teams – Functional and Specialist Consulting, Development, and Engineering teams. Based in four global offices, our exceptional consultants focus on delivering value to clients by keeping them at the centre of our service delivery.