Financial Transactions Intermediate Processes

After importing the input fields and augmenting them with the data from their lookup objects, the Financial Analytics dataflow filters out non-relevant or repeated records.

You can use the dataflow editor in Analytics Studio to visualize the Financial Analytics dataflow and its nodes. Alternatively, you can download the dataflow definition file which is a JSON file representing the dataflow and its logic. For more information on the dataflow editor and the dataflow definition file, see the Salesforce Help.

Warning:

Modifying the Financial Analytics dataflow might result in the loss of functionality. Contact your system administrator before using the data manager tool in Analytics.

Filters

These are the main filter nodes in the Financial Transactions flow.

Filter Node Description
ReportingBalance_Type_FILTER Filters out reporting balance records where the "Type" is any other than "Actual".
RepBalanceTLI_GLAType_FILTER Filters the GLA Type for any values selected in the configuration wizard Questions 4, 5, and 6.
RepBalanceTLI_BalanceType_FILTER Filters out any values other than "Actual" from the balance type records.
AccountingCurrency_Reporting_FILTER Filters out any values from the Accounting Currency other than those corresponding to the Reporting Currency fields.

Calculated Fields

These are the fields calculated by the Financial Transactions flow.

Field Label Field API Name Description
 

{{measure_field}} (s)

The fields used are the following: Home Value, Dual Value, Home Dr Value, Home Cr Value, Dual Dr Value, Dual Cr Value, Document Outstanding Value, Dual Outstanding Value, Home Outstanding Value, Value Reporting Outstanding Value, Reporting Value.

 Inverts the value sign +/- for the corresponding measure.
Account Payable/Receivable Type AccountPayableReceivableType Classifies accounts according to vendor and provider types.
Cash Entry Type CashEntryType

Calculates the type of a cash entry as follows:

  • If the transaction type is Cash then Cash Entry Type equals the transaction type.
  • If the transaction type is Journal and Bank Account Name other than "Unknown" and Exclude From Cash Flow condition is not selected and Home Value is less than zero then Cash Entry Type is "Journal Payment".
  • If the transaction type is Journal and Bank Account Name other than "Unknown" and Exclude From Cash Flow condition is not selected and Home Value is greater or equal to zero then Cash Entry Type is "Journal Collection".
Cash Flow Adjustment (s) CashFlowAdjustments Populates the Cash Flow Adjustments values.
Cash Flow Category (s) CashFlowCategory Populates the Cash Flow Category values.
Cash Flow Line Summary (s) CashFlowLineSummary Populates the Cash Flow Line Summary values.
Custom Any Outstanding CustomAnyOutstanding Calculates outstanding values for transactions.
Days between Period Close and Transaction Date DaysBetweenPeriodCloseTransactionDate Calculated as Period End Date - Transaction Created Date.
Dual CR Value ValueDualCredits Populates the Debits/Credits values.
Dual DR Value ValueDualDebits
Due Date DueDate Calculates the due date for transactions.
Financial Year/Period (s) PeriodYearPeriodDisplay Calculates the Period Year displayed by the dashboards.
GLA Types Code GLATypesCode Identifies the GLA Type for any values selected in the configuration wizard Questions 4, 5, and 6.
Home CR Value ValueHomeCredits Populates the Debits/Credits values.
Home DR Value ValueHomeDebits
Intersect Definition IntersectDefinition When Full Accounting Code is false this is the Intersection Definition Name, else this value is the Full Accounting Code.
Period Close Group Name PeriodCloseGroupName

Calculated from the resulting value of Days between Period Close and Transaction Date as follows:

  • If the value is 5 or less, the value is 05 Days or Less.
  • If the value is 32 or more, the value is 32 Days or More.
  • If the value is between 6 and 31 (both inclusive), the value is XX Days.
Example:

Days between Period Close and Transaction Date = 7

Period Close Group Name = 07 Days
Period Close Group Number PeriodCloseGroupNumber

Calculated from the resulting value of Days between Period Close and Transaction Date as follows:

  • If the value is 5 or less, the value is 0.
  • If the value is 32 or more, the value is 32.
  • If the value is between 6 and 31 (both included), this value is directly displayed.
Example:

Days between Period Close and Transaction Date = 17

Period Close Group Name = 17
Financial Period Name PeriodName Populates the Period Name value.
FRB Adjusted Year-End Balance Date FRBAdjustedYearEndBalanceDate

Calculated from the transaction's period end date:

  • If the period number is 101 and the GLA type is Balance Sheet, the value in the field is the period end date plus one day.
  • If the period number is 000 and the GLA type is Retained Earnings, the value in the field is the period end date minus one day.
  • In any other case the field is the same as the period end date.
Period Number and Special Periods PeriodNumberAndSpecialPeriods Calculates the period number and takes into account special periods if available.
Quarter and Special Periods QuarterAndSpecialPeriods Calculates the quarter and takes into account special periods if available.
Reporting Year/Period (s) ReportingPeriodYearPeriodDisplay

Displays the Reporting Period as a number value.
Tax Code {{N}} Reporting Code Is Payable TaxCode{{N}}ReportingCodeIsPayable Populates the tax code values for accounts payable.
Tax Code {{N}} Reporting Code Is Receivable TaxCode{{N}}ReportingCodeIsReceivable Populates the tax code values for accounts receivable.
TB1 Order TB1Order Classifies the Trial Balance 1 values.
TB2 Order TB2 Order Classifies the Trial Balance 2 values.
TB3 Order TB3Order Classifies the Trial Balance 3 values.
TB4 Order TB4Order Classifies the Trial Balance 4 values.
Transaction Document ID TransactionDocumentID

Identifies the transaction documents in the flow.