Conner Ash Logo

Crystal Reports Catalogue - Sage 100

Crystal Reports® empowers users to get the most from their ERP software. This powerful tool allows you to create and customize presentation-quality reports, giving your management the information they need to make knowledgeable business decisions. Crystal Reports® is an ODBC (open database connectivity) driven product and will link with Sage 100 (formerly Sage MAS 90 and 200), Sage 50 Accounting (formerly Peachtree® Accounting) and many other popular systems.

Below is a selection of the Crystal Reports we have designed for our clients which are available for purchase. For information about the report and a sample of the output, click on the Report Description link.  Some reports are installed by adding another Form Code to an existing report and some are installed on the Custom Report Menu for a module. These reports have been written for Sage 100 v4.5 thru 2016 and because the tables are compatible between the versions, they can be installed on any of these versions with minimal effort.

If you don't see what you are looking for, please contact Suzanne Watson at (314) 205-2510 or via email, swatson@connerash.com, for further assistance. We may be able to design a report to meet your needs. In addition, we add new reports as they are designed.

Accounts Payable Reports

Report Number and Name Report Description
AP301 - Accounts Payable File Labels Accounts Payable File Labels - with Vendor Name and Number
AP102 - Aged Invoice Report Accounts Payable Aged Invoice Report - export format
AP101 - Aged Invoice Report Accounts Payable Aged Invoice Report - landscape orientation
AP302 - New Vendor Listing New Vendor Listing - for Vendors added on or after a specified date
AP103 - Payment History Report *NEW Payment History Report - with General Ledger account numbers for invoices

Accounts Receivable Reports

Report Number and Name Report Description
AR306 - Accounts Receivable File Labels Accounts Receivable File Labels - with Customer Name and Number
AR105 - Accounts Receivable Aged Invoice Report Accounts Receivable Aged Invoice Report - export format
AR101 - Accounts Receivable Aged Invoice Report Accounts Receivable Aged Invoice Report - landscape orientation
AR103 - Accounts Receivable Aged Invoice Report - Credit Limit Removed Accounts Receivable Aged Invoice Report - with the Credit Limit Removed and Terms Code Description and Email Address Added
AR104 - Cash Receipts Report - Bad Debt Cash Receipts Report - Bad Debt Write-Offs
AR310 - Customer Sales History Graph Customer Sales History Graph - graphical presentation of Customer Sales for the current and two prior years
AR307 - Exemption Certificate Audit Exemption Certificate Audit - with Certificate Numbers
AR301 - Gross Margin By Price Level Gross Margin By Price Level Report - gross margin by invoice and price level
AR305 - Gross Profit By Product Line Gross Profit By Division By Product Line - Sales minus Returns minus Cost of Goods Sold minus Freight to yeild Profit and Profit Percent
AR308 - Gross Profit By Salesperson and Customer Gross Profit By Salesperson By Customer - Sales, excluding Freight and Sales Tax, less COGS equals Gross Profit
AR302 - Gross Sales By State and Zip Code Gross Sales By State and Zip Code - sorted by BillTo and Zip Code OR ShipTo State and Zip Code
AR102 - Invoice History - Gross Profit Report Accounts Receivable Invoice History - Gross Profit Report - the standard report has been modified to include a margin calculation
AR309 - New Customer Listing New Customer Listing - listing of the customers added during the previous week
AR303 - Paperless Customer Listing Paperless Customer Listing - listing of the documents that are set up in Paperless for each Customer
AR304 - Sales By ShipTo State Sales By ShipTo State - sales information sorted and subtotaled by ShipTo State code

General Ledger Reports

Report Number and Name Report Description
GL101 - General Ledger Trial Balance General Ledger Trial Balance - excluding deleted accounts

Inventory Management Reports

IM104 - Inventory Valuation By PeriodInventory Valuation By Period - grouped by Warehouse

Report Number and Name Report Description
IM301 - Inactive Inventory Items Inactive Inventory Items - using LastSoldDate as the basis for including items in the report
IM302 - Inventory Aging Inventory Aging - for FIFO, LIFO, Lot and Serial tiers
IM303 - Inventory On-Hand By Product Line Inventory By Product Line - landscape orientation; inventory value by Product Line
IM304 - Inventory On-Hand By Product Line Inventory By Product Line - portrait orientation; inventory value by Product Line
IM102 - Inventory Receipts History with Totals Inventory Receipts History - with Fiscal Year Totals
IM101 - Inventory Sales Analysis By Product Line Inventory Sales Analysis By Product Line - if the Sort Report By is Product Line, this report will include Product Line totals
IM103 - Inventory Sales History with Totals Inventory Sales History - with Fiscal Year Totals
IM105 - Inventory Valuation By Period *NEW Inventory Valuation By Period - order by valuation
IM104 - Inventory Valuation By Period *NEW Inventory Valuation By Period - group by warehouse
IM305 - Inventory Valuation Analysis Inventory Valuation Analysis - current inventory value plus last 12 months and previous 12 months information

Payroll Reports

Report Number and Name Report Description
PR301 - Employee Information Listing Employee Information Listing - name, address, phone, email, hire date and termination date
PR302 - Gross Earnings By Department Gross Earnings By Department - gross wages subtotaled by department for a specified check date range

Purchase Order Reports

Report Number and Name Report Description
PO301 - On-Time Delivery Report On-Time Delivery Report - calculates the on-time delivery percentage for receipts and units for a given date range for a specific or all Vendors
PO302 - On-Time Delivery Trend Analysis On-Time Delivery Trend Analysis - the on-time delivery statistics by month for the current and prior years for a specific or all Vendors; companion to the On-Time Delivery Report
PO101 - Open Purchase Order Report Open Purchase Order Report - landscape orientation
PO303 - Open Purchase Orders Open Purchase Orders Report - custom report
PO304 - Open Purchase Orders By Job Open Purchase Orders By Job Report - subtotal by Cost Code

Sales Order Reports

Report Number and Name Report Description
SO306 - On-Time Delivery Report On-Time Delivery Report - calculates the on-time delivery percentage for orders and units for a given date range
SO304 - On-Time Delivery Report By Item Code On-Time Delivery Report By Item Code - the number of work days between Order Date and Invoice Date grouped by Item Code
SO305 - On-Time Delivery Report By Work Days On-Time Delivery By Work Days - the number of work days between Order Date and Invoice Date grouped by Work Days
SO307 - On-Time Delivery Trend Analysis On-Time Delivery Trend Analysis - the on-time delivery statistics by month for the current and prior years; companion to the On-Time Delivery Report
SO301 - Open Orders By Item Open Sales Orders By Item - the Customer Name is replaced with the BillTo and ShipTo names; the Extended Description replaces the Item Code Description when one is entered
SO302 - Open Sales Orders By Product Line Open Sales Orders By Product Line - landscape orientation
SO303 - Open Sales Orders By Product Line Open Sales Orders By Product Line - portrait orientation
SO101 - Open Sales Order Report Open Sales Order Report - landscape orientation; if sorted by salesperson, there is a page break after each salesperson
SO102 - Open Sales Order Report Open Sales Order Report - portrait orientation; if sorted by salesperson, there is a page break after each salesperson