Veltronics Supply Company Answer all questions below. An answer should include a step by step list of commands used and a description of the result.

Question 1: Create a view of vendors and the balance payable to each vendor at 3/31/2019. The list should include from left to right the account number, vendor name, and balance due. 

Commands Used:

Answer:

Question 2: Create a view of aged accounts payable. The list should include only the following aging categories: 0 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days. Hint: The aging will be based on the unpaid invoice listing, rather than the list of vendor balances. First execute computed field for the days outstanding for each invoice. Then create computed fields for each aging category. The amount of the computed field will be equal to the invoice amount, conditional on the age of the invoice. For example, after computing a field for days outstanding (Days_ OS), the field for 31-60 days would be computed as follows: 

f(x) = Invoice_Amount 

If: Days_OS >30 AND Days_OS <=60

               Commands Used:

               Answer:

Question 3: Calculate the discounts that were lost by not taking advantage of the discounts available when invoices are paid within 30 days. The available discount rate is included in the master file.

               Commands Used:

               Answer:

Question 4: Determine that all vendors included on the unpaid invoices list are included in the accounts payable master list. List any discrepancies.

               Commands Used:

               Answer:

Question 5: Create a view of vendors to which confirmation requests for copies of vendors' statements will be sent. Requests will be sent to all vendors with an accounts payable balance greater than $50,000, a random sample of five of the vendors with balances below $50,000, and a random sample of four vendors with no balance outstanding. The list should include sufficient information to prepare requests for vendors' statements. The balance due should not be included in the list.

               Commands Used:

               Answer: