Refer to Figure 2-30 and the discussion about updating master files from transaction files. The discussion presents the record structures for a sales transaction. Prepare a diagram (similar to Figure 2-30) that presents the record structures for the receipt of cash from customers who are paying their outstanding accounts receivable. Assume a cash receipts file exists, which contains the transaction records to be processed. Show the subsidiary and general ledger files. Explain each step in the update process

 

Transcribed Image Text:

FIGURE 2-30 RECORD STRUCTURES FOR SALES, INVENTORY, AND ACCOUNTS RECEIVABLE FILES Record Structure for Sales Orders Transaction File (PK) (SK) (SK) Sales Order Number Account Inventory Quantity Number Unit Price Invoice Amount Number Sold (PK) Record Structure for AR Master File Last Account Number Address Current Balance Credit Limit Billing Date Name Payment Ďate (РК) Record Structure for Inventory Master File Inventory Number Quantity on Hand Reorder Vendor Number Standard Description Total Cost EOQ Point Cost FIGURE 2-30 RECORD STRUCTURES FOR SALES, INVENTORY, AND ACCOUNTS RECEIVABLE FILES Record Structure for Sales Orders Transaction File (PK) (SK) (SK) Sales Order Number Account Inventory Quantity Number Unit Price Invoice Amount Number Sold (PK) Record Structure for AR Master File Last Account Number Address Current Balance Credit Limit Billing Date Name Payment Ďate (РК) Record Structure for Inventory Master File Inventory Number Quantity on Hand Reorder Vendor Number Standard Description Total Cost EOQ Point Cost