Chapter $4,$ Problem $13$DQP

$(0)$

Problem

The cash disbursements transaction file $($also used in question $12)$ is used to update the open vendor invoice file and the vendor master file in an accounting system that uses batch posting. In this problem, you are required to update the vendor master file by the payments made by Clark Service Industries $($CSI$).$ This requirement is presented in more detail in parts a through d$.$ CSI uses a batech posting process.

The following vendor master file shows the current balances owed to each vendor. This file is stored in order of vendor number. The total of the invoice amounts in the open invoice file in problem $12$ equals the total of the current balances owed to vendors.

a$.$ Sort the cash disbursements transaction file by vendor number. sorting the records in the same order as the records in the vendor master file speeds up the posting process. Illustrate this activity by creating a sorted cash disbursements transaction file. Because the vendor number is stored in file $1,$ only this part of the file needs to be sorted. However, in your solution, re$-$create file $2$ as it is so you will have the entire cash disbursements transaction file together and can use it for the next step in the posting process.

b$.$ The vendor master file is updated by posting the sorted cash disbursements file to the vendor master file. Illustrate this activity by using the data in the cash disbursements transaction file to change records in fire vendor master file.

c$.$ Under what circumstances would you purge records from fire vendor master file?

d$.$ Does the total amount still owed equal the difference between the total dollar amount of the current balances before posting, minus the total cash disbursements? Show your reconciliation of these amounts.