I am putting together a VI import job to import invoices into the AR_InvoiceHeader table in Sage 100 2016.

The import appears to be identifying the headers and line items appropriately, however it does not skip duplicates as all existing invoices are listed in the AR Invoice History table.  Does anyone have any tips on how I can check to see if the invoice # I am trying to import already exists in the AR Invoice History tables?

I've seen that there are other similar posts, but none of them had a resolution that I could find.