export AR and AP vendor list from one company into a new company

i just want the names and addresses from our AR and AP list from one company 
to export into the new company.  I don't want any historical data 
transferred.  I just want to avoid a whole bunch a data entry.

Are the files to copy PM00200 and PM00300?  


0
Utf
1/26/2010 6:14:01 PM
greatplains 29623 articles. 3 followers. Follow

3 Replies
1461 Views

Similar Articles

[PageSpeed] 54

Payables
    Names etc   PM00200
    Addresses   PM00300
Receivables
    Names etc  RM00101
    Addresses  RM00102

Create all classes first
Run Checklinks and then Reconcile after loading this data (unless you use 
IM) to build some summary tables.

If you have internet information or record notes, they will be lost.  Record 
notes are in the SY03900 tables but that table also contains record notes for 
items, transactions, etc.  Moving it requires some other skills such as 
identifying the last note number and setting that correctly.

Internet information table also contains data for items, employees, et cetera.
-- 
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users

Get our Free Tips and Tricks Newsletter and check out our books at 
http://www.AccoladePublications.com



"JD" wrote:

> i just want the names and addresses from our AR and AP list from one company 
> to export into the new company.  I don't want any historical data 
> transferred.  I just want to avoid a whole bunch a data entry.
> 
> Are the files to copy PM00200 and PM00300?  
> 
> 
0
Utf
1/26/2010 7:12:01 PM
Hi JD,

You are correct and you can include PM00100 for vendor class!  But you have 
to change the update:

1.  Note Indexes of these tables
2.  All account indexs (references to GL Account Number) in PM00200 and 
PM00100

Lastly, if you install GP10 SDK from the CD, there is a clear gudieline 
using Table Integration>>The Puchasing Series and Vendor Master Impot 
guidelines (Vendor.doc file),

Hope this helps!

Cheers,

Dennis Araullo, MACS
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator


"JD" wrote:

> i just want the names and addresses from our AR and AP list from one company 
> to export into the new company.  I don't want any historical data 
> transferred.  I just want to avoid a whole bunch a data entry.
> 
> Are the files to copy PM00200 and PM00300?  
> 
> 
0
Utf
1/26/2010 7:22:01 PM
Thanks for the feedback!

So, in essence, if I do a sql query like this:

select into TWO.dbo.RM00101 from the source db, for each table, would this 
do it?  I tried a Sql Export, automated, but it did not work.

Thanks in advance,
Matt

"Dencio" wrote:

> Hi JD,
> 
> You are correct and you can include PM00100 for vendor class!  But you have 
> to change the update:
> 
> 1.  Note Indexes of these tables
> 2.  All account indexs (references to GL Account Number) in PM00200 and 
> PM00100
> 
> Lastly, if you install GP10 SDK from the CD, there is a clear gudieline 
> using Table Integration>>The Puchasing Series and Vendor Master Impot 
> guidelines (Vendor.doc file),
> 
> Hope this helps!
> 
> Cheers,
> 
> Dennis Araullo, MACS
> Microsoft Certified Technology Specialist GP,CRM,AX
> MCITP Installation and Configuration AX 2009
> MCITP Database Administrator SQL 2008
> Citrix Certified Enterprise Administrator
> 
> 
> "JD" wrote:
> 
> > i just want the names and addresses from our AR and AP list from one company 
> > to export into the new company.  I don't want any historical data 
> > transferred.  I just want to avoid a whole bunch a data entry.
> > 
> > Are the files to copy PM00200 and PM00300?  
> > 
> > 
0
Utf
2/2/2010 8:21:02 PM
Reply:

Similar Artilces:

merging 2 -3 different MS money files into one
hi over a period of testing and doing other things i have created multiple MS Money files mostly with the same accounts and same transactions, the main difference is the transactions that are available in those files, the oldest file has the oldest transactions and newest one has all the new transactions but both contain some common so i want to merge all of them into one so that i can get all transactions from the begining till now. what is the best method to do this. thanks There is no good method. The only method, and not a good one, is File|Export of individual accounts to .QIF ...

