Why i can not change the Valuation Method ??

[former_member654993]

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

[former_member816721]

You can search for any open transactions by replacing the XXX in the queries below with your problematic item number. If it returns a result, go fix it and you should then be able to change your valuation method.

select 'GRPO', T2."DocNum" from PDN1 T1 Inner Join OPDN T2 on T1."DocEntry"=T2."DocEntry" where T1."TargetType"<>'21' and T1."ItemCode"='XXX' and T1."LineStatus"='O';

select 'Good Return', T2."DocNum" from RPD1 T1 Inner Join ORPD T2 on T1."DocEntry"=T2."DocEntry" where T1."TrgetEntry" is null and T1."BaseType"<>'20' and T1."ItemCode"='XXX' and T1."LineStatus"='O';

select 'A/P Invoice', T2."DocNum" from PCH1 T1 Inner Join OPCH T2 on T1."DocEntry"=T2."DocEntry" where T1."ItemCode"='XXX' and T1."LineStatus"='O' and T1."BaseEntry" is null;

select 'A/P Credit Memo', T2."DocNum" from RPC1 T1 Inner Join ORPC T2 on T1."DocEntry"=T2."DocEntry" where T1."ItemCode"='XXX' and T1."LineStatus"='O';

select 'Sales Delivery', T2."DocNum" from DLN1 T1 Inner Join ODLN T2 on T1."DocEntry"=T2."DocEntry" where T1."TargetType"<>'16' and T1."ItemCode"='XXX' and T1."LineStatus"='O';

select 'Sales Return', T2."DocNum" from RDN1 T1 Inner Join ORDN T2 on T1."DocEntry"=T2."DocEntry" where T1."TrgetEntry" is null and T1."BaseType"<>'15' and T1."ItemCode"='XXX' and T1."LineStatus"='O';

select 'A/R Invoice', T2."DocNum" from INV1 T1 Inner Join OINV T2 on T1."DocEntry"=T2."DocEntry" where T1."ItemCode"='XXX' and T1."LineStatus"='O' and T1."BaseEntry" is null;

select 'A/R Credit Memo', T2."DocNum" from RIN1 T1 Inner Join ORIN T2 on T1."DocEntry"=T2."DocEntry" where T1."ItemCode"='XXX' and T1."LineStatus"='O';

[Former Member]

I saw your posted answer. I'd recommend replying to newer questions or asking a new question as this question is now a few years old and the original question poster may not reply. Feel free to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. With these tips you'll be able to prepare questions that draw responses from our members. Thanks!

Best,

Your SAP Community moderator

[narayanis]

Hi,

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

[ffabiano]

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

[former_member654993]

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

here is screenshot for your reference

[Johan_H]

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

[former_member654993]

Thanks John, I appreciate your response 🙂

[kothandaraman_nagarajan]

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

[jitin_chawla]

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

[former_member654993]

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

this is the image for refrence

[Former Member]

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

[former_member654993]

@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