Hi
One option is to use Business Central's Inventory Valuation report, which provides a detailed view of inventory movements, balances, and values across multiple locations and bins. You can filter the report by item, location, and date range to get the specific information you need.
Another option is to use Business Central's Inventory Posting Groups feature to group inventory transactions by specific criteria (such as warehouse location, bin number, or product category). This allows you to easily track and analyze inventory movements by these criteria.
You can also use Business Central's Jet Reports extension to create customized reports that consolidate and analyze inventory data across multiple warehouse bins. Jet Reports is a powerful reporting tool that integrates directly with Business Central and allows you to build reports using Excel.
DAniele