BenD
4Penny.net
Points: 7634

11/18/2021 1:52:53 PM

Inventory Running Total

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

I'm sure there are better ways to do this, but time was an issue so I just threw this together. 

This is a script that will give you (for each warehouse) a running total of the Quantity On Hand, and the exact transaction that changed it. 

We're using this to help the stock count people, they're counting in the middle of the day when stock is moving all around them. (sigh)

The results look like this. 

 

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3