Inventory

Inventory Counts

Go to Inventory > Operations > Inventory Adjustments.

Creating an Inventory Count

1. Click Create.
2. Location - Select the area to count.
3. Inventory Date - When the count happens.
4. Click Start Inventory - This locks the stock and pre-fills current quantities.
5. Product lines appear with their current quantity.
6. Enter the actual counted quantity in the Counted Quantity column.
7. Leave Scrapped Quantity if some units are damaged.
8. Click Apply All to post the adjustment.

Cyclic Counts

For ongoing cycle counting, enable in Settings → "Cycle Counting". Create a count per product or location on a regular schedule. Quickenerp groups all cycle counts for review & validation.

ABC Analysis

Categorize products by value:

• A - High-value, count more frequently (e.g. monthly).
• B - Mid-value, count quarterly.
• C - Low-value, count annually.

Set ABC category on the product form to automate cycle count frequency.

Inventory Adjustment Reporting

After applying an adjustment, the difference is recorded:

• Positive variance - Stock increases, value is added.
• Negative variance - Stock decreases, value is removed (inventory loss).

Go to Inventory > Reporting > Inventory Analysis to see adjustment history.

Inventory Reporting

Inventory Analysis

Go to Inventory > Reporting > Inventory Analysis. Pivot table with dimensions:

• Product, Product Category, Location.
• Warehouse, Company.
• Date (Day, Week, Month, Year).
• Operation Type.

Measures: Quantity In, Quantity Out, Quantity On Hand, Value.

Stock Forecast

Go to Inventory > Reporting > Stock Forecast. Graphical view of forecasted stock levels over time. Based on:

• Current on-hand quantity.
• Open purchase orders (incoming).
• Open sales orders (outgoing).
• Manufacturing orders (consumption + production).
• Reordering rule triggers.

Use this to anticipate stockouts and plan purchasing or manufacturing.

Inventory Turnover KPI

Key metric: Inventory Turnover Ratio = COGS / Average Inventory Value.

A high ratio means efficient stock management. A low ratio indicates overstocking.

Track this over time in the Inventory Analysis pivot.

Reordering Rules

Go to Inventory > Master Data > Reordering Rules. Auto-trigger replenishment when stock drops below a threshold.

Creating a Reordering Rule

1. Click Create.
2. Product - Select the product to replenish.
3. Location - The warehouse location (typically WH/Stock).
4. Minimum Quantity - When stock reaches this level, trigger reorder.
5. Maximum Quantity - Replenish up to this level.
6. Multiple Quantity - Order in multiples (e.g. case of 12).
7. Lead Time - Days from order to receipt (overrides product lead time).
8. Route - Buy, Manufacture, or Internal Transfer.
9. Save.

How the Replenishment Engine Works

1. The scheduled action "Reordering Rules" runs (every few hours or daily).
2. For each rule where virtual stock (forecasted) < minimum, a replenishment is created.
3. The replenishment follows the product's route (Buy → PO, Manufacture → MO).
4. The order quantity is max - forecasted (rounded to multiple quantity).

Virtual / Forecasted Stock

Quantity On Hand (QOH) - Physically in stock.

Forecasted Quantity - QOH + incoming - outgoing. This is what triggers reordering.

Manual Replenishment

Go to Inventory > Operations > Replenishment. View all products needing replenishment. You can:

• Click Order Once to create an immediate order.
• Click Create Reordering Rule for ongoing automation.