DBFinancial Function for Vista
This function can return a variety of financial values that are used in the construction of financial statements. This includes the ability to report balances as of a specific period or the activity for specific periods.
= DBFinancial ( ConnectionName , Year , Period , Entity , Group , Account , AmountType , BudgetType )
Returns the balance of account 41000 for period 10 of fiscal year 2007 under company 1 and consolidates all locations (part 3) under division 01 (part 2).
|ConnectionName||When working with Vista financial data, this should be "Vista".|
|Year||The four-digit year of the period being reported. This should correspond to the year in which the fiscal year ends.|
|Period||The period number (1 to 12) of the period being reported.|
Optional - Identifies the type of financial value to be returned. This may be one of the following values listed below. If no value is supplied, the default value "Balance" will be used. This value is not case-sensitive.
|BudgetType||Optional – When the AmountType specifies “PeriodBudget” or “YTDBudget”, this argument must be supplied in order to identify the type of budget to be returned.|