Great Plains Dynamics issue

I’ve looked all through-out google for any form of help for this situation, and alas, I am lost.

I am using a Windows 2000 Server running an SQL Database for Great Plains Dynamics 6.0.

An order was transfered into an invoice, but it wasn’t given a number. So now the batch is being held up. In Dynamics, I tried opening up the old order number and instead of opening up the order, it simply says “This number is in use.” I tried looking through the SOP files in the SQL to delete the order and recreate it, but I can’t even find it at this point. I’m running out of ideas on how to fix this, any advice?