Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Material, Capacity and Capacity OH Variance not calculating "True" variance per type

(1) ShareShare
ReportReport
Posted on by 4
Hello, 
 
On a production order using standard costing method, we are noticing that variances are being miscalculated when you look at the different type of variance transactions from a Production Order (Capacity/Capacity Overhead/Material). Interestingly enough, the TOTAL variance is correct if you collapse the three variance transactions; but separately they are misleading and incorrect.
 
My assumption is that the FG Std Cost is compared against Total Actual Material Cost only, but since that Standard Cost already includes the other costs (cap/cap oh) then, the material variance computed was not the "true" material variance. 
 
Since, variance in BC is based off the cost of the FG, maybe the way the variance calculations are done is good for BC algorithm with clearing the WIP & Interim inventory - it helps truing up the cost for the FG item. 
 
Is there any setup that I should look at that would potentially solve this issue - setup that could show us the "true" variance per type on Prod Order?
Thanks a lot in advance.
  • Rowena Madera Profile Picture
    Rowena Madera 4 on at
    Material, Capacity and Capacity OH Variance not calculating "True" variance per type
    Hello Alexander,
     
    Thanks so much for this response. I will try this and will post the results here once I've completed my tests. Thanks again!
  • Suggested answer
    Alexander Drogin Profile Picture
    Alexander Drogin 170 on at
    Material, Capacity and Capacity OH Variance not calculating "True" variance per type
    Business Central calculates each variance type separately, so each individual variance should tally. There is no setup as such, cost adjustment for standard costing method is based on cost components from the item card - material, capacity, capacity overhead, and subcontracting. But for correct calculation of variances, these values must be calculated from the BOM and routing if it's a manufactured product. It feels like your product standard cost is not rolled-up correctly.
     
    "Populate Standard Cost" section here describes the action you need to run to have the standard cost calculated.
     

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,540 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans