Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.12 » View Incident Report |
Serious |
Reported By: Ben Sprei Reported On: 1/31/2013 For: Version 2.11 Build 3 |
Select InvNum, Phone, Seq, CustName, InvDate, (LineTotal + FrtAmt) as TaxSale, 0 as NonTaxSale, TaxAmt, STP, Category, State, City from (Select a.*, b.CustZip, c.State, c.City, SUBSTRING (b.CustZip, 1 FOR 3) AS Category from InvHead a left join CusMas b on b.Phone = a.Phone and b.Seq = a.Seq right Join ZipCodes c on SUBSTRING (ZipCodes.Zip, 1 FOR 3) = SUBSTRING (b.CustZip, 1 FOR 3) Where Taxable = True and (STP is NULL or STP = ' ')) TaxSales Union All Select InvNum, Phone, Seq, CustName, InvDate, 0, (LineTotal + FrtAmt) as TaxSale, TaxAmt, STP, Category, State, City from (Select a.*, b.CustZip, c.State, c.City, SUBSTRING (b.CustZip, 1 FOR 3) AS Category from InvHead a left join CusMas b on b.Phone = a.Phone and b.Seq = a.Seq right Join ZipCodes c on SUBSTRING (ZipCodes.Zip, 1 FOR 3) = SUBSTRING (b.CustZip, 1 FOR 3) Where Taxable <> True and (STP is NULL or STP = ' ')) NonTaxSales Order by Category, InvDate, InvNum
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |