Balance Sheet Values by Account: Generating a List (SAP Library

Balance Sheet Values by Account: Generating a List

Procedure

Choose Valuation ® Balance Sheet Valuation ® Evaluations ® Balance Sheet value per Account. The selection screen appears.

Enter data as required: the company code in question, the key date, and the materials that you want the system to create the list for. You can narrow down your selection using material numbers, valuation areas, valuation types, valuation classes, material types, and material groups.

Select whether the current stock value, that of the previous month, or that of the previous year should be displayed in the list.

Choose Prices/levels. A window appears in which you define the following:

The physical inventory price fields in the material master that are to be taken into account

The level to which the price fields are to be grouped together (see Price Levels: Example)

What the levels in the list are called

If a revaluation between two levels is to be excluded

The level that a possible replacement value is to be taken from

The levels that the balance sheet value is to be calculated from

Choose to confirm your entries.

The balance sheet prices determined can be updated in the material master record. If you want to do this, select the field Database update in the screen box Update bal. sheet price. 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. A window appears 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 must select No update.

Choose to confirm your entries.

Choose Update phys. inv. prices.

A window appears in which you select the price field in which the balance sheet price is updated. If you want to delete prices in other price fields when carrying out the update, select the Reset field.

Choose to confirm your entries.

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

Choose Valuation level. You can configure whether the balance sheet values are to be displayed at Valuation area level or Company code level.

Choose

Execute.

Result

A list is displayed with the stock values for the materials entered. The individual columns show the stock value and the values on the individual levels for each material.

The values in the columns are added together for each valuation level and for each stock account. The difference between the sum of the values and the individual price levels is displayed in the Difference line. The respective Difference at lower level and Devaluation are listed underneath for each level.

If you intended to update the database, the system updates the physical inventory prices selected in the material master record. If you specified that the prices should be changed, the system either generates a batch input session to make the price changes, or – in the case of direct updating – makes the price changes immediately.

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