How to disappear "zero" stock location

[sangmin]

hi~
i work in warehouse. my company dosen’t have WMS.
so i want to make a simply location management app.

i found next Topic

Inventory tracking various locations Questions

I’d go with the following (TESTED): Location table. Fields: ID, Name Item table. Fields: ID, Name, other Inventory table. Fields: ID, Item (Ref), Location (Ref), Stock (VC) Transfer table. Fields: ID, timestamp, From Location (Ref), To Location (Ref) Transfer_Item table. Fields: ID, Transfer (Ref), Item (Ref), Quantity The Stock Virtual Column should take into account all the negative contributions of the From Location column, and all the positive contributions of the To Location column. …

i understood tracking From~To Location.
i just want to know how to show the current stock to the location.

ex)

[perissf]

Hi @sangmin
If you implement the table schema and column definition as per my post, showing the Inventory table will give you the exact view you are looking for.

If it’s not clear, please expand your question, or contact me in PM, I’ll give you access to my app