SQL to get stock balance

[royprotim]

From which table or tables we can get stock balance of an item through sql query?

[makarand_b]

@royprotim

From which table or tables we can get stock balance of an item through sql query?

check the tabBin for stock balance

[royprotim]

Thank you very much. That helped.

[Tom_AEC]

We are using Version 13 on Frappe cloud, but cannot find the table tabBin, could you please advice the sql to pull the standard stock balance data

We tried auto email for standard stock balance, but it is not saving due to from and to dates
Please help