Consignment Goods Not Owned Exclude Checker

Reconcile actual on-site stock values with explicit caller ownership evidence, retaining excluded consignment lines; physical possession alone does not establish ownership or which off-site owned stock is missing.

Description

Physical stock possession does not establish ownership.

Physical stock possession does not establish ownership. Explicit ownership flags separate included inventory from consigned goods.^[1]

The returned values include Owned inventory included minor, Unowned consigned stock excluded minor, Excluded observed line indices. The How section below explains the calculation, input rules and interpretation.

When to use Consignment Goods Not Owned Exclude Checker

Use Consignment Goods Not Owned Exclude Checker when you need to evaluate the supplied records under the calculation and evidence rules below. No ownership investigation, unknown-evidence category or missing off-site inventory is inferred.

Gather the source balances and explicit accounting policy. Monetary inputs use integer minor units in one currency; for a currency with 100 minor units per major unit, 12345 represents 123.45. One basis point is 0.01 percentage points; 10000 basis points is 100%. Dates and posting signs follow the individual rules below.

How to use Consignment Goods Not Owned Exclude Checker and understand its results

Gather the source balances and explicit accounting policy. Monetary inputs use integer minor units in one currency; for a currency with 100 minor units per major unit, 12345 represents 123.45. One basis point is 0.01 percentage points; 10000 basis points is 100%. Dates and posting signs follow the individual rules below.
Enter observedStockAmountsMinor, callerOwnedFlags using the field table and calculation rules, then run the tool.
Read ownedInventoryIncludedMinor, unownedConsignedStockExcludedMinor, excludedObservedLineIndices. The explanation below defines the units, signs, ordering and any flags or placeholder values.
If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.

Input field	Meaning	Value type; see rules below	Requirement
observedStockAmountsMinor	Observed stock amounts minor	list of number	Required
callerOwnedFlags	Caller owned flags	list of number	Required

Enter aligned nonempty nonnegative safe-integer observed values and binary caller ownership flags. Return checked owned/unowned totals and zero-based excluded indexes.

owned=sum(value where owned1); excluded=sum(value where owned0)

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output field	Meaning	Value type
ownedInventoryIncludedMinor	Owned inventory included minor	number
unownedConsignedStockExcludedMinor	Unowned consigned stock excluded minor	number
excludedObservedLineIndices	Excluded observed line indices	list of number

json

{
  "input": {
    "observedStockAmountsMinor": [
      100,
      200,
      300
    ],
    "callerOwnedFlags": [
      1,
      0,
      1
    ]
  },
  "output": {
    "ownedInventoryIncludedMinor": 400,
    "unownedConsignedStockExcludedMinor": 200,
    "excludedObservedLineIndices": [
      1
    ]
  }
}

Limitations and assumptions

No ownership investigation, unknown-evidence category or missing off-site inventory is inferred.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Numeric lists are limited to 10,000 entries and string lists to 128 entries of at most 128 characters. Follow any smaller limits above. Missing fields without a declared default, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use NRV Lower Of Cost NRV Inventory Test Tool: Net realizable value subtracts completion and selling costs from expected selling price. Inventory carrying value uses lower cost or NRV with a zero floor. For a complementary task, use Inventory Observation Count Tag Two-Team Controls Lookup: Two inventory counts and control tags provide different evidence. Count agreement alone does not satisfy the tag check.

References

Consignment Goods Not Owned Exclude Checker — tool.io

Similar or alternative tools

NRV Lower Of Cost NRV Inventory Test Tool
Net realizable value subtracts completion and selling costs from expected selling price. Inventory carrying value uses lower cost or NRV with a zero floor.
Inventory Observation Count Tag Two-Team Controls Lookup
Two inventory counts and control tags provide different evidence. Count agreement alone does not satisfy the tag check.