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 Configure the Dataflow in 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 API Name

Description
IntersectDefinition When Full Accounting Code is false this is the Intersection Definition Name, else this value is the Full Accounting Code.

{{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.
ValueHomeDebits Populates the Debits/Credits values.
ValueHomeCredits
ValueDualDebits
ValueDualCredits
CashFlowCategory Populates the Cash Flow Category values.
CashFlowLineSummary Populates the Cash Flow Line Summary values.
CashFlowAdjustments Populates the Cash Flow Adjustments values.
PeriodYearPeriodDisplay Calculates the Period Year displayed by the dashboards.
CashEntryType

Calculates the type of a cash entry as follows:

  • If the transaction type is Cash then CashEntryType 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 CashEntryType 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 CashEntryType is "Journal Collection".
PeriodNameDate Populates the Period Name value.
PeriodNumberAndSpecialPeriods Calculates the period number and takes into account special periods if available.
QuarterAndSpecialPeriods Calculates the quarter and takes into account special periods if available.
TaxCode{{N}}ReportingCodeIsPayable Populates the tax code values for accounts payable.
TaxCode{{N}}ReportingCodeIsReceivable Populates the tax code values for accounts receivable.
AccountPayableReceivableType Classifies accounts according to vendor and provider types.
DueDate Calculates the due date for transactions.
CustomAnyOutstanding Calculates outstanding values for transactions.
TransactionDocumentID

Identifies the transaction documents in the flow.
GLATypesCode Identifies the GLA Type for any values selected in the configuration wizard Questions 4, 5, and 6.
TB1 Order Classifies the Trial Balance 1 values.
TB2 Order Classifies the Trial Balance 2 values.
TB3 Order Classifies the Trial Balance 3 values.
TB4 Order Classifies the Trial Balance 4 values.
ReportingPeriodYearPeriodDisplay

Displays the Reporting Period as a number value.