Transferred Order to Invoice, Voided Invoice, Now Need to Get Order Back

(0) Share

Report

Posted on by Jennifer Wheeler

We are using GP 2010 R2. We have an order that has drop shipped items so it is linked to a PO. We did the enter/match invoices for the PO side. Then we went into the sales order and transferred it to an invoice. After transferring it to an invoice we realized that there was a problem with one of the quantites and voided the invoice before posting it. Now, we have a problem because the orginal order is in history. With voiding the invoice it looks like those quantities got put into inventory. So, we could enter in a sales order not attached to a PO to then transfer to an invoice but then we will end up with 2 orders that are the same and the order we no longer need will be affecting the customers credit limit. So, since I know you can't void a historical order what would be the best way to fix this? I don't want to go into SQL and delete the order from the history table since this order is linked to a PO. Is there a way to unvoid an invoice? Any advice?

Thanks
Jennifer

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

Re: Transferred Order to Invoice, Voided Invoice, Now Need to Get Order Back

Hi Jennifer -

I will be assisting you with your post today.

If you have voided your invoice, then the invoice is in history as is the order. There really is not a way to move the the order from history back to open. You would need to re-enter the order. If you need the order to have the same order number, then you could remove history on the original order and then enter the order again.

To remove history, go to Tools | Utilities | Sales | Remove Sales History. Here you can select the order based on document number. I do recommend you make a backup before you remove any history should you receive any undesired results.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Re: Transferred Order to Invoice, Voided Invoice, Now Need to Get Order Back

Hi Jennifer,

Rhonda is right. You cannot move history to open table. If having exact same order number is not important for, you can simply renter it with dot (.) at the end of the order and enter a proper description

Rubal,

http://www.dynamicsgphelp.com/

Was this reply helpful? Yes No
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

Re: Transferred Order to Invoice, Voided Invoice, Now Need to Get Order Back

Why not just create a new Invoice instead of starting from a new order? Fulfull all of the items correctly, then use SQL to change the master number to the same as the Order/Invoice previously done to "hook up" the history. The customer never saw the voided invoice anyways. For total correctness you could use SQL to change the Originating number and type also on the Invoice.

Tim

Was this reply helpful? Yes No
Jennifer Wheeler on at

Like (0)

Report

Re: Transferred Order to Invoice, Voided Invoice, Now Need to Get Order Back

Thanks for the reply Tim. We had ended up just doing a new invoice. I didn't think to go into SQL and change the master number. I think I will do that so that the history is there.

Thanks

Jennifer

Was this reply helpful? Yes No