Sanyakorn Chaiphiphatworakul
All work

In production

Container evaluation

Scores export container condition per shipment and rates forwarders and hauliers, using order data from the ERP.

Period
2024 – 2026
Role
Sole developer
Used by
QA and food safety

What I built

Pick an ERP order and the container, seal and transport details fill in. Inspectors score against configurable criteria, approvers sign off, and the system builds monthly carrier performance reports.

Key features

  • Customer, container number, size, seal and transport filled from the ERP
  • Configurable scoring groups and criteria
  • Sign-off, in-app alerts and email when scoring completes
  • Printable evaluation PDF
  • Monthly shipping-agent and transport performance reports
  • Field-level change log with old and new values

Under the hood

  • ODBC link to the ERP (DB2) for order headers and shipments from the last two years
  • Retro-fitted company SSO onto the 2024 app with cookie auth and a claims transformation