SQL In-class Assignment

Answer Sheet

Requirements:  Answer the following questions and upload it to In class Assignment on Canvas.

1. What can cause this balance in the suspense account? (Hint: there are 3 main causes)

2.Let’s create 3 reports analyzing these problems.

Insert Screenshot of Report 1: PPV over $$$

Insert Screenshot of Report 2: Invoices in transit

Insert Screenshot of Report 3: Inventory in transit

Upload this document to:

https://canvas.uw.edu/courses/1587834/assignments/7715587