Show Available Stock Quantity at Bin / Inventory Dimension Level

Description: Currently, Inventory Dimensions are selectable in both Sales Order and Sales Invoice. The issue is not with selecting or applying the Inventory Dimension.

The issue is that the available stock quantity is not visible at the Bin / Inventory Dimension level. Users can see the available stock at the Warehouse level, but they cannot see how much stock is actually available for a specific Bin / Inventory Dimension.

Similarly, in the Item Master, stock balance is available warehouse-wise, but there is no visibility of the stock balance for each Bin / Inventory Dimension.

Current Behavior:

• Sales Order and Sales Invoice support selection of Inventory Dimensions.
• Available stock quantity is displayed at the Warehouse level.
• Stock balance in Item Master is available warehouse-wise.
• Bin / Inventory Dimension-wise stock balance is not displayed.

Expected Behavior:

• Show the available stock quantity for each Bin / Inventory Dimension.
• In Sales Order and Sales Invoice, when an Inventory Dimension/Bin is selected, users should be able to see the available quantity for that specific Bin/Dimension.
• In Item Master, provide visibility of Bin-wise / Inventory Dimension-wise stock balance, in addition to the existing warehouse-wise stock balance.
• The displayed quantity should reflect the actual available stock for that specific Bin/Inventory Dimension.

Business Requirement: Users need to know the actual available quantity at the Bin / Inventory Dimension level, rather than only knowing the total quantity available in the Warehouse. This is required for accurate stock allocation and inventory visibility during the sales process.

Modules: Stock / Selling Documents: Sales Order, Sales Invoice, Item Feature Area: Inventory Dimensions / Bin-wise Stock Balance

@DipenFrappe can you plzz look this ? cc:@FOSS-ERP