Inventory Sales Analysis

 

Window Details

 

How Do I...

Navigation

 

Create a Report Setting

Overview

 

Print a Report, Listing, or Form

Fields

 

E-mail, Fax or Print a Report as a PDF

Report Sample

 

Enter Multiple Values Using Separators

 

Related Topics

 

 

Inventory Management Options

Update FAQs

Fiscal Year Maintenance

 

 

 

Navigation

Select Inventory Management Reports menu > Inventory Sales Analysis.

Overview

Use Inventory Sales Analysis to list an overview of each item's sales performance and gross profit percentage. This information can help determine whether or not an item is profitable on a continuing basis.

The quantity sold and returned, dollars sold, cost of goods sold, gross profit, and percentage of profit can be detailed for each item by period to date, year to date, and prior year.

You can also select the most active and least active products in your inventory by sorting information by period-to-date, year-to-date, or prior-year dollars sold and selecting items for the corresponding periods.

You can enter a selection of item codes, product lines, primary vendor numbers, item descriptions, warehouses, bin locations, period-to-date dollars sold, year-to-date dollars sold, prior-year dollars sold, user-defined categories (if descriptions have been entered in Inventory Management Options), and user-defined fields (UDFs). By entering these selections, you can obtain a list of items that allows you to identify pertinent information.

Fields

 

Report Setting

Number of Days with No Sales

Description

Product Types to Print

Type

Print Inactive Items

Default Report

Procurement Types to Print

Print Report Settings

Period to Date

Three Hole Punch

Year to Date

Number of Copies

Prior Year

Collated

Warehouse Detail

Sort Report By

Operand

Print Condensed

Value

Fiscal Year / Calendar Year

Printer/Output

Accounting Period / Calendar Month

Keep Window Open After Print

Print Only Items with No Sales

Keep Window Open After Preview