Customers may make payment to cover one or multiple invoices. Add additional tables in the database to show customer payments. You want to record the following information: cash receipt number, date of receipt, total amount received and amount applied to a specific invoice.
Record the following information in the new table(s): On Oct 31 received $2,300 payment from D Ainge (receipt#1031001). $898 of the payment applies for invoices 103 and the rest applies for 101.Design the query to show the customer name, invoice amount,invoice date, payment date, payment amount of invoice 101.
Customer
Inventory
Sales
Sales Invoice
Recently Asked Questions
- Which THREE of the following statements about CIMA are true? A. CIMA was established over 90 years ago B. CIMA members may only work in the UK C. CIMA members
- Which of the following words complete the statement below? ____________ accounts are prepared for external stakeholders. Management accounts are prepared for
- In the following table the activities with their precedence sequence and expected time (days) are listed for a project on which CarlBetterton's