Tracing recurring ERP stock discrepancies
I investigated recurring differences in ERP stock records. Controlled tests ruled out the network and isolated an application issue.
PT Cipta Kemas Indah Cemerlang
Investigated, tested and documented findings
Findings that supported management's decision to replace the ERP.
01 / Context
Recurring differences in stock records
Stock discrepancies kept recurring in the ERP. I investigated whether the cause was in the network or the application.
02 / Contribution
Testing the suspected cause
I tested the suspected causes under controlled conditions, ruled out the network and isolated an application issue. I documented the findings for management.
My day-to-day responsibilities include ERP support and Microsoft SQL Server/T-SQL. This case covers the investigation and technical findings.
03 / Outcome & scope
Findings used by management
The findings supported management's decision to replace the ERP. The replacement and data migration are outside the scope of this case.