Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / What is the correct wa...
Small and medium business | Business Central, N...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by joshtechsolutions 4,359
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.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    What is the correct way to get back the original item cost value and quantity amount?
    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)
     
    Thanks.
    ZHU
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    What is the correct way to get back the original item cost value and quantity amount?
    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.
     
  • joshtechsolutions Profile Picture
    joshtechsolutions 4,359 on at
    What is the correct way to get back the original item cost value and quantity amount?
     
    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.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,816 Super User 2024 Season 2 on at
    What is the correct way to get back the original item cost value and quantity amount?
    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?
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    What is the correct way to get back the original item cost value and quantity amount?
    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.
     
    Hope this helps as well.
    Thanks.
    ZHU
  • joshtechsolutions Profile Picture
    joshtechsolutions 4,359 on at
    What is the correct way to get back the original item cost value and quantity amount?
     
    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?
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    What is the correct way to get back the original item cost value and quantity amount?
    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans