Trying to write basic mathematical formula for Inventory

I need a sum so that the display shows the Remaining Stock

Fields are currently numeric for "Number" and "Supplied"

eg: Number = 50, Supplied = 3, so Remaining Stock = 47

I had: Remaining Stock = Number - Supplied

HELP!

- Nick
- 5 yrs ago
- Reported - view
Hi,

the normal way to count Inventory Items is:

Remaining Stock = UnitsInStock + sum(PurchaseInvoice.Supplied) - sum(SalesInvoice.Sold)

Please give us more details to help you out.

Nick
- Beswick_Life_Celebration
- 5 yrs ago
- Reported - view
That's too complicated. I ended up just using a field with Number-Supplied!
- Birger_H
- 5 yrs ago
- Reported - view
it has to be:

–––
Remaining Stock := Number - Supplied
–––

Birger
- Robert_N
- 4 yrs ago
- Reported - view
What I have is I'm tracking starting inventory, added inventory, transfered inventory, sold inventory, and end of day inventory. My problem is that i want to automatically sort items whether or not they are in the store. I'm currently using this:

if 'Starting Qty' = 0 then "No" else "Yes" end

I need to find a way to have it say Yes when the Add field has a number in it. Can anyone help me with this?
- TIM Systems
- Luis_Alarcon
- 4 yrs ago
- Reported - view
How can I keep track of inventory in a manufacturing process or a restaurant?
- Customer Service Ninox
- Maria_pasini
- 4 yrs ago
- Reported - view
Dear Luis,
You are welcome to try out our Inventory Template on Ninox https://ninox.com/en/templates/inventory
Hopefully that will be usefull to you!

Content aside