FRCREDIT Function

Sage 300 ERP

FRCREDIT Function

This function is the same as FRAMT Function, except that it returns values for only those accounts that have credit amounts (balances or net changes)—regardless of whether the account is a debit or credit account.

Note: This function can retrieve budget and provisional amounts, calculate balances, and include rollup amounts and rollup members accounts.

Syntax

FRCREDIT(field name, account reference, criteria, currency)

Tip: Use the criteria argument to restrict this function to credit (CR) account types.

FRCREDIT returns the credit value of the account, with the following exceptions:

  • Returns blank if the value of a debit account is zero or a debit amount
  • Returns 0 if the value of a credit account is zero
  • Returns "0" if the account reference is missing or if a specified account cannot be found

Arguments

Argument Description
field name

The name of a field from the General Ledger fiscal sets with an optional fiscal designator prefix and optional fiscal year suffix (separated from the field name with a period).

The fiscal designator prefix can be:

  • A. Actual amount
  • R. Rollup amounts. R must be the first character and can be used with other prefixes

    Tip: In Excel, if you use the FR PASTE screen to add the FRAMT function to a statement, select the Use Rolled Up Amounts check box.

  • P. Provisional amounts
  • Q. Quantities (either actual or provisional, depending on the report type)
  • QA. Actual quantities
  • QP. Provisional quantities
  • 1 to 5. Budget set number

    The number of available budget sets varies by product edition.

    • 2 in Sage 300 Standard ERP
    • 3 in Sage 300 Advanced ERP
    • 5 in Sage 300 Premium ERP

Note: If no prefix is supplied, the default report setting is used (either actual or provisional, depending on the type of report). Similarly, if the fiscal prefix is "Q" or "RQ," actual or provisional quantities are returned, depending on the type of report.

The fiscal year suffix can be:

  • YYYY. A specific fiscal year, such as 2010
  • Ln.n years ago relative to the current fiscal year; for example, L1 is last year, and L2 is 2 years ago
  • Nn.n years in the future relative to the current fiscal year; for example, N1 is next year, and N2 is the year after next

Note: If no suffix is supplied, the current fiscal year is used.

Example: For the field name argument ABALP.2008, ABALP is the combination of fiscal set prefix and field name referencing the actual balance for the current period, and 2008 is the fiscal year suffix.

account reference A string specifying a single account or a range of accounts. See About Account Number References.
criteria (Optional) An expression that imposes selection criteria on the accounts and account optional fields. The account reference and expression together determine the accounts and account optional fields that will be included in the calculation. See About Selection Criteria for Filtering Accounts.
currency (Optional)

A string containing the currency reference. A currency reference has the form "CCC.T," where CCC is a 3-character currency code (for example, CAD for Canadian dollars, or USD for US dollars), and T is the currency type (also known as the currency code qualifier).

The currency type can be:

  • S. Source currency
  • E. Functional equivalent of the source amount
  • F. Functional currency total (including functional equivalents of all source amounts)
  • R. Reporting currency total (includes reporting equivalents of all source amounts)

    Note: This option is only available if you select the Euro as your functional currency and specify a different reporting currency in Company Profile.

Note: If no currency is supplied, functional (home) currency is used.

Financial Reporter can retrieve the following balance and net change fields.

Note: In the Reporter Code Suffix, n is a number that can refer to the fiscal period (from 1 to 13), or to the quarter (from 1 to 4).

Period balance and net change
Field Description Reporter Code Suffix

BAL

(balance)

NET

(net changes)

Current period P BALPBALP, BALnP, BALYTD, etc. include adjustments from period 14 only if the balance is for the final period of the year. BALY includes period 14. The closing entries are not included. To include closing entries, use BALCLOSE. To print the balance from the final fiscal period without the adjustment amount, use FRAMT("BALP")-FRAMT("NETADJ").1 NETPNETP, NETnP, NET4Q, NETPQ will also include adjustments from period 14 if the net is requested for the final period of the year. (NET works like BAL.)2
Last period LP BALLP NETLP
nth period nP BALnP NETnP
n periods ago nPA BALnPA NETnPA
Quarter balance and net change
Field Description Reporter Code Suffix

BAL

(balance)

NET

(net changes)

