Knowella

Sales Activity — stock, orders and sales by item and DC

See cases on hand, on order, sold and received this week for every item at every DC, from the latest daily file. Search by item, UPC, vendor or DC.

2 min read Real product screens
app.knowella.com Live walkthrough
Sales Activity, under Transactional in the Supply Chain sidebar, shows stock and movement for every item at every DC, taken from the latest daily file. Three summary cards across the top total the cases on hand, sold this week and on order. Below them is a searchable table with one row per DC, vendor and item.
In this article

Open Sales Activity under Transactional

In the Supply Chain sidebar, open <b>Transactional › Sales Activity</b>. The top right shows the <b>Distribution Centers</b> filter and the date the data is current as of.

Read the three summary cards

All three come from the latest daily file.

  • Total Cases On Hand — Cases on hand across every DC, vendor and item. The figure can run about 3% above physical stock.
  • Cases sold this week — Cases picked from the DCs from Sunday to the day before the file, worked out from each item's average units a day, plus the cases received this week.
  • Total Cases On Order — Cases on open order into the DCs, and what share of on-hand stock that is.

Browse the list

The <b>Sales activity</b> tab has one row per DC, vendor and item, showing the <b>DC Warehouse Number</b>, <b>Vendor Number</b>, <b>Vendor Name</b>, <b>DC Item Number</b> and <b>UPC</b>, followed by <b>Cases On Hand</b>, <b>Cases On Order</b>, <b>Cases Sold This Week</b>, <b>Cases Received This Week</b> and <b>Cases Allocated</b>. Sort by any column and page through the rest at the bottom right. <b>Insights</b> is the tab beside it.

Search and filter

Type in <b>Search</b> to filter by item, UPC, vendor number or name, or DC. Use <b>Vendor</b> to show one vendor's items, and <b>Columns</b> to choose which columns show.

Why it matters

Orders, receipts and sales only make sense next to what's on the shelf. With on-hand stock, open orders and this week's sales and receipts side by side for every item at every DC, you can spot items running low or overstocked before they turn into short shipments or write-offs.

Ready to build your own?

Start free and ship your first app in minutes — or have us set it up with you.