187x Filetype DOC File size 0.04 MB Source: www.cpp.edu
CH 6: SALES/COLLECTION CYCLE BUILT AROUND THREE MASTER OR QUASI MASTER FILES 1. CUSTOMER (ACCOUNTS RECEIVABLE) MASTER FILE .each record corresponds to one customer .account balance, biographical data, credit info .ordered on customer number 2. OPEN SALES ORDER FILE .records of all unfilled orders .hard copy back-up copies of sales order documents .record is written when the order is taken and remains open until shipped or services provided .primary retrieval key is sales order number 3. OPEN SALES INVOICE FILE (BILLING FILE) .all invoices that are outstanding, not yet paid in full .copies of paper invoices hard copy back up 1 .record is added when the invoice is issued and remains open until final payment is received .ordered on invoice number SUPPORTING TRANSACTION FILES 1. SHIPMENT TRANSACTION FILE .accumulates sales or shipment transactions for posting to the open sales order file, the open invoice file, and the customer master file 2. CASH RECEIPTS TRANSACTION FILE .considerable redundancy with sales transaction file, the open sales order file, the open invoice file .eliminated by data base structure 3. GENERAL LEDGER TRANSACTION FILE BACKUP FILES 1. SALES HISTORY FILE 2 REFERENCE FILES 1. PRICING REFERENCE FILE 2. SHIPPING/CARRIER REFERENCE FILE INPUT DOCUMENTS 1. CUSTOMER PURCHASE ORDER .output document for the purchasing cycle 2. SALES ORDER .initiate sales transactions calling for future shipment of goods or services .prenumbered if paper .multiple copies, 1 to accounting, 1 to shipping .if using EDI , in machine readable form when received 3. RETURN TICKETS AND ALLOWANCE CLAIMS .sales returns relate to return of goods .allowances to customers who keep the goods but believe their value has been impaired .source documents for management review and later processing 4. REMITTANCE ADVICES 3 .provided to customers to accompany payments .provide source documents for recording receipt of cash and credit to customer's accounts OUTPUT DOCUMENTS 1. ACKNOWLEDGEMENT .used when delay in providing services or shipment .notifies the customer as to when to expect shipment 2. PICKING TICKET .used to help locate and retrieve goods from the stockroom or warehouse .prepared from info on sales orders (input document) 3. SHIPPING DOCUMENT .packing slips .accompany goods shipped to customers .omit price data .variance between quantity ordered and shipped identified 4
no reviews yet
Please Login to review.