Seller Central report path
Reports>Fulfillment>Inventory>Inventory Ledger
Table name
Seller: inventory_ledger_details
The inventory ledger report operates like a bank statement for a seller’s FBA inventory, providing end-to-end inventory reconciliation. The detail table shows details about all inventory events in a fulfillment center, including reason codes for inventory adjustments.
Statistics
Updated: Daily
Backfill: 1 year
Key Metrics
quantity
disposition
reason
Data Dictionary
Inventory Adjustment Reason Codes
Code | Type | Reason | Definition |
6 | - | Damaged at Amazon fulfillment center | A decrease to your carrier-damaged inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level. |
7 | - | Damaged at Amazon fulfillment center | A decrease to your expired inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level. |
E | - | Damaged at Amazon fulfillment center | A decrease to your sellable inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level. |
H | - | Damaged at Amazon fulfillment center | A decrease to your customer-damaged inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level. |
K | - | Damaged at Amazon fulfillment center | A decrease to your defective inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level. |
U | - | Damaged at Amazon fulfillment center | A decrease to your distributor-damaged inventory level. This code is always followed by a P code increase to your fulfillment-center-damaged inventory level. |
D | - | Inventory disposed of | A decrease to your inventory level because inventory has been disposed of |
F | + | Inventory found | An increase to your inventory level because missing inventory has been found |
N | + | Inventory found | An increase to your inventory level because inventory that was incorrectly assigned has been transferred to your account or because you received an Amazon reimbursement |
M | - | Inventory misplaced | A decrease to your inventory level because inventory is missing from a bin location in a fulfillment center |
5 | - | Inventory misplaced | A decrease to your inventory level because inventory is missing from a bin location in a fulfillment center |
3 | + | Product redefinition transfer in | Two products with separate identifiers (SKUs) are determined to be the same item. One SKU will be removed from your inventory (code 4) and added (code 3) as the other SKU. |
4 | - | Product redefinition transfer out | Two products with separate identifiers (SKUs) are determined to be the same item. One SKU will be removed from your inventory (code 4) and added (code 3) as the other SKU. |
O | - | Inventory correction | Units that have been transferred out of your account because they were incorrectly received into your inventory or because Amazon has reimbursed you for them |
P | + | Inventory disposition change | Units of a certain disposition are added to your inventory after the removal from a different disposition. This code always follows a code 6, 7, E, H, K, U, or Q adjustment. |
Q | - | Inventory disposition change | Units of a certain disposition are removed from your inventory and then added back to your inventory as a different disposition. This code is always followed by a P code adjustment. |