tutorial5

tutorial5 - ACL Tutorial 5 COMMANDS: CONTROL TOTALS: TOTAL...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ACL Tutorial 5 COMMANDS: CONTROL TOTALS: TOTAL ANALYZE -> COUNT ANALYZE -> TOTAL DATA -> EXTRACT DATA -> EXPORT DATA -> SORT DATA -> INDEX INVENTORY 1. Audit OBJECTIVE : Reconcile inventory amounts with physical inventory counts. Create a filter to select specific records with a location value 05. Prepare control totals by using the TOTAL command. Extract these records into a new input file called Inventory _ 05. Recalculate the control totals on the new input file and compare them to the original control totals. a. What types of control totals would be useful in this situation? b. What are your control totals values? c. Use EXTRACT to export the specific records to a new input file Inventory_05 and print the command log for this operation. d. Confirm Control Totals in the new file. Why perform this step? AR 2. Audit OBJECTIVE : Confirm accounts receivable amounts with customers. EXTRACT transactions in the AR file that have a due date prior to January 2, 2000. Create a new input file called AR_02.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/04/2011 for the course ACCT 5230 taught by Professor Szendi during the Spring '10 term at Kean.

Page1 / 2

tutorial5 - ACL Tutorial 5 COMMANDS: CONTROL TOTALS: TOTAL...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online