Right data for # Sold and Pieces when R.Price is 0
Posted: Fri Jul 07, 2006 9:09 am
In Stock Table we have
Stock Table:
- Stock # = 625
R. Price = 0
# Sold = 0
Value Sold = 0
Inventory = 7
- Stock # = 625
Price = 20.00
Qty = 1
- R. Price = 0
# Sold = 0
Value Sold = 20
Inventory = 6
- Stock # = 625
Pieces = 0
Sales = 20
Total Pieces = 0
Total Sales = 20
Stock Table:
- # Sold = 1
- Pieces = 1
Total Pieces = 1