Country Code Import Question

(0) Share

Report

Posted on by Community Member

I'm trying to import the ISO codes for the countries around the world from a CSV. I know what table they go to (VAT10001), but I can't figure out how to import it using Table Import, or Integration Manager as I can't find a destination for VAT10001. Anyone?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

L Vail 65,271 on at

Like (0)

Report

Re: Country Code Import Question

VAT10001 is the VAT Country Code MSTR in the Dynamics.dic. Company Series

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

Re: Country Code Import Question

Options:

Mail Merge Macro

SQL DTS

Create your own adapter

Hand Key

Squared,

I have been watching your posts for the last few days and posting replies when I can. I would like to suggest three things: first, contact Integrated Business Group in Orlando, Florida and sign up for some classes in Dynamics GP. Second, get a set of our books. Finally, loose the Elvis look. Mean while, we will continue to reply best we can to your posts.

I applaud your efforts to learn, get the resources to help you learn.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Re: Re: Country Code Import Question

Table Import would work too.

Ouch! I think the photo is fun! Much more character than a blue outline.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Country Code Import Question

Hi Squared. Shameless plug - if you need help with any European localisation issues - VAT / Intrastat / VIES / ESL etc., drop me a PM.

You should be able to table import into the VAT10001 table. Are you getting an error message or is it that you can't find the table?

Best regards,

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

Re: Re: Re: Country Code Import Question

I looked for a table import option in several different places. Where is this one located?

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Re: Re: Re: Re: Country Code Import Question

The name of the table is VAT Country Code MSTR, it is in the Company Series of the Dynamics.dic

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

Re: Re: Re: Re: Re: Country Code Import Question

So you select Administrator->Company->Company then Tools->Integrate->Table Import and select VAT Country Code.

I think I looked everywhere except the company setup window.

Was this reply helpful? Yes No