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
Get step-by-step solutions from verified subject matter experts
