Balance Sheet Values by Account: Generating a List

Procedure

  1. Choose Start of the navigation path Valuation Next navigation step Balance Sheet Valuation Next navigation step Results Next navigation step Balance Sheet Valuation Per Account. Next navigation step The system displays selection screen. End of the navigation path

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

  3. Select the current stock value, that of the previous month, or that of the previous year for the list display.

  4. Choose Prices/Levels .

Specify the following on the Phys. Inv. Price tab page:

  • Which physical inventory price fields in the material master 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 should be excluded

  • The level from which a possible replacement value is to be taken

  • The levels from which the balance sheet value is to be calculated

On the Valuation Alternatives tab page, you can select one or more prices and assign as many as required to a level. You can define up to a maximum of six levels.

Choose to confirm your entries.

  1. 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 Balance 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 dialog box is displayed, 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 balance 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.

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

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

  3. 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 a direct update – makes the price changes immediately.

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