Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested answer

Weighted Average price in planned costing version

(0) ShareShare
ReportReport
Posted on by 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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Weighted Average price in planned costing version

    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
    Microsoft Employee on at
    RE: Weighted Average price in planned costing version

    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

  • d365 Dynamics  community Profile Picture
    8 on at
    RE: Weighted Average price in planned costing version

    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

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Weighted Average price in planned costing version

    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
    8 on at
    RE: Weighted Average price in planned costing version

    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

  • Suggested answer
    Hossein.K Profile Picture
    6,646 on at
    RE: Weighted Average price in planned costing version

     Hi,

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

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,135 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,871 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans