Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Standard Cost Rollups and MO Variances

(0) ShareShare
ReportReport
Posted on by 2

I need some confirmation from accountant type folks.

I have a manufacturing client - they backflush all materials and labor for all mfg'd items.

Here's the scenario -

Open a MO on Jan 1st for FG A - ending qty = 100.

Standard cost on January 1st is $10 material, $20 labor for a total of $30.

They partially receive 10 on Jan. 2nd @ $30 - which is okay.

 They partially receive 10 on Jan 3rd @ $30 which is okay.

They roll up and re-value all items on Jan 4th - FG A has a new std - $12 material and $20 labor - total of $32.

They partially receive on January 5th qty of 10 @ $32 which is okay.

Remember - totally backflushed environment - if they close the MO on January 5th - I think there should be no variances - after all they backflush labor and materials. The raw materials used on the January 5th receipt were re-valued on January 4th.

However, in this scenario the system triggerred a MO Variance.............$20 material which is the difference between $32 receipt and the original $30 standard..........

I think this is wrong from a transactional processing point of view and from a financial accounting point of view.

 Thank you in advance for any comments you folks might have.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Standard Cost Rollups and MO Variances

    Bron,

    I'm not much of an accountant, but the system is "working as designed".  It will consume whatever is the standard at the time the receipt is done.

     As for the accounting part, I've had a similar discussion with the controller of a customer of mine.   My amateur shoot-from-the-hip conclusion in that case was that a different customer, the one that prompted the conversation, was using standard costing with an actual costing mindset.

    The customer in question was make-to-stock.  When I was training them they couldn't believe that all their stock would be revalued.  Their GAAP thinking was that the inventory went in at a given cost and should remain the same.  The controller I talked to said this made sense with standard costing, though.  I don't remember the details, but obviously, there must be many make-to-stock companies that have inventory and use standard costing.

    I'm thinking perhaps, accounting-wise, something similar applies here in that the standard is what it is at the time of receipt and any variances are handled against the COGS as would be the case with my example customer when they would roll standards.

    Maybe a real accountant can give a better answer, but just trying to help.

    Thanks,

    John Chastain

    MMLJ Consulting, LLC

    636-734-7935

     

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans