Inventory Management App

I have noticed it is a general pattern for most inventory management to allow user to input items sold each time. My challenge is unique, I hoping to create an app that keeps track of remaining stock everyday such that items sold can be determined dynamically rather than me inputting that.

In a small retail shop, it is convenient to count stock remaining every morning rather than recording every sale every time.

What logic do I use to ensure that I only input remaining stock every morning then the app itself can calculate number of items sold keeping in mind the remaining stock plus restock items for the previous day.

Hello @KelvinMacharia , your expression for the sales on each product would be something like this, if that you have a table called “Inventory reviews” for logging each item’s inventory amount at the start of the day, it would be a virtual column with this expression:

[currentInventory]-INDEX(SELECT(Inventory reviews[currentInventory],AND([ID]=[_THISROW].[ID],[date]=[_THISROW].[date]+1)),1)

1 Like

Hello *@*Rafael_ANEIC-PY,

Here is a link to my appssheet as described in my question. Kindly help me
implement the formula for sales as you have recommended.

*https://www.appsheet.com/Template/AppDef?appName=Inventory_app_mamuska_kosovo-6502791&utm_source=share_app_link
*

Here is the formula you recommended:

[currentInventory]-INDEX(SELECT(Inventory reviews[currentInventory],AND(
[ID]=[_THISROW].[ID],[date]=[_THISROW].[date]+1)),1)

The spreadsheet contains current inventory for 30th May 2022 and 31st May
3021 in the ‘Inventory reviews’ sheet of the spreadsheet.
How do I get sales for 31st May 2022 and so forth assuming I will continue
logging in the data everyday? How do I display the sold quantity and amount
sold(the sheet ‘Inventory’ sheet contains the price of each product).

Regards,
Kelvin Macharia
whatsapp +254714846762