BW Modules:
Inventory Control & Purchasing
2055 Carolyn Sue, Baton Rouge, LA 70815
225-923-1985 • fax: 923-3515
The Role of Inventory Control and Purchasing
The BusinessWorks Inventory Control and Purchasing module provides important information about each inventory item that would be practically impossible to obtain without a computer. In addition to keeping track of receipts, issues and adjustments, BusinessWorks maintains complete information for 99 warehouses and an unlimited number of serial numbers and parts. Inventory Control can even make order recommendations when the quantity of an item falls below a specified level.
Inventory Control Specifications
Inventory Control Features
- Tracks back orders if used in conjunction with the Order Entry module
- Assigns parts to sales promotions for use with the Order Entry module
- Provides complete physical inventory capabilities and makes the processes easy by providing worksheets and variance reports
- Provides instant inquiry of part information including: receipts, issues, returns and adjustments
- Imports part information from the Accounts Receivable module or from a text file
- Can import pricing information for parts
- Inventory Control information can be exported using over 30 different formats including Lotus 1-2-3, dBASE, Comma-Separated Variable, ASCII, Access, Excel, Word, Word Perfect, Quattro Pro and many others
- Allows you to post charges to the Job Cost module
- Automatically posts transactions to the General Ledger module
- Tracks quantities and history for up to 99 user-defined warehouses and provides a transfer option that allows parts to be easily moved between warehouses
- Tracks serial numbers for parts and indicates when parts are received, reserved and issued out of inventory
- Stores and displays images of your parts. Most standard graphic file types are supported including .pcx, .tif., .eps., .bmp, and .jpeg.
- Provides four costing methods: Standard, Average, FIFO and LIFO
- Maintains complete information for each inventory part, including on-hand backorder and on-order quantities, vendors, substitute items, components and transaction history for up to 60 months
- Provides three lines of part description
- Tracks minimum and maximum stocking levels for each part
- Provides “model” parts for easy addition of new parts to inventory
- Supports fractional costs, prices and quantities for stock and non-stock items
- Provides five pricing methods (absolute, margin, markup, base and line) for each part and allows price differences by customer type (for example, retail or wholesale) and quantity of items purchased
- Quickly locates parts, product lines, purchase orders, accounts payable vendors and general ledger accounts with a search feature
- Maintains an unlimited number of location names to be used as part bin/locations
- Product lines allow classification of parts on inventory reports as well as determines the general ledger posting
- Allows 5 user-defined product categories to be assigned to parts to further describe parts (i.e. by size, style, color, etc)
- Up to five substitute parts can be assigned for each inventory part
- Allows global changes to multiple part records at the same time to expedite data entry
- Permits pricing information for parts to be updated automatically through the global price change option
- Vendor supply list shows vendors and manufacturers’ part numbers for each part
- Component use list shows which assemblies use a particular component
- Tracks sales promotions
- “Builds” components into finished items with the subassembly option: automatically adds built parts to inventory and removes components from stock
- “Unbuilds” or “unpacks” assembled parts: automatically adds components to stock and removes the on hand quantity of the finished items
- Automatically accesses vendor information in the Accounts Payable module and can add new vendors “on the fly”
- Allows adjustment of inventory costs after parts have been received
- Allows entry of receipts, issues, returns and adjustments
- Tracks purchase orders
- Allows comments and non-stock items on purchase orders
- Accounts payable invoices can be posted in inventory control at the time purchase orders are received
- Provides the ability to copy purchase orders
- Allows purchase order fields to be disabled to customize purchase order entry
- Allows purchase orders to be edited, printed and reprinted at any time
- Prints purchase orders on laser and dot matrix printers
- Allows cancellation of all or a portion of a purchase order
- Automatic purchase order option generates purchase orders to primary vendors based on order recommendations
- Receives partial purchase orders
- Accounts payable vendors and parts may be added “on the fly” in the purchase order option
- Returns can be posted via the purchase order returns option
- Recommends parts to order on the Order Recommendation Report
- Sorts reports by part number, part description, vendor, product line or bin location
- Numerous inventory reports provided to analyze inventory performance and help control your inventory investment
Inventory Control Reports
- Master Parts List
- Price List
- Cost List
- Substitute Part List
- Component Use List
- Subassembly List
- Vendor Supply List
- Vendor Report
- Open Purchase Order Report
- Closed Purchase Order Report
- Past Due Purchase Order Report
- On Hand Report
- On Order Report
- Overstock Report
- Low Stock Report
- Stock Status Report
- Inventory Performance Report
- Transaction Summary Report
- Margin Analysis Report
- Inventory ABC Analysis Report
- Order Recommendation Report
- Transaction Detail Report
- Receipts Transaction Register
- Issues Transaction Register
- Adjustments Transaction Register
- Returns Transaction Register
- Receipt Adjustment Transaction Register
- Physical Inventory Worksheet
- Physical Inventory Variance Report
- Bin Ticket
- List of Product Lines
- List of Promotions
- List of Locations
- Pick List
- Flash Report (summary of Inventory Control and Purchasing activity)
- On Hand Serialized Inventory Report
- Receipts Serialized Inventory Report
- Issues Serialized Inventory Report
- Returns Serialized Inventory Report
- Warehouse Stock Report
- Graphical Report - On Hand Value
- Graphical Report - Cost and Profit
- Graphical Report - On Hand Value Highlight
- Graphical Report - YTD Cost of Goods Sold
- Graphical Report - YTD Sales Highlight
- Custom Reports
- Report Groups