For some strange reason we are unable to delete the record for a bad sales order from the BKARINV table.  In Maintain Datsabase (MDB) we find the record, select it in edit mode, then click in the minus link to delete.  Confirm the delete.  Nada. Still there. Go out and back in, still there for sure.  It will not delete.  Something weird, or something DA we are doing.
 
Anyone else had this problem, is there any way to delete it when it does this?
 
This record is causing issues--like printing sales order reports, for example. We can get a report of the latest SO # to the sales order just before this one, or the sales order just after this one to the earliest, but not a full list of the sales orders.  It is also preventing us from using a range for sale order invoicing forcing the invoicing to be one at a time which is very time consuming.
 
Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!