web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Can you have both FIFO & Standard costing methods?

(0) ShareShare
ReportReport
Posted on by 2,438

Hi All,

We are not exactly a manufacturer.  We purchase raw material, then we subcontract.  After we received the finished goods from our subcontractors, we ship them to our customers.  In terms of material, we use FIFO.  The different between the purchase price and the invoice price, we post to variance.   In what situation would you need to use standard cost?  Is standard cost applicable to manufacturing? 

Please share your thoughts.  Thanks so much!

*This post is locked for comments

I have the same question (0)
  • lmai Profile Picture
    2,438 on at
    RE: Can you have both FIFO & Standard costing methods?

    Thank you, magic1949

  • lmai Profile Picture
    2,438 on at
    RE: Can you have both FIFO & Standard costing methods?

    Thank you, Konrad

  • Konrad U Profile Picture
    804 on at
    RE: Can you have both FIFO & Standard costing methods?

    Hi Kim,

    First if you are on average cost you would have to convert to standard cost which can be easy or awful depending on how many transactions there are and other quality issues out of the database (accumulated transaction errors). There are some good online references on doing this. We never could get it to work in AX 2009 so we changed when we implemented AX 2012 R3.

    Once you are on standard cost since costs are "activated" there should be no need for the recalculation. The process is to set costs on the lowest level items and work you way up the bill of material to the final cost with the final step being activating the cost for finished goods.

  • lmai Profile Picture
    2,438 on at
    RE: Can you have both FIFO & Standard costing methods?

    Hi Konrad,

    If I were to choose Standard Costing method, and AX uses the Moving Average Cost out-of-the-box, am I not need to run the inventory recalculation at the end of the month?   Thanks  

  • Konrad U Profile Picture
    804 on at
    RE: Can you have both FIFO & Standard costing methods?

    If you search for converting to standard cost in AX quite a bit has been written about it. Might have misled you a bit on the features. What I meant was that certain options that have no meaning in standard cost have been replaced with an error message. Since everything in standard has the same cost marking has little use.

    Management of cost is a complicated issue as magic posts below. We really do not use AX to do final costing but use something like a big bucket approach sales - (materials + labor + overhead) = profit. Analyzing on model basis can lead to bad decisions.  

  • Sten Baumgarten Profile Picture
    12 on at
    RE: Can you have both FIFO & Standard costing methods?

    Hi Kim

    I use to work at at company where we bought raw materials in different countries. The raw materials where repacked and the finished goods were sold in different countries. Before we changed to using standard cost for our finished goods, we used FIFO. 

    The sales people responsible for sales in different markets used to spend a lot of time convincing the people that planned production of finished goods to use the cheapest raw materials in their products and thereby ensuring that their profit would be bigger than if a random raw material were used. 

    To get rid of this sub optimization we changed inventory cost principle from FIFO to Standard cost. The sales people then did not spend time trying to convince the production planner to use the cheapest raw material but could spend their time optimizing sales and the production planners could spend their time optimizing production planning. 

    Kind regards

    Sten

  • Suggested answer
    guk1964 Profile Picture
    10,886 on at
    RE: Can you have both FIFO & Standard costing methods?

    Many accountants with whom I discuss seem to have  only have book knowledge of costing and  have often only  been trained on, or had experience with, average costing. They then write the accounting standards so it becomes a loop. I say that because they say stupid thing like your get different profit margin with average and standard. However, profit is sell price - buy price so how you cost in between has no impact.

    Costing has to satisfy many stakeholders- the tax man has a major say the costing method can affect the timing of profit  - as do the auditors on behalf of shareholders-but that does not help the business to make decisions - the salesman who is quoting with average costs that were last updated a year ago find his actual margin on which his commission is paid bears no relation to his actual margin, or how does he decide based on his costs whether to take a large order at a much lower order at a lower price has different expectation of a costing system. (this ir elrevant for when was the BOM cost last rolled.).

    A major factor in costing is how variable is the sale /purchase /manufacturing order quantity, and cost,  and how long does it stay in inventory. The answer is probably different for every item and every company but auditors blindly insist on one method, because its what they understand.

    From an accounting perspective if standard cost is not suitable then neither is average. They both require relatively stable costs, which also often means stable order sizes (IFRS if I remember correctly requires that they should be within 3% of each other). Average needs marking to take out the highs and lows.  Averaging 49.9 with 50.1 makes sense averaging 40 with 60 does not.  From my perspective, when these factors are not stable you get variances - the case in many companies, and I would prefer to be aware of those rather than just push them into inventory value. FIFO suffers from having to use average cost as an estimated cost until month end close.

    In most companies some real world challenges are: that all inventory is not consumed in the same month - hence the need for inventory costing (as opposed to just bom costing), all orders and invoices related to receipts are not posted/closed  before the month end close so there are adjustments the next month and those can be confusing when there is little inventory on which to post the adjustments. Those can be difficult to understand and are more complex to analyse than separately posted variances,

    If costs are stable and inventory is largely consumed and accounted in the same month then any  costing methods work ok in general  you might as  well use the one that you understand and that has the least performance hit. How many items and orders you have, and the complexity of your boms , how seasonal and erratic is demand, exchange rates etc may force a pragmatic decision of what is most workable. 

    Think of it this way if you expensed everything on receipt your purchase price is that same and you make a loss. when you sell you make 10)% profit on those materials so that offset the stock write off you just had a smaller profit initially and a larger one later.

    Put  the inventory into stock at sale price and you make an immediate profit and when you sell make none.

    The other costing method are a compromise between those two extremes, Think about he business decisions you face with regard to inventory costs and that will help you decide.

  • lally Profile Picture
    8 on at
    RE: Can you have both FIFO & Standard costing methods?

    [quote user="Konrad U"]However the strictness of AX mandates that at standard all inventory is the same, certain features stop working or change how they work such as marking and reservations. With some minor code tweaks you can bring some of the function back, we had uses for marking beyond inventory valuation so we made a minor code change to bring it back. [/quote]

    Did you mean that standard cost stop some features ?

    What about those features which does not work ?

    Any document is available ?

  • Konrad U Profile Picture
    804 on at
    RE: Can you have both FIFO & Standard costing methods?

    It depends on the department tasked with managing standard cost. If accounting does it standard requires each item have a cost before it is touched. For manufactured items this involves doing cost rollups and then activating the new standard. If manufacturing does it accounting is probably happier.

    In average cost the main issue is correcting bad transactions before month end closes. Depending on what process you use this can either be a big or a small problem.

    A side issue is how sales prices are determined since they can be based on cost (markup) if you use that function.

  • Konrad U Profile Picture
    804 on at
    RE: Can you have both FIFO & Standard costing methods?

    Hi Kim

    It would be nice to have both methods available at once but AX forces the choice of FIFO (a version of average cost) and standard cost. In AX 2009 our weighted average cost was a problem since average costing requires an inventory close and that close had lengthened to a day. We changed to standard for AX 2012 R3 and now there are no inventory closes. Yeah!

    However the strictness of AX mandates that at standard all inventory is the same, certain features stop working or change how they work such as marking and reservations. With some minor code tweaks you can bring some of the function back, we had uses for marking beyond inventory valuation so we made a minor code change to bring it back.

    So standard is the best way for us and depending on your need for FIFO you can probably find workarounds to simulate it. Either one should work but in a high transaction environment standard performs far better.

    Hope this hasn't made it too muddy for you.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans