Accounting Software 411 View Cart | Login / Register
Jonas Construction Buyer Guide Banner

Sponsor Message
Jonas Construction Buyer Guide Sky

Reply to an existing message
The message you are replying to: Exporting Trial Balance from Great Plains to Excel

AS411 Community Home » Software Directory » Microsoft Dynamics GP (formerly Great Plains) by Microsoft Business Solutions » Exporting Trial Balance from Great Plains to Excel


tlally wrote the following post on 2/12/2005 7:01:00 AM

There are three ways you can export your trial balance from Great Plains. First you can use the report writer to create a properly formatted report and print the report to an ASCII file. Second you can create a ODBC connection in Excell and grab the records from GL20000 and GL00101 to read in the transactions by date. GL20000 maintains the current year transactions and GL00101 maintains the account numbers and descriptions. Third you can create a view in explorer and export it to Excell. However this only works in version 5.5 and 6.0 of Great Plains and does not work very well if you have a lot of transactions. For more help contact KTL Solutions, Inc. at 301-360-0001 or KTL Solutions, Inc. is a leader in Great Plains consulting and software development. Tim Lally

Email: *  

Subject: *  
Post Emoticon:


Email Notification Options:

Enter the code shown above:

(Note: If you cannot read the numbers in the above
image, reload the page to generate a new one.)

Company Info | Privacy Policy | Terms of Service | Advertise With Us | List Your Company | Contact Us | Help |
Copyright © 2006-20011 Accounting Software 411, LLC. All rights reserved.