Skip to main content
Post a question

Notifications

Announcements

No record found.

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

Material Quantity and Price Variance in Production order

Posted on 30 Jan 2023 19:39:49 by 25

Hi All,

 

I am encountering an issue relating to segregation of the material quantity and price variances in Microsoft BC. In the system, Inventory is set up on “ FIFO” and we are using FIFO for all Raw materials where as “Finished Goods” are set up on standard at item level.

Below is the inventory posting set up:

Screenshot-2023_2D00_01_2D00_30-143723.png

Now if there is any variance in production order, either in Cost of ingredients, or in quantity consumed, both are going in “54000” where as I want to track quantity & price variances separately. What is the solution for this issue??

  • Aamirr Profile Picture
    Aamirr 25 on 15 Feb 2023 at 16:56:58
    RE: Material Quantity and Price Variance in Production order

    Thanks for the answer and you are right.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on 06 Feb 2023 at 21:53:03
    RE: Material Quantity and Price Variance in Production order

    As far as I know that is not possible using standard functionality. So you either need to adapt a manual workflow to handle it or have it customized.  A customization around this could easily be expensive.

  • Aamirr Profile Picture
    Aamirr 25 on 06 Feb 2023 at 16:06:13
    RE: Material Quantity and Price Variance in Production order

    Hi,

    I want to set up different GL accounts for both quantity and price variances.

    Thanks..

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on 03 Feb 2023 at 20:24:21
    RE: Material Quantity and Price Variance in Production order

    Purchase Price Variance account is setup in General Posting Setup not Inventory Posting Setup. There is no quantity variance posting going to the GL....the quantity variance of materials used on a production order is what creates the material variance.

  • MahGah Profile Picture
    MahGah 15,428 on 02 Feb 2023 at 21:15:53
    RE: Material Quantity and Price Variance in Production order

    Sorry, I thought you were looking for setup area. Do you mean you want to track them separately for each finish good category? Or item per item? or you want them to post in different g/l?

  • Aamirr Profile Picture
    Aamirr 25 on 02 Feb 2023 at 19:06:03
    RE: Material Quantity and Price Variance in Production order

    Hi,

    Thanks for you answer. The above screen shot was from inventory posting set up for different product posting groups. There is only one field available for "Material Quantity Variance" and all variances (Price & Quantity) are going to that particular GL.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on 30 Jan 2023 at 20:24:04
    RE: Material Quantity and Price Variance in Production order

    Try going to "Inventory Posting Setup" then set Variant account for each posting group that you want to the account that you want. Then try again with new production order

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans