LIFO Lowest Value Comparison: Individual Materials

Use

When comparing the lowest values, the system calculates the net value for each existing layer. The system selects the lowest price from various prices. This price is multiplied by the layer quantity to form the net value for the current layer.

Features

To compare the lowest values, you can retrieve the following prices:

  • From the material master record

  • Tax prices 1, 2 and 3

  • Commercial prices 1, 2 and 3

  • From the layer

  • Prices 1, 2 and 3

  • The material price

You can compare the lowest values either layer by layer or for all layers together:

  • If you compare the lowest values layer by layer, the system compares the layer value for each layer with the lowest value determined. The lower of these is the net value of the relevant layer.

  • If you compare the lowest values for all layers together, the system compares the lowest value determined with the average value of all layers. The system calculates this average layer value from the gross value of the current layer and the net values of the old layers.

If the lowest value is smaller than the average value, the existing layers are dissolved. A current layer is formed at the same time, which is valuated gross using the average value of all layers and net using the lowest value determined.