FRAMTA
Syntax
FRAMTA(field name, account reference, criteria, currency)
For a complete parameter description, see FRAMT.
Description
The FRAMTA function is almost identical to FRAMT: it has the same parameters as FRAMT, and returns all the same data, including displaying Use Rolled Up Amounts. However, FRAMTA returns all debit amounts as positive numbers and all credit amounts as negative numbers.
By contrast, FRAMT returns debit balances in debit accounts as positive numbers and credit balances in credit accounts as positive numbers. In other words, the sign of the number returned by FRAMT depends on the type of account; whereas, the sign of the number returned by FRAMTA does not.
The following table illustrates the differences between FRAMT and FRAMTA.
|
Command |
Acct. Type |
Value |
FR Display |
|
FRAMT |
Debit Acct. |
100 DR |
100 |
|
|
Debit Acct. |
100 CR |
-100 |
|
|
Credit Acct. |
100 CR |
100 |
|
|
Credit Acct. |
100 DR |
-100 |
|
FRAMTA |
Debit Acct. |
100 DR |
100 |
|
|
Debit Acct. |
100 CR |
-100 |
|
|
Credit Acct. |
100 CR |
-100 |
|
|
Credit Acct. |
100 DR |
100 |
Another way of viewing this is to say that FRAMTA flips the sign of Credit accounts, allowing you to sum the value of a range in a single account number reference.
FRAMTA has two main uses:
-
It provides compatibility with the Financial Reporter in ACCPAC Plus for DOS.
-
It lets you sum a range of accounts without worrying about the account type.
See also