linking drop down lists
hi, im trying to create a user friendly spreadsheet. i have 2 columns need help with. in the first column i have created a drop down list containing continents of the world. in the second column i want another drop dow list to display only the countries from the continent selected. fo instance. in the first column i have selected africa. how can i make i so that when i have selected africa from the continents drop down list to make the cell next to it (the countries drop down list)( only giv the option of selecting a country from africa instead of all th countries of the world -- reading2...

Export to XML exports single row only
What I did: On XML source panel of Excel 2007 added XML map, mapped to columns using ranges (i. e. A1:A1825), selected “Export” from “Developer” tab in the ribbon. Result: Output XML file contains only one record (first row from the worksheet) I’ve done this numerous times in Excel 2003 with no problem. What happens?? Please help! Thanks, Eugene ...

Exchange 2003: Not all distribution list members recieving e-mail
Morning all! We have 3 distribution lists that we use to send mail to our 3 different regions. I have users in each list that are not reciving the e-mails sent to the lists. I have verified their email address's, made sure they were in the right group. I can look at the email (it gets sent to me as well) and I can see that they are in the list. Now, if I send them an e-mail from their contact, they get it. Its just when we send them e-mail on this list. Any ideas? Thanks, Tom On 12 Sep 2005 09:59:33 -0700, tomfarr@gmail.com wrote: >Morning all! > >We have 3 distribution li...

Contacts export display X400 not SMTP
Hi all, I'm not sure if this behavior is by default or not, but when my users try to export their contacts to an Excel file, any internal (domain) contacts show the X400 address rather than the SMTP address. Is there a way to change this? I've read some about VB scripts with CDO or something, but hoping there is an alternate way. Thanks Mike -- what version Exchange? -- Susan Conkey [MVP] "Mike W." <wallmr_snowpam@gmailDOTC0M> wrote in message news:iQ72h.553254$Pi2.240974@fe08.news.easynews.com... > Hi all, > > I'm not sure if this behavio...

Workflow question: Upon opening a new case notify team
I am trying to configure CRM so that it will notify a team (all team members) when a case is opened. How would I accomplish this? I have created a team, called tech support, added members, and was setting up a workflow rule when I noticed that you can set up notifications only to users, not teams. This just doesn't seem right. Oh yeah, I also created a new email template. Same thing, 1 owner.... What am I missing? David M Afraid there is no easy way to do this. You could use a Post-URL action to send the message and it could expand out the team members. Also note that you can&#...

one workbook, multiple users....
I plan to create a single workbook which multiple users will add their data into. It is possible that two or more users might attempt to add data simultaneously, but this might not always occur since only 16 people will have access to the workbook. Most users will probably close the multi-user workbook when they are finished....some users might also keep that workbook open once they are finished saving the file. My question is, are there any pitfalls or facts or valuable information that I should be aware of before I create this multi-user workbook?? For example, do I need to ...

MSExchangeFBPublish on new Exchange 2003 server
I've recently added an Exchange 2003 Enterprise server to an Exchange 5.5 organization (we are following the standard migration path). I have ADC recipient and public folder connection agreements (two-way). In the event viewer on the Exchange 2003 server, I'm seeing the following approximately every 25 minutes: Source: MSExchangeFBPublish Event ID: 8197 Description: Error initializing session for virtual machine <myservername>. The error number is 0x80040111. Make sure Microsoft Exchange Store is running. Do you have a replica of the free-busy system folder on your...

Export / Import Security
Ok, so I have setup my test environment again. Now I have to create security all over from scratch to define what will be used in production. Is there a way to export from the test environment and then import it into the newly upgraded installation? In both cases security has been/will be completely removed from the 8.0 install (restored on new server) before being upgraded to version 10. Dear, Security will be upgraded upon upgrading GP from GP 8.0 SP5 to GP 10.0. Converting the Security structure from GP 8.0 to 10.0 will not be an easy task. Regards, -- Mohammad R. Daoud MCP, MCBM...

Updating Global Address List
Our global address book needs to have many users updated due to phone number/address changes etc. and my help desk person is bugging me to allow some secretary access to do the updates. I do not know of any secure way to allow someone to do these updates. Can anyone point me in the right direction or am I right to tell the lazy brat it's his job. On Fri, 4 Feb 2005 07:19:02 -0800, "Maive72" <Maive72@discussions.microsoft.com> wrote: >Our global address book needs to have many users updated due to phone >number/address changes etc. and my help desk person is b...

Black Screen After Log In for One User but Other User Is Normal!
I am seriously computer illiterate and would be grateful for any help. My Sony Vaio laptop has Windows Vista Home Premium. I have two users set-up, user K (with Administrator rights I believe and a password) and user N. If I login as user K, after I enter my password my computer will run for a bit (I can see/hear it logging in) but after a few minutes the screen goes black except for my white cursor and nothing else happens. If I then hit ctrl-alt-del I can see the Task Manager and switch users to user N which will start up normally and give me access to my desktop. My hardrive ...

distribution list #29
i have a list of email contacts in an excel spreadsheet . Is there a way to convert them easily to a distribution list in Outlook 2000, without copy/paste each contact indiviudally ? thanks in advance , carolyn http://www.outlook-tips.net/archives/2004/20041105.htm if the addresses are in a column, you should just need to copy the column and paste it. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://w...

Exporting Sent Email Addresses from Entourage
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC Hello! I'm trying to export email addresses from an employee's Entourage, but would like to include email addresses in his "Sent Items" folder. Is there a way to export these email addresses aside from exporting the "MBOX" file, which has all the email content as well? Thanks in advance! On 3/12/08 8:49 AM, in article ee9381d.-1@webcrossing.caR9absDaxw, "Quinlisk@officeformac.com" <Quinlisk@officeformac.com> wrote: > I'm trying to export email addresses from an emplo...

Increase years by one formula
Hello all! I need help with a formula... I have a date (1/1/04 but displayed as Jan-04) in cell E4. I would like to have a formula that looks at E4 and returns the sam date but increase the year by one 1. Every formula I have trie doesn't work or increases the month by one. Any help would b appreciated! Cind -- Message posted from http://www.ExcelForum.com I'm sure there's a better way, but one way is: =E4+366 >-----Original Message----- >Hello all! > >I need help with a formula... > >I have a date (1/1/04 but displayed as Jan-04) in cell E4. >I wo...

Quickly moving down one row on pasted data from another worksheet.
Ok, this should be fairly simple but I'm a excel novice. I have two worksheets. One contains all data with each row representing a different store. I then have another worksheet that is a form. I need to fill out a form for each store. The information maps the same every time, just one row down. It looks like this... WORKSHEET1 A B C D E 1 A1 B1 C1 D1 E1 2 A2 B2 C2 D2 E2 WORKSHEET2 Name: =Worksheet1!A1 Company: Worksheet1!B1 Parts: Worksheet1!...

One money file, 2 computers
I am new to money. I want to be able to access money both from work and at home. To facilitate this, I have a portable Hard Drive. I installed money to it at home, installed money to it at work (stoopid registry) pointed both instances to a single money file. Now, when I run it at home, everything is fine. When I run it at work I get a critical file is missing error. I reinstall at work and everything is fine again. I go home and voila! A critical file is missing error! <grrr /> How do I skin this cat? Is there a better way of doing this? I won't be purchasing money un...

Banging my head against the wall
Hi, I need some clarification of if a control exists that will fit into m solution. What I need to do is display a list of data horizontally in a control. The data, is a question which can be 50 to 100 characters long and the need to see the whole text of the question. Preferably there would be 1 row of data and the questions would go int the columns with a scroll bar to move along. Thus far I have tried - A listbox - can't seem to toggle the height of the row so all of th question text can be displayed in one go. Listview - Same as above Spreadsheet 9.0 Control - Thought I had ...

new book saving & gridline colours
When I open Excel, a new workbook appears called "Book1.xls". On my home computer, I can go on to close Excel down without it asking me to save Book1. However, in my work computer, it asks whether I want to save changes to Book1. Both are Excel 2002. Is there a setting I need to change in work? Also, I was wondering if it were possible to change the gridline colours for all workbooks to a certain colour, or at least to any 'new' workbooks without having to go to Tools>Options each time. Second point. Open a new workbook, goto Tools>Options and set the gridlines col...

Export item ID?
Hi there. Having resolved my previous EMS Data import issues, I have now moved on to more complicated things (importing supplier lists, aliases etc). However, these operations require the item ID for each item - something I don't have. Is there some way I can export these from the database so I know what item ID corresponds to each item. I have run a query in Administrator (select itemlookupcode, ID from item) which tells me this, but I haven't worked out how to export this out to a spreadsheet. Any help would be appreciated, cheers After running your query goto File menu and Export....

need help with list box?
Hi I have a huge table of about 20000 records. how can I restrict entry for a few columns. I am new to excel programming. For example. I have a list of colors (red, green, blue) that I want to go under the Color column. how can I allow the user to click on a pulldown or list box similar to ms access for each cell. thanks in advance. Hi you could use 'Data - Validation'. See: http://www.contextures.com/xlDataVal01.html >-----Original Message----- >Hi > >I have a huge table of about 20000 records. how can I restrict entry for a >few columns. >I am new to exc...

Chart values do not update links to new worksheet
I have two worksheets, one with data and one with charts that plots the data, i.e. Charts and Data. I want to do a relative copy of both sheets so that all the links in Charts (2) update to the new Data (2). This is what I have do, Select both Sheets using <cntrl, right click> Right click on tab area, select 'move copy' Check copy, create copy This creates new sheets with xxxxx (2) as the name. The cell formulas all update to the new Data (2) worksheet as expected. But the charts in Charts (2) still reference the original Data worksheet. Is there a way to have the charts...

List views
I have a list view in which I have selected grid lines in report mode. The grid lines show ok until I scroll down and then the horizontal line fall out of step colliding with the text. Does anyone know what is happening here and how to fix it? >I have a list view in which I have selected grid lines in report mode. The >grid lines show ok until I scroll down and then the horizontal line fall out >of step colliding with the text. > >Does anyone know what is happening here and how to fix it? Sadly, the fix is to switch off the grid lines :( PSS ID Number: 813791 "B...

Exporting email in Outlook Express
I am unable to export all emails in Outlook Express. First it had an error message mentioning MAPI so i followed the instructions on Microsoft Knowledge Base to install Windows Messaging - now when i try to export the following error message is: MAPISP32 caused an invalid page fault in module KERNEL32.DLL at 0187:bff7b9a6. Does anyone know what this means? tania jackson <tania@realtime-bs.com> wrote: > I am unable to export all emails in Outlook Express. Ask in an Outlook Express newsgroup. -- Brian Tillman Smiths Aerospace 3290 Patterson Ave. SE, MS 1B3 Grand Rapid...

Exporting to Powerpoint
I have a small table in Excel that I am trying to export to PowerPoint, for some inexplicable reason one column was always missing even though it was specified in the range which the Macro is supposed to export. My manager is the only was able to see the value in that column and no other can replicate his success. Do you know any reason for this? We are all looking at the exact same file, why could he see something that the rest of us cannot? Tao, Why don't you simply copy and paste the whole table into a Powerpoin slide? Joh -- Message posted from http://www.ExcelForum.com...

POP Receipt Edit List with Lot Numbers & Attributes
Hi Folks Has anyone successfully managed to edit the POP Receivings edit list to include the Lot Number and the Lot Attributes? If so, could you advise me how you created the table links please? I am on version 10 Many thanks Sheila Sheila, Due to the Temp Tables looks very difficult. I would consider using another method like SQL Reports to get the Lot Information. Mick "Sheila" wrote: > Hi Folks > Has anyone successfully managed to edit the POP Receivings edit list to > include the Lot Number and the Lot Attributes? If so, could you advise me > how you...