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

What is the correct way to get back the original item cost value and quantity amount?

(1) Share

Report

Posted on by joshtechsolutions

4,971

Hi Community,

I have this issue..

What is the right way to retrieve back the original item cost value and quantity amount such that I can get back my original item quantity and cost price in Navision?

Suppose I have an Item A, this Item is Purchased using Purchase Order, and has been invoiced using Purchase Invoiced. Then the Item has been consumed in warehouse, and then some of the consumed item A has been sold using the sales order and then invoiced using the Sales Invoiced.

Now when I try to do a Purchase return order for the Item, I can't do it, because it shows me this error: "One or more return document lines were no copied. This is because quantities on the posted document lines are already fully or partially applied, so the Exact Cost Reversing Link could not be created.".

Can you share with me step by step in layman terms how to reverse this scenario such that I can get back my original item cost value and quantity in Navision?

Thank you.

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (1)

Report

On this error message, if You press OK, the lines are still created.

When pressing the Get Posted Document Lines to Reverse... button, There take out the checkmark - Return Original Quantity, switch to Document Type Filter = Posted Receipts, this way it will create the selected line and in quantity field, the Remaining quantity will be filled in.

If it is not working this way, in the Purchase&Payables Setup take out the "Exact Cost Reversing Mandatory" checkmark, and then try again.

Was this reply helpful? Yes No
joshtechsolutions 4,971 on at

Like (0)

Report

Hi KasparsSemjonovs,

Thank you for your reply. I'm actually not comfortable to take out the "Exact Cost Reversing Mandatory" checkmark at Purchase&Payables Setup.

I wonder if there are any other ways?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (2)

Report

Although it is not recommended, I think using Item Journals to make positive adjustments is the fastest.

As for the cost, it can be adjusted through the Revaluation Journal.

More details: https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-revalue-inventory?wt.mc_id=DX-MVP-5004336

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Could you clarify your process? You purchased an item, which was then sold and consumed. Now, you are trying to return the item that you bought. If so, there’s nothing to return since it has already been sold and consumed. What exactly are you attempting to return? Is it a partial return? Or, do you want to return the same quantity that you have in inventory from a different purchase?

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
joshtechsolutions 4,971 on at

Like (1)

Report

Hi Valentin Castravet,

Thanks for asking.

We wanted to reverse the sales invoice back to the purchase invoice and back to the item because we realized that the purchaser had issue the Purchase Order in another currency, say CAD, but the sales invoice from supplier was actually in USD.

Accounts still proceeded to pay in USD without checking the currency sign of our Purchase Order.

Please advise what do you think is the best way to revert the whole process back to original and allow us to reopen PO and SO again.

Thank you.

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (1)

Report

In this case, if the Inventory quantities and items were correct, You can create a Purchase Credit Memo with G/L account line in it (if actual unit cost was lower, or create Purchase Invoice if actual unit cost was higher) to sort out the balance with the Vendor, and then do correction from Item Revaluation Journal for this receipt - it will update the Unit cost of these items and when the "Adjust Cost- Item entries" process is run, it will adjust all the linked item movements (sales, transfers etc) with the update unit cost.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (2)

Report

Just adding some information. If you are not allowed to apply vendor payments in different currencies, you can disable the following setting.

Dynamics 365 Business Central: How to disable Application of Ledger Entries in Different Currencies (Appln. between Currencies)

https://yzhums.com/38907/

Thanks.

ZHU

Was this reply helpful? Yes No