SO was entered and lines were released. When the employee came to print the invoice, he noticed SO# was duplicated. He says he only released once. When I checked, SO 14912 was listed twice, one had an IVN 4907 and the other INV 4908. The invoices were identical exp for the Inv number. I changed the release qty so the INV are of zero value. Printed them, and posted.
INV 4908 posted no issues, while inv 4907 didnt post. now we are skipping an invoice!
SO 14912 shows on my list one as closed and the other not closed. If I enter the not closed SO, once I go to the next screen, it says SO closed do u want to re-open. I am not sure what happened. Its obvious something duplicated the SO, and then the indexing got mixed up between the 2.
 
We created and totally new SO and posted from there, but I stil have INV 4907 missing in my system! I cant seem to re-print it, SO is closed, although I choose not the closed SO from the list. and it does not exist to post!
 
Please help! its driving me crazy
 

Quote from fdiala on 05/07/14 at 09:10:13:

 
"Invoices" are not actual records on your system.  
Invoice numbers are assign to Sales Orders.  
 
You will not be able to recover that number because you have already post Invoice 4908.
 
 

 
Kelloggs
 

I would query my database and find the sales order and then delete. But it meas that you need to know a little bit of SQL language.
 
Have you contact ISTECH Support?
 
On your Pervasive Control Panel
 
select * from "BKARHINV" where bkar_inv_sonum = 14912;
This could return up to 3 records.
 
 
 
Kelloggs

There is two tables: BKARINV and BKARHINV
have fun...
 
 
 
Kelloggs