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 Costing modules.
- When used as a stand alone inventory module, no other software or modules are required.
- Transactions from the AccountPro
Invoicing 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 ID (to 999) when entering stock
transactions, transfers between branches, and in the
Invoicing 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 cycle counts
- 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 issued to
Equipment Maintenance
- Inventory returned from
Equipment Maintenance
- Automatic Inventory updating from the
Invoicing module
- Inventory warehouse location
- Multiple 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 Stock Location
- Inventory Costing
- 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:
- M = Manually
- A = Average
- L = Last Cost
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
- Cycle Count Audit Report
- Minimum stocking quantities desired
- Maximum stocking quantities desired
- Replacement method (4 options)
- 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 picking list for stock issued.
- Prints a proof list of all transactions entered.
- 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