Sage MAS 90 | Sage MAS 200| Sage MAS 500| Sage CRM SalesLogix | DSD

Sage MAS 90 and Sage MAS 200 Technical Tips from DSD Business Systems

****JavaScript based drop down DHTML menu created by Dan Smith. (DSD Inc. - http://www.dsdinc.com)****

MAS 90 & 200 Tech Tips General Tech Tips Hidden Utilites Identifying MAS 90 CD Roms Copying Company Data MAS90 3.71 PDF Manuals Recovering Disk Space Year End Closing Procedures E-mailing and Invoice or Order Creating a Custom Look-up Are you ready for 4.0? Business Insights Wizard Tape Backup Strategy Windows SP2 for 3.71 & 4.0 FRX Desktop - Custom Financials Share Point Required on Server How to copy a company in 4.0 Accounts Payable Tips Payments &: Wire Transfers Reversing an AP Check 1099 Printing for Year 2003 E-mailing an Order or Invoice Accounts Receivable Tips Bank Transfers Sales Tax Calculation Utility Balance Forward Issue Customer Sales Summary by Year Report Top 15 Customer Rank Report Refunding Sales Tax Customizing Lookups in 4.0 Apply a Credit Memo to an Invoice Processing Customer Deposits E-mailing an Order or Invoice General Ledger Tips Balancing Inventory to the GL Finding G/L Problems & Preparing for 4.0 Out of Balance in 4.0 Trial Balance Recording Bank Transfers with Transaction Journal Entry Batch Processing in G/L 4.0 Inventory Tips Inventory Transaction Types Purchase Order Tips How to Clear Backorderd PO's Managing the PO Clearing Account Payroll Tips Voiding a Direct Deposit Check Arizona State Income Tax Min. $5.00/Month Workaround Updating Federal 941 Form for Year 2003 2003 Payroll Year-End Procedures W-2 Processing W2 Printing for Year 2003 Sales Order Tips Credit Memo with a Credit Card Processing Customer Deposits Crystal Reports Tax Tips Using Form DE-4 to adjust CA State Income Tax Withholding 1099 Printing for Year 2003 W2 Printing for Year 2003 2003 Payroll Year-End Procedures W-2 Processing MAS 90 4.0 Tech Tips Are you Ready for 4.0? Solving Client Server Firewall Issues Finding G/L Problems & Preparing for 4.0 Out of Balance in 4.0 Trial Balance Windows XP SP2 Support for 4.0 Recording Bank Transfers with Transaction Journal Entry Batch Processing in G/L 4.0 How to Copy a Company in 4.0 DSD Services Training MAS 90 & MAS 200 MAS 500 SalesLogix On Site Training Crystal Reports IT & Network Services Internet Services Professional Services Consulting Implementation Support Custom Programming

Sage MAS 90 General Tech Tips from DSD

DSD Sage MAS 90 Tech Tip 9 - Customer Sales Summary by Year Report

by Ken Phillips

The Customer Sales Summary report prints sales history for selected customers for the five years 1999, 2000, 2001, 2002 and 2003. The report is sorted by Division and Customer Number.

Prompts: Division Range and Customer Number Range.

Table Reported From: A/R Invoice History Header (ARN) file.

Totals From: Taxable Sales + Non-Taxable Sales + Freight + Sales Tax – Discount Amount.

Download CustSalesSummary.rpt Crystal Report and save the file in your Sage MAS 90 Crystal Report folder or directory. Crystal Reports are commonly placed in the ..\mas90\Reports\###-ccc folder, where “ccc” is your three character company code.

A PDF example of the report is custsalessummary.pdf.

DSD Business Systems | Sage MAS 90 | Sage MAS 200 | Sage MAS 500 | Sage CRM SalesLogix | Sage BusinessWorks | Sage Abra | Sage FAS | ACT! by Sage
Site Map | Why DSD | Contact Us | Sage Software or Microsoft | Top 10 Reasons to Buy from DSD

©2006 DSD Business Systems 5120 Shoreham Place Suite 280 San Diego, CA 92122 Phone: 800.627.9032

Sage Software, the Sage Software logos, and the Sage Software product and service names mentioned herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities. All other trademarks are property of their respective owners.