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