Inventory Control Platinum overview
To assist in making purchasing decisions, purchase costs may be compared between vendors, including historical purchasing data which may be kept on file as long as required for every purchase made, including costs for items purchased and from which vendor.
- The module may be used as a Standalone Inventory Software module and optionally interfaced with the Purchase Order, Invoicing, Equipment Maintenance and Job Cost modules.
- When used as a stand alone inventory module, no other software or modules are required.
- Transactions from the AccountPro Invoice module, if installed, automatically update inventory quantities and do not need to be re-entered into the inventory module. User definable settings allow the bypassing of fields not required in the Inventory software module, for example, entry of manufacturers catalogue numbers.
- Multiple branches allow you to specify a branch (to 999) when entering stock transactions, transfers between branches, and in the Invoice module when entering orders.
- Branches may be identified as an actual branch, warehouse, truck, school, employee, etc.
- Charge stock against general ledger account and sub-account numbers, equipment, departments, jobs.
- Keep inventory cost control.
- Ability to track inventory by general ledger account and sub-account numbers.
- Supports warehouse locations, bin numbers.
- Track lot numbers and lot number details.
- Serial number tracking.
- Supports Cycle Counts.
- Standalone Inventory Control software module without requiring any other software.
- Integrates with other AccountPro modules if installed.
Inventory Control Detail Features
- Handles:
- Inventory cost statistics
- Loading of inventory quantities
- Inventory receipts
- Inventory issued
- Inventory stock transfers to or from Job Costing
- Receipts of inventory by customer
- Inventory issued for customer
- Inventory physical counts
- Inventory cycle counts
- Inventory issued to Equipment Maintenance
- Inventory returned from Equipment Maintenance
- Automatic Inventory updating from the Invoicing module
- Inventory warehouse location
- Multiple branch/bin locations per product
- Container number
- Serial number
- Lot number
- General ledger accounts for auditing and tracking inventory
- standalone inventory tracking software
- Facilitates grouping of items by class to control:
- Inventory quantities
- Cost of Sales
- Revenue
- Tax Rates
- Item Selection
- Report & List printing
- Display in pop-up windows
- Inventory Costing
- Inventory Stock Location
- Simplifying inventory management
- Tracks Low, High, Current, Last and Average Costs for each item.
- The item cost in the master database file may be updated manually, or automatically, using a number of options available in the module.
- Options to update Item Costs from Inventory Control Stock Receipts postings.
- Update Methods:
- L = Last Cost
- M = Manually
- A = Average
Item Detail
- Item details (partial listing) consist of:
- Item ID of up to 20 alphanumeric characters
- Class ID to 8 alphanumeric characters
- Group ID to 8 alphanumeric characters
- Branch ID to 3 alphanumeric characters
- Description up to 45 characters.
- 7 levels of Unit Pricing to $999,999,999.999999
- Calculates and displays margins for each of the 7 selling levels
- Unit Measures from 0.000001 to 999,999.999999
- Unit weight to calculated estimated shipping weight
- Supplier Catalog number
- Lot numbers to 20 alphanumeric characters
- Serial numbers to 20 alphanumeric characters
- Preferred Vendor ID to 12 alphanumeric characters
- Cost
- Unlimited alternate vendors, vendor catalogue numbers and costs
- Manufacturer ID
- Manufacturer product number
- MSRP - Manufacturer Suggested Resell Price
- Unlimited alternate manufacturers, manufacturer product numbers and MSRP
- UPC number
- Warehouse location or bin number
Assemblies
- The Assemblies option may be used to create assemblies or kits from any number of products (components of the assembly or kit) from the master product database. Entry of an Assembly ID into the inventory module will automatically update inventory with all of the components complete with component quantities as specified in the assembly, times the number of assemblies ordered.
Reports & Lists
- Inventory reports may be printed at any time and as often as required and are not dependent on period or month end closings
- A list of items in the master file may be sorted in a number of ways before printing.
- Allows for filtered reports and lists.
- The Suggested Re-Order Purchasing report shows current inventory items which are below the user defined re-order level. It also shows sub-totals of the Dollar value by Class, and total Dollar value required to purchase all items suggested in the report.
- Inventory report lists:
- On Hand quantities
- Minimum stocking quantities desired
- Maximum stocking quantities desired
- Replacement method (4 options)
- Cycle Count Audit Report
- Physical count report assists in taking an inventory count, eliminating the physical writing down of items and descriptions when doing an inventory count.
- Inventory may be printed by warehouse and shelve location for stock taking.
- Inventory Trial Balance report indicates Quantities and Dollar values with sub-totals by class.
- Maintains a detailed audit trail of all transactions.
- Prints a proof list of all transactions entered.
- Prints a picking list for stock issued.
- Warehouse inventory lists.
- Cycle lists may be filtered by branch, category, product, vendor and location.
Inventory Cost Statistics
- The Inventory module tracks purchased cost indicating, Low, High, Current, Last and Average Costs per item.
- Inventory cost statistics.
Optional Modules and Interfacing with:
Invoicing
- Postings from the optional Invoicing module will automatically update inventory quantities subject to setting the appropriate Yes/No option in the item master file on an item by item bases.
- Options to allow automatic updating of Item Costs in the Invoice module from Inventory Control Stock Receipts postings.
- Update Method:
- M = Update Inventory Costs Manually
- A = Automatically Update Inventory Costs by Average Costs from stock purchased
- L = Automatically Update Inventory by Last Cost from stock purchases
- Tracks Backorders from the Invoice software module.
- Supports posting to specified Inventory Branch ID from the Invoice module.
Job Costing
- Postings from Inventory to the optional Job Costing module will automatically update inventory quantities and Job Costing when posted.
Equipment Maintenance
- Interfaces with the optional Equipment Maintenance module to issue parts out of stock to specified equipment and update costing in the equipment maintenance module.
Bar Coding
Import
- Using the optional Import module, you can import customer, vendor and product lists from ASCII or CSV files.
Inventory Control add-on module