Inventory > Setup > Inventory Sales Quantity History

Inventory Sales Quantity History

You use this program to capture details of quantities sold for a stock item over the last 12 months, as well as additional sales history information.

You normally use this program when converting from a manual inventory system to a computerized one where you need to take on sales information for your existing stock items.

Inventory Initial Sales Quantity History

Field Description
Stock code Enter the code of the stock item for which you want to maintain sales quantity history.
Quantity History Take-on Select this to capture the sales quantity history for the selected stock item.

Inventory Sales Quantity History Take-on

Field Description
Stock code This indicates the stock item for which you want to capture sales quantity history.
Warehouse This indicates the warehouse for which you want to capture sales history for the selected stock item.
History from last month back 12 months  
Month 1 - 12 Indicate the quantities of the stock item sold in each of the last 12 months.
Sales History Select this to capture additional sales information for the stock code. This information is maintained automatically by the system.
Save

Select this to save your entries.

The system will check that the maximum number of decimals allowed for the stock item (Stock Code Maintenance) is not exceeded. You can either re-enter the quantity or allow the program to truncate your entry to the permitted number of decimals.

Sales History

This screen is displayed when you select the Sales History function.

Field Description
Date of last sale Indicate the date on which the item was last sold.
Date of last purchase Indicate the date on which the item was last purchased.
Year-to-date usage value

Indicate the annual usage value of the stock item.

[Note]

For a new warehouse (where the stock item has been on file for some time) your entry here should reflect the value of the stock item according to the number of months the stock code has been on file.

This information is used by the ABC Analysis program to classify a stock item according to its annual usage value.
Year-to-date sales value Indicate the annual sales value of the stock item.
Previous year sales value Indicate the sales value of the stock item for the previous year.
OK Select this to accept your entries.
Cancel Select this to ignore any changes you made and to return to the previous screen.