INVENTORY CONTROL SUMMARY

 

COST CATEGORY FM

Cost Categories are used to tie inventory transactions to the General Ledger module.  You may wish to have different GL account #ís for two different types of sales, production and prototype for example.  Cost categories are also used to sort reports.

 

PRODUCT CATEGORY FM

Product categories are used to group like inventory items.  Inventory and sales reports can be sorted by both product and cost categories.

 

RAW MATERIAL FM

All raw material is defined in the Raw Material File Maintenance.  Full description lines are available as well as gauge and width minimums/maximums.  Material can be defined as a certain type; roll, coil, bar etc.   Reorder points and reorder quantities and leadtime are setup here.  Four different cost fields are maintained for each material.  There is a separate cell for quantity on hand and quantity on hold, which is material that is currently not useable due to quality reasons.  Users can view other information about the material such as: where used, open lots, po history, and free form messages.

 

INVENTORY FM

Inventory File Maintenance is used to define finished goods, components, and packaging.  Engineering dates and levels are maintained here.  Reorder points and reorder quantities and leadtime are setup here for purchased components.  Four different cost fields are maintained for each item.  There is a separate cell for quantity on hand and quantity on hold, which are finished goods that cannot be shipped due to quality reasons.  Users can view other information about each item such as: where used, sales history,  router, bill of material, current releases, and free form messages.

 

CRITICAL ITEMS REPORT

Report that compares the quantity on hand to the reorder point and lists those items that are within the percentage selected.  Useful for those companies that are not utilizing the MRP module for their material ordering.

 

INVENTORY ACTIVITY REPORT

Listing showing quantity, sales, cost, and gross profit for this month, this year, and last year for each inventory item.

 

INVENTORY HISTORY

Inquiry screen and report that provides a full audit trail to determine how a certain quantity on hand occurred.   Each inventory transaction is maintained in the history file and the report can be run for only selected transactions to provide a multitude of information for all different types of departments.

 

INVENTORY LOT INFO

Lookup of all of the individual lotís for each inventory item along with location, if lot control is implemented.

 

PO RECEIPTS

Items received into inventory are entered in this screen.  Items can be received with or without a Purchase order.  The items can be purchased material, components, work-in-process from outside processors, or miscellaneous goods.  Receipt of items automatically creates a receiver that can be matched to the Accounts Payable invoice during entry.   Users also have the ability to utilize wireless scanners during the receipt process.

 

INVENTORY ADJUSTMENTS

Entry screen used to make quantity adjustments for raw or finished items.  Adjustment reasons are recorded and stored in history.

 

ON-HAND VALUATION REPORT

Provides a total value of your on-hand or on-hold inventory, including raw, work-in-process and finished goods.   Cost can be selected at report generation to either use average, last, standard, or frozen standard cost.

 

WORK-IN-PROCESS

Work-In-Process allows the user to view total quantities at each operation.  Adjustments can also be done to these quantities. A job in process is defined by the router # plus the operation #, which represents a reporting point in the router.

 

PROCESSING DATE

Screen used to change the processing date for this module.   The processing date represents the date you are currently working on, whether itís the current date, a past date or a date in the future.

 

SUPPLIER RECEIPT LISTING

Report showing all receipts within a specified time frame.  Can be sorted by vendor, part#, po#, or GL account#, as detail or summary.

 

BAR CODE RECEIVE LABELS

On-demand internal labels for receipts.  Simply enter the purchase order number (if used) and/or the part# and all of the required information is pulled from the data files.  Convenient search windows allow you to locate any number.  Internal labels are serialized so one scan of serial number tells you everything about the item.

 

ROUTER SEARCH

Allows you to search the routers for a particular machine, material, process,  tool, die or message.   All routers that match the criteria will display and each individual item can be expanded to see all details about the job, including bill of material.  Extremely helpful when answering questions such as:  What jobs run on this machine?  Which jobs use this material?  How many jobs go through this process?

 

SLOW MOVING INVENTORY REPORT

Listing showing the usage of each item over the last 3 months and the last 12 months to determine whether the material is obsolete.  Report also gives a total cost of your usage in 0-3 month, 3-6 month, and over 6 month buckets.

 

RECEIPT HISTORY

On-line ability to review a posted inventory receipt either for raw material or work in process from an outside vendor.

 

PHYSICAL INVENTORY MENU

 

STATUS UPDATE

Everyday inventory processing can continue during the physical inventory process. The system will keep track of everything coming in and going out after youíve done your count.  Run this status update when you know your counts and you want the system to start keeping track.  The physical counts can also be imported directly from the handheld scanners.

 

PHYSICAL COUNT SHEET PRINT

Prints all active inventory items on a form with boxes so that the counts can be recorded if not using a tag inventory.

 

DATA ENTRY

If the handheld scanners are not utilized for the physical inventory, the data entry screen is used to manually enter each count.

 

TRANSACTION LISTING

Edit report to verify your physical counts before updating.

 

EXCEPTION LISTING

Useful tool that will list all inventory items that a count was not entered for.

 

VARIANCE REPORT

Lists each inventory item that has a difference in the booked value and the physical value.  Gives a total amount of the difference so gain/loss can be booked.

 

TRANSACTION UPDATE

Updates the physical count and adds or subtracts the total transactions that occurred since the Status Update.  Option to either enter a count for every item or assume that if there is no entry, item should have a zero count.

 

STATUS CLEAR

Signals completion of physical inventory.