With the reportList of Stock Values, you can display the total stock quantity and the total stock value for a material (or several materials) at company code and valuation area level. In addition, the stock account to which the specified material is posted during goods movements is determined.
You can also display the balance values per company code and G/L account. For each G/L account, the balance is compared with the sum of the stock values of the associated materials. The difference between the two totals is displayed.
You can restrict the search options in the List of Stock Values report with the following fields:
- Material
- Company code
- Valuation area
- Valuation type
- Valuation class
- G/L account
In addition, you can choose the period for the evaluation (current period, previous period, or previous year) and specify the scope of the list, for example, totals or negative stocks only.
If you start the report without specifying a material, valuation area, and valuation class, the balance for each stock account must match the total of all stock values of the materials for the relevant valuation class. A variance can have the following reasons:
- You made manual postings to the stock account.
- Other postings besides stock postings are made to the stock account. In this case, you need to check the account determination in the Customizing settings for valuation. Ensure that the stock accounts are used only for transaction key BSX (stock postings).
- You changed the account determination for stock accounts (transaction and event key BSX) in the current operation, but you did not debit the relevant stocks from the old account (movement type 562) and posted to the new account (movement type 561).
If you place the cursor on the G/L account in the output list and choose Environment → Stocks, the system displays an overview of all materials that are managed in this G/L account. The system also displays the total value and total stock for each material.
Leave a Reply