Sample Reports
Stonefield Query comes with several pre-defined reports and labels. These reports are automatically added to your list of reports the first time you run Stonefield Query. You can delete any you don't wish to use. To re-add a pre-defined report you've deleted, choose the Import function, move into the Reports subdirectory, and select the desired report.
Please contact us to suggest new reports.
Reports
AR Open Invoice: Listing of current open receivables.
AR Revenue Report: This report displays the total revenue generated for each item shipped during a selected period of time by customer.
Inventory On-Hand Report: This report shows the on-hand amounts for each item by warehouse.
Most Profitable Customers (Profit Amount): This report displays the most profitable customers based on the profit amount.
Most Profitable Customers (Profit Margin): This report displays the most profitable customers based on the profit margin.
Most Profitable Items (Profit Amount): This report displays the most profitable items based on the profit amount.
Most Profitable Items (Profit Margin): This report displays the most profitable items based on the profit margin.
Top 10 Sales by Item Annually: This report shows the top 10 sales by item based on order quantity in a given year.
Top 10 Sales by Item Monthly:: This report displays the top 10 sales by item based on order quantity in a given month.
Top Sales by Company: This report shows the top sales by customer for a specified time period.
Top Sales by Item (Order Qty): This report shpws the top sales by item based on the order quantity.
Top Sales by Item (Total Sales): This report shpws the top sales by item based on the total sales.
Labels
Company Mailing Labels: This label prints the company name, contact name, two lines of address, and city/state/zip for customers.
Contact Mailing Labels: Similar to Company Mailing Labels except the contact name appears on the first line rather than the company name.
Employee Mailing Labels: This label prints the name, two lines of address, and city/state/zip for employees.
Vendor Mailing Labels: This label prints the company name, contact name, two lines of address, and city/state/zip for vendors.