Inventory System Reports

Every product sale in ERP123 is typically done by processing a Sales Order.  Sales Orders contain a list of items and quantities for the inventory items that are to be sold.  Sales orders represent demand the products on the order are soft allocate within the inventory software system.  These items are then shipped as they go out the door.  Packing slips and other shipping documents can be printed during the Shipping process.  What doesn’t get shipped remains allocated and is therefore back ordered.   Shipments provide an automated data feed to Accounts Receivable.

Purchasing and Receiving

ERP123 Purchasing incorporates purchase order entry, vendor quotes, supplier performance, and perpetual history so the buyer has all the tools necessary to make informed decisions.  In addition, ERP123 allows you to place limits and approval controls on the purchasing system.  And when products arrive at your facility they will be received through the Receiving module.  You can also charge line items directly to Work Orders (jobs).  This will allocate the direct PO cost to the work order in question.

Open purchase order provide the MRP modules with information on the timing and quantity details of the your purchases.  This data represents one part of the supply side of the inventory software loop.  When a purchase order is received there is an immediate increase in the inventory.  If an item is charged to a Work Order than the system will perform a flushing transaction concurrently.

Click on the Purchase Order Overview Flowchart below for a process-based view of the ERP123 Purchasing Management system.

See the QuickVid for a detailed look at the ERP123 Purchasing Management system.

Work Orders and Production Receiving

From an inventory management software  perspective Work Orders are required where labour is added to raw materials, a process which converts them into other products.  A Work Orders will typically back flush inventory as the product is produced a various stages.   These materials are accumulated in Work in Process.  Once the finishing stage is reported the system will add the product to inventory.

The ERP123 Work Order and Production Receiving systems are very extensive and comprehensive.  They will handle the requirements of virtually any repetitive, custom, or project-based manufacturing environment.  Work Orders can be created from standard item Bills of Material and Routing’s or structures previously created in the Estimating system.  Regardless, the Work Order contains the everything associated with the materials, labour, and overhead for the job including:

  • Multi-level bills of material with phantom support
  • Work centers, departments
  • Manpower classes
  • Standard labour rates and overhead factors
  • Drawings and detailed work instructions

Reporting time and material consumption in their inventory management software can be done manually or by using the ERP123 Shop Floor Data Collection module.  Either way the system produces the right costing and inventory transactions.  And when mistakes are made they’re easy to fix with our handy UNDO feature.

Cycle Counting and Adjustments

Sometimes inventory accuracy is the issue.  ERP123 inventory software supports your effort to manage your accuracy with its Cycle Counting and Adjustment modules.


Transfers are inventory movements from one location to another within ABACI.  Transfers take two forms, a simple inventory movement or a Sales Order Transfer which is used where strategic warehouse inventory replenishment comes into play.

Physical Inventory

ERP123 provides a complete Physical Inventory software system that includes pre/post counts for comparison, multiple station data entry, bar-code support, and tag auditing.  And there’s no need to wait until the inventory is posted before you can start using the system again.  Just backdate the transaction when you’re ready to enter it.  Nothing could be easier or more efficient.

Inventory Reports

ERP123’s Inventory software provides an array or reports that target values, quantities, locations, order points and transaction activity in hard report, Excel-based, or data download formats.