Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Micros 3700: Exclude discounts
I've been poking around but unable to find the table that houses discounts and definitions. If anyone can provide some insight on the query that would yield sales WITHOUT discounts by sales category, it'd make my year! Thanks!- jd83187
- Post #4
- Forum: Microsoft SQL Server: Setup and Administration
-
Micros 3700: Exclude discounts
Correction: The query above is pulling Gross Sales with Discounts included. So it is actually inflating sales. Thanks!- jd83187
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
Micros 3700: Exclude discounts
I am looking to pull Gross Sales with discounts excluded. The query (below) is what I am running now, which provides Gross Sales + discounts (negative values)which is deflating our daily numbers. select (b.net_sls_ttl) as AMOUNT, a.trans_seq as EXT_ID, DATEPART( dd , a.end_date_tm ) as DAY...- jd83187
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Setup and Administration
