Error 2014, Duplicate Invoice
Error 3062: DUPLICATE ORDER
To fix this error, go to Menus > Maintenance, then to Maintenance > Programmer’s and then *PROG* > Windows > Orders or Invoices (whichever is appropriate). Click on Find and enter the Order/Invoice number provided on the diagnostic. Now click on Next; the next Order/Invoice that appears should have the same number as the previous one.
*For Orders – The quickest way to fix this is to Edit the Order # of the duplicate order. Change the number to something that is not in use, then press OK.
*For Invoices – The diagnostic should also provide an available Invoice number that you can use; place that number in the INNUM field. Click Ok. If there are more Invoices that need fixing, run diagnostics again to get another available Invoice number.
Warning: this fix will create a Connection diagnostic error.
Foreign keys are not updated using the PROG windows.
Batch fix under Diagnostics > Connection Diagnostics > Fill Empty Child FK fields.
Or Edit the Foreign key in each child record.