Status colour Blue title Step 1
Start the transaction MRN1
| Info |
|---|
Determine Lowest Value: Range of Coverage: initial screen |
Status colour Blue title Step 2
Enter the company code
Key date: Last day of the month = reference date for the calculation of R.O.C.
Material type: ZMAT : Finished products & RM & SF
- Click on Valuation level to open a new window
Status colour Blue title Step 3
Select "Company Code"
Status colour Blue title Step 4
Click on
Enter:
- “Upper limit” = “key date”
- “Lower limit” = “Upper Limit” – 12 months
The range of dates corresponds to the period of analysis of the monthly stocks
and enter
Status colour Blue title Step 5
Click on
Enter Select and enter the range of date in the first range as the analysis period for the determination of consumptions.Select the
and enter
The option “Determine
consumptnconsumption via user exit” can be selected to apply
the rules tothe rules to calculate the range of coverage (average consumption).
and enter
Status colour Blue title Step 6
Click on
It is the standard cost of the month
- If the transaction is run before the end of the month:
- Select the current material price
- It the transaction is run after the end of the month:
- Select the Mat. Price Prev. Month
and enter
Status colour Blue title Step 7
- Check “Database Update” and 2 new buttons appear.
- Never click on “Change Material Price”
- Click on
- Check “Tax Price 1” to store the price calculated by the system
and enter
Then start the calculation by clicking on
Ignore the warning message 
by clicking on
Status colour Blue title Step 8
The report is displayed
M aterial Master Data & plant code.
Stock quantity at the end of the month (execution date)
Average consumption on the last 12 months
Number of months needed to consume the whole stock with the average consumption = Average stock (2) / Average consumption (3)
Base price used for the calculation of impairment (= standard cost)
% Deduct calculated in function of range of coverage (4)
Range of coverage < 12 = 0 %
12 < Range of coverage ≤ 24 = 50 %
36 < Range of coverage = 100 %
24 < Range of coverage ≤ 36 = 75 %
New price on which the range of coverage is applied = (100 - % Deduct (6)) x Base price (5)
| Viewtracker |
|---|
| user | crollier,alepercq,bfoisell |
|---|
|