COST ADJUSTMENT TO POSITVE ADJUSTMENT ENTRIES

(7) Share

Report

Posted on by DynamicsBC

276

Hi community,

I have a scenario, In which we posted opening balances by using item journal. but client didn't provided unit cost at the time of opening balances. And later they realised that these items are showing 100% profit that is not fine. For example on Jan 2024 the posted positive adjustment of an item with 10 quantity and also sold in Februry. On sale this item is showing 100% profit now after a year they want to adjust some cost to this item. I tried to reverse the opening entry but business central restrict me with error (unsuffiecient quantity)

Is there any solution to post cost adjustment against items which are posted using positive adjustments to get actual profit.

Thanks in advance

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central migration

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Pallavi Phade 5,420 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Namaste

Since your positivie adjustment entries are already consumed , there is no option for reversal . Yes we can revalue the cost using Item Revalution journal .

Tips

Adjust all the cost adjustments before running this revaluation journal

Steps

Go to Item revaluation journal .

Run the report - Calculate inventory Value . Specify the date . This option is to get valuation on that date . In your case its zero

You will get all items on that date .Add unit cost in revalued column which need to be revalued.

If you feel valuation is correct after preview posting , Proceed with posting.

It will add cost to your item line by line.

In value entry , with Entry type as Revaluation it will get posted

If you feel its helpful , please verify the answer

Regards

Pallavi Phade

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Chavda Dharmendra 1,000 Super User 2026 Season 1 on at

Like (6)

Report
Copy link

Link copied!

Yes Correct @Pallavi.

After then run Adjust Cost – Item Entries report for adjust in all historical data.

Thanks

Dharmendra Chavda

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Nimsara Jayathilaka. 4,950 Super User 2026 Season 1 on at

Like (6)

Report
Copy link

Link copied!

If the original balances were posted to items with positive adjustments not including unit cost, Business Central will not know the proper item costs and thus could produce incorrect profit measurements on sales. Since you are not able to reverse the entries since you have sold from the quantity you have performed subsequent sales, you can instead the next best thing, adjust costs.

The Inventory Cost Adjustment page in Business Central allows you to adjust the item cost against quantifying the remaining inventory on hand and not the cost of the quantity. Doing cost adjustments will produce a change in unit cost for the item, and therefore fix the profit calculations going forward. As cost adjustments let you batch and track items, cost adjustments can easily be done as post opening quantifying balance.

When you do not have quantity available to reverse, I suggest don't reverse your original entries and only be concerned with cost adjustments and ensure your cost base is correct. It is always best practice to first test and trial in 'sandbox' mode before implementation in production to ensure proper accounting and inventory valuation.

Thanks

Nimsara

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

PRao 447 on at

Like (3)

Report
Copy link

Link copied!

I agree with solution provided by others.
Positive adjustment entries(opening ) are already consumed , there is no other option for reversal or may be not right way.

Correct way is to update the cost using Item Revaluation journal against the previous entry.
Make sure before executing the item Revaluation journal Item Adjust cost already run.

Thanks,
PRao

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,757 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi,

Use Item Revaluation Journal to correct costs (after running Adjust Cost – Item Entries).

This updates inventory value and fixes profit reporting. Always test in a sandbox first.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,947 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Unit cost always gets calculated as per the costing method and all. At any point in if it's not showing correct value, Revaluation journal is the only option, post adjust cost run this and change it to the value you want.

Was this reply helpful? Yes No