Current quarter (to end) Q BALQ NETQ
Current quarter to date QTD BALQTD NETQTD
Last quarter LQ BALLQ NETLQ
Last quarter to date LQTD BALLQTD NETLQTD
nth quarter nQ BALnQ NETnQ
nth quarter to dateThis code allows you to compare the current QTD to the QTD of a previous quarter by providing you with to-date figures relative to the current quarter. If you are now in period 2 of the current quarter, QTD will give you the first 2 periods of any previous quarter.3 nQTD BALnQTD NETnQTD
n quarters ago nQA BALnQA NETnQA
n quarters ago to datenQATD lets you go up to four quarters ago. If you need to specify more, use nQATD.L1.4 nQATD BALnQATD NETnQATD
Preceding quarter (3 periods)PQ handles any three periods, providing you with revolving quarters. The preceding 3 periods include the current period plus the two previous ones.5 PQ BALPQ NETPQThe NET for a group of periods that crosses a year-end boundary will also include the adjustments in period 14, but not include the closing entry; otherwise, the net would include the zeroing entries in income and expense accounts.6
Preceding quarter (n periods ago) PQnPA BALPQnPA NETPQnPA
Half year balance and net change
Field Description Reporter Code Suffix

BAL

(balance)

NET

(net changes)

Current half year (to end) S BALS NETS
Current half year to date STD BALSTD NETSTD
Last half year LS BALLS NETLS
Last half year to date LSTD BALLSTD NETLSTD
nth half year nS BALnS NETnS
hth half year to dateThis code allows you to compare the current half year TD to the half year TD of a previous half year by providing you with to-date figures relative to the current half year. If you are now in period 2 of the current half year, half year TD will give you the first 2 periods of any previous half year.7 nSTD BALnSTD NETnSTD
n half years ago nSA BALnSA NETnSA
n half years ago to datenSATD lets you go up to 2 half years ago. If you need to specify more, use nSATD.L1.8 nSATD BALnSATD NETnSATD
Preceding half year (6 periods)PS handles any six periods, providing you with revolving half years. The preceding six periods includes the current period plus the five previous ones.9 PS BALPS NETPS
Preceding half year (n periods ago) PSnPA BALPSnPA NETPSnPA
Total year balance and net change
Field Description Reporter Code Suffix

BAL

(balance)

NET

(net changes)

Total year Y BALY NETY
Year to date YTD BALYTD NETYTD
Preceding year (12 or 13 periods) PY BALPY NETPY
Preceding year (n periods ago) PYnPA BALPYnPA NETPYnPA
Beginning of year OPEN BALOPEN  
End of yearBALCLOSE acts like BALP in every period except the last period of the year, when it includes the adjustments and the closing entry. NETCLOSE provides the closing entry only.10 CLOSE BALCLOSE NETCLOSE
Period 14 adjustments ADJ   NETADJNETADJ provides the amount from period 14. To print the balance from the final fiscal period without the adjustment amount, use FRAMT("BALP")-FRAMT("NETADJ").11
Note:
  • You can print year-end adjustments and transactions to close income accounts to retained earnings with NETADJ, and print closing figures with NETCLOSE and BALCLOSE.
  • All fiscal field set values are calculated relative to the fiscal period set for the report, with the exception of BALOPEN, NETADJ, and NETCLOSE, and fields that reference a specific time period.
    • BALOPEN is the opening balance of the account for the year.
    • NETADJ is the amount posted to the adjustment period.
    • NETCLOSE is the amount posted to the closing period.
  • If there are no records for a future period, zero is returned.
  • You can use a fiscal set prefix with NET and BAL to return specific values. For example:
    • BALP provides the actual balance (or provisional balance for supported functions) for the current fiscal period.
    • ABALP provides the actual balance for the current fiscal period.
    • 1BALP provides the balance from budget set 1 for the current fiscal period (for functions that can reference budget sets).

Examples

The following examples show the differences between the return values for the FRAMT and FRCREDIT functions.

Account Type Value FRAMT
Return Value
FRCREDIT
Return Value
Credit 100 CR 100 100
Credit 0 0 0
Debit 0 0 blank
Debit 100 CR -100 100
Debit 100 DR 100 blank

Related Topics