Includes many SQL files used to create various reports for the SAP ERP system as well as the ZedSuite Employee Portal.

Weekly Chemical Sales Report:

Chemical Weekly Sales Stored Procedure.sql

Crystal Report for Chemical Weekly Sales Report (sample page):

---

---

Weekly Power Sweeper Sales Report:

Weekly_Power_Sweeper__Sales_Report.sql

Crystal Report for Power Sweeper Weekly Sales Report (sample pages):

---

---

Weekly Sales Commission Report:

Comission Statement SQL Code.sql

Crystal Report for Weekly Sales Commission Report (sample pages):

---

---

Monthly Independent Sales Rep Comission Report:

Independent_Monthly_Commission_Report.sql

Crystal Report for Monthly Independent Sales Rep Comission Report (sample page):

---

---

Received Credit Card Payments For All Customers:

Received_Credit_Card_Payments_For_All_Customers SQL.sql

Crystal Report for Received Credit Card Payments For All Customers (sample page):

---

---

90-Day Slow Pay Aged Report:

90-Day_Slow_Pay_Aged_Report SQL.sql

Crystal Report for Received Credit Card Payments For All Customers (sample page):

---

---

Indiana State Tax Payable Report:

Indiana_State_Tax_Payable_SQL.sql

Crystal Report for Indiana State Tax Payable Report (sample page):

---

---

Michigan State Tax Payable Report:

Michigan_State_Tax_Payable_SQL.sql

Crystal Report for Michigan State Tax Payable Report (sample page):

---

---

Ohio State Tax Payable Report:

Ohio_State_Tax_Payable_SQL.sql

Crystal Report for Ohio State Tax Payable Report (sample page):

---

---

Minnesota State Tax Payable Report:

Minnesota_State_Tax_Payable_SQL.sql

Crystal Report for Minnesota State Tax Payable Report (sample page):

---

---

Texas State Tax Payable Report:

Texas_State_Tax_Payable_SQL.sql

Crystal Report for Texas State Tax Payable Report (sample page):

---

---

Wisconsin State Tax Payable Report:

Wisconsin_State_Tax_Payable_SQL.sql

Crystal Report for Wisconsin State Tax Payable Report (sample page):

---

---

ZedSuite AR Aging Report:

ZedSuite_AR_Aging_Report SQL.sql

---

---

ZedSuite Customer List Report:

ZedSuite_Customer_List SQL.sql

---

---

ZedSuite Document Look-Up Report:

ZedSuite_Document_Look_Up SQL.sql

---

---

ZedSuite Item Price List Report:

ZedSuite_Item_Price_List SQL.sql

---

---

ZedSuite Last Floor Soap Purchase Report:

ZedSuite_Last_Floor_Soap_Purchase SQL.sql

---

---

ZedSuite Last Power Sweeper Purchase Report:

ZedSuite_Last_Power_Sweeper_Purchase SQL.sql

---

---

ZedSuite Order Status By Item Report:

ZedSuite_Order_Status_By_Item SQL.sql

---

---

ZedSuite Sales History Report:

ZedSuite_Sales_History_Report SQL.sql

---

---