Test content One Two <td class=”addressheader” align=”left” style=”margin-top:2px;”>Account ID: ${parameters.data._cseg5__text} </td> <td class=”addressheader” align=”right” style=”margin-top:2px;”>Währung : ${parameters.data._currency__text} </td> <!–Statement for Fund Currency–>
Author: Jency Nidhin
Date format in FreeMarker Template Language (FTL)
In FreeMarker Template Language (FTL) script, the date format is set as ‘October 1, 2023 – October 31, 2023’, So the client needs to change this date format to ‘01.10.2023 – 31.10.2023’ (DD.MM.YYYY). _startdate: [“2023″,”10″,”01”],_enddate: [“2023″,”10″,”31”], The code for the date format ‘October 1, 2023 – October 31, 2023‘ is given below 2. The code… Continue reading Date format in FreeMarker Template Language (FTL)
Number format in FreeMarker Template Language (FTL)
In FreeMarker Template Language (FTL), to get the number format like xx,xxx.xx (eg. 12,345,678.00), use the following codes at the top of the script file, The result will be: 12,345,678.00 2. To get the number format in German (eg. 12.345.678,00), use the following codes, The result will be: 12.345.678,00
How to apply multiple Replace() functionality in FreeMarker Template Language (FTL)
Scenario: In our PDF template, the user needs to replace the company address with the following changes If the company address contains a comma, then replace it with empty that is, Replace the ‘,’ with ‘ ‘. If in the company address, the country name is ‘United States’, then replace it with ‘Deutschland’ Use the… Continue reading How to apply multiple Replace() functionality in FreeMarker Template Language (FTL)
Formula to find the day difference between two Dates
Scenario: In the vendor record, we have a status called ‘Charity Status’. While creating a vendor record, the status is set to ‘Initial contact’. The status of the vendor will converted to ‘Approved – Active’ after a time period. So the requirement is to calculate the number of days from the ‘Initial contact’ date/ create… Continue reading Formula to find the day difference between two Dates
Workbook- Formula to find the conversion rate
Scenario: The client needs to know how many vendors are created and among that how many of them are approved within this fiscal year. That is the Conversion rate = Total number of approved vendors within this fiscal year (21)/ Total number of vendors created in this fiscal year(140). For that, I have created a… Continue reading Workbook- Formula to find the conversion rate
To add the reversed transaction lines along with the existing lines
Scenario: While doing a CSV import process, the client needs to add an extra reversed line along with the existing lines. To meet this requirement, we have developed a new User Event script that inserts these additional lines. The User Event is deployed to the Journal entry with the ‘EXECUTION CONTEXT’ set as ‘CSV import.’… Continue reading To add the reversed transaction lines along with the existing lines
Condition to display Custom KPI Results in Trend Graphs
To display a custom saved search in a trend graph: The saved search does not contain any date fields as filters on the Criteria subtab. There must be only one field with a summary type other fields should not use any kind of summary type. A date field should be defined as an available filter… Continue reading Condition to display Custom KPI Results in Trend Graphs
Deploy Features using VS code
To deploy the ‘Enable Features’ using VS codes, follow the steps Created a new VS code project. Create an XML file that contains the features. The features are provided in the <feature> </feature> tags with the <id> and the <status>. If the status is Enabled, then the checkbox for that particular feature will be checked… Continue reading Deploy Features using VS code
Report – User-level preferences
User-level preferences are available at Home > Set Preferences. User preferences for reports are available on the Set Preferences page’s Analytics tab. If the user selects the ‘Financial Only’ preference, then it will show the reports filtered by period. If the user selects the ‘Never’ preference, then it will show the reports filtered by Date.