Program Description
Sales History by Item can be found on the Billing Reports Sales Reports menu (BI-4-2-21). The purpose of the program is to access the Sales History by Item (SAHIST.DT) data file. This file stores information by fiscal month, and is updated at the end of the month when running the End of Month Field Clearing program. When the End of Month Field Clearing program is run, a fiscal month is entered. The SAHIST data file is then updated for the inputted fiscal month. The information stored in this file is the total sales and cost dollar amount and units sold for each month for each item found in the Item data file. The same information is also stored for each item found in the Item Warehouse data file. The End Of Month Field Clearing program transfers the sales and cost information to the SAHIST file, prior to zeroing it out of the Item and Item Warehouse data files. At the end of the year, the End Of Year Field Clearing program is run. This program transfers all of the 12 months of information found in the SAHIST data file to last year fields in the SAHIST file. The SAHIST file stores the current and last year total sales, cost, and units sold per month per item and warehouse.
Additional information from the Item (ITEM) and Item Warehouse (ITEMWHD) data files are now transferred to the SAHIST file. This occurs during the End of Month Field Clearing program. This includes the current on hand, on order, allocated, and back ordered quantities from the Item file for warehouse 1 and the Item Warehouse data file for all other warehouses. Also written to the SAHIST file is the current average and last cost and pack multiple from the Item data file. When a new SAHIST file is created, the system date now is written to the file as the date added. The additional fields provide the inventory status of an item per warehouse as it was at the end of a month, which is the ending for that month and the beginning for the next month. This greatly aids in finding any inventory discrepancies. Using these figures with the Inventory Transaction file (IMWACTD) and the Sales History File (SHHIST), you will be able to track every movement of an item.
Rev 13 Changes
Internal program changes were made to correct the Divide By Zero or Other Arithmetic Error stop when calculating the percent profit for large numbers.
Inputs were also corrected so that a return in the last field will bring the cursor back to the beginning.
Also, when entering Shift-6 (^) to return to a previous field, the screen will clear correctly.