[quote user="Ludwig Reinhard"]
Hello Effamira,
There can be multiple reasons responsible for that.
One reason that I have seen often is if you ship a product to a customer and get it returned by the customer later on with a different cost price because the issue and receipt (return) transactions were not market against each other.
There might also be an issue with how the inventory value report is setup and processed.
For details, see for example:
blogs.msdn.microsoft.com/.../how-to-use-inventory-value-report-part-4
dynamicsax-fico.com/.../inventory-value-report
Best regards,
Ludwig
[/quote]
Hi Ludwig,
Thanks for your response.
As the same issue still persist, I check the detail transaction for the affected items.
For example in Inventory Value Report (Inventory: Financial quantity = 0, Inventory: Financial Amount = -304.01)
Std Cost, 01/04/2017-31/03/2018 = 12.8538
Std Cost, 01/04/2018-31/03/2019 = 12.2482
When I export the inventory transaction into Excel & calculate the Std Cost (see in Std Cost column), below is the data:
**What I understand:
1. Transaction until 19/3/2018 will follow Std Cost = 12.8238
2. Transaction from 13/4/2018 will follow Std Cost = 12.2482
#There will be a small variance to cost amount due to decimal place rounding issue. Am I correct?
#Std Cost (6 d.p.) & Cost Amount (2 d.p.)
However, why the Std Cost for 1st transaction on 13/4/2018 = 17.3683?
What I see from Update, there was an adjustment. Why system auto do the adjustment?
Could you help me to clarify on this query? Thanks in advance.
