Hi

in the Import/Export tab of the customer, did you check the box "This customer uses my item numbers on orders" or fille the window with headings Customer'item no, My Item number, ans My account.?

Regards,

Danielle

Yes I did, that why this doesn't make sense. 

for all the items?

Which question are you answering 

Michelle Morency said:

Yes I did

to?

Was it

Danielle_LPC said:

did you check the box "This customer uses my item numbers on orders"

or 

Danielle_LPC said:

or fille the window with headings Customer'item no, My Item number, ans My account.?

I have 1 item for each invoice as that is the only info I need, being as its an import and I only need the sales and HST accounts to be affected, not inventory. So yes each invoice I have to verify. I tried to change the item to see if it was something I enter wrong but that has not changed anything.

Is the .imp file from Sage?

I created it. It imports fine just asked me to verify the item number each time.

then, must be a "gug" somewhere!

do you use , as separators?

do you use " " around your item name?

could you show me a few lines of your imp file?

<Version>
"12001","1"
</Version>
<SalInvoice>
"ACCESS DOORS 'N' MORE"
"1",,"13","3-15-2021","0",,"62.14","0.00"
,"100","1.0000","54.99","GST/HST","0","1","13.00","7.15"
</SalInvoice>
<SalInvoice>
"ACCESS DOORS 'N' MORE"
"1",,"14","3-15-2021","0",,"62.14","0.00"
,"100","1.0000","54.99","GST/HST","0","1","13.00","7.15"
</SalInvoice>

Here is what I use, created with Excel, then copy-paste into a .imp file (text file, ansi encoding):

<Version>
12001,3
</Version>
<SalInvoice>
Energies (C)
1, ,Com_20210101,01/01/2021, 3,CAC,222.12,0.00
CB,1,193.19, 193.19, TPS/TVH, 0, 1, 5.00, 9.66, TVQ, 0, 1, 9.975, 19.27
</SalInvoice>
<SalInvoice>
Energies (C)
1, ,Com_20210102,01/02/2021, 3,CAC,131.31,0.00
CB,1,114.21, 114.21, TPS/TVH, 0, 1, 5.00, 5.71, TVQ, 0, 1, 9.975, 11.39
</SalInvoice>

I don't use "" and it works fine!

Here is what I use, created with Excel, then copy-paste into a .imp file (text file, ansi encoding):

<Version>
12001,3
</Version>
<SalInvoice>
Energies (C)
1, ,Com_20210101,01/01/2021, 3,CAC,222.12,0.00
CB,1,193.19, 193.19, TPS/TVH, 0, 1, 5.00, 9.66, TVQ, 0, 1, 9.975, 19.27
</SalInvoice>
<SalInvoice>
Energies (C)
1, ,Com_20210102,01/02/2021, 3,CAC,131.31,0.00
CB,1,114.21, 114.21, TPS/TVH, 0, 1, 5.00, 5.71, TVQ, 0, 1, 9.975, 11.39
</SalInvoice>

I don't use "" and it works fine!

I just erased all the "" and it imports fine still but asked me to verify the item number.

maybe a letter would be ok instead of a number?

Thanks for info about the "" removal. That was great. 

I saw that is what you had and I just tried changed my 100 to an S but it still asks me to verify. 

there is a comma before your 100!  

I tried without it and it gave me an error, says invalid number and won't import at all. 

sorry, I had to go out. I would replacce "100" by a letter code, let's say AAA

could you show me your new lines that don't work?

Danielle

I tried that. Its not that they don't import. They just keep asking me to verify. I have tried changing the service number to letters and back again. I have tried restarting my computer after the changes.  It doesn't seem to matter.