Skip to main content
Business Central forum
Suggested answer

Average cost calculation - Clarifications

editSubscribe (1) ShareShare
ReportReport
Posted on by 207
I am trying to identify the logic behind the average cost calculation. 

There are two items in the item list with a unit cost of Zero. Both the items do not hold inventory. There are transactions for both items. 

 
ItemUnit costInventory Costing method
190040.000Average
1899878.180Average
 
Item 19004 average cost calculation
 
 
 
 
Item 18998 average cost calculation
 
 
 
What is the reason that item 19004 does not contain a unit cost, but item 18998 contains a unit cost?
 
 
Attachments
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 3,580 Super User on at
    Average cost calculation - Clarifications
    first and foremost, you need to make sure the costing in your BC is up to date. To achieve this, you can run adjust cost item entries. leave the filers blank, BC will true up for all items. Check your item card again to see if cost of 19004 is updated. 
    Even with a updated cost on item card, the unit cost is just used to calculate the total inventory value of invoiced and received not invoiced on hand inventory, so it is often misleading for users to use this number as the real unit cost. 
    how BC calculate real average cost for items depends on the setup on inventory setup page. Go there and take a look at the set up of . with different setup, BC has different behavior calculating the average cost of items
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 2,786 Super User on at
    Average cost calculation - Clarifications
    Hi
    You could see what settings you have in this option.
    Here you have very detailed information about the calculation that is carried out, I hope it can help you a little.
    Best regards
    Gerardo

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,126 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,646 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans