Transfer items in inventory managment app

[Omer_Man]

Hello,
I started to build my own app for my business (a bar) and i have many locations (warhouses) where i place my inventory. its important for me to know where the inventory is placed in any time. i want to make a feature in the app where i can transfer items between warhouses, for example:
transfer 20 bottles of vodka from warhouse A to warhouse B.
any ideas how can i do it?
thanks!

[IrsyadIsmail]

Any luck so far?

[Hani_Ibrahim]

right now i am preparing an inventory system almost like yhe one you do,

i created the following tables:

• Table for all products i have

• Table for stores

• Table for products in “supply”

• Table for products out “Export”

• Table for transfer between Stores from “Store A” to “Store B”
  Each table has a column referencing the Store from Stores table
  so i can easily open the store detailed view and see the related Transferred Products and its Qty.