Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Ledger Combination Must Be Re-Validated

  • 1.  Ledger Combination Must Be Re-Validated

    Posted Jan 03, 2019 02:37 PM
    Edited by Steve Latta Jan 03, 2019 02:39 PM
    ​Hello friends,

    Last month, we made a change to our ledger account structures to change from a range of values in a segment to a list of values because the system was allowing values outside the range to be posted without throwing a stop error. After we made the change, we started getting an error on certain transactions. The error looked similar to this (the exact account shown varied, but all fell within the same account structure):

    We realized that we had activated an account structure without validating it, and about a days worth of transactions occurred before we started seeing posting errors as a result. We have since validated and activated the affected structure, and transactions created since then have been processing fine. However, we had a lot of transactions which we had to back out and redo.

    With the sales orders, we were able to back out the pick and/or pack and create a new sales order to invoice against. Not ideal, but not a show stopping problem. The same was true when we tried to pay AP invoices posted during the affected time period. Today, we are getting the error on a purchase order that was received during that time frame and we are unable to cancel the receipt and redo it. This material is now sitting in accrued receipts, unable to be invoiced due to this error.

    Does anyone know what can or should be done to fix the problem or have a workaround that will allow us to get this item out of accrued receipts, either by eliminating the original transaction or by successfully getting it through the invoice process?

    The only solution to the error I've seen is to put the combination into draft status, validated it and reactivate it - but we've done that and the system didn't allow us to back-date the activation to include the time all these transactions posted. 

    Steve Latta
    Ortec, Inc.
    Easley SC
    AXUG Summit - Post

  • 2.  RE: Ledger Combination Must Be Re-Validated

    Posted Jan 04, 2019 02:15 AM
    The error message is a bit confusing, but what I understand from you has happened is that:
    1. user posted a transaction with a particular dimension value combination
    2. the account structures were modified to make that particular combination of dimension values invalid
    3. An automated transaction trying to reverse the transaction made in step 1 is failing, since the that value combination is not valid. (sinfind ce the accrual is reversed when you invoice a purchase order)

    If that's the case, you can find time when no one if using the system (+disable all user access), activate an account structure that allows that dimension value combination, reverse all the transactions in question (better) or invoice them (also acceptable), and then revert back to your "correct" account structures.

    Zvika Rimalt
    Functional Consultant
    Vancouver BC

    AXUG Summit - Post

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