View Source

Start the transaction MRN1

Determine Lowest Value: Range of Coverage: initial screen

Finance Service Line > MRN1 - Lowest Value Determination Based On Range Of Coverage > MRN1_ initial screen.png

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

Finance Service Line > MRN1 - Lowest Value Determination Based On Range Of Coverage > MRN1_ initial screen_ filled 1.png

Select "Company Code"

Finance Service Line > MRN1 - Lowest Value Determination Based On Range Of Coverage > MRN1_select company code.PNG

Click on Finance Service Line > SAP Transactions > SAP_BUTTON_MATERIAL STOCKS.png

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 Finance Service Line > KSUx KSVx KEUx - Create a cycle run group > BUTTON_SAP_ENTER.PNG

Finance Service Line > MRN1 - Lowest Value Determination Based On Range Of Coverage > MRN1_ initial screen_ material stocks.PNG

Click on Finance Service Line > SAP Transactions > SAP_BUTTON_MATERIAL CONSUMPTION.png

Select and enter the range of date in the first range as the analysis period for the determination of consumptions.

and enter Finance Service Line > KSUx KSVx KEUx - Create a cycle run group > BUTTON_SAP_ENTER.PNG

The option “Determine consumption via user exit” can be selected to apply the rules to calculate the range of coverage (average consumption).

Finance Service Line > MRN1 - Lowest Value Determination Based On Range Of Coverage > Captura de ecrã 2022-12-07 0938501.png

Click on Finance Service Line > SAP Transactions > SAP_BUTTON_BASE PRICE.png

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 Finance Service Line > KSUx KSVx KEUx - Create a cycle run group > BUTTON_SAP_ENTER.PNG

Finance Service Line > MRN1 - Lowest Value Determination Based On Range Of Coverage > MRN1_ initial screen_ base price.PNG

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 Finance Service Line > KSUx KSVx KEUx - Create a cycle run group > BUTTON_SAP_ENTER.PNG

Then start the calculation by clicking on Finance Service Line > KEU5 - Perform actual assessment to CO-PA > BUTTON_SAP_EXECUTE

Ignore the warning message Finance Service Line > MRN1 - Lowest Value Determination Based On Range Of Coverage > ZWFA12A_ initial screen_ message.PNG by clicking on

Finance Service Line > MRN1 - Lowest Value Determination Based On Range Of Coverage > MRN1_ initial screen_ update prices.png

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)