Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Unanswered

Production - BOM Cost Shares Report Average Cost

Posted on by 2,262

Hi All

All the items are using FIFO costing (finished goods and Components) and when running BOM Cost Shares report, it takes average cost if component item is in stock (and last cost if not in stock). Is there a report where we can simulate cost roll up using last cost. The requirement is for quoting based on BOM structure, last cost is more realistic in some situations as average cost might be outdated.

BOM-cost-share.png

Categories:
  • Samantha73 Profile Picture
    Samantha73 2,262 on at
    RE: Production - BOM Cost Shares Report Average Cost

    Thanks. A custom report is what I was thinking. The actual cost that gets to the production order is not very relevant in this use case as we are quoting to customers for future sales in a rising cost environment such as now last cost (including landed cost) help adding the sales margin

  • Robert Jolliffe Profile Picture
    Robert Jolliffe 859 on at
    RE: Production - BOM Cost Shares Report Average Cost

    A custom version of this page could be created, but to be honest the trouble will be that if the item with the average cost is consumed on a DIFFERENT production order (ie: you don't produce it in the sequence you calculate the cost in) then your actual cost from the FIFO layer may not have anything to do with the cost you see in your BOM Shares.

    Average cost is at least going to be more or less close to what you might actually use.  

    If that doesn't make sense just reply and we can get into more detail.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans