Treat stock movement as a transaction
A stock issue should create a traceable movement or waybill. The sender's balance changes according to the configured business rule and the receiver explicitly accepts or rejects the movement.
Operational checks
- Verify source and destination stock locations.
- Confirm commodity and unit of measure.
- Record issued, received, consumed, returned, damaged, or adjusted quantities through approved transaction types.
- Do not repair balances by editing database rows directly.
Reconciliation
At close-out compare opening balance, receipts, issues, consumption, returns, adjustments, and expected closing balance. Investigate variances with the movement ledger and audit trail rather than a parallel spreadsheet.