FRACCT
Syntax
FRACCT(fieldname, account reference, criteria, formatted)
Description
The FRACCT function provides account master information stored by the General Ledger Accounts form, including optional fields.
Arguments
fieldname
The name of a field from the G/L account view.
account reference
The number of the account from which the value of fieldname should be returned.
criteria
An expression that imposes selection criteria on the accounts. The account reference and expression together determine which accounts are included in the calculation.
formatted
Optional. Indicates that the return value should be formatted or unformatted. The default is "Formatted". If you leave the default, no indicator appears in the formula. If you clear the default, a "U" appears in the formula (for "unformatted").
Result
The value of the field specified in the formula. (For special treatment of the account description for a range of accounts, see "ACCTDESC for a Range of Accounts," below.)
Examples
|
This statement |
Returns this |
|
FRACCT("ACCTDESC","1000-333") |
"Cost of goods sold" |
|
FRACCT("QTYSW","1000-333","F') |
"Yes" |
|
FRACCT("ACCTTYPE", |
"Income" |
|
FRACCT("A.ACCTCLASS","4000") |
"Sales" |
General Ledger Account Data Field Names
Field names from the General Ledger account view:
|
Name |
Contents of the field |
|
ACCTID |
Account number, including all segments. |
|
CREATEDATE |
Date the account was created. |
|
ACCTDESC |
Account description. |
|
ACCTTYPE |
Account type. If unformatted, I, B, or R. If formatted, "Income," "Balance sheet," or "Retained earnings." |
|
ACCTBAL |
Normal balance. If unformatted, 1 for debit or 2 for normal credit. If formatted, "Debit" or "Credit." |
|
ACTIVESW |
Active switch. If unformatted, 1 for active or 0 for inactive. If formatted, "Active" or "Inactive." |
|
CONSLDSW |
Consolidation switch. If unformatted, 1 if transactions are consolidated on posting; 0 if they are not. If formatted, "Consolidate journals" or "Do not consolidate journals." |
|
QTYSW |
Quantity switch. If unformatted, 1 if quantities are used with account; 0 if not. If formatted, "Yes" or "No." |
|
UOM |
The unit of measure if quantities are used. |
|
ALLOCSW |
Allocation switch. If unformatted, 1 if account can be reallocated, 0 if not. If formatted, "Yes" or "No." |
|
ACCTOFSET |
Account number for reallocation. |
|
ACCTSRTY |
Allocation transaction source code. |
|
MCSW |
Multicurrency switch. If unformatted, 1 if multicurrency, 0 if not. If formatted, "Yes" or "No." |
|
SPECSW |
Specific source currencies switch. If unformatted, 0 is in all currencies, 1 is specified. If formatted, "All currency" or "Specific currency." |
|
ACCTGRPCOD |
Account group code. |
|
CTRLACCTSW |
Control account. If formatted, 1 is yes; 0 is no. If formatted, "Control account" or "Non control account." |
|
SRCELDGID |
Source ledger if control account (e.g. AR, AP). Reserved field. |
|
ALLOCTOT |
Total of different allocation rates. |
|
ABRKID |
Account structure code. |
|
YRACCTCLOS |
Year of the last close. |
|
ACCTFMTTD |
Formatted account number. |
|
ACSEGVALn |
Account segment value 01 to 10. |
|
ACCTSEGVAL |
Account Segment Code |
|
POSTTOSEGID |
The code for the segment by which account posting is done. |
|
DEFCURNCOD |
The code for the default currency. |
|
ACCTGRPSCD |
Account Group Sort Code |
|
ROLLUPSW |
Rollup switch. If unformatted, 1 if account is a rollup account, 0 if not. If formatted, "Yes" or "No". |
To retrieve account optional fields, add the prefix "A." before the field name (include the period).
"ACCTDESC" for a Range of Accounts
Generally, if you specify a range of accounts for a particular statement line, you will type an account description, rather than use FRACCT.
If, however, you do want FRACCT to retrieve a range description, you should know what behavior to expect.
The function, FRACCT("ACCTDESC","1000-333:1000-400"), will print a description that includes all the words common to each account in the account range.
For example, if the accounts in the range have the following descriptions:
Accounts Receivable: customers
Accounts Receivable: employees
Receivable: over 90 days
The program will print the following word:
Receivable
If you try to print information from a non-existent account, Financial Reporter will print a hyphen.
See also