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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / The actual cost amount...
Small and medium business | Business Central, N...
Answered

The actual cost amount is showing differently for the same serial number in the Item ledger Entries

(4) ShareShare
ReportReport
Posted on by Dharmendra Patel 45
Hello Team,
 
The actual cost amount is showing differently for the same serial/ Lot  number in Item ledger Entries Flow Feilds for Entry Type Output and Sales entry types in Business Central.
 
Item Costing Methos is "Average" and Average Costing period is "Day" in Inventory setup.
 
Business cental Version 24 India Localization.
 
Please help us out why this diffrent showing in system.
 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Verified answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 21,181 Super User 2025 Season 2 on at
    I think it does not use the serial/lot cost. It re-calculates a daily average cost and applies that value to all outbound entries. So the entries can show different Actual Cost Amounts for the same serial/lot. This is standard and expected behavior for Average costing.
  • Verified answer
    Valentin Castravet Profile Picture
    Valentin Castravet 31,637 Super User 2025 Season 2 on at
    That is normal. The Cost Amount (Actual) on the sale is based on the item’s average cost; it is not a one-to-one relationship with the output cost. If you want the sales transaction to carry the exact same cost as the output, you would need to use the Specific costing method.
     
  • Verified answer
    OussamaSabbouh Profile Picture
    OussamaSabbouh 7,560 on at
    Hello,
     
    With Average Cost (Day), it’s normal that Output and Sales show different Actual Cost Amounts, even for the same lot/serial.
     
    Because:
     
    Output uses the average cost at output time
     
    Sales uses the average cost at sale time
     
    Any purchase/revaluation between those two moments changes the average
     
    Adjust Cost later applies corrections differently to each entry
     
    So differences are expected and correct for Average Costing.
     
    Regards,
    Oussama Sabbouh

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,638

#2
YUN ZHU Profile Picture

YUN ZHU 837 Super User 2025 Season 2

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 704 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans