Sage will not allow you to manually enter or import duplicate invoice numbers. In your screen shot the duplicate import happened because the invoice number is blank, so Sage will allow you to import duplicate blank invoice numbers. Sometimes the reason the import does not work is as simple as when the columns for the export do not exactly match the columns of the import. For example if the export includes the customer name for column B  but the import for column B is the invoice date, the file will not import.

Thanks for the response.  I am getting two invoices created after importing a single line.  So the duplicates didn't occur bc I am importing the same file over and over.  Rather, I import once, and I get 2 invoices.  

I also tried by adjusting my file to remove the Invoice # columns and not importing that column as part of my import template.  I still get 2 invoices per single import operation.  Any ideas on what is causing this?

If you have 1 invoice with invoice # 123 to import but you have 2 lines that belong to invoice 123 then the number of distributions column needs to be 2 for both lines.

Thanks. However, I importing one row (not multple lines).  You can see exactly what I am importing above.  Looking at the table, is there anything about my import values that is wrong or out of sync?

The serial number column requires an Item ID. The Item ID must be set up as an item class of serialized stock item. If you were to manually enter this entry into Sage you would see that it would not accept a serial number without an item ID. Furthermore that serial number needs to already exist as a selection from inventory that has been received and serialized.

If you don't want to keep track of serialized items then force the serial number to populate the description column.

Hope that helps

Ok, so my issue is I am not passing a Serial Number.  Based on what I have learned previously, this is a required field.  Since we don't want to keep track of serialized items, you state ...

KimClement said:

force the serial number to populate the description column.

How is this done?

I found this post which solved my issue.  I added the Credit Memo column with a value of FALSE, and the duplicates stopped.

https://sagecity.na.sage.com/support_communities/sage50_accounting_us/f/sage-50-accounting---u-s-edition/72733/importing-sales-journal-transactions---duplicating-the-invoice

You say, I am not passing a Serial Number. Are you are using the serial number field on the import?  I would not use the serial number field, instead I would use the description field, then in your Excel sheet cut/copy the column for the serial numbers to the description column.  Now the serial number will appear in the description part of the line.

Gotcha.  No I don't need the serial number, but it's a required field, so that's why it's included, but blank.