Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Enter a wrong document and then delete it - delete tracks everywhere in the system

Posted on by Microsoft Employee

Hi,

I'm a complete beginner in Microsoft Dynamics Nav and I have a task to accomplish which is:

I have entered a document/invoice/order in the company which affects company income/expenses/employees' salaries and so on. Then I realize I've done a mistake and try to delete that. So company budget should be restored as earlier like this document had never been there. Can you recommend me an approach for this scenario?
Thanks in advance!

*This post is locked for comments

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Enter a wrong document and then delete it - delete tracks everywhere in the system

    deleting the posted documents does not solve the issue, although one could think it should. ;-) dynamics nav creates, when posting documents, many other data, so called ledger entries (value entries, item ledger entries G/L entries, etc.). these additional data is relevant for calculating the balance values and is not automatically deleted when removing the posted documents..

    to reverse the complete activity (creating sales order, posting, therefore creating posted sales shipment doc. and posted sales invoice, creating of the ledger entries, ...) it's needed to create a sales credit memo, set the same sell-to customer no. as in the posted sales shipment, then click on "get posted document lines to reverse", select "posted shipments" from dropdown, select the posted shipment line(s) you want to reverse, ok, the lines are inserted to the credit memo, post it. after that, balance should be correct again.

    other possibilities to reverse such activities is: open posted sales shipment document, click on Functions button above the sales lines, then select "undo shipment" to remove the shipment activities for that line. but ... only works, if the line is not invoiced.

    follow

    msdn.microsoft.com/.../hh168338(v=nav.70).aspx

    msdn.microsoft.com/.../hh173655(v=nav.70).aspx

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Enter a wrong document and then delete it - delete tracks everywhere in the system

    Do not delete any entry in NAV if you do not know exact places to delete. Plus it is not the best practice. If you have done a mistake then you have to post related return documents so that your document effect get null automatically.

    If you have posted a sales invoice then you need to post a credit memo to make the effect null.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Enter a wrong document and then delete it - delete tracks everywhere in the system

    Thank you for your reply, Jonathan. May I ask you one more question - when I make a sale order and I ship and invoice it to a particular customer, then customer's balance (LCY) get increased to the price of the sold items. Then I delete posted shipment and posted invoice but customer's balance (LCY) does not get reduced. When removing posted shipment and invoce to the customer I expect my income from this customer to reduce to the point before sending the shipment (like it had never happened). Thanks for your help.

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Enter a wrong document and then delete it - delete tracks everywhere in the system

    did  you create a sales invoice and posted it? if yes, posted documents can be reverted using undo function.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans