Issue I am trying to resolve: Sales Journals with multiple Invoices appears to repeat the import when it should end and I get the error message that there is a duplicate Invoice number on line number ??

The purpose of my project is to reduce duplicate data entry by our accounts receivable clerks. I am taking information they have to enter in a form one of our customers requires to be filled out and submitted for payment. The form the customer provides is a custom Microsoft Excel 2013 macro enabled workbook. I identified the fields containing information we need in Sage 50 Quantum 2015 for our invoices.

I created a template file which has all of the required fields for an import as well as the all of the number of invoice distribution lines that each invoice will have. I verified that the template file works multiple times by just changing the Invoice number for each invoice distribution line. Next, I started adding new invoices to a copy of the import template with unique invoice numbers and then run the import and after increasing the number of invoices to 5 with unique invoice numbers with no errors during the import. I think now I am ready to try an import with normal amount of invoices which is around 216 invoices. Everything appears to be working correctly while running the test import until I see the error message indicating there is a duplicate invoice number on the last invoice distribution line of each invoice I am importing. I have looked at the imported invoices and found them to all be entered properly into Sage. I do not understand why the import of the sales journal seems to be running a second time.