Financial Balances Intermediate Processing

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

Filter Nodes in the Financial Balances Flow

Filter Node

Description
FinancialPlans_ExcludeDummyRow_FILTER Filters out the placeholder row from the Financial Plans dataset.
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 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

 Inverts the value sign +/- for the corresponding measure.
Balance Type  

The type of balance record. This is set to:

  • "Actual" for Accounting transactions
  • "Budget" for Accounting reporting balances of type "Budget"
  • "Extended Planning Plan" for Extended Planning and Analysis plans
  • "Financial Planning Budget" for Planning and Analysis tags
  • "Target" for Accounting reporting balances of type "Target"
Notes:
  • The "Extended Planning Plan" value is only available if you have Extended Planning and Analysis installed.
  • The "Financial Planning Budget" value is only available if you have Planning and Analysis installed.
Cash Entry Type 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".
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.
Dual CR Value ValueDualCredits Populates the Credits or Debits values.
Dual Dr Value ValueDualDebits
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.
Home CR Value ValueHomeCredits Populates the Credits or Debits values.
Home Dr Debits ValueHomeDebits
Intersect Definition IntersectDefinition When Full Accounting Code is false this is the Intersection Definition Name, or else this value is the Full Accounting Code.
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.
Record ID RecordId

The ID of the source record. This is set to:

  • PlanId for Extended Planning and Analysis plans
  • Id for Accounting reporting balances
  • Id for Planning and Analysis tags. This is the ID of the related budget.
  • Id for Accounting transaction line items
Source Document SourceDocument

The name of the source record. This is set to:

  • PlanName for Extended Planning and Analysis plans
  • Tag1Name for Planning and Analysis tags. This is the name of the related budget.
  • TransactionDocumentNumber for Accounting transactions
Source Document ID SourceDocumentId

Depending on the type of source record, set to:

  • PlanId for Extended Planning and Analysis plans
  • Tag1 for Planning and Analysis tags. This is the ID of the related budget.
  • TransactionDocumentID for Accounting transactions
TB1 Order TB1Order Classifies the Trial Balance 1 values.
TB2 Order TB2Order 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.
Transaction Document Number 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.
Version Version

The version of the source record. This is set to:

  • PlanVersion for Extended Planning and Analysis plans
  • c2g__Version__c for Accounting transaction line items
  AccountPayableReceivableType Classifies accounts according to vendor and provider types.
  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.
  PeriodNameDate Populates the Period Name value.
  PeriodYearPeriodDisplay Calculates the Period Year displayed by the dashboards.
  TaxCode{{N}}ReportingCodeIsPayable Populates the tax code values for accounts payable.
  TaxCode{{N}}ReportingCodeIsReceivable Populates the tax code values for accounts receivable.