The Reports and Prints Submenu contains numerous reports with various options and parameters for selecting the report in a format most desired. For example, most reports allow printing an item, alphabetic, vendor or item class order. Additionally, the range of items, etc. maybe specified.
Most inventory reports have the option of printing in item, alpha, item class or vendor order. In addition to the order, the user may choose the range to be printed. For example, if the order selected is item number, field of the beginning and ending item number is required.
These programs are on the Inventory Control reports submenu.
The Stock Status Report provides a report listing the on hand quantity of each item, the value (cost) of the item and extension giving the total valuation of each item. The report may be printed by warehouse giving the value of each warehouse. The value (cost) may be selected when printing the report. Therefore, the user may see the value of a warehouse based on the standard, average, last or manual cost. You have the ability to cost serial and lot items by the system cost (costing method for the module). The feature provides for GAAP compliance. For the FACTS SO, IC and MC modules, you can decide if the cost for serial and lot items will be averaged actual (as it has always operated in the past) or system cost (costing method for the module). The default setting for each Static Control F/M is A-Averaged Actual (same behavior as they have before the monthly is applied). Users who want to take advantage of this change will need to change the option to S-System Cost for each of the applicable modules. The net result of selecting S-System Cost is that serial/lot items will be costed like non-serial/lot items. The results of this program are affected by this selection. An asterisk (*) indicates the on hand and committed quantities are insufficient to meet the committed and backordered requirements.
In the three formats, item and report totals and the total number of items listed are printed. If the print order selected is vendor, the report prints item class totals within vendor and vendor totals. If the print order selected is item class, the report prints vendor totals within item class and item class totals.
The Surplus Stock Report provides a report listing all items at or above their maximum stocking levels. The available quantity is defined as the on hand minus committed quantity. The surplus for order point/line point is defined as the available less order quantity plus line point. The surplus for min/max is defined as the available minus maximum stock. The Months of Surplus is the surplus stock divided by the average monthly usage. It represents the number of months you should expect to go before you sold all surplus stock.
The Item Sales Report provides a report listing sales based on the accumulated sales history stored for each item or item by warehouse. The report includes month-to-date, year-to-date, and prior year figures in unit or dollar amounts.
The Inventory Turns Report provides a report listing the number of inventory turns per item and provides warehouse totals. Inventory turns are calculated as the unit sales divided by the average on hand. Turns equals total cost (usage times (x) average cost) for 12 periods divided (./.) by average value (average beginning on hand value) for 12 periods.
The Movement Class Report provides a report listing item by warehouse code in movement class order. The movement class is determined by the percentage of sales of the item in the last year.
The Seasonal Item Report provides a report listing seasonal items along with usage information. There are two types of seasonal items: low seasonal is an item that has 80% of its annual sales within six consecutive periods; high seasonal is an item that has 80% of its annual sales within three consecutive periods. The report prints seasonal items along with seasonal information. The report may also recalculate seasonality of items and optionally reset the seasonality flag in the warehouse/item file.
The Warehouse/Item Listing provides a report listing all items assigned to each warehouse. On hand, on order and committed quantities may be included. This listing is especially useful for verifying stocking information after the initial warehouse setup. Items entered into the warehouse/item file through the Warehouse Item F/M or the Create Warehouse/Item Records programs are available for printing. Report information includes: General--item number and description(s), stocking unit of measure, movement class (1-12, 13=dead stock, 14=not set), seasonal item flag (Nonseasonal, Low, High), warehouse location, date created in warehouse, last and next physical dates, and whether ledgercards are stored and Receipt--item number and description(s), movement class (1-12, 13=dead stock, 14=not set) and seasonal item flag (Nonseasonal, Low, High). For each receipt, the received quantity, stocking unit of measure, received cost, costing unit of measure, date received, lead time and lead time status (Abnormal=causing a greater than 50% change in average lead time, Ignored=disqualified by user in average lead time calculations, blank-normal).
The report also includes the total number of items listed.
The Item Ledgercards Listing prints a list of the transaction types chosen that have affected the item’s on hand quantity. Warehouses may be selected.
The Item Listing provides a report listing all items in the inventory file, along with specific information regarding each item. The user may print either package (units of measure, conversion factors, etc.) or general (item class, alpha sort, etc.) information. Report information includes: general information about each item including item number and description, stocking unit of measure, standard pack, alpha, vendor, item class, sequence number, vendor-item number, general ledger posting table, freight class, commission percent, date created, taxable flag, update inventory flag, serial/lot flag, manufactured flag (Bill of materials, Formulation and Neither) and miscellaneous sales flag and packaging information about each item including item number and description, units of measure, conversion factors, standard pack and weight per the smallest, 2 and 3 units of measure.
The Substitute Item Listing provides a report listing each item and its substitute items. Substitute items are maintained through the Item F/M program and may be used in sales orders as a substitute (replacement) when the item ordered is not available. Substitute items are maintained through the Item F/M program and may be used in sales orders as a substitute (replacement) when the item ordered is not available. For each item, the report provides item number and description, substitute item(s) and description(s) and total number of items listed.
Item Interchange Listing prints a list of all item interchange numbers. The item interchange file is a storage place for interchangeable or superseded part numbers listed for one stock item. The item interchange file is a storage place for interchangeable or superseded part numbers listed for one stock item. It might be used to store customers’ own part numbers to access your numbers when sales orders are entered. It might also be used to identify your own numbers using user-defined codes. For each item, the report provides item number and description; corresponding interchange item(s) and memo(s); and total number of items listed.
The Catalog Item Listing allows listing of catalog items to be printed. Catalog items are items that are provided by a vendor but are not stocked.
The Safety Allowance Reset may be used to recalculate and update the safety allowance. Initially, all items are assigned the standard safety allowance percent. However, after 12 periods of usage has been maintained the standard percent may be too high or too low depending on individual item usage and the amount of safety stock used. The system contains a default safety allowance percentage (%), which is set in the IC Static Control F/M. Initially, it defaults to 50%. That safety allowance percent calculates the safety stock.
The safety stock is inventory that ideally is never sold but rather is stored as a precaution against running out of stock due to a variance in anticipated lead time or usage when replenishing the item. Each item’s safety stock amount is calculated from the safety allowance %. Many items may dip into the safety stock due to variances in lead times, etc. However, if safety stock is never used, it has a turn ratio of zero. The cost of stocking a 50% safety allowance may not be necessary on all items. Some items may never dip into the safety stock. Therefore, it may be cost effective to lower the safety allowance % on these items. Other items may dip into the safety stock more often, resulting in stockouts (no stock on hand). For these items, It may be cost effective to raise the safety allowance on these items.
The Safety Allowance Reset program enables you to recalculate the safety allowance % based on 12-month usage rates. If the item in the warehouse does not have usage rates for the last 12 periods, the program skips this item.
The Vendor Review Cycle Reset may be used to recalculate and update the vendor’s review cycles. Initially, you establish the vendor review cycle. However, after the system maintains 12 periods of purchasing, the review cycles may be too high or too low depending on the total purchases and buying target ($) you set for each vendor. The optional update allows you to reset the current with the recommended cycles as displayed on the report.
The vendor review cycle is the amount of time between dates that a vendor is reviewed for replenishment in order to meet buying targets. For example, if in order to receive a discount there is a minimum purchase amount, that minimum should be met each time you order from the vendor. The review cycle determines when orders should be placed in order to take advantage of the discount.
The review cycle formula is as follows:
Review cycle = 360 days/number of reviews per year
(reviews per year = total annual cost/buying target $)
This reset determines the buying target in dollars only. Buying target pounds are not used.
The vendor review cycle is used to print the Vendor Review Dates Report.
The Item Label Print program allows labels to be printed from the information stored in the item file. Each label includes the item number and description. Optional information includes the unit of measure, standard pack, item class and location. Label information includes: item number and item description and optional information includes unit of measure, standard pack, item class and location. The program prints on 4-up 3.3 x 15/16 labels. For more information see the forms section in the PIA Manual.
The Bar Code Label Print program prints bar code labels of item numbers. Since there are different types of bar codes, make sure the printer uses the bar code standard needed. The hex code for bar code on and off must be set up in the Printer F/M program. The program prints on a 1-up 5 x 1 label. The program prints item number, description, stocking unit of measure and the bar code for the item number.
The Item Balancing Register resets quantities for on-hand, on-order, committed, backordered, and LIFO/FIFO cost layers. It needs to be run only if quantities become out of balance due to a system malfunction or user error. The register first prints all out-of-balance items, then offers an optional update to reset the quantities to match the printout. Only run this program only if any quantities in Sales Orders, Purchase Orders, Or Inventory are out of balance.
The IC Code List prints a listing of the various IC codes including item classes, item price classes, general ledger posting tables, adjustment codes, unit of measure codes, and warehouses. Each type of code is created and maintained in its own file maintenance program. Most are used in the item file. The adjustment code is used for making inventory adjustments. Report information includes each code, the information stored with each of those codes and the total number of codes listed.
Resetting Movement Classes
To reset movement classes, the system takes each item (per warehouse) and multiplies the last 12 periods of usage by the unit cost. The totals for each item are then sequenced in order with the best items (most dollars moving through inventory) at the top of the list. Each item is then assigned to a class based on the following:
Top 7 ½% of the items - Class 1
Next 7 ½% - Class 2
Next 10% - Class 3
Next 10% - Class 4
Next 8% - Class 5
8% - Class 6
8% - Class 7
8% - Class 8
8% - Class 9
8% - Class 10
8% - Class 11
Last 9% - Class 12
0% - Class 13 (Dead Stock)
0% - Class 14 (Unassigned)
100%
Movement Class is calculated for an item based upon six months of history for the item and warehouse. Items that do not have six months of history may be included or excluded from this report. If these items are included, then the known usage of these items is averaged and extrapolated over twelve previous months (based on the current date).
Movement Class Recalculate
When the Movement Class Report is selected with the option to recalculate, the user has the option to specify the number of months of usage to exclude. Any item that does not meet the specified number of months of usage is excluded from the recalculation.
For item with usage greater than or equal to the specified months but less than 12 months, an average for the known usage is taken and extrapolated across the months not known (up to 12 months). The known and extrapolated monthly usage will be added for the annual usage needed to recalculate the movement class.
• Items in Class 13 (Dead Stock) remain in Class 13.
• Items in Classes 1-13 which do not have the specified number of months of usage in ‘Exclude New Items’ are moved to Class 14 (Unassigned) and print on this report.
• Nonstocked and uninventoried items are moved to Class 14 and print on this report.
Blank usage for a month is considered as a month with NO usage history. Zero usage for a month is considered as a month with usage history of zero.