Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Tracy Hanson]

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
——————————

[Lewis Rosenberg]

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
————————————————————————
——————————
——————————————-

[Tracy Hanson]

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
——————————
——————————————-