a

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

Decision Inc. is committed to delivering world-class solutions ensuring that our offerings remain at the forefront of excellence. In line with our commitment and industry best practices updates on the Vendor Reconciliation module will align with the service update release cadence from Microsoft.

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 is 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

Internal Azure DevOps Work Item: 7837, 7988, 7992

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

Internal Azure DevOps Work Item: 7983

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

Internal Azure DevOps Work Item: 8412

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'

Internal Azure DevOps Work Item: 8413

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

Internal Azure DevOps Workitem:  8418

Vendor Reconciliation data is no longer editable after completing and posting the Vendor Reconciliation.

Fix: Reconcile button availability when the Variance is zero

Internal Azure DevOps Workitem: 8421

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

Internal Azure DevOps Workitem: 7995

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

Internal Azure DevOps Work Item: 8404

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

Internal Azure DevOps Work Item: 7984

The Variance was not being updated when the Cleared option on a Vendor transaction was ticked.

Fix: Import statement matching rules

Internal Azure DevOps Work Item:7989

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

Internal Azure DevOps Work Item:7985

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

Internal Azure DevOps Work Item: 7841

Upon clearing or removing adjustments, the balances and related information are automatically refreshed.

We strive to communicate effectively and transparently. Therefore, the release notes will be updated shortly after each Microsoft service update. For any further inquiries, please feel free to get in touch.

About Decision Inc.

Decision Inc. is a global digital partner that enables businesses to reinvent themselves to realise their full potential.

We deliver agility, resilience, and intelligence to any enterprise, enabling them to adapt quickly and thrive through innovation and opportunity. Our teams have engaged with more than 400 clients globally over the past 15 years, providing them with the expertise to build, operate, and optimise their digital businesses.

We achieve this by leveraging the world’s best technology to drive our client’s business ambitions forward into tomorrow’s reality.

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.

CONTACT US

Fill in a Form

WHAT WE DO

Our Data Solutions