Problem 19-01

Please download the Roger Company IDEA files, if you haven't already. See instructions for obtaining the Roger Company files in the Chapter 5 assignment.

A policy that is in effect at Roger Company is that cash disbursements should only be made to vendors with an approved vendor number. In some cases, a vendor number is not available but the vendor is still valid. With the Roger Company Cash_Disbursements file open, on the Analysis tab, in the Relate group, select Join to open the Join Databases window to determine which cash disbursements have an authorized vendor number and which ones do not (see IDEA Tutorial Section 4 for further assistance; also see instructions for Chapter 5 Problem 3). To make it easier for you to scan the database for valid vendor numbers you may also want to use the criteria function. How many cash disbursements do not have a valid vendor number? Comment on the results.

New number of cash disbursements without a valid vendor number?