Lab6_Ex4 - Comments Accounts Receivable Model This model...

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

View Full Document Right Arrow Icon
Comments Page 1 Peter Cribb 123456789 Accounts Receivable Model This model records the customers of a company in the Customers worksheet along with the discount the customer would receive if they pay their account within a certain number of days after the due date of the account. The worksheet also contains the number of days after which the account is considered late for each customer and the  late fee applied if the account is paid late. The Invoices worksheet contains the actual amounts owing from any particular transaction with a customer and the status of that particular invoice (is it within the discount period, the normal period, or is it late) and the discount or late fee owing. If and lookup functions are used to calculate the status of the invoice and the discount or late fee.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Customers Page 2 Peter Cribb 123456789 Cust_No Discount Days Due C_002 ABC Inc
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/13/2012 for the course CSE 1520 taught by Professor Kemeny during the Fall '08 term at York University.

Page1 / 3

Lab6_Ex4 - Comments Accounts Receivable Model This model...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online