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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (2)

keoma 32,729 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.

Was this reply helpful? Yes No
Community Member 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.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 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.

Was this reply helpful? Yes No
Verified answer

keoma 32,729 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

Was this reply helpful? Yes No