Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Original Problem

The last step in receiving/check-in flow is to update the status of PO Line to "Partially Received" or "Fully Received". It's possible that something may go wrong and status won't be updated even though the items were actually received. So the mechanism to guarantee the status is up-to-date needs to be worked out.

Possible Approaches

Check and updating the PO line status upon retrieving

Trigger functions

Vert.X Periodic Timer

#_executing_periodic_and_delayed_actions

PostgreSQL cron-job

pg_cron

Summary