This document explains in an example, values ​​taken by the VARVAL field during a transaction.

 

Description of Solution / Details

In the table STOJOU (Development>Utilities>Maintenance>Line, Table: STOJOU) the VARVAL field corresponds to the movement variance. This field contains variance between the product stock cost and the invoice cost.

If you want X3 to take into account variances between the stock cost and the product invoice cost you need to tick Adjust receipt price:

Parameters >Inventory>Valuation methods, choose your valuation method. In this example it’s AVC, then in the method tab, click on the method 1 lens. Now in the standard rules, tick Adjust receipt price and save.

 

 

In this example, the product valuation method is the Average Valuation Cost (AVC) and the product is stock managed (Common Data>Product>Product Site, in the control tab, in the stock management bloc, tick Managed)

 

Ø Order Creation

Ø Receipt Creation

 

Common data> Product >Product – sites: Product and Site selection. In the Cost tab, in the Unit Price you can see that the Average Cost=10, 00.

 

 

Ø This is the first transaction with this product, so there are no cost variances.

Here is what we have in STOJOU table.

 

Ø Invoice Creation and validation. Change of the product cost.

 

 

 

Ø In STOJOU table, explanation of  VARVAL value

Quantity =10 Price= 10 Cost=100

Quantity =10 Price= 12 Cost=120