import chart of acount

I use GP7.5 I export chart of account to excel sheet and modify but i don't 
know how i can import agine to new company please is there any way to make 
it this.

thanks for help

M.Own 


0
5/9/2006 1:52:51 PM
greatplains 29623 articles. 6 followers. Follow

3 Replies
501 Views

Similar Articles

[PageSpeed] 10

If you have Integration Manager, then you would find it to be the easiest 
tool to use. If you do not have it, then the data can be loaded using SQL 
Server tools and other products that work with SQL Server. However, if you 
are not familiar with these tools, you should get help from somebody who 
does. 
-- 
Charles Allen, MVP



"M.Own" wrote:

> I use GP7.5 I export chart of account to excel sheet and modify but i don't 
> know how i can import agine to new company please is there any way to make 
> it this.
> 
> thanks for help
> 
> M.Own 
> 
> 
> 
0
callen (2505)
5/9/2006 2:23:02 PM
Thank you, how i can get these Integration Manager no body can send this for 
me?

Thank for your help Mr.Charles


"Charles Allen" <callen@nospam-bkd.com> wrote in message 
news:53B00006-84A2-4658-B196-F7B78FF696CF@microsoft.com...
> If you have Integration Manager, then you would find it to be the easiest
> tool to use. If you do not have it, then the data can be loaded using SQL
> Server tools and other products that work with SQL Server. However, if you
> are not familiar with these tools, you should get help from somebody who
> does.
> -- 
> Charles Allen, MVP
>
>
>
> "M.Own" wrote:
>
>> I use GP7.5 I export chart of account to excel sheet and modify but i 
>> don't
>> know how i can import agine to new company please is there any way to 
>> make
>> it this.
>>
>> thanks for help
>>
>> M.Own
>>
>>
>> 


0
5/9/2006 5:04:11 PM
You would need to purchase it through a GP partner. 
-- 
Charles Allen, MVP



"M.Own" wrote:

> Thank you, how i can get these Integration Manager no body can send this for 
> me?
> 
> Thank for your help Mr.Charles
> 
> 
> "Charles Allen" <callen@nospam-bkd.com> wrote in message 
> news:53B00006-84A2-4658-B196-F7B78FF696CF@microsoft.com...
> > If you have Integration Manager, then you would find it to be the easiest
> > tool to use. If you do not have it, then the data can be loaded using SQL
> > Server tools and other products that work with SQL Server. However, if you
> > are not familiar with these tools, you should get help from somebody who
> > does.
> > -- 
> > Charles Allen, MVP
> >
> >
> >
> > "M.Own" wrote:
> >
> >> I use GP7.5 I export chart of account to excel sheet and modify but i 
> >> don't
> >> know how i can import agine to new company please is there any way to 
> >> make
> >> it this.
> >>
> >> thanks for help
> >>
> >> M.Own
> >>
> >>
> >> 
> 
> 
> 
0
callen (2505)
5/11/2006 3:58:01 AM
Reply:

Similar Artilces:

Excel 2000
Is there a limit to the number of slices in an Excel 2000 pie chart. I can only get (9) to work using the wizard. As soon as I add (10) the last one gives an error readin and it sits there incomplete. Hi, There are limits but it's not 10. What data do you have in those 10 cells? Cheers Andy Bob wrote: > Is there a limit to the number of slices in an Excel 2000 pie chart. I can > only get (9) to work using the wizard. As soon as I add (10) the last one > gives an error readin and it sits there incomplete. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info I a...

selective import data from SO to HQ
Can i selectively import data(customer, cashier, etc.) from SO to HQ and export it out to other new stores? Thanks. - The customer data is brought to HQ automatically through Worksheet 401. So answer is NO you cannot be selective about this. - Cashiers are not global setting [unless you use RR HQ Misc that allows you to have global cashier and send messages from to store]. Afshin Alikhani - [afshin@retailrealm.co.uk] CEO - Retail Realm -- URL http://www.retailrealm.co.uk "JayK" wrote: > Can i selectively import data(customer, cashier, etc.) from SO to HQ and > expo...

Import from Outlook Express #2
As I switch from Outlook Express to Outlook how can I import my e-mails without losing the original received dates? In OE - go to File-Export. "Richard" <anonymous@discussions.microsoft.com> wrote in message news:18e801c3a8a6$4ea68800$a601280a@phx.gbl... > As I switch from Outlook Express to Outlook how can I > import my e-mails without losing the original received > dates? ...

can msn email msgs be imported to outlook? thanks
can msn email msgs be imported to outlook? thanks This is a multi-part message in MIME format. ------=_NextPart_000_003D_01C6E208.943A9200 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: quoted-printable There was a feature but I don't believe future versions of Outlook will = support it. I would transition to a pop or imap account as your mail = email. There are services that will retrieve your MSN mail and redirect = it to your other email account. =20 e-Commerce unveiled The e-book http://www.projectthunder.com http://blog.projectthunder.com "r...

