Production Order Statistics Report

(6) Share

Report

Posted on by JE-20081519-0

3,240

Hi:

In the Production Order Statistics Report run after finishing the Production Order, the Expected Cost and Actual Cost columns are calculating correctly.

But, the Variance column is not.

In fact, the Variance column appears to be simply a "copy" of the figures in the Actual Cost column.

Why is this happening?

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report

Hi John,

I hope this can help to review the setup

https://learn.microsoft.com/en-ca/dynamics365/business-central/design-details-production-order-posting

Thanks

Ramesh

If this helped you, please check the box Does this answer your question?

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,384 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Material Quantity and Price Variance in Production order

Solved: How to Review Manufacturing Variances

Best Regards
Gerardo

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,750 Super User 2025 Season 2 on at

Like (2)

Report

Hi, hope the following helps as well.

https://community.dynamics.com/forums/thread/details/?threadid=4a7dab0c-0c70-4fc9-90dc-7092d1bb88e0

And

https://yzhums.com/wp-content/uploads/2023/12/80550_NAV2013_ENUS_MANI_05.pdf

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,247 Super User 2025 Season 2 on at

Like (0)

Report

Please provide an example of where it might be incorrect and the expected value for that column. If you are using a standard production statistics report without any customizations, then the values are accurate.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,838 Super User 2025 Season 2 on at

Like (1)

Report

Hope this helps as well: https://community.dynamics.com/forums/thread/details/?threadid=fcf0c437-7973-4557-b9e1-7b000c0bc6c2

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report
Hello,

The Variance column should ideally show the difference between the Expected Cost and the Actual Cost. If it's displaying the same figures as the Actual Cost column, there might be a configuration or calculation error.

Here are a few steps you can take to troubleshoot this issue:

Check Report Configuration: Ensure that the report settings and filters are correctly configured. Sometimes, incorrect settings can lead to miscalculations.

Review Costing Methods: Verify that the costing methods used for the production order are consistent and correctly applied. Different costing methods (e.g., FIFO, LIFO, Standard Cost) can affect how costs are calculated and reported.

Update Business Central: Make sure you are using the latest version of Business Central. Updates often include bug fixes and improvements that could resolve this issue.

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/reports/report-99000791

Was this reply helpful? Yes No