Order being transferred to Invoice

[brendasql]

Hi,
I have an order that was transferred to an invoice, but only 2 out of the 3 items on the order was invoiced. The user assumed that it was hung up and they have now VOIDED the order. Is there a way to unvoid the order. I can see both the order and the invoice in the SOP30300 table. And what would happen to this invoice and order if a reconcil was run?
We are using GP 9. Any advice would or recommendations that you can give would be wonderful.
Thanks,
Brenda

 

[jazgeek]

it's voided so there's not much you can do unless you go into the database and manually reset it (not sure what this would do if a checklinks or reconcile were to be run)

I would first run checklinks on your sop tables to see if anything needs closing/fixing (remember to back your database up first) then run a reconcile. This should put your numbers on the original sop doc back into place.

-----------
and they wonder why they call it Great Pains!

jaz

 

[brendasql]

Thanks Jaz. I have read your reply on both threads. I will try the checklinks and reconcil. Not sure about manual correcting in the table, I have SQL experience but this Great Plains database is a Great Pain as your signature implies!