Skip to main content
Looking for help with a solution.. maybe i'm making it more difficult than needed. However i have a company year over year excel that tracks finacial information then sums all  that information for the year in a column... i'm trying to move this process to salesforce... I created 2 objects one for the monthly financial information and one to summerize the monthly records over 12 months.. in order to make them relate to one another the year summary records is master detail to the monthly record... so my issue is that I created a process builder that in thoery create 12 monthly records and 1 year record.. i'm trying to relate them by id but the 12 monthly records fail because the master detail ID is missing however in the process builder i define that i want the master detail ID to populate from the 1 year record but it doesn't seem to be working is there something i should do different?

 

help with a solutionexample for the monthly recordwhen running live
27 件の回答
  1. 2020年10月27日 14:34
    You would search for the program financial as it is the current state accounting "truth" record for each opportunity. Currently, our account team uploads financial information via CSV to that record for reporting financial information back to the business. The fiscal summary object was recently created to capture a full year summary for each opportunity financial information (Blue) the monthly object was created to capture the monthly financial information for the opportunity (Orange). The end goal is to eliminate the Excel below as users will enter the information into the new object records in Salesforce and remove the need to upload csv information into the program financial record as the totals from the new objects can flow back to the accounting truth record... so the master detail field is being established with the program financial truth record

     

     You would search for the program financial as it is the current state accounting
0/9000