Crystal Reports for Sage Peachtree, Crystal Reports for Sage MAS 90 ERP, Crystal Reports for Sage MAS 200 ERP

*Helping you do more in less time*	*Chicago, Detroit, Memphis & St. Louis*

Crystal Reports for Sage Peachtree, Sage MAS 90 ERP and Sage MAS 200 ERP

These reports are available for purchase. Call 800-475-1047 or contact us for further details.

Report Name	Description	Year
% of Bad Debt Chart	Compares a group of GL accounts considered for returned checks against a group of income accounts to determine a bad debt percentage for a month then displays each month on a YTD chart. One chart being displayed for each reporting entity. This report is based on a specific COA and COA structure and would require considerable modification.	2002
6 Mo. Stock Movement Report	This report bases it's information on the current accounting period. It shows Location, Item Type, Item ID, Desc., Current Qty on Hand, Average Cost, Current Value, Last IN Date, Last OUT Date, IN and OUT Quantities for each of the last 6 months, Beginning Qty on Hand, Average Cost and Value.	2005
Active Job Pre-bill Worksheet	For an entered range of jobs, this report finds all unbilled time and expense tickets and then lists; Ticket Date, Employee Name; Task; rate; hrs worked; amount; billable hrs; and ticket status. A header area for each job includes summary information about the job and customer.	2005
Active Job Pre-bill Worksheet	For ALL jobs, this report finds all unbilled time and expense tickets and then lists; Ticket Date, Employee Name; Task; rate; hrs worked; amount; billable hrs; and ticket status. A header area for each job includes summary information about the job and customer.	2005
Active Job Pre-bill Worksheet	For an entered range of jobs, this report finds all unbilled time and expense tickets and then lists; Ticket Date, Employee Name; Task; rate; hrs worked; amount; billable hrs; and ticket status. A header area for each job includes summary information about the job and customer. This report uses sub reports to help speed processing in some situations.	2005
Aged Payables with comments	This is an aged payables report showing vendor ID & Name, Inv#, Total Amt Due, Inv Date, Due date, Discount amt, Disc Date, Net to Pay and the line description from the first line of the invoice as a comment.	2005
Budget Worksheet	This report pulls from GL summary info for all accounts with Ids > 4 and with any amounts in any of the 3 open years (last, this, next) and shows all budget amounts from this year and actual for this year and last year with entry lines for next year It prints two accounts / page. This report will require modification for Peachtree versions > 2002 and crystal>v8	2002
Budget Worksheet 2	This report pulls from GL summary info for all accounts within a specified acct range and shows all budget amounts from this year and actual for this year and last year with entry lines for next year. It prints two accounts / page. This report will require modification for Peachtree versions > 2002 and crystal>v8	2002
Budget Worksheet 3	This report pulls from GL summary info for all accounts with Ids > 4 and with any amounts in any of the 3 open years (last, this, next) and shows all budget amounts from this year and actual for this year and last year with entry lines for next year It prints two accounts / page. This report will require modification for Peachtree versions > 2002 and crystal>v8	2002
Cash Requirements Report	This custom cash requirements report finds all open AP invoices through an entered as of date. It then prints; Vendor ID, Name, Inv #, Inv Date, Due Date, Open Inv Amt, Disc Date, Disc amount and Net cash required. It prints in due date order w/ a daily total due, daily discount available and a running total of cash required. Discount amounts are not included in the running total.	2006
Certified PRForm	Custom Certified PR form for time ticket employees pulled by pay Period end date and Job. Showing employee Name, Addr & SS#, sex & ethnic grp fromcustom fields, work clfs from empType, std & OT hrs/day w/ totals, pay rates & Gross pay. A subreport calculates FedW/H, FICA,Other/Union,StateWH, Total Deducted and Net Job Wages. a Payroll No. may be entered at the entry prompt. This report will require modification to handle Union/other deductions based on company default settings.	2004
Change in Financial Position Statement	This report is written for a not for profit organization w/ a departmentalized GL. The first 4 digits of the GL acctID is the account # and account names are pulled from an Acct w/ the same first 4 digits and on '-' included in the ID. A date range and beginning fund balance is entered. A running total fund balance is then printed for Revenues and expenditures w/ activity for main accounts under these headings shown. Unpaid expenditures (open AP) is then listed. yielding a net change amount for the period and a final total fund balance. Can be modified for differing account structures.	2004
Check Register by Vendor Expense Account	This customcheck register prints all checks within both a specified Date and Check # Range. It displays; Check #, Check Date; Payee, Cash Acct DI, Vendor Default Exp. Acct. and Check Amount. This report subtotals by expense account.	2006
Check Register by Vendor Expense Account	This customcheck register prints all checks within a specified Check Number Range. It displays; Check #, Check Date; Payee, Cash Acct DI, Vendor Default Exp. Acct. and Check Amount. This report subtotals by expense account.	2006
Check Register by Vendor Expense Account	This customcheck register prints all checks within a specified Date Range. It displays; Check #, Check Date; Payee, Cash Acct DI, Vendor Default Exp. Acct. and Check Amount. This report subtotals by expense account.	2006
Custom Quote	Custom Crystal quote form, pulling a specific Peachtree quote id from within a specified date range. Detail shows qty, UoM, quote line description, unit price & extension. There are detail sale terms and an acceptance signature line.	2004
Customer Ledger by Center Type	Detail customer ledger grouped by Customer Type (cost center). Shows Trans Date, Jrnl, Ref#. Sales amt, Pmt amt & Invoice PD. Note.	2003
Customer Ledger by Center Type	Customer ledger report grouped by specified range of customer type. This report shows all transactions sorted by date. Cash receipts show individual invoices paid and amounts paid toward that invoice. Columns are, cust.name, jrnl, ref#, sales amt, pmt amt, running balance ant invoice paid.	2005
Customer Sales by Item	Lists sales figures for each item with a valid ID field with detail for each customer purchasing that product showing Invoice date, # customer and total amount paid by customer for that product	2005
Customer Statement Form	Custom customer statement form showing all customer invoice sorted by invoice # and associated payments with a running balance. Totally paid invoices are marked and total check amounts are shown in a comment field. This report was based on a Peachtree sample report which I later found to not work in all situations. Aging category totals may not be correct for customers spanning multiple statement pages.	2004
Daily Operations Report w/ Insert	This report summarizes totals for various groups of GL accounts on a daily basis for an entire month. Same as Daily Operations Report by contains an inserted sub report showing some other comparison totals for the month. This report is based on a specific COA and COA structure and would require considerable modification.	2002
Daily Operations Report	This report summarizes totals for various groups of GL accounts on a daily basis for an entire month. This report is based on a specific COA and COA structure and would require considerable modification.	2002
Daily Orders& Sales	This report looks print a daily summary of the line by line detail of sales invoice and Sales Orders for a specified range of dates	2005
Detail Sales Analysis Report	Sales analysis report subtotaled by customer and sales rep. This report pulls detail for lines that contain a valid item id and have been assigned a valid sales rep. It shows invoice # & date, item ID & description. Qty, net sales amount, cost of sale, gross profit and profit%	2005
EE Net/Gross Pay by row	Assistance report to list payroll records by row # to help determine which PR transaction row # is associated with a specific employee field name.	2004
Fees vs. Net Income Chart	Compares group of GL income accounts vs net income for a month then displays each month on a YTD chart. One chart being displayed for each reporting entity. This report is based on a specific COA and COA structure and would require considerable modification.	2002
Item Sales by Customer	This report shows sales for a supplied period of time. It is grouped by Item and show Inv#, InvDate, Customer and Amount with a subtotal by item.	2005
Items Sold to Customer	Sales report for specified accounting period listing item sold to customer w/ sales amount, cost, % of total sales/customer and Item profit % with totals /customer and company.	2003
Job Profitability Report - Detail by Job	This report shows job profitability for a specified date range and 1 specified Job. It creates a sub report to pull phase descriptions then prints job cost transaction detail comprised of TransRef, TransDate, JournalCode, Job#, PhaseCode, PhaseDescription, GL Acct#, RevenueAmt,ExpenseAmt, Profit & Profit %. It then subtotals first by GL acct, Phase & then Job. This report equates employees with phases and assumes employee works just 1 job per paycheck. employer paid tax expenses are included as an expense.	2005
Job Profitability Report - Detail by Job	This report shows job profitability for a specified date range and ALL Jobs. It creates a sub report to pull phase descriptions then prints job cost transaction detail comprised of TransRef, TransDate, JournalCode, Job#, PhaseCode, PhaseDescription, GL Acct#, RevenueAmt,ExpenseAmt,Profit & Profit %. It then subtotals first by GL acct, Phase & then Job. This report equates employees with phases and assumes employee works just 1 job per paycheck. employer paid tax expenses are included as an expense.	2005
List of PAID Bills	List all AP bills Paid during an the entered date range sorted by GL account #. Acct# is first 4 digits of the Account ID. Shows vendor name, Check date, Check#, Ref.# and Amount and is totaled by GL Acct#. This report would need to be modified for acct structure.	2004
List of UNPAID Bills	List all Unpaid AP bills for the entered date range sorted by GL account #. Acct# is first 4 digits of the Account ID. Shows vendor name, transaction date, Ref.# and Amount and is totaled by GL Acct#. This report would need to be modified for acct structure.	2004
MDT Fees Collected Detail-By DM	Further breakdown of Income categories from MDT Fees Collected-By DM report with income categories still displayed by reporting entity totaling by district manager, defined within the report. This report is based on a specific COA and COA structure and would require considerable modification.	2002
MDT Fees Collected-By DM	Summarizes groups of income accounts into income categories then displays by reporting entity totaling by district manager, defined within the report. This report is based on a specific COA and COA structure and would require considerable modification.	2002
Non-Stock Sales Rep by Invoice Report	This sales report list all invoices that were Paid during a specified time frame and shipped on or prior to the end of that time frame or paid prior to the beginning of that time frame and shipped during for a specified list of sales reps. This report prints only items with an item class of Non-Stock and prints; Invoice #, Ship date, inv date, paid date, cust ID & Name, Item ID and Inv line description, Qty sold, Inv total, Line item total, COGS amount Profit and Profit% with invoice and sales rep totals.	2006
Open Accounts Payable	This report finds open AP as of a specific date showing vendor id & name, inv#, total due, inv date, due date, disc amt, disc date, net to pay and any invoice comment. Will require logic update for newer versions.	2004
Payroll Distribution by Job by Employee ID -Detail Report	For a given date range, list on a job by job basis PR date, Employee ID & Name, Hours and Expense allocated to a job with subtotals by job and a grand total sorted by job and employee ID	2004
Payroll Distribution by Job -Detail Report	For a given date range, list on a job by job basis PR date, Employee ID & Name, Hours and Expense allocated to a job with subtotals by job and a grand total sorted by job and employee name	2004
Payroll Distribution by Job -Summary Report	For a given date range, list on a job by job basis showing a summary of Hours and Expense allocated to a job with subtotals by job and a grand total sorted by job and employee ID	2004
Pending (Unpaid) Sales; Rep by Invoice Report	This sales report list all invoices that have not been paid and have not been shipped as of the end of a specified date range for a specified list of sales reps. This report prints only items with an item class of Stock; Master-Stock; Assembly, Serialized or Serialized-Assemblies and prints; Invoice #, Ship date, inv date, paid date, cust ID & Name, Item ID and Inv line description, Qty sold, Inv total, Line item total, COGS amount Profit and Profit% with invoice and sales rep totals and payment/ship status grouping invoices by customer name.	2006
Periods	Sub report showing the month name for the current year fiscal periods 1-12.	2002
Phase Array Report	Saved sub report moves Phase ID and Phase Description into an array to be used in some job profitability reports.	2005
Product Price List	The is a product price listing broken out by item type (product line) it shows the item ID, Description for Sales (or Description), the stocking unit of measure (as bundle qty) and 2 price columns the first showing price level #1 and the second showing a 10% discount. The item type is converted to a product line description within the report and will need to be modified. Other 2 column reports exist showing various price levels.	2005
Purchase for Account	Details of each purchase transaction distributed to a specified GL asst number group for a specified range of dates. This report is sorted and subtotaled by vendor. This report was designed for a specific GL account structure. ####-### with the first for digits being the account # and that last 3 being a specified reporting entity	2002
QDT Fees Collected-By DM	Summarizes groups of income accounts into income categories then displays by reporting entity totaling by district manager, defined within the report. This report is based on a specific COA and COA structure and would require considerable modification.	2002
Sales Invoice Register	This report prints for all invoices dated within a specified date range. It lists Document ID, Date, Cust ID & Name, Terms Desc, Sales amt, Freight amount and invoice total with summary totals at the end of the report	2006
Sales Order/Job Picking List	This report selects from all Open Sales orders, recovers a Job code located in the CustPO field on Open SO's and Invoices corresponding to that SO. It then creates a picking report by job and S/O # showing Qty Ordered, Installed, item ID and SO Line Description. The same job code must also be entered on each SO line. Any Description line that has been entered in all upper case will be highlighted in bold text and is assumed to be a comment/message rather than a item line.	2004
Sales Rep by Invoice Report	This sales report list all invoices that were Paid during a specified time frame and shipped on or prior to the end of that time frame or paid prior to the beginning of that time frame and shipped during for a specified list of sales reps. This report prints only items with an item class of Stock; Master-Stock; Assembly, Serialized or Serialized-Assemblies and prints; Invoice #, Ship date, inv date, paid date, cust ID & Name, Item ID and Inv line description, Qty sold, Inv total, Line item total, COGS amount Profit and Profit% with invoice and sales rep totals. This report is printed in Customer / Invoice ID order.	2006
Sales Rep by Invoice Report	This sales report list all invoices that were Paid during a specified time frame and shipped on or prior to the end of that time frame or paid prior to the beginning of that time frame and shipped during for ALL sales reps. This report prints only items with an item class of Stock; Master-Stock; Assembly, Serialized or Serialized-Assemblies and prints; Invoice #, Ship date, inv date, paid date, cust ID & Name, Item ID and Inv line description, Qty sold, Inv total, Line item total, COGS amount Profit and Profit% with invoice and sales rep totals. This report is printed in Customer / Invoice ID order.	2006
Sales Rep by Invoice Ship Date Report	This sales report list all invoices that were Paid during a specified time frame and shipped on or prior to the end of that time frame or paid prior to the beginning of that time frame and shipped during for a specified list of sales reps. This report prints only items with an item class of Stock; Master-Stock; Assembly, Serialized or Serialized-Assemblies and prints; Invoice #, Ship date, inv date, paid date, cust ID & Name, Item ID and Inv line description, Qty sold, Inv total, Line item total, COGS amount Profit and Profit% with invoice and sales rep totals. This report is printed in ship-date order.	2006
Sales Rep Report by Item ID	This sales report list all invoices that were Paid during a specified time frame and shipped on or prior to the end of that time frame or paid prior to the beginning of that time frame and shipped during for ALL sales reps. This report prints only items with an item class of Stock; Master-Stock; Assembly, Serialized or Serialized-Assemblies and prints; Invoice #, Ship date, inv date, paid date, cust ID & Name, Item ID and Inv line description, Qty sold, Inv total, Line item total, COGS amount Profit and Profit% with Item and sales rep totals. This report is printed in Item / Customer / Invoice ID order.	2006
Sales Report by Customer	This sales report lists sales detail for invoices falling in a specified date range. This report prints only items with an item class of Stock; Master-Stock; Assembly, Serialized or Serialized-Assemblies and prints; Customer Name, Item ID, Inv #, Inv Date, Qty Sold, Unit Price Extended Price, Unit Cost, Total Cost, Profit and Profit %. with subtotals by Customer. Total Cost, Profit and Profit % can be turned off with a prompted selection.	2006
Sales Report by Item	This sales report lists sales detail for invoices falling in a specified date range. This report prints only items with an item class of Stock; Master-Stock; Assembly, Serialized or Serialized-Assemblies and prints; Customer Name, Item ID, Inv #, Inv Date, Qty Sold, Unit Price Extended Price, Unit Cost, Total Cost, Profit and Profit %. with subtotals by Item ID. Total Cost, Profit and Profit % can be turned off with a prompted selection.	2006
This Year	Sub report showing the current years range of dates (month & year only)	2002
Vendor Check Detail Report	This report shows all checks for the current accounting period sorted by check reference. I lists Vendor ID, Name and address on check, Vendor Phone #, Check Date, Check # and a line for each invoice paid, showing Invoice Date, Ref, and amount applied to that Invoice and finally a check total.	2005
Vendor Check Detail Report by Bank Acct.	This report shows all checks for the current accounting period subtotaled by cash account and sorted by check reference. I lists Vendor ID, Name and address on check, Vendor Phone #, Check Date, Check # and a line for each invoice paid, showing Invoice Date, Ref, and amount applied to that Invoice and finally a check total.	2005

Copyright 2010 JCS Computer, Inc. Site Map
All Logos & Brand Names throughout this website copyright 2009 to their respective owners. 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 owner. Crystal Reports is the registered trademark and technology of Business Objects SA. JCS Computer Resource software training and support for Sage Peachtree, ACT! by Sage, Timeslips by Sage Fixed Asset, Sage MAS 90 ERP, Sage MAS 200 ERP and Crystal Reports are available in Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, Florida, Georgia, Hawaii, Idaho , Illinois, Indiana, Iowa, Kansas, Kentucky , Louisiana , Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma , Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin and Wyoming.