Lesson Progress
0% Complete

Everything revolves around the ITEM itself, from the Items table. The Stock In Flows, Sales Order Items, and Invoice Items tables all look up to the items table.

So, we will pull the available stock on hand from the stock inflows table, the committed stock from the sales order items table (conditional on if the sales order is open or not), and the recent sales data from the invoice items table.