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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Weighted Average price...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Weighted Average price in planned costing version

(0) ShareShare
ReportReport
Posted on by d365 Dynamics comm... 8

Hello,

After inventory recalculation, I want to get the average prices calculated in a planned costing version.

The planned costing version for purchased item are based on :

the purchased price (in released products)

or the cost products (also in released productis)

or the trade agreement

but not on the weighted average prices.

So how to do when we want to calculate the cost of finish goods based on the average price  of the raw material (not the current one but the one calculated by a closure) ?

BR,

Karim BELHEDI

SPX

I have the same question (0)
  • Suggested answer
    Hossein.K Profile Picture
    Hossein.K 6,648 on at

     Hi,

    Please refer to: Inventory Recalculation | Inventory recalculation frequency |Inventory Calculation Affecting Previous Period | Finding Recalculated Trans

  • d365 Dynamics community Profile Picture
    d365 Dynamics comm... 8 on at

    Thank you Hussein.

    These posts deal with inventory closure. not planned costs.

    I didn't find any way to link inventory closure to planned costing.

    exemple: the weighted average cost after closure = 10

    The latest cost = 11.

    If I want to put the weighted average cost in a planned cost.

    The only way I found is to copy manually the average cost in the cost field of the released products and then to calculate the item price.

    I'm asking for the way to make these manipulation automatically.

    BR,

    Karim

    SPX

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello SPX,

    What inventory valuation method did you setup for your items (weighted average date, FIFO, standard costs, moving average, etc)?

    Do you have the parameter for the 'latest cost price' active in your released product form?

    Best regards,

    Ludwig

  • d365 Dynamics community Profile Picture
    d365 Dynamics comm... 8 on at

    Hello Luvig,

    The inventory valuation method setup for my items are weighted average date.

    yes, I have the parameter  the 'latest cost price' active in the released product form but in that field, we fin the latest cost not the average one.

    My question is how to transfert the weighted average costs after closure to a planned costs.

    BR,

    Karim,

    SPX

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi SPX,

    Doesn't the recalculation update the cost price if the latest cost price parameter is turned on?

    If that is ok, it will be available in the costing version.

    In case you open the costing version from the menu item 'costing versions' you won't see that update but if you open it from the individual item you should be able seeing that.

    Have you checked that out already?

    Best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi SPX,

    Doesn't the recalculation update the cost price if the latest cost price parameter is turned on?

    If that is ok, it will be available in the costing version.

    In case you open the costing version from the menu item 'costing versions' you won't see that update but if you open it from the individual item you should be able seeing that.

    Have you checked that out already?

    Best regards,

    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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 301 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 120 Super User 2025 Season 2

#3
Siv Sagar Profile Picture

Siv Sagar 105 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans