This blog aims to briefly outline the basic principles for the valuation of stocks.

In Sage X3, the management of the stock is based on the following tables:

STOCK

The stock itself is materialised in the database by records in the STOCK table (Stocks).

Each record corresponds to a stock line.

A group of stock lines characterized by various attributes (e.g., lot, status, location) correspond to a given product, in each warehouse.

Each stock line carries a global quantity. The value, used as the calculation basis for the financial stock value is stored in other tables.

STOJOU and STOJOUVAL

The journal of stock movements is materialized in the database by records in the STOJOU (Stocks journal) and STOJOUVAL (Stock movement values) tables.

The journal of stock movements finds, in chronological order, the movements completed in quantities (receipt, issue, internal movement) or in value only (impairment losses, miscellaneous adjustments).

The Quantity field is entered even when the movement does not affect the quantity in stock: for movements in value, it is necessary to know to what quantity the change of value is applying to.

Each record in this journal carries the characteristics of the stock line where a movement was performed and is linked to a source movement (document and document line that initiated the movement).

Documents include delivery notes, material tracking reports, and receipt notes.

Each movement carries two values:

The movement value is defined based on the setup rules. These values impact the global stock value of lines.

The value recovered from the source document.

If the valuation method includes two methods, then these values are displayed for both methods.

Main fields of the STOJOU table

TRSTYP = Identify if the movement type

VCRTYP = Identify the document type

VCRNUM = Stock document number

OWNER = Identify which site owns the stock

NUMVCR = Accounting entry including this value

STOJOU

Double valuation method

Sage ERP X3 allows handling two different stock valuation methods for the same product. All the fields for stock valuation in STOJOU are existing two times:

Valued price with the 1st method: PRIVAL

Valued price with the 2nd method: PRIVAL2 (linked to the activity code VLT)

Movement value with the 1st method: AMTVAL

Movement value with the 2nd method: AMTVAL2 (linked to the activity code VLT)

Movement variance with the 1st method: VARVAL

Movement variance with the 2nd method: VARVAL2 (linked to the activity code VLT)

Variance not absorbed with the 1st method: AMTDEV

Variance not absorbed with the 2nd method: AMTDEV2 (linked to the activity code VLT)

STOLOT

STOLOT is the table of lots (Lot number). This table assigns default features to a lot and to a given product (for all warehouses).

This table includes the total quantities and a guide value (expressed in reporting currency).

ITMMVT

ITMMVT is the table of product/warehouse totals (Product-Site totals).

It contains the total quantities by status (A, Q, R) and by the report (internal, at the dock, loan, allocated, subcontracted, etc.).

The totals (base and quantity) are used to perform the average cost (AC) calculation.

This table also includes values such as last purchase price, last receipt price, date of the last receipt, and last entry.

The values of the table can be recalculated for a given product and warehouse by starting from the last inventory values and browsing through the stocks journal.

ITMMVTHIS

ITMMVTHIS is the table of monthly product or warehouse totals (History of Product-Site totals).

This table includes the totals by period and fiscal year. This table is updated based on the allocation date of each movement. 

STOCOST

STOCOST is the table storing the elements required for the FIFO or LIFO management (stock FIFO cost).

For each product and warehouse, the table includes a set of lines characterized by a quantity and global value.

Note: This table is used in the FIFO or LIFO valuation, but it has no links to physical locations or specific lots.

STOALL

STOALL is the table recording the allocated quantities and quantities in shortage for each product and warehouse (Allocations).