Define the reporting boundary
Agree the period, timezone and treatment of unposted movements at cut-off. Overnight work and late documents can place the same movement on different dates. Distinguish generation time from business cut-off. Mark revised reports with versions and reasons rather than silently replacing files already used for decisions.
Separate balance from availability
Physical balance may include pending inspection, held and picked-but-unshipped goods. Availability applies agreed restrictions and allocations. In-transit shipments and return requests are not automatically on-site stock. Define mutually exclusive states versus overlapping attributes to prevent double deductions, especially where held and allocated quantities refer to the same units.
Reconcile movements to the closing balance
Use consistent units across opening, receipts, dispatches, returns, corrections and closing stock. Internal relocations affect locations but not total stock; ownership transfers affect owner balances. Trace differences to transaction IDs rather than an unexplained other-adjustment column. For late entries, preserve both occurrence and posting dates.
Manage questions and revisions
A discrepancy request should identify SKU, batch, expected quantity and evidence. Revised reports should flag impacts on decisions or settlement already made. Classify recurring problems as timing, unit, status or actual stock differences and address each appropriately. Report acknowledgement does not by itself settle contractual rights concerning later findings.
Illustrative decision or record
Illustrative report: a 100-unit balance includes 20 allocated units and ten separately held units, producing 70 available under the agreed formula. If those ten held units are already within the allocated 20, subtracting twice is wrong. State the relationship between categories. This illustrates definitions and does not prescribe a universal availability formula for every system.
Before you proceed
- Cut-off and report versions are identifiable
- Balance, availability, holds and transit are defined
- Differences link to transactions or open investigations
Related operations
Review the cargo and the work together
Share the product, packaging, batches and quantities, customs status, expected schedule and the special requirements discussed here. Confirm acceptance before arranging delivery.