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 Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

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