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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Adjusting Incorrectly received Item qty but invoiced with correct amount

(3) ShareShare
ReportReport
Posted on by 231
We incorrectly setup the item with a receiving master unit of 1 MSU = 12 units, but it should be 1 MSU = 6 units.
 
We received 408 units of this item instead of 204, and it got invoiced with the correct amount.
Unit cost became 10 instead of 20.
 
How can we adjust the unit cost correctly?
Inventory Control team negatively adjusted the items using a item journal taking out 204 units at ZERO value.
They were hoping that it would adjust the remaining inventory to double the cost, but instead cost adjustment just added an entry to remove the cost associated with the 204 units adjusted out.
Currently our inventory is 0 for this item because of the negative adjustment and sales.
We already sold the 204 units of the item but now our reporting still says that unit cost is 10 instead of 20.
Edited: Posting date for this has been closed since last fiscal year
How can we go about fixing this?
I have the same question (0)
  • Jainam M. Kothari Profile Picture
    16,548 Super User 2026 Season 1 on at
    Hello,
     
    You can Post the Purchase Credit Memo for Remaining Items, and then Change the Unit of Measurement Values. and Post the Purchase Receipt with Right Qty, Right UOM and Right Amount.

     
    Then your Unit Cost will be updated with 20.

     
    I hope your query will be resolved.
  • Suggested answer
    BryLearnsBC Profile Picture
    231 on at
    @Jainam M. Kothari This helps but the items have already been adjusted out.
    The recommended solution was to use a Revaluation Journal to adjust the cost of the Purchase Receipt manually.
     
    My issue is if I revalue to cost manually, will any applied Purchase Invoices to the Receipt also get revalued.
     
    Soo unit cost should be 20.5 including applied Purchase invoices but if I revalue the purchase receipt to 20 will the unit cost be just 20 or 20.5?
     
     
     
  • Gerardo Rentería García Profile Picture
    26,834 Most Valuable Professional on at
  • Suggested answer
    Valentin Castravet Profile Picture
    32,693 Super User 2026 Season 1 on at
    The purchase receipts and posted purchase invoices are tied, so if you adjust the receipt, then the invoice gets adjusted as well.
     
  • Suggested answer
    YUN ZHU Profile Picture
    101,202 Super User 2026 Season 1 on at
    I think the most thorough way is to scrap the current inventory (Negative Adjustment in Item Journal) and then add a new item with a new cost.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    22,435 Super User 2026 Season 1 on at

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,233 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,360 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,216

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans