Hi All -
Does the sales column of the batch table include the final bottom line
sale without tax but includes coupons/gift certificates? If a
customer uses a coupon (tender type) of $10 off on a $30 sale will the
sales field equal $30 or $20? Does sales represent the before the
discount total or the total including the discount?
I run the following query:
select (closingtime),sum(customercount), sum(salesplustax),sum(sales),
where closingtime between '2007-01-1' and '2007-12-31'
and customercount 0
group by (closingtime)
The daily sales don't match the sales figures using the Shirt + F6
function from POS.
Date SQL Query POS Shift F6
2007-06-14 1162.9500 1055.12
2007-06-15 1848.4300 1771.85
2007-06-16 565.11 513.75
- posted 13 years ago