Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

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

Posted on by 4,241
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 70,191 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,786 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,241 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 22,350 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 70,191 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,241 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,786 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans