D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Settlement Transactions on Customer/Vendor subledger accounts

  • 1.  Settlement Transactions on Customer/Vendor subledger accounts

    SILVER CONTRIBUTOR
    Posted 20 days ago
    Since upgrading to version 10.0.13, our team has noticed an unwanted change to the transactional activity showing in the customer and vendor transactions pages. In addition to invoices and payments, we are now seeing the settlement transactions which previously did not show up here. Has anyone else noticed this change? Is there a parameter I can change to revert back to the old way? Is there a feature I need to disable?

    Thank you!

    ------------------------------
    Karl Arensdorf
    Corporate Controller
    Mansfield Oil Company
    Gainesville GA
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: Settlement Transactions on Customer/Vendor subledger accounts

    GOLD CONTRIBUTOR
    Posted 20 days ago
    Hello,

    I am not sure that this was a change in version 10.13, this has been the case for us since the beginning. In our case the settlement transaction happens because the invoice and payment have different financial dimension combinations so the system creates the extra settlement entry. In our case we had a customization on that form since the beginning to filter out those extra settlement transactions. I have seen plenty of posts regarding this topic and no one can really tell what causes this settlement transactions to occur.

    ------------------------------
    Juan Sebastian Grijalba
    Berkowitz Pollack Brant
    Miami
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: Settlement Transactions on Customer/Vendor subledger accounts

    SILVER CONTRIBUTOR
    Posted 19 days ago
    Hi Karl,

    I have seen this and there is a fix currently in LCS to rectify. I found that any transactions generated before the upgrade posted settlements but any newly generated invoices don't have the issue.

    As part of the upgrade to 10.0.13 MS have changed the way Financial dimensions are generated moving away from Hash Keys to a new algorithm called Spooky Hash Keys. This is for performance/data integrity purposes.

    https://cloudblogs.microsoft.com/dynamics365/it/2020/08/03/verify-hash-function-changes-after-update-to-dynamics-365-finance-2020-release-wave-2/

    LCS Details:
    Issue 515784 - Open
    After updating to 10.0.13 Two more additional customer settlement transactions are posted even if no financial dimensions are used for customer main account
    Product and version: Finance and Operations
    Release: 10.0.13
    KB number: 4588750




    ------------------------------
    Mark Bailey
    Application Consultant
    Annata
    Portsmouth
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role