/
Understanding Inventory Audit Report

Understanding Inventory Audit Report

This report helps you to track the complete life cycle of a sku available at the Eshopbox fulfillment center. This will give you a detailed report of each product available in the Eshopbox fulfillment center.

Audit Report

This report will provide the data for each sku. Each row of the downloaded report will represent the combination of sku and FC.

Summary

  • ESIN: Eshopbox serial identification number of the product.

  • Name of the product (sku): Unique identifier of the product assigned to the product by you.

  • Name of the fulfillment center.

  • Opening quantity: It is the physical count of your units in the FC at the beginning of the report date. (Sellable + Non sellable + Inward in progress + Outward in progress)

  • Inward quantity: Consignment items pending for inward and returns received yet to restock during the period. (Delivered quantity - Shortage quantity + Returned quantity)

  • Outward quantity: Orders items pending to ship and recall consignment items pending for handover during the period. (Invoiced quantity + Recalled quantity)

  • Closing quantity: It is the physical count of your units in the FC at the end of the report date. (Opening quantity + Inward quantity - Outward quantity)

Opening quantity

  • Sellable: Inventory which is available for sale at the beginning of the report date.

  • Non-sellable: Inventory that cannot be made available for sale at the beginning of the report date.

  • Inward in progress: Consignment items pending for inward and returns received yet to restock at the beginning of the report date.

  • Outward in progress: Orders items pending to ship and recall consignment items pending for handover at the beginning of the report date.

Inward quantity

  • Delivered: It is the total quantity of units of the consignment deliver at the FC via inward consignment.

  • Shortage: It is the total quantity of units of the consignment which is delivered but physically not received.

  • Returned: It is the total quantity of units returned to the FC against the orders invoiced.

Outward quantity

  • Invoiced: It is the total quantity of units invoiced from the FC against the orders received.

  • Recalled: It is the total quantity of units recalled from the FC against the recall consignment.

Closing quantity

  • Sellable: Inventory which is available for sale at the end of the report date.

  • Non-sellable: Inventory that cannot be made available for sale at the end of the report date.

  • Inward in progress: Consignment items pending for inward and returns received yet to restock at the end of the report date.

  • Outward in progress: Orders items pending to ship and recall consignment items pending for handover at the end of the report date.

Variance

  • Lost: It is the total quantity of units marked as lost.

  • Found: It is the total quantity of units marked as found.

Related content