Tabs are "Deliveries", "Inventory", "Pickup orders". Can both the delivery quantity & pick-up quantity to reduce the # in the inventory tab from orders, is this possible?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Photo of Crystal


  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
If you have a table of items, yes you can make a summary field for any transactions which represent stuff going out and another summary field to represent stuff coming in, and probably another summary field to represent adjustment transactions (for when you do a physical count) and then you can calculate the amount available for sale.