Analyzing reports in excel

Question

Trying to download reports in excel so that i can better sort the data. But whenever i do, the collumns etc nevr are done properly. Anyone know how to fix?

anne@medallionathletics.com · Answer

Try doing using the inquiry option in Job Cost and choose All Entries. Exporting Inquiries to excel are much better to work with in excel than exporting reports. I use this to sort and filer by cost codes, jobs, transaction types, vendors, PO's or any other field that is available by adding columns. Once you start using this option there is another add on module, Inquiry Designer, that will save the formats.

ghollister · Answer

If you are talking about getting the information directly from the database into Excel, you may be able to use an ODBC connection to do that (Sage does not offer support on setting that up). There is also an integration solution called Sage Intelligence Reporting that will output data directly into Excel

Sage Construction & Real Estate

Analyzing reports in excel

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING