0

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!

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Nick
    • Nick
    • 3 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

    Like
  • That's too complicated.  I ended up just using a field with Number-Supplied!

    Like
    • Birger H
    • Birger_H
    • 3 yrs ago
    • Reported - view

    it has to be:

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

    Birger

    Like
    • Robert N
    • Robert_N
    • 2 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?

    Like
    • Luis Alarcon
    • TIM Systems
    • Luis_Alarcon
    • 2 yrs ago
    • Reported - view

    How can I keep track of inventory in a manufacturing process or a restaurant?

    Like
    • MariaNinox
    • Customer Service Ninox
    • Maria_pasini
    • 2 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!

    Like
Like Follow
  • 2 yrs agoLast active
  • 6Replies
  • 2392Views