Administration->Setup->Company->Company
Then select Tools->Integrate->Table Import and select the VAT Country Code MSTR and click OK.
What do I do here? I don't understand how I am supposed to import data using this form. How do I do it?
*This post is locked for comments
Thank you. I read your article a few days ago. What is the menu path to create the import definition? We have no definitions created yet. This is the first import I am attempting. I will be working with a consultant in a few days but want to have some of the infrastructure in place.
Take a look at my article dynamicsgpblogster.blogspot.com/.../often-overlooked-yet-powerful-table.html. I have a concrete example on importing data.
I want to import an item/pricing file into GP. I understand the steps to import except for the Import Definition. Where do you go to the Import Definition? I have watched so many videos and read so many blogs but they all assume the import definition is already existing.
Thanks
Just a quick question. What happens if there is data in the table. will it clear it and re import or will it just add the new records?
It's important to know that Table Import only imports new records and does not update existing records. So, now, here's what you do. You need a file in a comma-delimited or tab-delimited format.
Enter a Definition ID and Description. These just need to describe what you're doing.
For the Source File Format, select one of the two options.
Select your file as the Source File.
The Destination Table should be VAT Country Code MSTR.
For fields present in your source file, double-click on them to select the source fields, one field at a time. For example, if Country Code is in your file, double-click the Country Code field and select the appropriate field from your file. Repeat this step for each field you have in your source file.
For fields not in your source file, you can hard-code a value by typing it in the Constant field and clicking Add. Make sure the field to which you are assigning the constant is selected first.
For fields you do not need, like, probably, the Note Index, leave it blank.
Lastly, once you map your data, back up your text file and remove the header row. If you leave the header row in the file, that row will be imported into GP. You don't want that junk.
Then click the Import button. A file with rjt will be created. Hopefully, it's blank. If it isn't, it's because you have duplicate values based on what GP allows in the destination table. You can use Notepad to open the file.
That's it!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (