Skip to main content

Notifications

Microsoft Dynamics AX forum
Suggested answer

Inventory cost revaluation, and account structures

Posted on by Microsoft Employee

When posting a sales invoice (with an order line containing a standard cost item), there sometimes is some sort of rounding in our vouchers, labeled 'Inventory cost revaluation'. The accounts used are 'Adjustment standardcost', offset by the stock account, and the amount is normally 0,01, plus or minus.

In the GL account structures, we have a rule saying that ALL accounts must contain Cost center. In the postings above, this is not the case; the only financial dimensions inherited are those which are defaulted on the item. NB! We have a customization using cost center from warehouse level (rather than from site) which I suspect has something to do with it. Nevertheless - the account structures should not have allowed the posting to be completed.

So, what to do? Are we experiencing a bug regarding account structure/dimensions vs the Inventory cost revaluation job? We cannot bypass this by making a correctional voucher, as the account structure prevents us från correcting the accounts...

Categories:
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory cost revaluation, and account structures

    Hi Ulrika,

    I think you only chance is to grap one of your developers and debug the issue. I do not only find it a bit strange that the 0,01€ get posted but also that AX uses the posting type that is actually supposed to be for cost revaluations.

    Let's probably wait for some other community members to respond. Maybe the one or the other has experienced similar scenarios and might help a bit more.

    All the best,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory cost revaluation, and account structures

    Hi Ludwig,

    thanks for answering. This is an R3 CU9 version.

    Yes, isn't it odd? I'm collecting info on this to be able to re-create it in a Contoso environment, but I haven't found the pattern yet.

    I am aware that MS wouldn't fix it for us because of our mod - the bug itself is the fact that the posting took place at all - because of the account structures.

    In the test case you mention (activating a new std cost), we get an error message referring to the account structure - we are in control of that and need to complete the mod - but in this 'rounding' case, the posting runs through just fine.

    //Ulrika

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory cost revaluation, and account structures

    Hi Ulrika,

    What AX2012 Version do you run exactly (CU7/8/9..)?

    I find it interesting that you say that the 0,01€ is posted as "inventory cost revaluation" which is typically used when standard cost prices get adjusted. I would have expected that the amount hits the standard cost "rounding variance" but anyway.

    What to do?

    Well, as you mentioned you modified the standard behavior of AX in regards to the cost center inheritance and therefore MS will most probably not accept this as a bug and fix it for you.

    What I got from your description is that the inheritance of your cost center does not work for those little penny differences with this transaction type.

    Have you checked whether the inheritance of your cost centers works correctly if you are activating a new standard cost Price as activating a new standard cost prices also uses the same variance type "inventory cost revaluation"? I would assume that it does also not work in this case.

    Can you check that in a demo/test System an let us know?

    Ludwig

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans