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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

How To Correct An Incorrect Unit Cost on Item Due To Old Purchase Invoice Error

(0) ShareShare
ReportReport
Posted on by 50

I have 2 items with incorrect unit cost. Drilling back, I discovered that the unit costs on a purchase invoice from 2020 were swapped for two items on the invoice. An item with a unit cost of $108.00 was purchased for $453.60, and an item with a unit cost of $453.60 was purchased for $108.00. I cannot go back into 2020 to correct this mistake. But, I do need to correct the unit cost of these two items going forward.

We do not carry inventory of these items. Both have an inventory quantity of 0. I tried using the Item Revaluation Journal, but I am getting the following error: 

Quantity must have a value in Item Journal Line: Journal Template Name=REVALUATIO, Journal Batch Name=DEFAULT, Line No.=0. It cannot be zero or empty.

We are using Average cost.

Is there a way to correct the unit cost of these 2 items moving forward?

I appreciate any suggestions.

I have the same question (0)
  • Suggested answer
    Snehanshu Mandal Profile Picture
    560 on at

    I believe you can manage it with the revaluation journal with a little known trick. 

    In the revaluation journal - 

    1. create the lines manually for items [just the document number and item number. Nothing else]

    2. in the "applies to entry", lookup and select the original entry which has gone wrong.

    3. This will bring up all the relevant information missing in the line.

    4. Change the unit cost [Revalued] and Inventory Value [revalued] as you desired.

    5. Post it and it will revalue only those wrong entries to correct value.

    Try this out in a sandbox. If successful, do let me know.

    1263.pastedimage1627402206421v1.png

  • KAY15 Profile Picture
    50 on at

    Thank you for the suggestion! I tried in the Sandbox. I had to re-open the inventory period for Sept 2020. Then, I was able to post the Revaluation Journal. The unit cost on the item was corrected.

    I appreciate the help.

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

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,468

#2
YUN ZHU Profile Picture

YUN ZHU 923 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans