Crystal Reports® for Peachtree®
and Crystal Reports for Sage MAS 90® / Sage MAS 200®
These reports are available for purchase; call 866/467-7672 or email us for detailed costing.
% of Bad Debt Chart
Compares 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, avg.Cost, Current Value, Last IN Date, Last
OUT Date, IN and OUT Quantities for each of the last 6 months, Beginning
Qty on Hand, Avg.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 payPeriod end date and Job.
Showing employee Name, Addr & SS#, sex & ethnic grp from custom fields,
work clfs from empType, std & OT hrs/day w/ totals, pay rates & Gross
pay. A sub report 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 digest 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 custom check
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 custom check 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 custom check
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 ArrayReport
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
Since 1989 JCS Computer has offered Certified Peachtree, ACT!, Timeslips, Sage MAS 90, Sage MAS 200 and Crystal Reports training and support. Helping you learn how to do more in less time, JCS Computer provides installation, onsite training, classroom training, online training, online support, onsite support and phone software support. Our software training classes are guaranteed or come back for free.
All Logos & Brand Names throughout this website copyright 2008 to their respective owners. JCS Computer Resource Corp is an independently owned & operated value added reseller for Sage Software, SB Inc. and Microsoft Corp. 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.
JCS Computer Resource Corp.'s online support & training services 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.
