Notifications
Announcements
No record found.
Hello for all
we used inventory model Weighted avg. date But we can not understand the method of calculating the cost .
kindly review attachment excel and please advise .
*This post is locked for comments
any respond
Hi Mohamed,
On the Inventory model of the item, is 'Include physical value' ticked?
On the Released product -> 'Manage costs' fast tab, what is the 'Price'? Is 'Latest cost price' ticked?
Did you have any inventory of the item before the purchase order on the 01/03/2016?
Have you run Inventory close or Recalculation since 01/03/2016? If yes, when (what date)?
Hi Guy Terry
thanks for reply,,
this test item created on test environment and no any transaction posted before 01/03/2016.
we used 'Include physical value' on item model group and don't use "fixed
receipt price".
we don't enter any value on "Price" field and don't use "Latest cost price".
Hi Mohamed , did you close you inventory before that you check your final cost ?
Hi ismail
this test item created on test environment and no any transaction posted before 01/03/2016 and run Recalculation after 30/4/2016.
Is it the two lines you've highlighted in red that you're asking about? I took a quick look. At the end of March, I think you have 1070 in inventory, with a value of 54900. This gives a cost price of around 51.31. Since you have no receipts after this date, this cost price has been used to value your subsequent sales.
Thanks Guy Terry
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