Changing chart background color in Excel 97 SR 2
I am fairly new to this so please bear with me. I have a chart based on numbers in a spread that has a grey background (The chart) but I would like the background to be white and can not get it to change. I right clicked on the chart and went to Format Chart Area, Patterns, Fill Effects, Patterns and changed the background to white but the ok button is greyed out. Am using Excel (Office) 97 SR 2 TIA http://members.aol.com/larrystark/ Right click (or double click) on the gray region, which is the Plot Area. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tut...

Combo Boxes in Charts
I have created a chart which includes a combo box which refers to a list of names. The problem is that the font size is too small - size 10 - and I would like to make it bigger. Have tried changing the font size of the data range for the combo box but this has no effect. The properties of the combo box let me change its size but not the font size of the list of items. Any suggestions. Thanks Shirley Munro -- Shirley Munro ------------------------------------------------------------------------ Shirley Munro's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=83...

Background picture behind chart
In Excel I have successfully inserted a picture behind an interactive chart so the chart (graph) is visible overtop of the picture. But when I Save as Web Page the picture doesn't show up. The graph is fine, and is interactive, but the background picture file (gif) has disappeared. How can I preserve the picture so it will save as part of the Web Page? Thanks. Ralph Hi, Not tested but could you use the picture as the Fill Special for the chart or plot area? Cheers Andy RalphB wrote: > In Excel I have successfully inserted a picture behind an interactive chart > so the...

Automate text import
Hi, I've wrtten a batch file to audit all our servers, what I'd now like to do though is come up with a way excel can load these text files into one worksheet. Can anyone please help? Below is an example of the data gathered - the text files are named after the computer. Thanks Ben Computername: TEST Kernel version: Microsoft Windows 2000, Uniprocessor Free Product type: Professional Service pack: 3 IE version: 5.0100 System root: C:\WINNT Processors: 1 Processor speed...

importing data from the query wizard
i have tried to import the data using the query wizard but all i get is SYNTAX ERROR in FROM CLAUSE. Im not doing this using visual basic so i have no idea how to correct this error. Can anyone help please? ...

Can I import a calendar from a palm os to outlook?
"kyle" <kyle@discussions.microsoft.com> wrote in message news:D9E20640-188D-4355-A3D6-28C3E586A28C@microsoft.com... > Hi - When you post in here, always include your version, SP level, and mode (if applicable) of Outlook - you can find this information in Help | About. Also include the type of mail account(s) you use and any other pertinent details. Be sure to put a consise summary of your question in the subject line, and the full details in the body of your post. That said, your best bet is just to sync your Palm to Outlook directly. If your Palm CD didn't...

All formatting not saving in Chart Template 04-07-10
Hi, sorry if this has been answered. I am new to Chart templates. I created a pivot chart and saved it as a template. When I bring it back up again, not all of the formatting is saved. For example, the title is just "Title" and I had data values being shown and they are not, and also the colors of the columns are not the same. Is there any way to save all of these as part of a template? thanks, Varvara ...

Import data from FileMaker
I have a School Suspension file that is in FilemakerPro. It works very well. I want to automate a monthly report for our business office and want to be able to import data from the db into Excel. On Mac's I can do so quite nicely, simply Open Excel, then Open the FMPro db which launches a wizard and all is done in a few key strokes. Obviously I'm not as adept in XP. Using Excel 2003 and FileMaker Pro 6.ov4 how can I accomplish this task? I don't speak FileMakerPro, so you can try this or wait for a real response! Open excel. File|Open Look at all the fileformats that excel ...

Legend in charts
how do i change the legends in multiple charts to read the same thing? Hi, In what way? The legend reflects what is in each chart, so if your charts are different, so will your legends be. Or are you referring to the formatting? Dave "queenie" wrote: > how do i change the legends in multiple charts to read the same thing? ...

Auto Scaling Charts
I am trying (in Vain) to auto scale bar charts in excel. I have attempted a macro in VB to do this, but it just seems to do nothing, does not fail or succeeds. If anyone could take a look at the macro below and assist in where it is going wrong would be much appreciated. Thanks Sub AutoScaleCharts() Dim ws As Worksheet Dim cht As ChartObject Dim ValuesArray(), SeriesValues As Variant Dim Ctr As Integer, TotCtr As Integer For Each ws In ThisWorkbook.Worksheets For Each cht In ws.ChartObjects For Each X In cht.Chart.SeriesCollection SeriesValues = X.Values ...

Trying To Add a Line to an Excel chart using variable cell values
I'm using an XY Scatter chart and I want to draw a straight line between 2 points which passes through a 3rd point on the chart. The line represents the Security Market Line (relating risk and return) with Standard Deviation on the X axis and Portfolio Return Percentage on the Y axis. One point is the 3 Month TBill. The point that the line is passing through is an index point (e.g. S&P 500) and the 3rd point will be one that is calculated based on the slope of relationship between the TBill point and the index point. The 3rd point needs to be plotted on either the top or bott...

How to print 15 embeded charts on two sheets at once?
Hello specialists! How to print 15 embedded charts (without data cells) on two sheets at once? Best regards, Dima kopnichevdi@lukoil.comDelete You don't want data cells. Does that mean you want each chart printed on its own page? This cannot be done without a macro. Do you instead want just the portion of the worksheet with the charts to be printed, but not the portion of the sheet with the data? Select the range containing the charts, and set the print area (File menu > Print Area > Set Print Area. Repeat for the other worksheet, then select both (click on one, ctrl+click on...

Autoscaling on XY chart
Hi, Is VBA the only solution to autoscale axis in an XY plot...? I would like to set the min and max for my x-axis as my data changes. (I know how to do it through VBA). Or is there any other short-cut? -- - Mangesh ------------------------------------------ Office 2003 & Windows XP Hi, Unfortunately you can not link the min/max of the scale to cells directly. I think VBA is the only approach to dynamic updating of those properties. Cheers Andy Mangesh Yadav wrote: > Hi, > > Is VBA the only solution to autoscale axis in an XY plot...? I would like to > set the min ...

i can't see a chart i made, all i get is blue worksheet
when i make a chart, it will appear in worksheet with original data. when i move to its own chart worksheet, all I get is a blue window. What am i doing wrong? Are you selecting the chart and then moving it choosing the command Chart, Location...? -- Thanks, Shane Devenshire "drwink" wrote: > when i make a chart, it will appear in worksheet with original data. when i > move to its own chart worksheet, all I get is a blue window. What am i doing > wrong? ...

Badly need help to put four categories in one pie chart
The problem is getting the 4 groups on the same Pie Graph I don't kno how to go about it. I am taking a correspondence course, the course is MEL4E-A Key questio 8 for anyone that maybe has did this course Here is the scenario- The Table below lists baseball team standings. Create a frequency tabl and a pie graph of the teams that have 80 or more wins, 70-79 wins 60-69 wins, and fewer than 60 wins. Wins Losses New York 83 53 Boston 79 58 Toronto 68 69 Baltimore 61 75 Tampa Bay 53 82 Chicago 73 64 Kansas City 70 65 Minnesota 71 66 Cleveland 62 76 Detroit 34 102 Oakland 82 55 Seatt...

Does VS2005 import XP icons properly?
I imported an XP icon into my project and assigned it IDR_MAINFRAME id. Unfortunately it looks like alpha blending is not working properly when the application runs. Specifically app's icon displayed on the app's title bar and on the task bar is ragged and not anti-alised on the edges. I've tried quite a few of icons with the same results. A good example would be "ICS Client.ico" found in VS2005ImageLibrary. Should XP (i.e. 32 bit) icons work with VS2005 and MFC apps? If yes, what is the proper procedure of importing them? Thanks, Bogdan You can use the ico...

Area Chart #2
I would like to know if it is possible to produce an area chart, where instead of the data being shown in an upwards format (column style ) it is shown in an acrosswards format (i.e. like an Exel bar chart). Thanks for your help. Hi, It's not a built-in style of chart. You could possible use Jon's code approach, Fill Left example. http://peltiertech.com/Excel/Charts/VBAdraw.html Another possibility is to use a bar chart but for each point in the series you need to plot multiple bars. Each of the extra bars needs it length calculated taking in to account the slope between each ...

Formatting Imported Data
Hi, I want to be able to read in a single column of data from either an Excel file or from a column of a word document and then produce the same column of data so that each entry has two cells separating them. So that the column 1 2 3 would look like 1 empty cell empty cell 2 empty cell empty cell 3 I there a straightforward way I can do this in Excel w/o having to use some type of additional program (like VBA)? TIA, Matt Nothing straightforward that I can see. Without some manual arranging which would be onerous, you will be better off to use a VBA macro. Sub InsertRows22() Appli...

Outlook 2003 Imported Emails Date Problem
I imported OE to Outlook 2003 last night, and now all my imported emails dates are scrwed up. Even though the properties on the emails show the correct dates, the "Recieved" sort on the main window shows a totally different date. IS there a way to fix this? ...

showing a break in bar chart
Can anyone tell me how to show a break in bar graph so that I can show small bars and large bars (truncated) on the same graph. Hi, Here are a couple of examples. http://peltiertech.com/Excel/Charts/BrokenYAxis.html http://www.andypope.info/charts/brokencolumn.htm Although I notice Jon provided these links to another post you made on the 19th Cheers Andy GK wrote: > Can anyone tell me how to show a break in bar graph so that I can show small > bars and large bars (truncated) on the same graph. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info ...

To Mr. Liengme: Re My previous Post Concerning My Bar Chart Problem
Hello again Mr. Liengme, I tried what you suggested, and it works just fine. But, I really don't understand what, exactly, I am doing when I do this cell deletion. And then "select that cell (B1) down to the last and across to C". a. Can you explain, please what I am accomplishing when I do this ? What happens or changes in the Formatting, or... ? b. Also, I thought I would be clever and formatted one column as text. This did not work. Why not ? Thanks again; really appreciate your time and help/ Bob ------------------------- Your x and y values are both num...