This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi, I have in shortcut
table Productstable Deliveries with a link to a product and amount of the product we bought in that particular delivery
and some other tables storing how many products were sold, used, etc.
and I would need to have a Stock tabl...
Having delivery and subdeliveries doesn’t help or I don’t see a way. I’m able to do SUM of associated deliveries but I’m not able to do SUM of previous associated deliveries. Have a look here https://airtable.com/shrGv4VthYG6JcIgI I faked in the tab...
Simply I’m looking for a way how to track First In First Out stock.
So I have a product with 3 deliveries - first for 6 items, second for 8 items and third with 5 items.
It’s 19 IN and I sold 10 pieces. We need to know which 9 items are in stock. It’...
Many thanks, Arlo, we’re getting closer. Perhaps I could rethink the concept. But It should be simple for my non-technical colleagues.
I created simple base to show you what I need to do https://airtable.com/shrGv4VthYG6JcIgI
We need to be able to se...
Arlo, I understand what you mean. Actually, we have it as well. My problem is how to calculate SUM of all previous transactions linked to one product (customer at your db) for every transaction.
customer x
transaction linked to x
transaction y1 - 10 ...
Thanks, Damon, I know about it, actually I’m using it in that table but id doesn’t help me with the calculation of pieces left in the stock. Or does this grouping brings some new formula?
