What inventory items did we receive but have no invoice?
- Lets create 3 reports analyzing these problems. Below are the tables and attributes.
- Open DB Browser, start a new database, choose folder, give it a name,
- import csv tables (invoicing.cvs and receiving.cvs).File/Import.Make sure to click on column names in first line box
- Write and run SQL code for the following Questions
- What items match on PO, Item#, and what is the variance?Use SQL to create a table for matched items that calculates the variance.Add a criteria for PPV > $5. then export it
- What inventory items did we receive but have no invoice?
- What invoice did we receive but have not received the inventory items?
