web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Moving Average

(0) ShareShare
ReportReport
Posted on by 30

Hi, 

I am using Moving average valuation method. I am unable to understand the following : 

scenario is  as below: 

Amount = 3000 

Qty=20

Cost Price= 150

latest purchase was at=200 

In the item Master card under the Manage Cost the price is shown as 200. as in below screen shot 

pastedimage1642601771456v1.png

where as the actual calculated cost which is 150 is shown on the On-hand inventory as shown below 

pastedimage1642601906202v2.png

I want that 150 should be shown under The Manage Cost instead of 200 also when i issue from a movement journal then cost of 200 is being picked up.

any help would be highly appreciated. 

Regards,

Sanam Khan 

I have the same question (0)
  • Sanam Khan Profile Picture
    30 on at

    Waiting for response

  • Suggested answer
    Cristian Campora G. Profile Picture
    240 on at

    Uncheck Latest cost price. When checked will update Price with last receipt price which is 200 in this case.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
#ManoVerse Profile Picture

#ManoVerse 101

#2
Siv Sagar Profile Picture

Siv Sagar 93 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 62 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans