General discussion

Exporting From Great Plains to Excel

At work I needed some information on my department's budget so I went to fiscal services where they printed me out a "Detailed Trial Balance" report from Great Plains. I then asked if I could possibly have that report in excel form so I could work with the data. I personally do not want to have to spend the time to enter it in AGAIN. I was told that Great Plains cannot export into excel. I kind of find this hard to believe. I was also told that "maybe we need an extra module for that and we don't have it" Anyone familiar with this software that can give me some insight? Sorry but I don't know the version.

Discussion is locked
Reply to: Exporting From Great Plains to Excel
PLEASE NOTE: Do not post advertisements, offensive materials, profanity, or personal attacks. Please remember to be considerate of other members. If you are new to the CNET Forums, please read our CNET Forums FAQ. All submitted content is subject to our Terms of Use.
Reporting: Exporting From Great Plains to Excel
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
- Collapse -
Re: export from Great Plains to Excel
- Collapse -
Don't ask for "excel form"

This is what I found:
Microsoft Business Solutions?Great Plains now known as "Microsoft Dynamics GP" is a full-featured business management solution that streamlines and automates financial, manufacturing, and supply chain management.

I think someone answered your question exactly (to be able to export to Excel form, IE .xls), without giving you a possible option. The option is to try and put the data out as a CSV (Comma Separated Value) format file. That is just the plain column and rows data (all formatting is lost).

- Collapse -
Using Excel with Great Plains

There are a number of products that connect Excel directly to Great Plains via a data management system. The products enable you to create dynamic spreadsheets that update both as the source data changes and also if you change any variables in the spreadsheet such as department codes or date ranges without impacting the report layout. Furthermore you can drill into specific cells in the spreadsheet to see the transactions making up the balance in the cells.

If you need more information please don't hesitate to contact me:

I hope this is of help.

CNET Forums