Determining the Lowest Value Based On Movement Rate (SAP Library

Determining the Lowest Value Based On Movement Rate

Note Because of the volume of data involved, you should only determine the lowest value using background processing.

Procedure

Choose Valuation ® Balance Sheet Valuation ® Determine Lowest Value ® Movement Rate. The system displays selection screen.

Enter data as required: the company code in question, the key date, and the materials for which you want to determine the lowest value. You can narrow down your selection using material numbers, valuation areas, valuation types, valuation classes, material types, material groups, and creation date.

Define the criteria for the movement rate. Choose Material Movements and select how you want the movement rate to be determined. You have the following options:

From Material Documents

In this case, you must select at least one of the fields Receipts and Consumption.

Note Note that determination using material documents can be very time-consuming.

From Material Master Data

In this case, the issues recorded in the material master record are automatically used.

In the fields Threshold Values, you enter the percentage rate up to which the materials are regarded as non-moving for receipts and consumption. If the movement rate is smaller than this percentage, the devaluation indicator is increased.
You can weight receipts and issues across the period under review. This allows you to give greater significance to more recent movements than to older movements when determining the movement rate.
Define the Period Under Review:

The system can determine the stock used to calculate the movement rate from the closing stock of various periods. Select Material Stocks. Specify the period from which the system should determine the material stocks. You can use Weighting Factors to weight the determination of the closing stocks. Choose to confirm your entries.

Select Base Price.

You can select one or more prices from the Phys. Inv. Prices and Valuation Alternatives tab pages. The method thus determines the basis price as the minimum of all specified prices and valuation alternatives. Choose to confirm your entries.

Select Deval. Percentages to check or change the devaluation percentages.

The system displays a dialog box where you specify whether the devaluation rates are to be defined at Valuation Area Level or Company Code Level. This dialog box takes you straight to Customizing. If you make changes, save them. Choose Back. The dialog box is displayed. Choose to confirm your entries.

You can update the material master with the results of lowest value determination. If you want to do this, select the field Database Update in the screen box Update Material Master. You can change the material prices or the physical inventory prices in the material master.

If you want to change the material prices, select Change Material Prices. The system displays a dialog box, in which you select if:

A batch input session should be generated for the price changes
The prices should be changed directly when valuation is carried out
You do not want the material prices to be changed, in which case you need to select No Update.

Choose to confirm your entries.

Choose Update Prices.

The system displays a screen with two tab pages. SAP recommends that you only process one of these tab pages.

On the Phys. Inv. Prices tab page, select the price field of the movement price in which the data is to be posted. If you want to delete prices in other price fields when carrying out the update, select the Reset field.

On the Valuation Alternatives tab page, select the price indicator that indicates the valuation alternatives to be updated.

Choose to confirm your entries.

Note You should only trigger the automatic price change function if you do not want to carry out further lowest value determinations with price changes.

Choose List Format and specify the type of print list that you require.

Choose Valuation Level. Select whether the procedure is to be performed at valuation area level or company code level.

Choose

Execute.

Result

The system generates a list of the materials with their percentage devaluation and lowest prices determined.

If you set the automatic price change function, the name of the batch input session or the numbers of the price change documents posted appear at the end of the list.

You can analyze the results using the Schedule Manager and the messages using the application log.

Determining Lowest Values

Balance Sheet Valuation (MM-IM-VP)