tutorial4

tutorial4 - ACL Tutorial 4 COMMANDS: ANALYZE -> AGE DATA...

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

View Full Document Right Arrow Icon
ACL Tutorial 4 COMMANDS: ANALYZE -> AGE DATA -> JOIN DATA -> MERGE AR 1. The Aging of Accounts Receivable is a frequently used audit technique that is supported by the AGE command in ACL: a. Using AGE , develop an aging report of current, 30, 60, 90, 120, and above 120 days late using the AR file. Cutoff date is August 31, 2000. b. Use filter to set up an aging where transactions are Invoice type [IN] and cutoff date is December 31, 2000 using the DUE date versus Date of invoice. EMPMAST 2. The JOIN command will combine the fields of two files with different structures to produce a third file. In ACL, this task requires one file to be designated the PRIMARY file and the other the SECONDARY file. If you JOIN a transaction file with a master file, the transaction file would be the PRIMARY file and the master file would be the SECONDARY file. You obtain a different result if the files are reversed. The PRIMARY file is the first file to be opened, and the SECONDARY file is the second file opened. You
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.

Page1 / 2

tutorial4 - ACL Tutorial 4 COMMANDS: ANALYZE -> AGE DATA...

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