Inventory Software

The Inventory software module helps you track item usage and purchasing costs, and maintain inventory at optimum levels at set by management. 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.

• More Info and Pricing

The following is a summary describing some of the features of the AccountPro Inventory Control software module. Should you have further questions, please contact our office through one of the available contact options.

Overview

• The AccountPro Inventory Control module may be used as standalone module inventory management software and optionally interfaced with the Purchase Order, Invoicing, Equipment Maintenance and Job Costing modules. Interfacing with other AccountPro modules is automatic if installed and requires no additional setup.
• 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 catalog 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.
• Ability to track inventory by general ledger account and sub-account numbers.
• Supports warehouse locations, bin numbers.
• Track lot numbers and lot number details.
• Cycle Counts are supported in the Professional and Platinum versions.
• Charge stock against general ledger account and sub-account numbers, equipment, departments, jobs.
• Standalone Inventory Control software module without requiring any other software.
• Integrates with other AccountPro modules if installed.

Detail Features

• Handles:
  • Inventory cycle counts
  • Inventory costs 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 numbers
  • Serial numbers
  • Lot numbers
  • General ledger accounts for auditing and tracking inventory
• 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 Locations
  • 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.

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.9999
  • 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's catalog numbers and costs
  • Manufacturer ID
  • Manufacturer's product number
  • MSRP - Manufacturer's Suggested Resell Price
  • Unlimited alternate manufacturers, manufacturer's 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 (parts or 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.

Statistics

• The Inventory module tracks purchased cost indicating, Low, High, Current, Last and Average Costs per item.
• Inventory cost statistics.

Interfacing with Invoicing

• Postings from the optional Invoice module will automatically update inventory quantities in the inventory management software module, subject to setting the appropriate Yes/No option in the product 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 = Manually
    • A = Average
    • L = Last Cost
• Tracks Backorders from the Invoice software module.
• Supports posting to specified Inventory Branch ID from the Invoice module.

Interfacing with Job Costing

• Postings from Inventory to the optional Job Costing module will automatically update inventory quantities and Job Costing when posted.

Interfacing with 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

• Bar Code printing and Bar Code Scanning is available as an add-on module.