Forum Post: Sales object fields deducted from Inventory and Delivery object fields

  • Thread starter Thread starter mjmadelo
  • Start date Start date
Status
Not open for further replies.
M

mjmadelo

Guest
Hi all! I just started exploring Rollbase and my question might just be a little noob. I am working on a simple inventory project where I have a Deliveries object (with fields DeliveryItem, DeliveryQuantity and DeliveryDate) and an Inventory object (with fields InventoryItem, InventoryQuantity ande InventoryDate). Is there a way that I could automate the values for Sales objects based from the values of the two other objects? For example, let's say I have these records: _________________________________________________ DeliveryItem | DeliverQuantity | DeliverDate | Tables | 10 | 30-Mar-2014 | Chairs | 10 | 30-Mar-2014 | Keyboard | 10 | 1-Apr-2014 | _________________________________________________ InventoryItem | InventoryQuantity | InventoryDate | Tables | 2 | 30-Mar-2014 | Chairs | 3 | 30-Mar-2014 | Keyboard | 5 | 1-Apr-2014 | where DeliveryQuantity is the number of items delivered towards a certain store and InventoryQuantity is the number of items left in a certain store after an inventory. Is there a way to automatically match the two items from Delivery and Inventory and subtract InventoryQuantity from DeliveryQuantity to get SalesQuantity? Thank you very much! Any response from you guys would be very helpful!

Continue reading...
 
Status
Not open for further replies.
Back
Top