STEP 1

Start the transaction ZWFA21A


Determination of Lowest Value: Sales price determination: initial screen



STEP 2

  1. Enter the company code 

  2. Key date: Last day of the month

  3. Material type: ZMAT - Raw materials & Finished goods

  4. Valuation class:

    • Z130 : Trading goods

    • Z150 : Finished products

  5. Sales organisation: All sales organisation of the company

  6. Currency type: Useless (all data in specific table are in local currency

  7. Uncheck Exclude Cross company delivery




STEP 3

  1. Click on "Valuation level" 
  2. Check "Company code"

and enter



STEP 4

Click on 

Select the relationship to Market Price = Lowest val. Comparisn

Select the price used for the comparison:

- “ Mat.Price   Prev.Month ” (material price previous month )

and enter 



STEP 5

  1. Check “Database update” and a new button appears.
  2. Click on
  3. Select “Tax price 2”: field of the material master data in which the calculated price is saved

and enter 


Then start the calculation by clicking on 

Ignore the warning message  by clicking on 




STEP 5

The report is displayed

  1. Material Master Data & plant code

  2. Stock quantity at the end of the month (execution date)

  3. Net Real value most recent “net real value” on the “key date”

  4. Comparison price: Price selected in the “comparison price” box (here “price on the previous month”)

  5. Lowest price: Lowest value of the two prices (3) & (4) followed by the price unit

  6. Price date: Date of calculation of the price

  7. Price Source: Origin of the price