Previous	Next		Contents	Index	Navigation	Glossary	Library

   To enter a formula:

1. Enter a Step number to specify the order in which you want to process the steps in your formula. Each formula can contain an unlimited number of steps.

2. Enter a factor for the formula step. There are two types of factors you can use:

• Enter a fixed Amount.

• Specify an Account to use a balance in the formula calculation. You can use standard, end-of-day, or average balances in your formula lines.

3. Specify the type of calculation you want to perform by entering a mathematical Operator for the formula step. The valid operators are based on EasyCalc - a General Ledger mathematical notation feature.

   To use an account balance in your formula:

1. Enter the Account you want to include in your formula step.

You can enter a summary account, but you cannot use accounts with parent values for which no summary account was created. General Ledger automatically maintains references to summary accounts in your formula lines even after the summary template which created the account is deleted and recreated.

2. Choose a Balance Type of Actual or Budget. If you choose budget balances, you must specify the budget to use when you generate the recurring journal batch.

3. Choose an Amount Type. Choose PTD to use the period-to-date balance of your account. Choose YTD to use year-to-date balances for income statement accounts and life-to-date totals for balance sheet accounts. If you have average balance processing enabled in your set of books, PATD (period average-to-date), YATD (year average-to-date), and EOD (end-of-day) will also appear in the Amount Type list of values.

Note: You can mix standard and average amount types in the same recurring journal formula.

4. Choose a Currency Type of Monetary if the account balance is a currency account, or STAT if it is a statistical account.

5. Choose the relative Period balance you want to use in your formula (Current Period, Same Period a Year Ago, or Previous Period). The relative period, combined with the amount type, determines the type of account balance your formula uses.

Amount Type	Period	Meaning
PTD	Current Period	Net activity of current period
YTD	Current Period	Ending balance of current period
PTD	Previous Period	Net activity of previous period
YTD	Previous Period	Ending balance of previous period
PTD	Same Period as a Year Ago	Net activity of year-ago period
YTD	Same Period as a Year Ago	Ending balance of year-ago period
Table 1 - 1. (Page 1 of 1)

6. Save your work.

See Also

Defining Summary Accounts

Generating Recurring Journal Batches

Calculating Budget Amounts