Understanding Inventory Management

The Inventory module is your central hub for tracking all the products you buy and sell. Proper inventory management is critical for understanding your profitability, ensuring you have enough stock to meet customer demand, and knowing the value of the assets you have on your shelves.

This system tracks inventory by integrating directly with your Accounts Payable (buying) and Accounts Receivable (selling) workflows.

Step 1: Setting Up Your Items

Everything you buy or sell should be set up as an "Item." This provides consistency and allows for powerful tracking.

Item Types Explained

Creating a New Item

  1. Navigate to Inventory & Services from the main menu.
  2. Click the Add New Item button.
  3. Fill in the key details:
    • Item Type: Choose "Product" or "Service".
    • Item Name & Description: What you and your customers call the item.
    • Sales Price: The price you sell one unit for.
    • Cost Price: What it costs you to buy one unit from your vendor. This is crucial for calculating profitability.
    • Preferred Vendor: Select the primary supplier for this item to speed up Purchase Order creation.
  4. Click Save Item.

The Inventory Lifecycle

For "Product" type items, the system automatically tracks several key quantities as you conduct business.

Key Quantities Explained:

On the item list, you will see several quantity columns. Here is what they mean:

  • On Hand: The actual number of units you physically have in your warehouse right now.
  • On Order: The number of units you have ordered from a vendor via a Purchase Order but have not yet received.
  • Allocated: The number of units that are committed to customers on confirmed Sales Orders but have not yet been shipped.
  • Available: This is the crucial number: On Hand - Allocated. This tells you how many units you are free to sell to a new customer.

How Quantities Change: A Step-by-Step Example

  1. You need more widgets.
    Action: You create a Purchase Order for 100 widgets.
    Result: On Order becomes 100.
  2. The widgets arrive from your vendor.
    Action: You find the PO and click Enter Bill to record the vendor's invoice.
    Result: On Hand increases by 100, and On Order decreases by 100.
  3. A customer wants to buy 10 widgets.
    Action: You create and confirm a Sales Order for 10 widgets.
    Result: Allocated becomes 10. Your Available quantity drops by 10 (even though they are still on your shelf).
  4. You ship the order.
    Action: You use the Fulfillment Queue or the Sales Order to mark the items as shipped.
    Result: On Hand decreases by 10, and Allocated decreases by 10. The cycle is complete.

Inventory Reporting

Understanding the value of your inventory is essential for accurate financial statements.

Inventory Valuation Report

Navigate to Inventory Reports (from the main Reports module) to find this report. It provides a snapshot of your inventory asset value.

The report calculates the total value by multiplying the Quantity On Hand of each item by its Cost Price. The grand total of this report should match the balance of your "Inventory Asset" account on your Balance Sheet.