Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Can't cancel inventory close transaction. Financial dimension restriction

Posted on by 2,432

Hi All, 

When I tried to cancel the Closing transaction, I had this error in screenshot 2.  I set the Account Structure to accept blank, but the error did not go away.  Could someone suggest where I should look for the root cause?  Thanks so much!

8284.Inventory-close1.jpg

8715.Reverse-Inventory-closing1.jpg

  • lmai Profile Picture
    lmai 2,432 on at
    RE: Can't cancel inventory close transaction. Financial dimension restriction

    I did "Verified" the answer. Thanks

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Can't cancel inventory close transaction. Financial dimension restriction

    Hi Kim,

    Good to hear that this one got fixed.

    Let's then please very the answer and move on :-)

    Cheers,

    Ludwig

  • lmai Profile Picture
    lmai 2,432 on at
    RE: Can't cancel inventory close transaction. Financial dimension restriction

    Hi Ludwig,

    The Financial dimension error is now resolved.  You are so awesome! Thank you!.

    About the Adjustment number error, I don't know what that is and I will continue to look around although I don't know, in what area to look.

  • lmai Profile Picture
    lmai 2,432 on at
    RE: Can't cancel inventory close transaction. Financial dimension restriction

    Thanks, Ludwig, for your suggestion.   The current financial dimension set up is valid.   Did you mean to set it up to match the financial dimension at the time the Closing transaction was posted?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Can't cancel inventory close transaction. Financial dimension restriction

    Hi Kim,

    What you can try doing is setting up some valid fixed financial dimensions for your inventory accounts used.

    Once this is done, try to reverse the transaction (close).

    This should work an make sure you jump over the error message 'hurdle'.

    Best regards,

    Ludwig

  • lmai Profile Picture
    lmai 2,432 on at
    RE: Can't cancel inventory close transaction. Financial dimension restriction

    Hi Ismail,

    From the backend, what would the Developer look for to "debug" it or to allow the transaction to cancel?  Is it the transaction type, the voucher, the amount?  I don't know if you come from a technical background or not.  I hope to get some guidance/suggestion so that we can go straight to it without looking everywhere.  Thanks so much!

  • lmai Profile Picture
    lmai 2,432 on at
    RE: Can't cancel inventory close transaction. Financial dimension restriction

    Ok.  Thanks

  • inadir Profile Picture
    inadir 400 on at
    RE: Can't cancel inventory close transaction. Financial dimension restriction

    Hi Kim,

    the only and safest way is debug this with a Developper , you have to check which transaction caused this issue , then go to adjust it and try to cancel your closing...

    Please try to do that in TEST environnement

    Thanks

  • lmai Profile Picture
    lmai 2,432 on at
    RE: Can't cancel inventory close transaction. Financial dimension restriction

    Hi Ismail,

    I'd appreciate that very much if you could suggest how I can get the inventory Closing transaction canceled or reverse.  

  • lmai Profile Picture
    lmai 2,432 on at
    RE: Can't cancel inventory close transaction. Financial dimension restriction

    Hi Andre',

    A few months prior to September 2019, the inventory closes were not performed.  So I think inventory value (FIFO) is either overstated or understated.  We use FIFO method.  

    So, in TEST, if we were to reverse the inventory Closing transaction for September and October and do the inventory closing for the prior months, for example, July and August 2019.  Then do close the September and October again.  Continue for the rest of the year.  Then do the same for the year 2020.  Any thoughts on that?  Is this the right path to take? What are the alternatives, if any?

    If the Recalculation is performed every month, inventory value adjusted to FIFO (the adjustment is posted), would you still need to do Inventory Close?  I have reviewed the inventory close (Close procedure>Close),  Based on what I see, AX backed out the COGS under the Running Moving Average method which was used during the month.  Is that what you see as well?  Does it do anything else? 

    Thanks so much for your feedback!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans