Stock > Utilities > Valuation > Value change 

This function is used to modify the Moving Average Price value for the lines in the FIFO stack and for lots.
Value change movements will be created according to the context.

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    This function is composed of a single screen that regroups the selections, the update parameters and the modifiable elements.

    Entry screen

    Presentation

    Product-site

    This section contains the site and the product that will be subject to a value modification.

    Global values

    This section contains the moving average price information.
    It is possible to modify the base amount of this or to re-evaluate it at a certain percentage.

    FIFO totals /FIFO stack

    These sections contain the information on the FIFO stack total and the FIFO stack itself.
    For each level in the FIFO stack , it is possible to modify the value, the quantity or the unitary value.

    Lot totals / Lots

    These sections contain the information of the lot totals and the lot detail.
    For each lot it is possible to modify the global value or the unitary average price.

    Close

     

    Fields

    The following fields are present on this tab :

    Product-site

    The storage site is initialized by default with the site linked to your function profile.

    This field is used to enter the reference of the product for which the user wants to inquire the costs.

     

    Block number 2

    • Allocation date (field IPTDAT)

    Date utilisée à la comptabilisation du mouvement. Elle est initialisée avec la date du jour et peut être changée pour une date antérieure, si la date sélectionnée se situe dans une période ouverte du calendrier comptable.

    SEEINFOVous ne pouvez pas saisir une date supérieure à la date du jour.

    • Distribution (field REPFLG)

    When the moving average price (MAP) is modified, it is possible to update the FIFO basis and the lots.
    If this field is set to "No", only the MAP will be modified.
    Otherwise, the values will be modified according to the chosen distribution method.

    The MAP variation distribution (X%) can be carried out according to:

    • The value:
      The increase of each element (FIFO basis or lot) is prorated based on the amount of each element so that the global amount increases by X%.
    • The quantity:
      The increase of each element (FIFO basis or lot) is prorated based on the quantity of each element so that the global amount increases by X%.

    Example

    • Variation percent: 0.1
    • The 3 lines below represent either 3 FIFO basis elements, or 3 lots.

    Quantity

    Price

    Amount

    Distribution byValue

    Distribution by Quantity

    Delta

    New amount

    Delta

    New amount

    2

    2

    4

    0.4

    4.4

    0.7

    4.7

    4

    3

    12

    1.2

    13.2

    1.4

    13.4

    10

    4

    40

    4

    44

    3.5

    43.5

    Total

    16

    56

    5.6

    61.6

    5.6

    61.6

    Enter the automatic journal code to be used to post the value change movements generated. The automatic journal COST is delivered as standard.

    Global value

    • Global amount (field AVCBASAMT)

    Base amount serving for the calculation of the moving average price.

     

    • Revaluation (%) (field PERDEP)

    Revaluation in percentage of the global stock amount.

    • Total quantity (field AVCBASQTP)

     

     

    • Average cost (field AVC)

     

    • Active quantity (field AVCBASQTY)

     

    FIFO totals

    • Total qty. (field QTYTOTCST)

     

    • Quantity variance (field DIFQTYCST)

     

    • Total amount (field AMTTOTCST)

     

    • Average price (field PRICST)

     

    Lot totals

    • Total amount (field AMTTOTLOT)

     

     

    Grid FIFO basis

    • Value (field CST)

    Value of the FIFO basis element.

    • Active quantity (field QTYSTUACT)

     

    • Unit price (field AVCCST)

    Unitary price for the FIFO basis element.

    • Entry type (field VCRTYPP)

     

    • Entry (field VCRNUMP)

     

    • Entry line no. (field VCRLINP)

     

    Grid Batches

    • Lot (field WLOT)

     

    • Sublot (field SLO)

     

    • Lot value (field LOTCST)

    Total value of the lot in stock

    • Active quantity (field LOTQTYACT)

     

    • Average cost (field LOTAVC)

    Average price for the lot

    Close

     

    Menu Bar

    Options/Dimensions

    This menu is used to enter the analytical dimensions for the value change movements that will be created.
    The default section code STJVAL - Value changes is associated with the function.

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation