Need help with moving inventory from site to site

Ask for Help
1

Hey everyone!

I am creating an app for a company that keeps track of their inventory across various sites. I’m having difficulties with implementing a function that allows the user to move one item to another and set the quantity.

At the moment, the user has to go on the equipment at one location, subtract from it x amount, and then go to the new location, add the item there, and add x amount to it.

I would be very grateful for any help. I am willing to pay money for this. Please reach out, I would love to organise a call.

Thank you!

2

I think it would be beneficial for you to have a logs table.

In that table, you store information related to:

Item ID
Transfer From - Location ID
Transfer To - Location ID

Then, you can have a rollup of all transfer from transactions and transfer to transactions in your items table (which I assume would have a unique combination of item ID and location ID in each row).

Use a math column to calculate the live amount: base amount - rollup sum of transfer from transactions + rollup sum of transfer to transactions.