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.
Recently Asked Questions
- Use the figure below to answer the following question (s) . Figure 10-15 The economy 's short-run SRAS and long-run LRAS aggregate supply curves are shown in
- Refer to Table 9 - 1 . In order to maximize its profits , the firm should continue to produce in the short run even if the market price is less than its ATC as
- Which is an example of a market failure ?