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

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.

Product-site

Stock site (field STOFCY)

Enter the storage site. It is initialized by default by the site associated with your function profile.
Product (field ITMREF)

This field is used to enter the reference of the product for which the user wants to inquire the costs.
Valuation method (field VLTCOD)

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.

SEEINFO Vous 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

Auto journal code (field ENTCOD)

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.
field ACCCUR
Revaluation (%) (field PERDEP)

Revaluation in percentage of the global stock amount.
Total quantity (field AVCBASQTP)
field STU
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)
field LOTCUR

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

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