Inventory

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.

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 Valuation

Configure on the Product Category. Go to Inventory > Configuration > Product Categories, select a category, edit the Inventory Valuation section.

Valuation Methods

Accounting Valuation

Inventory Valuation Report

Go to Inventory > Reporting > Inventory Valuation. See the current value of each product at each location. Columns: Quantity, Unit Cost, Total Value. Also shows layered cost history.

Stock Moves as Accounting Entries

With Automated Valuation, each stock move generates:

• Receipt: Debit Inventory, Credit Stock Input (or directly Credit Vendor if not separate).
• Delivery: Debit Cost of Goods Sold (COGS), Credit Inventory.
• Scrap: Debit Inventory Loss, Credit Inventory.

Review entries via: Product → Accounting → Journal Entries.