Shipping check - Inventory update error

Creation date: 30/10/2025 09:23    Updated: 30/10/2025 09:23   @shipmentcheck @updateinventoryerror
Question:

Monday October 13, 2025 9:30 AM
Created by: Johanna Castro


Hi CSO,


We have a new error message encountered in Shipping check.  Please help to check.


SO25101100006

“Failed to update the inventory statement”


https://drive.google.com/file/d/1mKmcaxFyFp72ccNvD5poLNN3ydYWKq0h/view?usp=drive_link


INCIDENT REPORT

IT WMS 25-34

Customer name: Phardz Garcia

Issue Description: Failed to update the inventory statement

Affected Environment: Live

Affected warehouse: Tunasan

Screenshots of error messages: < Attachment >

Time when issue occurred: 10/13/2025 9:22

Affected module: Shipping Check

Detailed description of issue: Failed to update the inventory statement

Expected result: 0

First level investigation/troubleshooting taken: 0

Case replication in original warehouse: < Details of replicated case >

Sample Screenshot:


Answer:

Monday October 11, 2025 10:50 AM
Commented by: Johanna Castro


INVESTIGATION:
  • From the recording, it seems the error may have been triggered by clicking the “Confirm” button twice. We need confirmation from the user on why this action was done.
  • The SO is currently in Cartonized status. Based on the edit timestamp, the Shipment Check was completed on 2025-10-13 at 10:08:36.
  • For SKU IC-23-646, the quantity remains under QTY Allocated, and the inventory balance appears consistent. 
  • Upon refresh the SO status is now Shipment Order Closed (Edit Time: 2025-10-13 at 10:17:20).
  • Upon rechecking the inventory for the SKU involved, the allocated lot is no longer present in the system, which aligns with what we see in the database and on the UI. 

ROOT CAUSE:
  • There doesn't appear to be an issue with the inventory balance for SKU IC-23-646 with Trace ID 9K337449.

  • The error message likely resulted from an operational event specifically, a repeated confirmation click, causing the system to attempt an update to an already-updated inventory balance.