Skip to Content
0

Why i can not change the Valuation Method ??

Jan 27, 2017 at 06:48 AM

228

avatar image
Former Member

i can not change the valuation method (Evalsystem) for some itemcodes i have checked all the possible ways but failed, kindly help why it showing the uneditable?

thanks in advance screen shorts is availabe below for your help to understand the problem

error-why.jpg (205.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

avatar image
Former Member Jan 27, 2017 at 07:16 AM
0

Dear Malick,

If you have Stock in the warehouse , you cannot change Valuation method.

As per SAP Standard it will be grayed out .Once you don't have inventory ,this field becomes active and you can change Valuation method.

Please check in Test DB to get better clarity.

Hope this will help you

Regards

Anish A

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

@Anishsamvel A thanks for reply but the problem is same there is an itemcode with out the stock in inventory means with no quantity but again in valuation method there is again the standard with un editable

below is the screenshot for that itemcode

0
Jitin Chawla
Jan 27, 2017 at 07:31 AM
0

Hi,

Apart from Anish's recommendation above, you can check SAP Note No. : 869071 which discusses 'Changing the Valuation Method of Items'.

Hope it helps you.

Regards,

Jitin

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you for reply it showing again standard with un editable box

this is the image for refrence

0
Nagarajan K Jan 27, 2017 at 09:19 AM
0

Hi,

Below is the solution from SAP note 869071,

It is possible to change the Valuation Method of an item after transactions using the Inventory Valuation Method window (Inventory Management → Item Management → Inventory Valuation Method).

However, to change the Valuation Method of an item, the following conditions must be met:

•The In Stock quantity for the item must be zero in all warehouses.

•No open inventory relevant documents exist. Open inventory related documents include:

◦Open Deliveries, which are not copied to Returns.

◦Open Sales Return documents which are not based on Delivery documents.

◦Goods Receipt PO not copied to a Goods Return.

◦Open Goods Return, which is not based on a Goods Receipt PO.

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 27, 2017 at 12:30 PM
0

@Nagarajan Thanks for reply , plz check my reply on above comments

here is screenshot for your reference


Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi,

Did you confirm that no open inventory relevant documents exist?

Please use this query to make sure:

/* SELECT * FROM OITM i */
DECLARE @ItemCode AS NVARCHAR(20)
SET @ItemCode = /* i.ItemCode */ '[%0]'
SELECT 'Delivery:'
      ,h.DocNum
FROM DLN1 r
     INNER JOIN ODLN h ON r.DocEntry = h.DocEntry
WHERE (NOT h.DocStatus = 'C')
  AND r.ItemCode = @ItemCode
UNION ALL
SELECT 'Returns:'
      ,h.DocNum
FROM RDN1 r
     INNER JOIN ORDN h ON r.DocEntry = h.DocEntry
WHERE (NOT h.DocStatus = 'C')
  AND r.BaseEntry is null
  AND r.ItemCode = @ItemCode
UNION ALL
SELECT 'GRPO:'
      ,h.DocNum
FROM PDN1 r
     INNER JOIN OPDN h ON r.DocEntry = h.DocEntry
WHERE (NOT h.DocStatus = 'C')
  AND r.ItemCode = @ItemCode
UNION ALL
SELECT 'Returns PO:'
      ,h.DocNum
FROM RPD1 r
     INNER JOIN ORPD h ON r.DocEntry = h.DocEntry
WHERE (NOT h.DocStatus = 'C')
  AND r.BaseEntry is null
  AND r.ItemCode = @ItemCode

Regards,

Johan

1
Former Member
Johan Hakkesteegt

Thanks John, I appreciate your response :)

1
Francisco Fabiano Sep 29, 2017 at 12:57 AM
0

Purchase reserve invoice is consider a pending quantity?

I would like to change the valuation method till the moment before affect Stock.

Thanks in advance

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 07, 2017 at 09:29 AM
0

Hi,

In order to change the valuation method, there should not be any open transaction and stock should be zero.

Share
10 |10000 characters needed characters left characters exceeded