Production Material Variances

Production Material Variances
Follow
Tracy Hanson
Tracy HansonMar 13, 2023 02:46 PM
We are struggling to understand our material variances from production orders. When we look at the value …

1. Production Material Variances

Tracy Hanson
Posted Mar 13, 2023 02:46 PM

We are struggling to understand our material variances from production orders. When we look at the value entries or the GL for material variances, we are finding that Business Central is only showings us the total variance but not what is driving it (i.e. we used qty 2 of part 1 but the BOM only called for a qty of 1). Outside of pulling the consumption by production order that has generated a material variance and comparing it to the BOM manually, is there a better way to pull this data from business central?

——————————
Tracy Hanson
Finance Business Partner, Operations
Terso Solutions Inc
Madison WI
——————————

2. RE: Production Material Variances
NAVUG ALL STAR
Lewis Rosenberg
Posted Mar 20, 2023 09:18 AM

I’m not sure if you are looking for this or something else, but, you can look at the production lines from the (finished) production order to see Expected Qty and Actual Consumption (Qty).

Find more responses on the new forum: https://dynamicscommunities.com/community/groups/d365ugbc/forum/discussions/production-material-variances/

——————————
***MOVING TIME: This forum is schedule to shut down in April 2023 and the new replacement is already running. Try the new DCI BCUG/NAVIG Message Forum: https://dynamicscommunities.com/

Lewis Rosenberg
IT Manager
Mars Fishcare/Mars Horsecare
Chalfont PA
http://www.apifishcare.com
————————————————————————
D365UG-BC/NAVUG All-Star
Community Summit Legend
D365UG-BC/NAVUG Advisory Board Member (Former Chairperson)
D365UG-BC/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————
——————————

3. RE: Production Material Variances
Tracy Hanson
Posted Mar 21, 2023 03:26 PM

HI Lewis,

Thank you for porting this over to the new site! i do not have access to that site yet but can see many response that have come in. I will try to respond to these as soon as possible.

regarding the production lines – can you confirm the process to view these? when i look at the entries-Item ledger entries – i do not see these columns available. am i looking in the wrong spot?

——————————
Tracy Hanson
Finance Business Partner, Operations
Terso Solutions Inc
Madison WI
——————————

Dynamics Communities Home