Question

Assuming that all the table and column names are spelled correctly, what's wrong with the INSERT statement that follows?
INSERT INTO InvoiceCopy
(VendorID, InvoiceNumber, InvoiceTotal, PaymentTotal, CreditTotal,
TermsID, InvoiceDate, InvoiceDueDate)
VALUES
(97, '456789', 8344.50, 0, 0, 1, '2006-08-01')

Answer 1

Answer:

(VendorID = 97

InvoiceNumber = 456789

InvoiceTotal = 8344.50

PaymentTotal = 0

CreditTotal = 0

TermsID = 1

InvoiceDate = 2006-08-01

InvoiceDueDate = ?

You cannot have PaymentTotal = 0. The sales value was $8,344.50, and since the sales was paid with cash (no invoice due date), the payment should record the same amount as the invoice.

InvoiceTotal = PaymentTotal + CreditTotal, since you were paid with cash or you gave credit to the client.