1099 code problem when importing Vendors from Excel

Business Central/NAV Developers Forum
1

Hi everyone,
I work with Nav. 5. I am trying to import Vendor’s data through Excel.
First, I export blank file from Nav. 5 to Excel, than in Excel I fill it with data. When I try to import it back to Nav. 05 I see a message:

/This message if for C/AL programmers:
The call to member selectSingleNode failed.msxml6.dll returned the following message: Expression must evaluate to node-set.
–>1099<–Code/
The strange thing is that when I am doing it to import Customers I have no problems with importing.

How can I solve this problem?

Thank you in dvance for any help

2

Hi Skazka,

Did you install msxml6 ? Maybe you repair this pro.

Regards,

3

xml file do not allow elements starting with number. One suggestion is to renumber the 1099 to ten99, or remove the field from your file.

4

Hi All,

Even I am facing the same problem, while importing vendor records in NAV ERP via Excel, mentioned by Skazka…

I renamed the field ‘1099 Code’ as ‘Ten99’ in NAV database. The renamed name doesn’t get reflected in Vendor table i.e table #23 in NAV ERP, and when I tried to import records I got below mentioned error message:

“The 1099 code field on the vendor table does not exists in the SQL Server Table or view.”

Further I tried by deleting ‘1099 code’ column from ‘Vendor’ table in NAV Database. I am still getting the same error message mentioned above.

Renaming/deleting ‘1099 code’ field is not working for me.

Can anyone tell me how to import vendor records in NAV ERP without getting below mentioned error.

/This message if for C/AL programmers:
The call to member selectSingleNode failed.msxml6.dll returned the following message: Expression must evaluate to node-set.
–>1099<–Code/

Thanks in advance.

Sujata