Issue / Summary

When and why movements using STKUV automatic journal are created? Can I change STKUV?

Description of Solution / Details

STKUV automatic journal was created since patch 22 and is in hard code, this is because there is some specific control on it.

You can't use your own automatic journal and set it up to be able to use it because STKUV is put directly on the source code.

In cases of cancellation/deletion of stock receipts, the amounts of stock receipts and stock issues could be unbalanced. A new type of movement has been created (TRSTYP=35), so the non-absorbed part is taken into account in those cases.

Those types of movements are counted with the new automatic journal of the STKUV stocks.

Here is an EXPLANATION OF THE USE OF STKUV – In which case this auto journal is used? 

Particular case: STOJOU Table with TRSTYP field = 35 (manage on the source code). 

TRSTYP is a change value movement (with STKUV as auto journal = ENTCOD field in STOJOU Table) 

When a movement is created and that there is too much or not enough value, a movement with TRSTYP=35 is created:  

Example 1: Order price valorization 
1. Rcpt1: Q=1 P=10 
2. Rcpt2: Q=15 P=12 (PMP =11.5) 
3. Liv: Q=-15 P=11.5 
      è A base=57.5 & Q base=5 
4. Deletion of Rcp1 : Q=-5 P=10 
      è A base = 7.5  & Q base = 0 ! 
5. => Creation of movement TRSTYP=35 : 
     VARORD=-7.5 ; VARVAL=0 ; AMTDEV=-7.5 
     STKUV is with this movement TRSTYP=35 

But you can have the Hypothesis (from point 4): If A base is with a negative value & Q base = 10, you will have the creation of  TRSTYP=35 

Example 2: Standard  price valorization 
1. Rcp1 : 01/MM/YY Q=20 P=10 
2. Change standard cost : 15/MM/YY P=11.5 
3. => Creation of movement TRSTYP=23 : 
    VARORD=0 ; VARVAL=30 ; AMTDEV=-30 
4. Rcp2 : 20/MM/YY Q=10 P=11.5 
5. Liv : 10/MM/YY Q=-5 P=10 (antidate= before point 2) 
6. => Creation of movement TRSTYP=35 
    (IPTDAT=10/MM/YY) : 
    VARORD=0 ; VARVAL=-7.5 ; AMTDEV=7.5 

Detail explanation: 
Q=Quantity 
P=Price 
A= Amount 
& = and 
Rcpt*= Receipt 
Liv = Delivery 

For your information: 7.5 = difference between P=10 & 11.5 = 1.5x5 

To check, you can make a search in STOJOU table, TRSTYP=35, the ENTCOD field will be STKUV (for TRSTYP=23, ENTCOD=COST).