Export pre-built inquiries Excel
Inquiring minds want to know!
Meaningful information, at your fingertips – is a common expectation for today’s business software. Sage 300 Construction and Real Estate does this well with an abundance of pre-built inquiries. Inquiries provide instant access to information for users at all levels. From AP/AR personnel to operations and project managers, even company owners will benefit from this data. And did you know you can easily export pre-built inquiries to Exel from Sage 300 CRE?
In as much as inquiries are windows into your Sage 300 data, most have views that show summarized totals as well as nuts-and-bolts details. They also serve as a handy tool to print mini-reports. Not to mention the contents of inquiries export beautifully to Excel at the touch of a button!
Best use of the ‘Information Assistant’ module
Inquiries are available in the individual Sage 300 applications, but users can get the information they need all in one location with the use of Information Assistant (Sage security settings control user access). Some of the answers available quickly include:
- Amounts invoiced and paid for vendors, customers, contracts, and jobs.
- Overall job performance, with drill-down into cost-estimate variances and transaction details.
- Project Management document log and change management information.
- General ledger balances and transaction details.
- And so much more!
Inquiries are flexible
To get exactly the information you need, click on a column header to select an option to edit the column contents, insert a column before or after the column, or delete the column altogether. Resize the columns by clicking on and dragging the vertical lines between them. Use conditions to limit the data presented in an inquiry. And if you find that you are constantly customizing the same inquiries every time you use them, you can permanently save the view that gives you the best information if Inquiry Designer is part of your Sage 300 software suite.
More exporting help
Learn more about exporting reports to Excel here.
by Kyle Zeigler, Sage Certified Senior Consultant