Question: . Write a script that declares and sets a variable (data type is money) thats equal to the total outstanding balance due. If that balance

. Write a script that declares and sets a variable (data type is money) thats equal to the total outstanding balance due.

If that balance due is > $10,000.00, the script should return a result set consisting of VendorName, InvoiceNumber, InvoiceDueDate, and Balance for each invoice with a balance due, sorted with the oldest due date first.

If the total outstanding balance due is < $10,000.00, the script should return the message Balance due is less than $10,000.00.

Balance : InvoiceTotal - CreditTotal - PaymentTotal

Outstanding balance due : InvoiceTotal - CreditTotal - PaymentTotal > 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!