Financial spread configuration
On installing the Origination packages, an initial configuration is created in the system, allowing users to create various financial statement templates. This configuration contains the details like the document category name where the financial statement file will be uploaded, the financial statement default month (defaulted to December), and the financial spread configurations that explain whether the user can input a decimal value in a statement.
To verify whether the initial configuration is created in the system, perform the following steps:
Log in to your Salesforce account.
Go to
( App Launcher) > Origination Configuration > Financial Spread Configuration.
Select Initial Configuration and validate the fields of the Details and Related sections.
Note:You can edit the Financial Statement Default Month and Decimal Scale fields.
Field Name Description Financial Spread Configuration Name This field represents the configuration name for the financial statement. Generated File Name This field represents the name of the generated financial statement pdf. Document Category Name This field represents the document category where the generated pdf of financial statement is to be uploaded. Document Sub-category Name This field represents the sub-category name of the Document Definition. Financial Statement Report Header This field represents the name of that is to be reflected in the generated pdf. For example, if it is HDFC Asset, the header of the generated pdf would be HDFC Asset. Financial Statement Default Month This field represents the month that is reflected while adding a financial statement. The Statement Date is defaulted based on the value of this field while adding a financial statement. For example, if the default month is December, the Statement Date would be the end date of December.
Note:If this field is not specified, the Statement Date would not have any value.
Download Financial Statement PDF Locally By selecting this checkbox the Financial Statement PDF gets downloaded into the local system.
Note:If this field is not selected, the Financial Statement PDF gets downloaded in the document category and can be viewed in the Documents tab.
Enable Sensitivity Analysis This field represents whether the Sensitivity Analysis tab would be visible on the financial spread page or not. Enable Add Projection Statement This field represents whether the Add Projection Statement button would be visible on the financial spread page or not. Enable Download This field represents whether the Download button would be visible on the financial spread page or not. Statement Type This field represents the statement type.
The supported options are:
Balancesheet
Income
Ratio
Cashflow
UCACashflow
GlobalCashflow
Now, the order of the Financial Statements tabs can be changed as required. For more information, see Rearrange the Financial Statements tabs.
Statement Header Name This field represents the name of the statement that is to be reflected in the generated pdf. For example, for Balancesheet if it is HDFC Balance Sheet, then in the generated pdf Balancesheet would be named as HDFC Balance Sheet. Active This field represents whether the Financial Spread Details Configurations records tab would be visible on the Financial Spread page or not. Enable PDF Download This field represents whether the respective Financial Spread Details Configurations record would be available as a picklist value or not in the Select Statement Type field to generate PDF. Party Types This multi-picklist value field is used to configure the party types for which financial statement can be added. Decimal Scale This field represents the number of decimal places allowed while keying in amount in a financial statement. As per the configuration, decimal values cannot be entered in the balance sheet, income, and UCA cash flow statements. Order This field represents the order in which the statements should be displayed in the generated pdf. Placement of tabs is not affected with this field.
Rearrange the Financial Statements tabs
To rearrange the Financial Statements tabs, follow the steps:
Prerequisities
The Tab Order and Tab Label fields must be added to the Page layout of the Financial Spread Details Configuration.
To add these fields, follow these steps:
Go to Setup > Object Manager > Financial Spread Details Configuration > Page Layouts.
Select Financial Spread Details Configuration Layout.
Drag the Tab Order and Tab Label fields from the Fields section and drop them under the Information section.
Select Save.
Steps
To define the configuration, follow these steps:
Log in to the Salesforce account and go to Origination Configuration.
Select Financial Spread Configuration under the Financial Spreading Setup section , and then select Initial Configuration.
Go to the Related tab.
In the Related tab, all the financial spread configuration details are listed.
To modify the configuration details, expand the dropdown list of the financial spread configuration that you want to modify, and then select Edit.
Change the values for the Tab Order and Tab Label fields as needed.
Refer to the following table as an example on how the configurations can be modified:
Statement Type Tab Order Tab Label Balancesheet 1 Balance Sheet Income 2 Income Cashflow 3 Cashflow Ratio 4 Ratio UCACashflow 5 UCACashflow GlobalCashflow 6 GlobalCashflow
Note:If you are making changes in the Tab Order and Tab Label configuration, ensure to rearrange all the available tabs. For example, if you want to move Cashflow to second position, ensure that all the six tabs are arranged from one to six positions, as moving only one tab may leave the other tabs with the same order. If you do not rearrange all the available tabs, the system may not work properly.
When you use the Tab Order configuration, the system displays the tab which is marked as 1 as the default tab. You can change the tab order to set it to 1 for the required default tab.