How to get total inventory for a given day from Inventory Ledger?
user profile
Seller_wrXqE6Orj7m9C

How to get total inventory for a given day from Inventory Ledger?

Hello,

If I run an inventory ledger report, - daily report - summary by country, what columns would I add to get the total inventory count for that date?

Thank you for the help!

12 views
1 reply
Tags:Inventory, Inventory feeds
00
Reply
1 reply
user profile
Seller_i6S8knzW6zU6Z

Hi @Seller_wrXqE6Orj7m9C,

Looking at the Inventory Ledger report documentation here, for a daily summary by country report, you'll want to add together two main columns:

  1. "Ending warehouse balance" - This shows your units available in fulfillment centers
  2. "In transit between warehouses" - This covers any units being transferred between facilities

Here's a helpful tip from the documentation's example section: If you have inventory in different conditions (like both Sellable and Damaged), make sure to include all relevant dispositions when adding up your totals.

You can find detailed descriptions of all the columns in the Custom Report Builder help page here under "Attributes available in the Inventory business view."

Hope this helps you get an accurate count of your total inventory! Let me know if you need any clarification.

10
Follow this discussion to be notified of new activity

Similar Discussions