Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX forum / Why zero cost on Stock...
Microsoft Dynamics AX forum
Suggested answer

Why zero cost on Stock transactions

(0) ShareShare
ReportReport
Posted on by Conrad_ZA

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

Categories:
Financial Management
  • 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

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans