Adding Current Sales and Return Statistics
Adding or Editing Transaction 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.
- To edit sales data, you need security authorization for Day End Processing and/or Item Maintenance.
- If you use multicurrency accounting, enter amounts in your company's functional currency.