Financial Balances 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 Balances flow.

Filter Nodes in the Financial Balances 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.
Tag_DimNameBudgetApp_FILTER Filter fields coming from the budget dimension and excludes totals.
Tag_DimNameBudgetAppAmount_FILTER Filter fields coming from budget amount dimension and excludes totals.

Calculated Fields

These are the fields calculated by the Financial Balances flow.

Calculated Fields in the Financial Balances Flow

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

 Inverts the value sign +/- for the corresponding measure.
AccountPayableReceivableType Classifies accounts according to vendor and provider types.
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".
CashFlowAdjustments Populates the Cash Flow Adjustments values.
CashFlowCategory Populates the Cash Flow Category values.
CashFlowLineSummary Populates the Cash Flow Line Summary values.
CustomAnyOutstanding Calculates outstanding values for transactions.
DueDate Calculates the due date for transactions.
GLATypesCode Identifies the GLA Type for any values selected in the configuration wizard Questions 4, 5, and 6.
IntersectDefinition When Full Accounting Code is false this is the Intersection Definition Name, or else this value is the Full Accounting Code.
PeriodNameDate Populates the Period Name value.
PeriodNumberAndSpecialPeriods Calculates the period number and takes into account special periods if available.
PeriodYearPeriodDisplay Calculates the Period Year displayed by the dashboards.
QuarterAndSpecialPeriods Calculates the quarter and takes into account special periods if available.
SourceDocument

Depending on the type of source record, set to:

  • TransactionDocumentNumber when the source is an Accounting transaction.
  • Tag1Name when the source is a Planning tag. This is the name of the related budget.
SourceDocumentId

Depending on the type of source record, set to:

  • TransactionDocumentID when the source is an Accounting transaction.
  • Tag1 when the source is a Planning tag. This is the ID of the related budget.
TaxCode{{N}}ReportingCodeIsPayable Populates the tax code values for accounts payable.
TaxCode{{N}}ReportingCodeIsReceivable Populates the tax code values for accounts receivable.
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.
TransactionDocumentID

Identifies the transaction documents in the flow.
TransactionDocumentNumber

When the source record is a Planning tag, this is only populated if all of the following are true:

  • Tag2Name is the same as the name of the general ledger account.
  • Tag3Name is the same as the name of the Accounting period.
  • Tag4Name is the same as the name of the Accounting company.
ValueDualCredits Populates the Debits/Credits values.
ValueDualDebits
ValueHomeCredits
ValueHomeDebits