/
Reconciling Inventory

Reconciling Inventory

Owned by Mituj Rana
Last updated: Jul 17, 2020
2 min read

  1. Inventory audit summary

  2. Inventory ledger

Steps to reconcile inventory

Navigate to Reports from the navigation bar of the Eshopbox workspace. Here you’ll see the multiple reports available on the Eshopbox workspace.

Click on the inventory report available in the Inventory block. You’ll be redirected to the Inventory audit detail pane. Here you’ll see the inventory audit summary of last 7 days by default having below details:

  • ESIN and name of the product (sku).

  • Fulfillment center.

  • Opening stock 7 days ago.

  • Inventory received at Eshopbox FC in the last 7 days.

  • Inventory invoiced in the last 7 days.

  • Inventory returned to the Eshopbox FC in the last 7 days.

  • Inventory recalled from Eshopbox FC in the last 7 days.

  • Closing stock as of today.

  • Any inventory marked as lost in the last 7 days.

  • Any inventory marked as found in the last 7 days.

You can also view the inventory ledger from the details pane itself. Here you can track each and every movement of the inventory. You’ll be able to view:

  • ESIN and name of the product (sku).

  • Fulfillment center.

  • Transaction type / Event type. (https://support.stitchlabs.com/en/articles/90105#inventory-event-types)

  • Transaction id like the order number, consignment number, etc. (need to define these)

  • Transaction date / Event date. You can filter for a maximum of 30 days range.

  • Quantity.

  • Closing stock after the transaction/event.

The inventory audit report is not in real-time. You can view the UP-TO-DATE THROUGH to check the by when is the report updated. Usually, the gap is 3-4 hours from the current time. (Need to discuss this)

You can also filter the report using:

  • ESIN.

  • Name of the product(sku) or and other additional names assigned to the product.

  • Fulfillment center.

  • Transaction Date.

  • Transaction type / Event type. This is available only for inventory ledger.

ESIN in which there are no inventory changes won’t be a part of the report.

 

// Download the report

You can download the inventory audit summary as well as the inventory ledger. Click on the Download icon action button available on the top right. You’ll be notified once the download is completed. A zip folder will be downloaded which will have below files:

  • Inventory audit report

  • Inventory ledger

  • Inward report of the inventory received at Eshopbox FC.

  • Order report of items invoiced.

  • Inventory returned to the Eshopbox FC.

  • Inventory recalled from Eshopbox FC.

  • Current inventory summary

Transaction Type and subtype and transaction ID

  1. Received

    1. Inward - Inward consignment number

    2. Return - Recall Id

  2. Removed

    1. Order - Order number / Shipment number

    2. Recall - Return consignment number

    3. Shortage - Inward consignment number

  3. Lost

    1. Cycle count -

    2. Damaged -

    3. Picking / Processing - (no transaction id) or picklist id

  4. Found

    1. Found -

Data points in the csv:

  • Transaction Type

  • Transaction subtype

  • Reference

  • ESIN

  • Name of the product (sku)

  • Fulfillment center

  • Quantity

  • Transaction date and time

 

 

 

Related content