Start the transaction ZWFA10A

 

Balance Sheet Values by Account: initial screen

 

 

  1. Enter the company code 

  2. Key date: Last day of the month

  3. Remaining shelf life: Number of days

  4. Usage decision: It concerns batches

  5. Check Ignore stocks null in order that materials with stock quantity zero do not appear i n the report.

 

 

 

  1. Click on "Valuation level" 
  2. Check "Valuation area"

and enter

 

 

Click on 

  1.   Check “Tax Price 1” (where the range of coverage is stored) and “Tax Price 2” (where the Net realizable value is stored)

  2. Check “0=0” Level 1

  3. Click on 

  4. Add “Stock Value” to the already selected values.

    The calculation of impairment will be based on the lowest of the 3 values

    - Stock value (=standard)
    - Value Level 1 (= Tax Price 1)
    - Value Level 2 (= Tax Price 2)

 and enter   if you have a message you can click on 

Then start the calculation by clicking on   Ignore the warning message  by clicking on 

 

 

The report is displayed

  • For finished product

  1. Material Master Data & plant code
  2. Stock quantity at the end of the previous month (Key date)
  3. Stock value : Stock quantity (2) x standard cost
  4. Cover : Stock value calculated with the price coming from MRN1 stored in “tax price 1” field
  5. Market price : stock value calculated with the price coming from ZWFA21A stored in “tax price 2” field
  6. Source price : origin of the market price
  7. Date Pr : date of the calculation of the price
  8. Rhodia Bal.Sheet : value of the stock after that the inventory impairment is applied (it is the lowest value between “stock value”, “cover” and “market price”)
  9. Remain. Period : when the remaining shelf life (number of days) is entered, the system is individualizing all batches with a remaining quantity, with a manufacturing date older than the key date of ZWFA10A and an expiration date older than the key date + remaining shelf life (nbr of days). In this column is displayed the number of days between the expiration date of the batch and the key date (expiration date older than key date => negative in red; key date older than expiration date => positive in green)
  10. Usage decision : according to the usage decision entered in the selection parameter and the batch
  11. Profit center : profit center of the material in the plant

 

  • For raw materials and packaging

  1. Material Master Data & plant code
  2. Stock quantity at the end of the previous month (Key date)
  3. Stock value : Stock quantity x standard cost
  4. Cover : Stock value calculated with the price coming from MRN1 stored in “tax price 1” field
  5. Market price : stock value calculated with the price stored in “tax price 2” field calculated by a previous MRN0. They are not used.
  6. Source price : Blank here as for these materials
  7. Date Pr : Blank here as for these materials
  8. Rhodia Bal.Sheet : value of the stock when the impairment is applied. It is the lowest value between “stock value”, “cover”. The “market price” is not taken in account for these materials.
  9. Remain. Period : when the remaining shelf life (number of days) is entered, the system is individualizing all batches with a remaining quantity, with a manufacturing date older than the key date of ZWFA10A and an expiration date older than the key date + remaining shelf life (nbr of days). In this column is displayed the number of days between the expiration date of the batch and the key date (expiration date older than key date => negative in red; key date older than expiration date => positive in green)
  10. Usage decision : according to the usage decision entered in the selection parameter and the batch
  11. Profit center : profit center of the material in the plant