Why is sage still asking me to match the item when importing an imp file when I have checked the import/export box on the customers account file?
Why is sage still asking me to match the item when importing an imp file when I have checked the import/export box on the customers account file?
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
Yes I did
to?
Was it
did you check the box "This customer uses my item numbers on orders"
or
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!
and here is my custome data
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?
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.
*Community Hub is the new name for Sage City