maso100
Salesperson Sales Order Recap - Invoiced Sales Order Only
This report provides a
listing of all credit card deposits on Sales Orders sorted by Sales Order
Number. The report also includes Sales
Order Date, Customer #, Bill to Name, Cardholder Name, Card #, Expiration Date,
Authorization # and Deposit Amount.
maso101
Salesperson Sales Order Recap - Invoiced Sales Order Only
Produces a report of
invoiced sales for one salesperson between specified beginning & ending
sales order dates. Report is sorted by
sales order number.
maso102
Sales Order History Report by Sales Order #
Shows Sales Orders by Order Number
with Items on S.O. and lots of related information.
maso103
Sales Order History Report By Salesperson
This report produces a
detailed list of active and completed sales orders by salesperson for a range
of sales order dates. It includes regular, special and miscellaneous line items
associated with each order, specifies whether the items have been shipped or
back ordered, and identifies the price, discounts applied, freight and sales
tax. Orders are subtotaled by salesperson.
maso104
Quantity Ordered - By Item By Month
Shows total quantity ordered
by part number to estimate future demand for products.
maso105
Open SO Report by Warehouse
Produces report of open
sales orders for a specified warehouse sorted by order number.
maso106
Backorder Report by Invoice Date
This report produces a list
of invoiced backorders for a range of specified dates.
maso107
Invoice Gross Margin using Standard Cost
This report calculates
Margin % and Gross Profit $ on invoice detail lines using standard cost
regardless of inventory valuation method. The report may be used to determine
whether pricing to customers is sufficient and/or overpriced by examining the
margin percentages. Note that the Total
for Invoice Extension does not include miscellaneous charges and the page
header doesn't appear on the drill down.
maso108
Quantity Shipped Report by Item
This report demonstrates a
customer's buying pattern for inventory items. It produces a list of items
purchased by customer for a specified time period. It may also be used to view
what items a customer purchases, the customer's demand for a particular
product, and the cycle in which they purchase these items.
maso108a
Quantity Shipped by Salesperson, Customer and Item
This report demonstrates a
customer's buying pattern for inventory items. It produces a list of items
purchased by salesperson, customer and item for a specified time period.
It may also be used to view what items a customer purchases, the customer's
demand for a particular product, and the cycle in which they purchase these
items.
maso109
Commission Based on % off List Price using Table for Rates
This report uses a different
commission rate depending on the percentage of difference between list and
sales price. The report also establishes different commission rates depending on
product line. The report is designed to reward salesmen by increasing their
commission when they sell at lower discounts.
maso111
Monthly Sales Recap - By Product Line & YTD Gross Profit - All Warehouses
An excellent management
report highlighting Period to Date and Year to Date Sales, Gross Profit and
Gross Profit Percentage for the top 4 product lines. The report sorts the
product lines by highest product line YTD Sales Dollars. The report includes
three graphs: A bar graph comparing YTD Sales with Gross Profit by product
line. Two pie charts, one showing YTD Sales by product line and the other
showing YTD Gross Profit by product line. Note: This is the same report as maso112
except sorted by YTD Sales instead of YTD Gross Profit. Both reports are
available for a package price of $750.
maso112
Monthly Sales Recap - By Product Line & YTD Gross Profit - All Warehouses
An excellent management
report highlighting Period to Date and Year to Date Sales, Gross Profit and
Gross Profit Percentage for the top 4 product lines. The report sorts the
product lines by highest product line YTD Gross Profit Dollars. The report
includes three graphs: A bar graph comparing YTD Sales with Gross Profit by
product line. Two pie charts, one showing YTD Sales by product line and the
other showing YTD Gross Profit by product line. Note: This is the same report
as maso111 except sorted by YTD Gross Profit instead of YTD Sales. Both reports
are available for a package price of $750.
maso114
Highest Margin Report by Item
This report provides a
listing by Item Number, sorted by highest Gross Margin percentage. The report
includes Item Number, Description, Quantity, Total Dollar Sales and Cost of
Sales amounts as well as Gross Margin Percentage. You enter a beginning and
ending date for the report to pull information. This is a great report to see
what items are providing the highest Gross Margins and the Dollar Sales
associated with that Gross Margin.
maso115
Highest Sales Volume Report by Item
This report provides a
listing by Item Number, sorted by highest Dollar Sales amounts. The report
includes Item Number, Description, Quantity, Total Dollar Sales and Cost of Sales
amounts as well as Gross Margin Percentage. You enter a beginning and ending
date for the report to pull information. This is a great report to see what the
Gross Margins are for your best selling items in terms of Dollar Sales.
maso116
YTD Actual Sales - By Salesperson - By Month
This report runs YTD Sales
by Salesperson for each month. The
report gets its data from A/R invoice history and groups invoice totals by the
original salesperson on the invoice. It
can be run for any period 1-12, assuming a calendar year) and for any
year. Any future months are suppressed.
A great report for analyzing and comparing salespeople on your sales force.
maso117
Current Year vs Prior Year Sales Comparison by Salesperson
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 ran for any date.
maso119
Sales Analysis by Customer Type - PTD & YTD by Item
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.
maso120
Sales Dollars by Product Line by Period
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.
maso121
Sales Quantities by Product Line by Period
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.
maso122
Sales Commission Report
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.
maso123
Customer Invoiced Sales Summary
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.
maso124
Customer Sales Report by Ship to Location
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.
maso125
Gross Sales by Customer and Product Line
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 MAS 90 setup.
maso126
Cash Receipts Report by Salesperson
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.
maso127
Sales Analysis by Customer - Sorted by YTD Dollars
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.
maso128
Sales Order Requirements Report - 15 weeks Out
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.
maso129
Open Order Flash Report
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.
maso130
Check Summary Per Customer
This report details cash
receipt payments by Customers sorted by Division and by Customer. The detail
shows Check Number, Transaction Date, Payment Date and Payment Amount. Payment
Amounts are totaled by Customer, Division and for all payments.
maso131
Item Sold per Customer for a Date Range
This report is an inquiry report that tells you the quantity of a give inventory part number purchased by a selected Customer for a selected period. To run the report, you need to input the Customer, Part Number, Beginning and Ending Date. This is a great tool for finding out the history of sales of a item for a customer.
maso131a
Item Sold for Inputted Customers for a Date Range
This report is the same as maso131 except it tells you the quantity of all inventory part numbers purchased by a selected customer or range of customers for a selected period. To run the report, you need to input the Customer or Customer Range and Beginning and Ending Date. This is a great tool for finding out the history of sales of a item for a customer.
maso132
Accounts Receivable Open Invoice Report
This report lists open
invoices by Customer and shows Invoice Number, Invoice Date, Due Date, Original
Invoice Amount, Payments to Date, and Balance due. A great report for analyzing your Accounts Receivable.
maso133
Sales Recap by Salesperson, Customer and Supplier
This report provides summary
information by customer to help identify high volume, high dollar customers.
The report sorts by customer number and includes columns for Gross Profit
Dollars, # of Invoices, Average GP per Invoice, Total Items Shipped, Average
Items per Invoice and Average GP per line item.
maso135
Sales History Report By Month
This report lists each
customer’s monthly sales from both the AR & SO modules for the current
& previous years. It sorts customers by the highest to lowest total sales
for the current year.
maso137
Sales History Report by Customer
This report shows Sales
History by Customer for any two years specified. The report includes all
Invoices, Debit Memos and Credit Memos from Sales Order and Accounts
Receivable. This Report is great for looking at sales trends.
maso138
Sales History Report by Customer & Salesperson
This report shows Sales
History by Customer and Sales Person for any two years specified. The report
includes all Invoices, Debit Memos and Credit Memos from Sales Order and
Accounts Receivable. This Report is great for looking at sales trends.
maso139
Sales Account Analysis
This report provides a
detail of all sales transactions for Misc Charges (Type 6) Regular Items (Type
4), Misc Items (Type 8) and A/R Sales Codes (Type1) that were charged to Sales
and Cost of Sales Accounts in the ARO file. The report lists the Customer
Number, Customer Name, Invoice Number, Line Type, Invoice Date, Sales Order #,
Unit Price, Quantity, and Amount. When running the report, you input the
Customer Number, Start Date, End Date, Beginning G/L Account and Ending G/L
Account.
maso141
Sales History By Customer By Month By Item
This report is similar to
the MAS 90 standard Inventory Sales History Report. This report is sorted by
Customer or Customer/Ship-to. The report lists quantity and dollars by
month. You can input a range of years, choose only Dollars, only Quantity, or
Dollars and Quantity.
maso142
A/R Customer Sales Analysis
This report is similar to the Customer Sales Analysis included in MAS 90 standard reports except it is missing the Cash Receipts column and has a prompt for the prior year date range. The report then pulls the PTD and YTD Sales Dollars from the Customer file and then creates a sub-report based on the date range, to come up with the 2nd Prior Year numbers. This way you can compare 3 years Sales, Cost of Sales and Profit Percentage at once.
maso143
Quantity & Dollars Sold by Customer by Product Line by Item
This report is an inquiry
report that tells you the quantity of all inventory part numbers purchased by a
selected customer or range of customers for a selected period. To run the
report, you need to input the Customer and Product Line. This is a
great tool for finding out the history of sales of a item for a customer.
maso144
Open Orders for Management
This report provides the Open
Orders for a particular time, based on the Ship Date within each Sales Order
entered. This report is sorted by Sales
Order Number and Item Number. The
report will prompt the user for a Beginning and Ending Ship Date. At the end of each sales order on the
report, the user will also find the Accounts Receivable Information as provided
in the Accounts Receivable Customer Master File.
maso145
Salesperson Commission with Product Line Detail
This report shows sales
information by salesperson sorted by invoice number. The report details Invoice
Date, Commission Rate, Invoice Total, Amount Subject to Commission, Gross
Profit and Commission Amount. You input a date range to generate the report.
maso146
Sales Order Recap Report
This report will list Sales
Order information for a range of Customer Names. You can select on of four sort
options: Customer Name, Order Number, Order Date or Customer Number. The report
shows Order Number, Order Date, Customer Number, Customer Name, The Comment
Field, Customer PO # and the Order Dollar Total.
maso147
Sales by Product Line and Item with Graphs
This report shows Current
and Prior Year Unit and Dollar sales for inventory items only. Sorted by
Product Line and Item with graphs on report header for Current and Prior Year
unit and dollar sales. User is prompted for years.
maso149
Sales History by Customer PTD, YTD Current & Prior Yr
This report is a breakdown
by Division by Customer showing history of items sold for an inputted period
and year. The report returns Current PTD Dollars, Prior PTD Dollars as well as
Current YTD and Prior YTD Dollars.
maar150
Sales Aging Summary Report by Cust or SalesPerson
This report is a summary AR
Aging report that has the option of being sorted by Customer or Sales Person.
It shows Customer, Sales Person, Total Balance, Past Due Balance, Current, Over
30, Over 60 and 90 and Greater.
maar151
Sales Aging Summary Report by Past Due Balance
This report is a summary AR
Aging report that is sorted by Past Due Amount. It shows Customer, Sales
Person, Total Balance, Past Due Balance, Current, Over 30, Over 60 and Greater
maar152
Sales Code Summary By Cust & GL AC
This report is used for
companies utilizing AR Sales Codes. The report prompts for Beg and End Date and
a range of Account Numbers. The report will return a summary of all sales
charged to the inputted Account Number Range showing Customer Name, Customer #,
Sales Amount and % of Total Sales.
maar154
Sales History by Customer by Item for PTD,YTD Curr & Prior Yr $ & Units
This report is a breakdown
by Customer showing history of items sold for an inputted date. The report
returns Current Period Dollars and Units, Year to Date Dollars and Units as
well as Total Prior Year Dollars and Units. This report is available for Fiscal
Years and can be modified for calendar years.
maar154a
Sales History by Sales Code for Current Pd, Prior Yr Pd $ & Unit
This report is an
extension of AR 154. It shows a breakdown by Salesperson and Customer showing
history of items sold for an inputted date and sales code. The report returns
Current Period Dollars and Units, Prior Year Period Dollars and Units, Current
Year to Date Dollars and Units compared to Prior Year to Date Dollars and
Units. The report also shows Total Prior Year Dollars and Units. This report is
available for Fiscal Years and can be modified for calendar years.
maar155
Customer AR Summary Report
This report prints one line
per customer showing Customer#, Customer Name, Salesperson #, AR Balance and
Credit Limit. The report also shows if the Customer is on Credit Hold. This is
a great report for quickly seeing the status of all customers including those
with no AR balance.
maar156
AR History w/ Item
Description by Customer, Date, and State ranges
This report provides a
history of invoices by a range of Customers, Dates and States. It shows Invoice
#, Invoice Date, Customer PO # Item Descriptions and Invoice Total.
maar157
AR Aging by Past
Due or Invoice Date
This is a A/R Aging Report
where you have the option of aging by Due Date or Invoice Date. The report is
grouped by Customer and Division. It shows the Division, Inv Date, Due Date and
Current, 30, 60, 90,120 day and over amounts.
The report also shows the days outstanding.
Copyright © 2004 by CrystalReportsLibrary.com, Inc.