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

  • Thread starter Thread starter Sopna
  • Start date Start date
Status
Not open for further replies.
S

Sopna

Guest
Hello, Thanks for providing detail steps. I worked on this and came up with the following method which best suites your scenario. Create a One-to-One relationship between Deliveries and Inventory object. Similarly create a One-to-One relationship between Inventory and Sales object. Create an 'Update Field Value' trigger in Inventory object to change 'SalesQuantity' value when 'InventoryQuantity' value is changed. Enter the formula to return the subtracted value in formula field. Now changing the value in InventoryQuantity field will automate the value for Sales object. Hope this helps. Please revert back if you have any questions. Thanks, Sopna.

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