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

(0) Share

Report

Posted on by Community Member 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

All responses (4)

Answers (2)

Verified answer

keoma 32,675 on at

Like (0)

Report

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 23,116 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 32,675 on at

Like (0)

Report

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.