You need to sign in to do that
Don't have an account?
Bob Poliquin 9
Display monthly payments from record in visualforce pdf
I am trying to figure out if something is possible. I have a custom object that has a monthly payment field, number of months field, contract start date and end date fields.
what i need to do is display a monthly payment schedule on my visualforce pdf document But i not sure if this can be done. My screen shots below shows what I have built out but it is not dynamic at all.
When the Number of Months changes I need the VF document to display a payment for each month and the month of the payment as above.
Below is a snippet of my visualforce code, but as I said it is not dynamic. I am looking for a better way to make this dynamic especially with the months btween the start and end contract dates.
Any help would be greatly appreciated. A better solution earns a gold star
View of the fields on the record
what i need to do is display a monthly payment schedule on my visualforce pdf document But i not sure if this can be done. My screen shots below shows what I have built out but it is not dynamic at all.
When the Number of Months changes I need the VF document to display a payment for each month and the month of the payment as above.
Below is a snippet of my visualforce code, but as I said it is not dynamic. I am looking for a better way to make this dynamic especially with the months btween the start and end contract dates.
Any help would be greatly appreciated. A better solution earns a gold star
<apex:outputPanel layout="none" rendered="{!IF(sbd.Number_of_Months__c >= 1 && sbd.Contract_Start_Month__c= 1 && sbd.IsSeasonal__c=true ,true,false)}"> <tr> <td style="font-weight:bold;border:1px solid black; color:#000000;padding:1px;text-align:center;background-color:#dce6f1;font-size:10px;font-family:Times New Roman, Helvetica, sans-serif;">10-Jan-20</td> <td style="font-weight:normal; border:1px solid black; color:#000000;padding:1px;text-align:center;background-color:#ffffff;font-size:10px;font-family:Times New Roman, Helvetica, sans-serif;width:40px"><apex:outputText value="{0, Number, Currency}"><apex:param value="{!sbd.Monthly_Payment__c}" /> </apex:outputText></td> <td style="font-weight:normal;border:1px solid black; color:#000000;padding:1px;text-align:center;background-color:#ffffff;font-size:10px;font-family:Times New Roman, Helvetica, sans-serif;"></td> </tr> </apex:outputPanel> <apex:outputPanel layout="none" rendered="{!IF(sbd.Number_of_Months__c >= 2 && sbd.Contract_Start_Month__c= 2 && sbd.IsSeasonal__c=true ,true,false)}"> <tr> <td style="font-weight:bold ;font-size:10px;font-family: Times New Roman, Arial, Helvetica, sans-serif;border:1px solid black; color:#000000;padding:1px;text-align:center;background-color:#dce6f1">10-Feb-20</td> <td style="font-weight:normal ;font-size:10px;font-family: Times New Roman, Arial, Helvetica, sans-serif; border:1px solid black; color:#000000;padding:1px;text-align:center;background-color:#ffffff"><apex:outputText value="{0, Number, Currency}"><apex:param value="{!sbd.Monthly_Payment__c}" /> </apex:outputText></td> <td style="font-weight:normal ;font-size:10px;font-family: Times New Roman, Arial, Helvetica, sans-serif; border:1px solid black; color:#000000;padding:1px;text-align:center;background-color:#ffffff"></td> </tr> </apex:outputPanel>
View of the fields on the record