You are here: Home Solutions Report Writing Sample Reports

Sample Reports
REPORT NAMEDESCRIPTIONMODULE
Aged Payables Report (Custom)This report has been customized to include additional information from the vendor maintenance window and/or the Invoice.AP
 Vendor Purchases Report (Custom) This report lists the purchases for each vendor by items purchased.  This report is sorted by item and can contain unit cost, quantities, etc.AP
 Sales Rep Commission-Invoice Detail (Form) This report produces invoice forms to match to attach to a sales representative's commission report.AR
Aged Receivables Report (Custom)This report has been customized to include additional information from the customer maintenance window and/or the invoice.AR
Billed and Back Log by CustomerThis report lists the Invoice Numbers, Invoice Amounts, Open Sales Orders and Sales Order Amounts by CustomerAR
Cash Receipts Report (Custom)This reports lists cash receipts with additional information from the customer maintenance window.AR
Customer Prices by ItemThis report lists the items purchased by a customer showing the last date the item was purchased and the price paid on the last purchase.  The report is sorted by customer and then by item ID.AR
Customer ProfitabilityThis report lists the sales by customer and the gross profit and gross margins with amounts compared to the past year.AR
Customer Sales by CountryThis report lists the total sales by Ship to Country.  AR
Customer Sales by Item with Cost and Unit PriceThis report lists the line detail information off of an invoice.  It does not include sales tax or freight unless they are entered as line items.  The report is sorted by customer and then by invoice number.AR
Customer Sales History SummaryThis report summarizes sales for each customer by item.  It does include sales tax and freight.  The report is sorted by customer and then by transaction date by invoice.  Sales through cash receipts are not included.AR
Detail Sales Analysis Report - Sales by CustomerThis report lists the sales for each customer by transaction date.  It does include sales tax and freight.  The report is sorted by customer and then by transaction date by invoice.  Sales through cash receipts are not included.AR
Factor Assignment SheetThis report is used for customers that factor their receivables.  It lists the invoices that have been assigned to the factor.AR
Items Sold to CustomersThis report lists the sales for each customer within a specified date range by items purchased.  It does not include sales tax or freight unless they are entered as line items.  The report is sorted by and selected by customer.  This report does not include sales made through the receipts journal.AR
Mailing Labels - Ship To RepeatThis report creates mailing labels for the Ship to AddressAR
Monthly Billing SheetThis report lists the items sold to each customer by the item description only showing the last time the item was sold.  The report is sorted by customer, then by item description and then by transaction date.AR
Sales Invoice Line DetailThis report lists the line detail information off of an invoice.  It does not include sales tax or freight unless they are entered as line items.  The report is sorted by customer and then by invoice number.AR
Sales Rep Commission Report (Custom)This report calculates commission for sales representatives.  This report can to be customized to include commission calculated by paid invoices, commission calculated on all invoices, and with varying commission calculations.AR
  Income Statement-Detailed This is a customized income statement that includes additional roll-up information and/or external data ie. shipped amounts, etc.GL
Weekly Balance SheetThis report lists balance sheet information on a weekly basis.GL
Weekly Profit & LossThis lists income statement information on a weekly basis.GL
 Inventory Sales Activity Report (Custom) This lists inventory items and their sales activity. INV
 Item Report  This report lists inventory items and detailed information from Sales Orders, Purchase Orders, etc.  Can also include images. INV
  Product Sales By Category (Cross Tab) This report lists the product sales by categories setup in inventory maintenance custom fields. INV
 Rebate Report This report calculates rebate amounts to vendors on items using custom fields. INV
 Job Ledger (Custom) This report lists the job ledger activity but also includes purchase order and sales order information.  Construction customers have found this report extremely useful for tracking the status of jobs including change orders and payments. JOB
 Job Transaction Report  This report lists the jobs including the amount of transaction activity for a certain date as well as the current balance. JOB
Weekly Ship ListThis report lists purchase orders and when they are due to be shipped. PO
  NYS-45 Report This prints a NYS-45 report. PR
 NYS-45 Unemplyment Insurance This report calculates the unemployment insurance. PR
 Factor Order List This report is used for customers that factor their receivables.  It lists orders to be approved by the factor. SO
 Open Sales Order Report This report lists the open sales orders, sorted by ship by date SO
 Sales Order Picking List (Form) This report produces a sales order picking list that sorts the items by their location. SO
 Work Ticket Order Form This report is actually a Work Ticket form that includes Sales Order information - single level WT/INV