Issue / Summary
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.
** This is the first product transaction.
Ø Invoice Creation and validation. Change of the product cost.
Common data> Product >Product – sites: Product and Site selection. In the Cost tab, in the Unit Price you can see that the Average Cost changed=12, 00.
Ø In STOJOU table, explanation of VARVAL value
Quantity =10 Price= 10 Cost=100
Quantity =10 Price= 12 Cost=120
***variance between the product stock cost and the product invoice cost