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. Periods up to 119 months in the past and up to 6 months in the future can be specified. This supports Accrual-Basis as well as Cash-Basis accounting. Budget values can be specified using any of the ten possible budget types that can be defined in General Ledger. Prefixes can be reported individualy or consolidated in various ways.
= TSGLAmount ( Prefixes , BaseAccounts , Year , Period , AmountType , BudgetType , Partner , DataFolders )
Returns the balance for base account 4001 of prefix 10 for fiscal year 2001, fiscal period 5.
|Prefixes||If your account format does not use prefixes, leave this argument blank. This argument specifies the GL prefix to be reported or the set of prefixes to be consolidated. This may one of the following types of values:
|BaseAccount||This argument specifies the GL base account to be reported or the set of base accounts to be consolidated. This may be one of the following types of values:
|Year||In general, this argument identifies the year from which the value should be reported. The specific use of this argument depends on Period argument.
|Period||Identifies the period to be reported. Depending on your version of General Ledger, this may either go back as far as 23 periods or as far back as 119 periods (provided that master file totals have been stored that far back). The following values may be used:
|AmountType||Optional - This argument indicates the type of value to be returned. If this is not specified, the balance will be returned. This may be one of the following values:
|BudgetType||Optional - This argument is only used if the AmountType argument specifies a budget value to be returned. This may be one of the 10 user-definable budget types in General Ledger. The name supplied for this argument must exactly match what was entered in General Ledger. If this is not specified, the first budget type will be used.|
|Partner||Optional - If Partners are used in General Ledger, this argument identifies the Partner to be reported. When reporting partner values, the partner's ownership percentage of the entity is multiplied by the amount that would otherwise be returned. If the partner has no ownership in an entity, zero is returned. If a value is supplied for this argument and the entity has no partners defined, zero is returned.|
|DataFolders||Optional - If blank or not specified, the current data folder will be used. Possible values include: