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

Incorrect Unit Cost in Posted Purchase Invoice

(5) Share

Report

Posted on by CU04020711-0

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)

All responses (5)

Answers (0)

Suggested answer

RockwithNav 8,727 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Have a look -

https://learn.microsoft.com/en-us/dynamics365/business-central/payables-how-assign-item-charges

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,637 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hope this helps as well - How to Credit an Item Without Putting it Back in Inventory - Dynamics 365 Business Central Insights

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,261 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

I personally recommend using Purchase Credit Memo.

Correct or cancel unpaid purchase invoices

https://learn.microsoft.com/en-us/dynamics365/business-central/purchasing-how-correct-cancel-unpaid-purchase-invoices?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Assisted by AI

Aman Kakkar 2,526 on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Suggested answer

Alex A 2,924 on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No