Card Set Information
This card set will help prep for the CIDA exam
How do you import a .asc file?
Text in the import assistant will be used to import the .asc file (ASCII)
How do you import a .sap file?
SAP AIS in the import assistant will the used to import the .sap (SAPAIS) file
How do you import an HTML file?
Convert the HTML file to a PDF through MS Word and use the Report Reader
How do you check for negative cash balances?
Equations are saved with what file extension?
What is a .jpm file?
.jpm is an import definition template for Print or Adobe PDF files.
How do you find a particular record number in IDEA?
What are the categories on the Analysis tab?
Extract, Relate, and Explore
What categories are on the DATA tab?
Order, Fields, Search
What categories are on the SmartAnalyzer tab?
Apps, Data Preparation, Audit Tests
What function can be used to identify missing or blank address fields in a vendor master file?
What is duplicate key exclusion?
It allows the user to capture matching fields across rows where one independent field is different.
Which function do you use to identify payments made on Sundays or public holidays?
Which operator will you apply through the equation editor to capture round sum values?
How would you identify employee payments with zero deductions?
How do you capture the top 5 debit cash expenditures in each general ledger account?
Top records extraction with Grouping on general ledger account.
How do you identify blank payee names in a vendor payment file?
How do you filter out cases where posted by and approved by users are similar
Direct Extraction with criteria posted by = approved by