How To Fix WR172 - Unprocessed Retail revaluation document item with status A exists

SAP Error Message - Details

• Message type: E = Error

• Message class: WR - Messages for Revaluation at Retail

• Message number: 172

• Message text: Unprocessed Retail revaluation document item with status A exists

What causes this issue?

Material &V1& is managed on a <ZK>value-only</> basis in plant &V2&.
Before the total stock can be revaluated, the stock on-hand <ZK>must be
counted</>.
A retail price change as a result of a pricing change has resulted for
&V3&.
However, retail revaluation document items with the status <ZK>A (to be
counted)</> still exist in plant &V2& for the same date of the retail
price change &V3&. These are a result of the previous
re-calculation of the sales price and <ZH>must be revaluated first</>.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Enter the quantity counted of the material and revaluate the material
using transaction <ZK>VKU3</> <ZK>
(partial revaluation online)</>. After the revaluation, the item status
is changed from <ZK>A (to be counted) </>to <ZK>C (revaluated)</>.
Using transaction <ZK>VKU6 (List display </><ZK>retail price changes)
</> or <ZK>VKU7 (automatic total revaluation at retail)</> - or by
scheduling report <ZK>RWVKU001</> in the background - revaluation
document items with status <ZK>A </> <ZK>(to be counted)</> can be
created for the new price.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message WR172 - Unprocessed Retail revaluation document item with status A exists ?

  Certainly! Here's a detailed explanation for the SAP error message WR172: "Unprocessed Retail revaluation document item with status A exists":
  
  Error Message: WR172
  Text:
  
  Unprocessed Retail revaluation document item with status A exists
  
  Cause:
  This error occurs in SAP Retail when you attempt to post or process a retail revaluation document, but there is already an existing revaluation document item with status A (which typically means "Created" or "Not yet processed") that has not been processed or cleared.
  In other words, the system detects that a previous revaluation document item is still open or pending, and it prevents you from creating or processing a new one to avoid inconsistencies or duplicate postings.
  
  Context:
  
  Retail revaluation documents are used to adjust inventory values based on price changes, cost updates, or other valuation reasons.
  Status A indicates that the document item is created but not yet posted or processed.
  The system enforces that only one revaluation document item per relevant criteria (e.g., material, store, period) can be open at a time.
  
  
  Solution:
  
  
  Check Existing Revaluation Document Items:
  
  Use transaction codes related to retail revaluation documents, such as:
  
  WRMASS (Mass Revaluation)
  WRMASS_DISPLAY (Display Revaluation Documents)
  Or relevant custom reports/transactions in your system.
  
  
  Identify the document item(s) with status A.
  
  
  
  Process or Delete the Pending Document:
  
  If the document item is valid and should be posted, proceed to post it.
  If the document item was created in error or is no longer needed, delete or cancel it according to your business process.
  
  
  
  After clearing the pending document item, retry your operation.
  
  
  Check for Background Jobs or Interfaces:
  
  Sometimes, revaluation documents are created by background jobs or interfaces and remain unprocessed.
  Ensure that these jobs have run successfully or manually process the pending documents.
  
  
  
  Consult with Retail Finance or Inventory Team:
  
  Since revaluation affects inventory valuation and financial postings, coordinate with the responsible teams before deleting or posting documents.
  
  
  
  
  Additional Information:
  
  
  Status Codes in Retail Revaluation:
  
  A = Created / Not processed
  B = Processed / Posted
  Other statuses may exist depending on configuration.
  
  
  
  Related Tables:
  
  /SAPAPO/REVAL or similar tables may store revaluation document items.
  Check your system's specific retail revaluation tables.
  
  
  
  Related Notes and Documentation:
  
  SAP Notes related to retail revaluation errors.
  SAP Retail documentation on inventory revaluation processes.
  
  
  
  Preventive Measures:
  
  Ensure timely processing of revaluation documents.
  Monitor background jobs that create or post revaluation documents.
  Implement checks in custom programs or user exits to prevent multiple open revaluation documents.
  
  
  
  
  Summary:
  
  
  
  Aspect
  Description
  
  
  
  
  Cause
  An unprocessed retail revaluation document item with status A already exists in the system.
  
  
  Effect
  New revaluation documents cannot be created or processed until the existing one is handled.
  
  
  Solution
  Identify and post or delete the pending revaluation document item with status A.
  
  
  Check
  Use retail revaluation transactions or reports to find and manage open document items.
  
  
  
  
  If you need specific transaction codes or steps tailored to your SAP Retail version or setup, please provide more details about your environment.
  
  Let me know if you want me to help with the exact steps to find and process these documents in your system!