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

(4) Share

Report

Posted on by Dharmendra Patel

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)

All responses (4)

Answers (4)

Verified answer

Khushbu Rajvi. 21,573 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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.

Please check: https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-average-cost

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 31,935 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Verified answer

OussamaSabbouh 10,875 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Dharmendra Patel 66 on at

Like (0)

Report
Copy link

Link copied!

Hello Team

If you want the same Actual Cost Amount to be updated in the Item Ledger Entries, please ensure that select “Applies-to Item Entry” is selected on the outbound entry against the corresponding inbound entry with the same Serial No./Lot No. on item tracking lines.

By doing this, the system will update the same actual cost amount for both inbound and outbound entries against the same Lot/Serial No.

Was this reply helpful? Yes No