Apex Code Development You need to sign in to do that
Don't have an account?
Danica Alexis Llantos Hi, I need a help with apex that will add Installment Date (Date Field) to the number of Terms (number field)
For ex: Installement Date is 4/01/2023 and number of terms is 30 days the custom field should print out 5/1/2023. If number of terms is 0 it should print out the next installment date.
Terms is under Master-Detail(Invoice) while Installment Date is under Installment (child object)
Terms is under Master-Detail(Invoice) while Installment Date is under Installment (child object)
Can you confirm Installation is child and Invoice is Master object also on which object were Installmentdate, Terms and new field to add those date is present ?
Thanks
Thank you for your response, yes - Installment is child object and Invoice is a Master Object, Installment Date is under Installment Object and Terms and New custom field (Date Field ) is under Invoice. I was suppose to create a formula field usig this formula IF( fw1__Terms__c = 0, fw1__Installment_Date__c ,
DATE(YEAR(fw1__Installment_Date__c), MONTH(fw1__Installment_Date__c), DAY(fw1__Installment_Date__c) + fw1__Terms__c)
)
But snce the Installment Date is under child object I was getting an error as Parent records can't look down to the child records.
As installemnt is child object and Invoice can have multiple installment record so which record should it consider to add the terms to installation Date?
Thanks,
In this sample record the higlighted part should capture the Installment plus terms, if terms is 0 get the next Installment Date which is 6/1/2023