How To Fix WSTI_CALC068 - Item written off but unposted POS transactions still exist in PIPE

SAP Error Message - Details

• Message type: E = Error

• Message class: WSTI_CALC - Physical Inventory Messages: Book Inv. Calc. at Count Time

• Message number: 068

• Message text: Item written off but unposted POS transactions still exist in PIPE

What causes this issue?

The book inventory has been calculated and the inventory difference
written off for this item. However, there are POS transactions in the
PIPE that are relevant for this item and that have not yet been
transferred to the ERP system. This means that if you were to
recalculate the book inventory for the count time, this could lead to a
different result. However, since the difference has already been written
off, which means that physical inventory is completed, no further
changes can be made to the item.

System Response

The system displays this message as the result of an analysis when the
POS transactions are displayed for the inventory document.

How to fix this error?

Find out why additional relevant POS transactions have been transferred
to the PIPE after the book inventory was calculated for the count time
and the differences were written off. Make sure this does not happen
again.
You can restart the function for displaying the POS transactions after
you have posted these POS transactions to the ERP system. In this case,
an additional message is displayed indicating whether a different value
would have resulted from recalculating the book inventory. If this would
have resulted in a different value, you should consider repeating
physical inventory for this material.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message WSTI_CALC068 - Item written off but unposted POS transactions still exist in PIPE ?

  Certainly! Here's a detailed explanation for the SAP error message:
  
  SAP Error Message:
  WSTI_CALC068 - Item written off but unposted POS transactions still exist in PIPE
  
  Cause:
  This error occurs during the write-off process in SAP Retail when the system detects that there are still unposted Point of Sale (POS) transactions in the PIPE (Post In Process Environment) table for the item that is being written off.
  
  PIPE is a staging area where POS transactions are temporarily stored before being posted to the backend system.
  If an item is written off (e.g., due to damage, loss, or expiration), but there are still unposted POS transactions related to that item in PIPE, the system raises this error to prevent inconsistencies in inventory and financial data.
  Essentially, the system is warning that you cannot write off an item while there are pending sales or returns transactions that have not yet been posted.
  
  
  Solution:
  To resolve this error, you need to ensure that all POS transactions related to the item are posted before performing the write-off.
  Steps to resolve:
  
  
  Check for unposted POS transactions:
  
  Use transaction codes or reports to identify unposted POS transactions in PIPE.
  For example, use transaction /POSDW/PIPE or relevant POS data warehouse tools to view unposted transactions.
  
  
  
  Post the pending POS transactions:
  
  Run the POS posting programs or batch jobs to post all pending transactions.
  Common programs include POS posting jobs like /POSDW/POST or similar, depending on your system setup.
  
  
  
  Verify that PIPE is empty for the item:
  
  Confirm that no unposted transactions remain for the item in PIPE.
  
  
  
  Retry the write-off process:
  
  Once all POS transactions are posted, proceed with the write-off again.
  
  
  
  If transactions cannot be posted:
  
  Investigate why POS transactions are stuck (e.g., errors in posting, missing master data).
  Resolve underlying issues before attempting write-off.
  
  
  
  
  Related Information:
  
  
  PIPE (Post In Process Environment):
  
  A temporary storage area for POS transactions before they are posted to the backend system. Ensures data consistency and allows batch processing.
  
  
  Write-off Process in SAP Retail:
  
  Used to adjust inventory for items that are lost, damaged, expired, or otherwise removed from stock without sale.
  
  
  POS Posting Jobs:
  
  Regular batch jobs that post POS transactions from PIPE to the backend system, updating inventory and financial records.
  
  
  Transaction Codes:
  
  /POSDW/PIPE – Display PIPE transactions.
  /POSDW/POST – Post POS transactions.
  WSTI – Write-off transaction interface (depending on system).
  
  
  
  Notes and Documentation:
  
  Check SAP Notes related to POS posting and write-off processes.
  Review SAP Retail documentation for PIPE and POS transaction handling.
  
  
  
  
  Summary:
  Error WSTI_CALC068 indicates that you cannot write off an item because there are still unposted POS transactions in PIPE. The solution is to post all pending POS transactions first, then proceed with the write-off.
  
  If you need help with specific transaction codes or programs in your SAP Retail system, please provide your SAP version or module details.