Inventory Control Overview

Manage inventory with a powerful cataloging tool.

Getting Started

EBMS includes a comprehensive inventory management system. Managing inventory is a very important part of managing a profitable company. Managing pricing, tracking parts, and cataloging options is especially important for a sales, manufacturing, distribution, or service company.

Associating the items sold to the purchase invoice is often necessary to properly process warranties or to meet mandatory reporting requires. The inventory module includes the tools and information required to properly purchase, sell, and manage a large number of inventory items.

Complete the following settings before using the inventory tools within EBMS:

Select Inventory > Options > General tab from the main EBMS menu.
Set the Method to markup prices. EBMS can calculate pricing based on Margin or Markup. Review Price Formulas for pricing formula details.
The Inventory Method should be set to Perpetual unless perpetual inventory value is not calculated. The optional Periodic option should only be used when EBMS is not used to calculate inventory values. Review Inventory Count Overview for more details on these settings.
Set the Available Quantity Calculation to the first option (Processed Count + Incoming Received - Outgoing Ordered) unless inventory is available as soon as the product is placed on a purchase order. The second option (Processed Count + Incoming Ordered - Outgoing Ordered) will include the available quantity as soon as product is placed on a purchase order. For most situations, the first option is better.
In the Cost of Goods section, Allow propagation of adjustments should be enabled unless extensive transactions are created in a manufacturing or multiple warehouse environment.

EBMS allows a user to sell a product before the purchase order is processed. If the cost of the item on a purchase order is changed after the item has been sold, EBMS updates the cost on all the documents that contain this item. This process can be extensive depending on the number of steps that an item has traveled. A simple link between the purchase order and the sales invoice requires very little processing, but the steps may include many levels if manufacturing or multiple warehouses are involved. A single line on a purchase order may also affect many sales orders, manufacturing batches, or warehouse transfers, and will be multiplied if the cost within manufacturing affects multiple levels or if the item has traveled through multiple warehouses.

Disabling the Allow propagation of adjustments option will keep the financials accurate but will not propagate the new Cost of Goods Sold value to the end product when it is sold.
In the Cost of Goods section, enable the Use Single G/L account option to combine the Purchase and Inventory Variance accounts within the product record's Advanced tab. Review Inventory Variance for more details on dividing these transactions.
EBMS contains various special order purchase methods. Individual purchase method types can be disabled. Review Purchase Methods for a description of each of the listed purchase method options.

Common Use Cases

Product Catalog: The product catalog can be used to organize tens of thousands of inventory items into category folder and subfolder groups. Managing FIFO (First In, First Out) inventory is a very important part of a profitable company. Managing pricing, tracking parts, and recording purchasing and sales history are especially important for a sales, distribution, or service company. Order entry and inventory tools to manage special orders, drop shipments, and maintain stock levels are essential.

Advanced inventory management: Advanced tools to manage serialized items, lots, assemblies, and kits are included. Optional features to manage multiple locations, link vendor catalogs, organize made-to-order products, manage inventory using mobile bar code tools, and distribute information using online web catalogs are available.

Video Walkthrough

Features Included:

Allows users to categorize inventory items into groups and subgroups
Supports multiple description lines
Advanced General Ledger account options are available to record standard sales, purchasing, asset, and other inventory accounts
Purchasing window includes powerful querying capabilities, lists, and grouping to simplify purchase order entry and processing
Allows multiple Units of Measure (UOM) for the same inventory item
Allows components or inventory assemblies
Facilitates FIFO (First In, First Out), LIFO (Last In, First Out), or Perpetual Inventory Processing
Records monthly purchasing and sales history for an unlimited number of years
Multiple price levels with flexible pricing based on cost, list price, or other formulas
Complete vendor purchasing history
Supports multiple Vendor Part Numbers for each item
The purchase invoice of an inventory item can be directly referenced from the sales invoice
Maintains easy-to-view on-hand inventory counts, purchase orders, and sales order balances
Facilitates substitute items for obsolete or discontinued items
Records when a sale is lost and relevant information regarding the reasons for the lost sale
Batch adjust the counts and values of multiple track count inventory items
Batch edit certain properties (e.g. description, cost, type, weight, minimum stock, etc.) of inventory items from a spreadsheet.

Inventory Control Overview

Manage inventory with a powerful cataloging tool.

In this article

Getting Started

Common Use Cases

Video Walkthrough

Features Included:

Enhancements & Customizations Available

Sample Reports

Related Videos and Content

Videos

Blog Articles