FRAMT
FR Paste form
When you select the FRAMT function from the Function list in the FR Paste form, the right side of the form shows a set of fields and two buttons which launch popup dialog windows: Selection Criteria, Currency Options, and Use Rolled Up Amounts.
You can select an individual account or a range of accounts to apply this function to. Or, you can build account selection criteria by using the Selection Criteria popup dialog box to create a filter that will be applied to an account or account range. The purpose of using a filter is to restrict data records within an account or account range.
Using the Currency Options popup dialog box, you can select a specific currency or a currency type, such as home, source, source-equivalent in functional currency, total functional currency or reporting currency. (The reporting currency option is only available if you selected the euro as your functional currency and specified a reporting currency in the Company Profile form in Common Services.)
By choosing values for the fields related to the FRAMT function, you build this function according to the following syntax and arguments.
Syntax
FRAMT(field name, account reference, criteria, currency)
Description
The FRAMT function provides monetary, budget and quantity balances and net amounts from the general ledger accounts.
All amounts provided by FRAMT respect the type of the account. This means that debit balances in debit accounts and credit balances in credit accounts are both returned as positive numbers. (Credit balances in debit accounts and debit balances in credit accounts are returned as negative numbers.)
FRAMTA differs from FRAMT by returning all debit balances as positive numbers and all credit balances as negative numbers — for both debit and credit account types.
Arguments
field name
The name of a field from the general ledger account master with an optional fiscal designator prefix and optional year suffix.
Prefixes are:
|
R |
to retrieve the rollup amount (must be first character and can be used in conjunction with other prefixes) |
|
A |
for actual account set |
|
P |
for provisional |
|
Q |
for quantities |
|
QA |
for actual quantities |
|
QP |
for provisional quantities |
|
1 to 5 |
for the budget sets |
The year can be a 4-digit year, L1, L2, etc. for the last years, or N1, N2 for the next years (budgets only). See Field Names.
account reference
A string specifying the account number reference. See Specifying Account Numbers and Number Ranges.
criteria
A string containing an expression that imposes selection criteria on the accounts. The account reference and expression together determine which accounts are included in the calculation. See Using Selection Criteria.
currency
A string containing the currency reference. A currency reference is on the form "CCC.T," where CCC is the currency code, and T is "S" for source currency, "E" is the functional equivalent of the source amount, and "F" is the functional currency total. (Note: For reporting currency, the currency reference is simply "CCC," without an extension.)
Result
The total values of fiscal field code from all accounts selected for a given fiscal set.
If the account does not exist, or if no accounts exist in the specified range, the Financial Reporter will print a value of 0.
Examples
|
This statement |
Returns this |
|
FRAMT("PBALP.L1","1000-33-248"; "DEM.S") |
The provisionally-posted balance of Deutsche Marks (in source currency) to account 1000-33-248 for the current period last year. |
|
FRAMT("QBALP","2000") |
The quantity balance of the current period for account 2000 |
|
FRAMT("ABAL.1999","1000%%", |
The total actual balance for all balance sheet accounts for the year 1999 whose account numbers start with "1000". |
See also