I/C Sales Statistics Screen

To open this screen

Open Inventory Control > I/C Statistics and Inquiries > Sales Statistics.

Fields and controls

Item Number

Specify the item number for which you want to add, edit, or view sales statistics.

Location

Specify the location code for which you want to add, edit, or view sales statistics.

Year and Period

Specify the year and period for which you want to add, edit, or view sales statistics.

Table

Amount

Enter the amounts for sales and returns for the statistical period. If you use multicurrency accounting, enter amounts in your company's functional currency.

Cost

Enter the cost of goods sold and returned for the statistical period. If you use multicurrency accounting, enter amounts in your company's functional currency.

Count

Enter the number of sales and returns transactions that occurred during the statistical period.

Margin

Inventory Control calculates the margin and displays the amount. Margin is calculated as:

(Sales amount - Sales cost) - (Returns amount - Returns cost)

Quantity

Enter the number of items sold and returned (in stocking units) during the statistical period.

Overview

Use the I/C Sales Statistics screen to:

• View sales and return statistics for inventory items.
• Enter sales and return quantities and amounts for the years and periods for which you keep data in Inventory Control (if you selected the Allow Edit of Statistics option on the Processing tab of the I/C Options screen).

If you want to use the I/C Sales Statistics report to assist you in managing your inventory, use the I/C Sales Statistics screen to add sales and returns data for your inventory items during setup.

You can add sales data for reporting periods from the current year and from previous years. After setup, Inventory Control automatically updates these statistics when you run Day End Processing. If you select the Allow Edit Of Statistics option on the I/C Options screen, you can edit the statistics as needed.