Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Why zero cost on Stock transactions

Posted on by

Good Day Dynamics Community

Have the following strange scenario.

When posting Purchase Order invoices, sometimes the stock transaction posts with a zero cost. The GL voucher will post fine, but the stock transaction will have a zero value against it. The item does have an average value already when posting the invoice. I cannot replicate this consistently and do not know what is causing it. Result is an imbalance between Stock and GL values.

Stock valuation method is moving average. (On AX2012, R2, CU7)

See PO line, with unit price.
PO-line.jpg

See Stock transaction, with zero cost amount. For both invoices against this PO:

Stock-cost-amount.jpg

  • Suggested answer
    Conrad_ZA Profile Picture
    Conrad_ZA on at
    RE: Why zero cost on Stock transactions

    Hi All

    Riste's answer is on the right track. My developer was able to find a hotfix for the problem.

    The hotfix is called: "Deleting a financial dimension affects the distributions on a purchase order receipt, invoice vouchers and inventory costs". 

    Can be found here:

    https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?WTNTZSMNWUKNTMMYZWLSWZQTLLRPPXLZNYOZUOVKZRPYYKTQ

    So in short when financial dimensions are deleted after initially adding the lines, the accounting distributions are not updated and this causes the zero cost issue. This is specific to R2 CU7 and was corrected in later versions.

    Thanks to all of you for you assistance

    Regards

    Conrad

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Why zero cost on Stock transactions

    My advice with moving average is don;t allow negative financial inventory.

    Also don't allow backdated adjustment transactions 

    There is about  week's delay between your posted date and your transaction date so investigate, counting journals or   issue transactions between those dates  .

    You cannot reconcile from to GL from an item value report based on  transaction date- only on posted date.

    If you sort transactions on the inventory value report according to transaction time, then transactions are listed chronologically, and you can view the costs from a moving average perspective. This way, you can verify that the cost of a moving average product has not been changed retroactively.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Why zero cost on Stock transactions

    Hi Ludwig, Conrad_ZA,

    I experienced the same issue. Did the debugging and noticed that the cost price calculation is based on the accounting distributions. The logic takes into account all distributions on the line with the same financial dimensions as the PO line. In my case these are different. I assume this is because the PO is created from a PRQ. The accounting distribution has the same dimension as the PRQ line while the PO line dimensions are blank.

    BR,

    RM

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Why zero cost on Stock transactions

    Hello Conrad,

    What you describe is a very strange behaviour. I would recommend that you try debugging this issue with a developer. Would be great if you could keep us updated here. Many thanks and best regards,

    Ludwig

  • Conrad_ZA Profile Picture
    Conrad_ZA on at
    RE: Why zero cost on Stock transactions

    Hi Ludwig

    Thank you for your reply.

    Number of transactions affected: about 500.

    Number of items affected: about 200.

    So not happening to all items.

    The items affected are all stock items (Product type = Item; Sub-type = Product).

    For zero amount transactions:

    a) No modifications

    b) There's only one item model group/dimension group for stock items. It's thus only in this group. For item groups, it is various item groups. But the item group really just provides the GL accounts for posting.

    Item model group setup for items looks like this:

    6562.Item-model-group.JPG

    Thanks for your assistance
    Regards

    Conrad

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Why zero cost on Stock transactions

    Hi Conrad_ZA,

    Can you provide us with some more information on the number of transactions affected?

    Is it that all your items post with a zero value or only some (e.g. only non-stocked items)?

    For the lines that show a zero amount, can you identify

    (a) whether an adjustment has been created probably through a system modification?

    (b) whether some specific item Groups/item types are affected?

    Ludwig

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,632 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,528 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans