Undo Posted Invoice

mstallmann

Posting date was incorrect on an invoice. I was wondering the best way to back it out, and create another one. I know that I can write reversing entries, recreate the order and post again, but was not sure of all the entries to make, and wanted to know if there was a better solution than that.

Thanks,

Mike

Dean_Axon

By far the easiest solution is to use the "Copy Document" function. This is avaliable in both "Sales & receivables" and "Purchase & payables".

You can copy ANY document type listed in these tables.

So, assuming that this is a sales invoice that has been posted you should :

Sales & recievables>>Credit Memo>>New.
Functions>>Copy Document.

Document type to copy : Posted Invoice

Choose you posted invoice from the list avaliable and then create your credit memo.
(i apologise if the wording is not exactley the same as I a doing this from memory)

This has then created an EXACT reversal entry for the posted invoice.

You could also use the copy document function to create your new order.

Hope this helps.

p.s. as a safeguard you could place a confirm prompt in the posting routine to check if the user has changed the posting date BEFORE creating the invoice. I would not recommed this for batch posting though.

mstallmann

Can I change the posting dates on the entries? Any suggestions on what areas are affected, and how to do this?

Mike

Savatage

You need a developers license to change the dates directly in the tables. It hits so many tables that just using the copy document function to post a credit to the bad invoice & recreate it is the easiest and surest way.

mstallmann

I have a developer's license. What is the best way to find out all of the transactions that are affected? Is navigate sufficient?

Mike

Alterant

mstallmann wrote:

I have a developer's license. What is the best way to find out all of the transactions that are affected? Is navigate sufficient?
Mike

The best way to solve this problem is
1. to make a local copy of the database.
2. Enable Client Monitor and make incorrect transaction again.
3. In Client Monitor window you can see all tables and fields that was affected during the transaction.

mstallmann

You learn something new every year...

mstallmann

I have decided to do this manually, too much to pay attention to in order to do it otherwise. The problem however is that the invoices are closed as the payments have been made to them. How can i credit the payment and reopen the invoice so I can create the credit memo to back out the invoice??? Also, will the credit memo back out the shipment as well?

Mike

SpeedLoader

Sorry, you cant.



The only thing you can do is to:
Create a copy of the database;
Delete the records of the payment (Extremly careful) and to manualy (with a developers license) make the corrections on to the open value.


Very, very tricky but doable