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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Incorrect Unit Cost in...
Small and medium business | Business Central, N...
Suggested Answer

Incorrect Unit Cost in Posted Purchase Invoice

(4) ShareShare
ReportReport
Posted on by CU04020711-0 34
Hi.
 
There is a Posted Purchase Invoice which has been posted to an incorrect Unit Cost.
 
 
After checking the relevant Item ledger Entries i have noticed that the relevant Item Ledger Entry that has been created through the Posted Purchase Invoice has been applied for a Sales Shipment and two Sales Invoices.
 
 
The Current Costing Method is "AVCO".
 
What is the best approach to correct this matter. 
 
Your quick response on this is highly appreciated.
 
Warm Regards
 
 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Alex A Profile Picture
    Alex A 2,880 on at
    Hello,
     
    You will use the Revaluation Journal to revalue the related Value Entry. Please look into this process.
     
     
     
    Regards,
     
     
    Please mark the answer if it lends to your success.
  • Suggested answer
    Assisted by AI
    Aman Kakkar Profile Picture
    Aman Kakkar 2,319 on at
    Hi,

    What you should NOT do- 

    • Do not delete or modify Item Ledger Entries
    • Do not unapply entries manually
    • Do not change the cost directly on Value Entries
    • Do not use SQL or configuration packages
    These will break costing history and audit integrity.
     
     
    What you can do -
     
    • OPTION 01: Post a correcting Purchase Credit Memo. Make sure Adjust Cost – Item Entries is run after posting both documents.
       
    • OPTION 02: Revalue using Item Revaluation Journal. Only possible if some quantity from that purchase is still in inventory.
     
    Hope this helps.
    Aman K
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,432 Super User 2025 Season 2 on at
    I personally recommend using Purchase Credit Memo.
    Correct or cancel unpaid purchase invoices
     
    Hope this helps.
    Thanks.
    ZHU

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,064

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,568 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=643746800++REGULATOR" - Nested quantifier +.