The Excess Found inventory status is used when an item previously marked as Not Found is physically located in the warehouse but cannot be marked as found due to a barcode-related issue.

In such cases, the warehouse team creates a Re-inward consignment to record the recovered inventory. Once the re-inward process is completed, the recovered quantities are reflected in Excess Found inventory.

As a result, the same SKU may appear under three inventory statuses: Not Found, Excess Found, and Sellable.

How does Excess Found occur

When the warehouse team is unable to locate an item, it is marked as Not Found. If the item is recovered later but its barcode is faded or unreadable, the team may be unable to update its status to Found.

To account for the recovered inventory, the warehouse team follows this process:

1. The warehouse team identifies an item previously marked as Not Found.
2. Due to a faded or unreadable barcode, the item cannot be marked as Found.
3. A new Re-inward consignment is created for the affected items.
4. The recovered items are inwarded through the new consignment.
5. Once the re-inward process is completed, the re-inwarded quantities are reflected in Excess Found inventory.

The original quantity may continue to appear under Not Found, even though the items have been physically recovered.

Understanding inventory statuses

The same SKU may appear under multiple inventory statuses:

• Not Found: Items that were previously reported missing and have not been updated as found.
• Excess Found: Items recovered and re-inwarded through a new consignment because the original inventory status could not be updated.
• Sellable: Items available in sellable inventory.

How to calculate the actual Not Found quantity

Since recovered items may remain recorded under Not Found while also appearing under Excess Found, the Not Found quantity may not represent the actual number of missing items.

To determine the actual missing quantity, subtract the Excess Found quantity from the Not Found quantity.

Formula:

Actual Not Found = Not Found Quantity − Excess Found Quantity

Example

Consider a SKU with the following inventory quantities:

Using the formula:

Actual Not Found = 20 − 8 = 12 units

In this example:

• 20 units were originally marked as Not Found.
• 8 units were subsequently recovered and processed through a Reinward consignment.
• 12 units remain unaccounted for.

Therefore, the actual Not Found quantity is 12 units, rather than the 20 units displayed under Not Found.

Important considerations

• A faded or unreadable barcode may prevent recovered items from being marked as Found.
• The recovered quantities are reflected in Excess Found inventory after the re-inward process is completed.
• The same SKU may appear under Not Found, Excess Found, and Sellable inventory statuses.
• When calculating the actual Not Found quantity, subtract only the Excess Found quantities associated with the corresponding Not Found inventory.
• The presence of a SKU under multiple inventory statuses does not necessarily indicate additional physical stock.

Note: The actual Not Found quantity should be calculated using the adjusted inventory figures rather than relying solely on the quantity displayed under Not Found.