Inventory Valuation

​

Before You Start

• Permission: you need the reports view permission to open the screen and run the report.
• Location filter: the Location list is read from your locations settings. It appears only when your company has more than one location, and it needs settings view access to load. Without that access the report still runs for all locations.
• Stock with cost: the report values stock from FIFO cost layers, which are created when you receive inventory with a unit cost. Stock received without a cost layer does not appear.

Other ways in: search for Valuation in the command palette, or open it from the Inventory pages that share this section (Overview, Transactions, Receive, Adjustments, Supply & Demand, Aging, Dead Stock and ABC Analysis).

​

Run the Report

1. Open Operations > Inventory > Valuation. The report runs for today as soon as the page opens. Today means today in your company’s time zone.
2. Choose the As of date. You can pick today or any earlier date; future dates are not allowed. The report runs again for the new date.
3. If you have more than one location, choose one in Location, or leave All locations. The report runs again for the new location.
4. Select Run Report to run it again with the same choices, for example after receiving stock. The button reads Running while the report loads, and pressing it again while it runs does nothing.
5. To go back to the current value, select As of Today. It does nothing while the date is already today, and its hover text then reads Already showing today’s live inventory valuation; on an earlier date it reads Reset to today’s live inventory valuation.

The as-of date and the location are kept in the page address. A refresh, a copied link, or coming back to the page with the browser’s Back button runs the same valuation again, and each date or location you pick can be undone with Back. Opening Operations > Inventory > Valuation fresh starts at today for all locations.

​

How Each Layer Is Valued

Each open cost layer is valued at its current layer cost: the cost the stock was received at, plus any inbound freight or duty that was landed onto the layer after receipt, plus any revaluation or layer cost correction. A layer’s cost is not frozen at the moment of receipt, so posting a landed cost to a received purchase order raises the value this report shows for the stock it covers. Cost that has already left with a sale is not in this report; it is in cost of goods sold.

​

Live and Historical Values

A badge above the results says which basis you are looking at:

• Live valuation as of (date) (current FIFO layers): the date is today. The report sums every open cost layer as it stands now.
• Historical snapshot as of (date) (FIFO backward-rewind): the date is in the past. Arcus rebuilds each layer’s quantity at the end of that date, counting only layers received on or before it.

Below the badge, the report states its basis in one sentence. The value here is the layer basis: every unit that still has an open cost layer, including units held in quarantine or staged for a vendor return. The inventory value on a product page or on the Inventory Overview leaves those held units out, so the two numbers can differ by exactly the value of held stock. Neither is wrong; they count different populations.

​

Read the Results

Summary cards:

• Total inventory value: the sum of open FIFO layer cost, held stock included.
• Total units in open layers: the units behind that value, with a line such as 12 products at 2 warehouses, held stock included.
• GL 1410 basis: the same total, labelled for comparison with your inventory asset account. The card’s note reads Layer cost, before unbacked held stock for a live run and Historical FIFO rewind for an earlier date.

Table columns: With All locations, a product held at more than one location appears on one row per location, and the Warehouse column tells the rows apart. The product count on the Total units in open layers card and in the footer counts each product once, however many warehouses hold it. The footer row, such as Total (12 products at 2 warehouses), totals the units and the value for every row in the report. On a phone, the table scrolls sideways inside its card.

​

Messages You May See

​

Common Scenarios

• A value moved after a landed cost was posted: freight or duty landed onto received stock is added to its layers, so the live value rises by the amount that stayed in inventory. The share that belongs to units already sold went to cost of goods sold instead.
• Month-end inventory listing: set the as-of date to the last day of the month and run the report for all locations.
• Compare to the balance sheet: use Total inventory value against your inventory asset account. If they differ, look for held stock (quarantine, vendor returns) and for stock taken into quarantine on receipt, which has no cost layer.
• One warehouse: choose the location to value only the stock there.

​

What This Report Does Not Change

Running the report is read-only. It posts nothing to the ledger, moves no stock, and sends no notifications.

​

Related Articles