The table that is used by the standard liability report does not contain the information by state. Use one of the following queries instead.

SELECT CheckDate AS PayDate, SUM((SSTax+MediTax)*2+FedTax+ TYPEE) as FedTaxLiab, SUM(GrossPay) AS Pay, Sum(FedTax) AS FWT, Sum(StateTax) AS Swt, SUM(SSTax) AS SSTx, Sum(MediTax) AS MedTx, SUM(OtherAddsDeducts) AS Othr, SUM(NetPay) AS NetP,SUM(typeE) AS AEIC,Sum(LocalTaxes) as LocTax INTO JournalByDate From CheckHistory WHERE CheckDate Between BegDate AND EndDAte GROUP BY CheckDate;

or

SELECT statecode, CheckDate AS PayDate, SUM((SSTax+MediTax)*2+FedTax+ TYPEE) as FedTaxLiab, SUM(GrossPay) AS Pay, Sum(FedTax) AS FWT, Sum(StateTax) AS Swt, SUM(SSTax) AS SSTx, Sum(MediTax) AS MedTx, SUM(OtherAddsDeducts) AS Othr, SUM(NetPay) AS NetP,SUM(typeE) AS AEIC,Sum(LocalTaxes) as LocTax INTO JournalByDate From CheckHistory WHERE CheckDate Between BegDate AND EndDAte GROUP BY statecode,CheckDate;

or

SELECT statecode, SUM((SSTax+MediTax)*2+FedTax+ TYPEE) as FedTaxLiab, SUM(GrossPay) AS Pay, Sum(FedTax) AS FWT, Sum(StateTax) AS Swt, SUM(SSTax) AS SSTx, Sum(MediTax) AS MedTx, SUM(OtherAddsDeducts) AS Othr, SUM(NetPay) AS NetP,SUM(typeE) AS AEIC,Sum(LocalTaxes) as LocTax INTO JournalByDate From CheckHistory WHERE CheckDate Between BegDate AND EndDAte GROUP BY statecode

Last update: 05:21 PM Wednesday, July 12, 2006

• Why do I get a prompt for approval when trying to send email from within Temps Plus?
• How can I control the rounding of billing/invoice amounts?
• When the ForceUniqueCheckNumbers feature is opted for, how does the system set the starting check number?
• How does Temps Plus determine the default UserName in the login window?
• How can I make a formula to make Applicant names First Name First on checks?
• A formula for showing only the last 4 digits of the social security number.
• What is the Temps Plus "log file"?
• For auditing purposes, how would I access the information stored in Temps Plus to show the user and date/time something was entered or changed?