data mining using the yesco workbench. resource menu – commonly used area’s »ap invoices...
TRANSCRIPT
Data MiningUsing The YESCO Workbench
Resource Menu – Commonly Used Area’s
» AP Invoices» Billings» Customer
Sites» Customers» General
Ledger» Job Releases
» Jobs» Labor» Materials» Payments» Purchase Orders» Vendors» Employees
Column Commands – Advanced Filter
» Contains» Like» Equal To» Greater Than» Greater Than Or Equal To
» Less Than» Less Than Or Equal To» Between» In» Starts With» Ends With
- The Advance Filter Command allows you to filter the contents of the column being filtered.
Column Commands – Add Column
- The Add Column Command allows you to add a column to your query. These columns are made up of fields from Jobscope tables.
Column Commands – Remove Column
- The Remove Column Command allows you to delete a column from your query.
Column Commands – Column Settings
- ????????????
Favorite Views
- The Favorite Views Button allows you to save the query you have created so that you can easily retrieve it any time.
Sample Queries» Open type 8 Jobs that have had no
labor charges in 2009.» The amount of revenue we have
generated in the state of Pennsylvania in 2009.
» A list of employees that report to Rod Wardle, sorted by tenure.
» Vendors with whom we spent more than $1,000,000 in 2008 that are not offering us an early payment discount.
Questions?