Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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... 118

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
    Ludwig Reinhard 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
    Ludwig Reinhard 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
    d365 Dynamics comm... 118 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
    Ludwig Reinhard 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
    d365 Dynamics comm... 118 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
    Hossein.K 6,642 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans