Learn the basics of row and column formats, review the use of trees and integrate external financial data into financial statements. Basic SQL Syntax Develop skills in creating and utilizing simple and complex SQL statements. Database Structures Review the Elite database table structure and relationships. This information is extremely useful in the creation of reports, utilizing such products as IQ Objects and Crystal Reports as well as analyzing data from such products as Excel. Understand the importance of error logs, review the architecture of Elite for Windows and learn valuable troubleshooting techniques.
Templates Eliminate the mystery behind templates.
Classes on these various template disciplines will show how to create new templates or modify existing ones. A multi-company infrastructure is ideal for firms that need to maintain multiple sets of books with respective retained earnings accounts for each company. Produce separate sets of financial statements for each company, track revenue by company and report on revenue attributed to one company from resources outside that company. Our consultants guide users through masking changes or adding ledger and cost codes based on various changes in a firm s operation, such as the acquisition of an overseas office. The Elite Consulting team can assist with the redesign of a firm s chart of accounts or a change from cash basis accounting to cash and accrual, for example.