Why zero cost on Stock transactions

(0) Share

Report

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.

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

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Conrad_ZA on at

Like (0)

Report
Copy link

Link copied!

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:

Thanks for your assistance
Regards

Conrad

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Conrad_ZA on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No