AnsweredAssumed Answered

Calculation Question

Question asked by ianchristopher on Aug 10, 2013
Latest reply on Aug 11, 2013 by ianchristopher

Title

Calculation Question

Post

     Hello,

      

     I am making a simple inventory system which keeps track of units in and units out and then calculates the on hand quantity. So I have 2 fields: Units in and Units out. There are also 2 layouts, one for scanning in UPC's and another for manually entering part numbers. Everytime you scan a UPC, there is a new record. And when you enter a quantity manually the units in/out fields will get the quantity.

     The calculation I am using for units in is this:

      

      

     If ( ((${Check In/Check Out Mode} = "Scan") & (Action = "Check In"))  ; 1 ; 
      
     If ( ((${Check In/Check Out Mode} = "Manual") & (Action = "Check In")) ; GetField ( Bulk Quantity ) ; 0 ) )
      
     The units out calculation is similar. 
      
     So when I scan something in, the Units In field should say 1, and Units Out should be 0.
      
     However, when making a new record units in and units out both display a 1. 
      
     Can someone explain what is happening here? And is there a way to make this approach work?
      
      

Outcomes