Crystal Reports Library—Sales Order/Accounts Receivable 2

Order

Report

Price

Current Year vs. Prior Year Sales Comparison by Salesperson   SO-117  (pdf 7 kb)
This report gets its data from A/R invoice history.  It compares sales by salesperson from current period and year to date to current period last year and year to date last year.  It also includes variances and percentages. It can be run for any date.

$ 350.00

Sales Analysis by Customer Type - PTD & YTD  SO-119 
(pdf 37 kb)
This report prints PTD and YTD Sales Dollars, Quantities, Gross Profit Dollars and Gross Profit Percentage for all items sold during one user-defined period.  The data includes current year and prior year data and is sorted and subtotaled by customer type with a page break after each customer type.  Within each customer type the items are sorted and subtotaled by customer.  Grand Totals for all customer types are included at the end of the report.

Sales Dollars by Product Line by Period     SO-120 (pdf 10 kb)
This report produces a list of the sales dollars associated with each item shipped for each period in a particular fiscal or calendar year.  It is sorted and subtotaled by product line and includes grand totals.

Sales Quantities by Product Line by Period    SO-121  
(pdf 11 kb)
This report lists the quantities of each item shipped for each period in a particular fiscal or calendar period.  It is sorted and subtotaled by product line and includes grand totals.

$ 400.00

Sales Commission Report    SO-122  (pdf 8 kb)
This report prints a commission report based on the AR Salesperson Commission files and selects records based on user-defined beginning and ending dates.  It creates a report that shows each invoice subject to commission.  The report is sorted by customer then salesperson and prints a new page for each salesperson.  It lists each Invoice, Invoice Date, Payment Date, Invoice Total, Invoice amount subject to commission, Invoice amount paid and Commission amount for the invoice.  The report includes subtotals for each customer, each salesperson as well as providing a grand total for all salespeople.  Please note that this report works only if the client has commission reporting selected in AR Setup and there is data in the AR Salesperson Commission files.  If a client runs the commission register and purges the data in those files this report cannot be reproduced.

$ 325.00

Customer Invoiced Sales Summary   SO-123  (pdf 5 kb)
This report prints the total quantity of each item invoiced to a customer through Sales Order for a specified time period.  The report lists the Item Number, Item Description, Sales Order units of measure and total quantity invoiced.  This report only prints if Sales Order is used for entry of invoices.  If AR Sales Codes are used to track sales then no data will be returned.

$ 325.00

Customer Sales Report by Ship to Location   SO-124  
(pdf 10 kb)
This report shows Sales information sorted by Customer and Ship-To Location. The report includes Invoice #, Invoice Date, Ship to Location and Invoice Amount for each Customer. The report provides a subtotal by Ship to Location for each Customer.

$ 350.00

Gross Sales by Customer and Product Line   SO-125  (pdf 5 kb)
This report lists Gross Sales by Product line for an inputted date range. The report is sorted by customer with columns for three Product Lines. The Product Line names within the formulas in this Crystal report must be edited to match the Product Line names used in your Sage MAS 90 setup.

$ 325.00

Cash Receipts Report by Salesperson  SO-126  (pdf 10 kb)
This report is a Cash Receipts report sorted by Salesperson. The report shows Salesperson #, Deposit Date, Deposit #, Customer #, Name, Ck #, Invoice #, Cash Applied, Discount and Balance of Invoice Due. This is a great report to help compute commissions for Salespeople who are paid upon payment of invoices.

$ 325.00

Sales Analysis by Customer - Sorted by YTD Dollars  SO-127 (pdf 5 kb)
Prints standard Sales Analysis (using PTD/YTD fields in AR) The report is sorted by YTD Dollar Sales per customer and includes the % of total for each customer.

$ 325.00

Sales Order Requirements Report - 15 weeks Out  SO-128
(pdf 9 kb)
Report breaks down requirements for items in a columnar form, every 7 days for up to 105 days from date of running report.  Also gives supporting detail at bottom of report.

$ 325.00

Open Order Flash Report    SO-129  (pdf 9 kb)
Open Order Report based on Order Date. Can be run with order detail, or just as summary. Includes Customer, Part Number, Description, Unit of Measure, Quantity Ordered, Price, Extension and Due Date. The report can be run in detail to show the above information or in summary, which shows only Order Date and Order Total.

$ 325.00

We will contact you shortly to complete your order, adding applicable sales tax and shipping costs.