Hi, There is no inventory table in the principle sense in Business Central, you need to calculate it in the Item Ledger Entry table. If you need Bin information, you also need to extract it from the Warehouse Ledger Entry table.
You can refer to the standard Query below.
Hope this can give you some hints.
Thanks.
ZHU
