Small and medium business | Business Central, N...

Regarding wrong unit cost value

(1) Share

Report

Posted on by Shaikh Zuber

Dear Team,

Can you please check the Unit Cost calculation on Item 19385, there is only 1 purchase recorded for this item at 38.10 while Unit Cost is calculated at 125.32

Screenshot 1

Screenshot 2

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Gerardo Rentería Ga... 27,507 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

You can review this content and see if anything it indicates may be affecting your cost.

When is the unit cost field updated About Unit Cost Calculation - Business Central | Microsoft Learn

Manually Adjust the Costs of Items - Business Central | Microsoft Learn

best regards

Gerardo

Was this reply helpful? Yes No
Shaikh Zuber 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please explain me in a simple way or alternate solution, so that I can do it in sandbox environment.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,389 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, have you executed Adjust Cost - Item Entries batch? You can confirm after running it.

In addition, if Item Charge is posted to this receipt, it will also cause this problem, such as shipping costs, tariffs, etc.

It is recommended that you search this item in Value Entries to find out the specific reason.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Shaikh Zuber 20 on at

Like
a
(0)

Report
Copy link

Link copied!

I also executed Adjust Cost - Item Entries batch, but nothing happens. Also checked the Item in Value entries.

Below excel file of value entries for your reference.

Can you suggest what further steps i need to perform ?

Was this reply helpful? Yes No
Suggested answer

HVGEEL 310 on at

Like
a
(0)

Report
Copy link

Link copied!

Drill down on the Cost Amount (Actual) field in the Item Ledger Entries in order to make sure no additional charges were applied.

There is more to Unit Cost than Direct Cost only.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,220 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

a simple answer is that as a rule, the value in the Unit Cost field on the item card is based on the standard cost for items with costing method standard. For items with all other costing methods, it is based on the calculation of the inventory available (invoiced costs and expected costs) divided by the quantity on hand.

in many cases, the unit cost on item card is calculated as an average and doesn't reflect the true unit cost used by the system. you need to check how the average costing set up on inventory setup page since average cost has different options. It is hard to tell simply why BC calculate the cost as 125.32. It could be other costs rolled up to the item in question. You can test again to validate since your screenshots don't tell the whole story.

Was this reply helpful? Yes No