Skip to Content
0
Former Member
Feb 15, 2011 at 11:20 PM

REPORT - Sold quantity and OnHand quantity

57 Views

Hello Everyone,

How can I create a query to show what I have sold within a date range and how much inventory I have of those items. Thank you.

itemcode sold onhand whscod

x 10 5 AH

x 5 0 CH

x 12 3 GB

Y 0 5 AH

Y 0 10 CH

Y 2 20 GB