Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Average cost calculation - Clarifications

Posted on by 229
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?
 
 
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 5,659 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 5,292 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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans