Creating Recurring Journal Entries
You can define an unlimited number of journal entry lines for each recurring journal entry. The journal entry lines specify the accounts to update with the recurring journals. Each line also contains the amount to post to the designated account, or a formula to calculate the journal amounts.
2. Enter or query the batch name and the journal entry name.
3. Choose Lines.
4. Enter a Line number to set the order of your recurring journal entry lines. You can indicate an automatic offsetting line for your recurring journal entry by entering the line number 9999.
5. Enter the Account you want General Ledger to update when you generate and post your recurring journals.
6. Enter an optional Line Description for the recurring entry line.
7. Enter a Formula for the line.
8. Enter the remaining lines for the recurring journal entry. Remember that you can use line number 9999 as the automatic
offsetting line for each recurring journal entry.
9. Save your work.
To enter an automatic offsetting line:
You can enter a recurring journal entry line and have General Ledger calculate and insert the balancing amount for the recurring journal entry automatically. This is useful for allocation-type entries.
1. Enter one or more lines for the recurring journal entry.
2. Enter 9999 as the line number for the automatic offsetting line.
3. Enter an Account for the line but do not enter a formula. General Ledger will automatically calculate the amount for this journal entry line when you generate your recurring journal.
4. Save your work.
Entering Formulas with EasyCalc
EasyCalc is a powerful, yet easy–to–use calculation notation based on the mathematical logic used by Hewlett–Packard calculators. EasyCalc lets you enter complex formulas to calculate journal entries, allocations, budgets and report balances.
2. Use the EasyCalc operator Enter to save the value of the first factor in memory. Enter identifies the first factor of each calculation, and separates it from previous calculations in the formula. Using Enter enables you to create a logical sequence of formula steps, and enter nested calculations in a formula.
3. Enter the next factor to use in your calculation.
4. Enter the EasyCalc operator to specify the calculation involving the previous two factors. The following are the valid mathematical operators you can use in an entry formula:
Comments
Post new comment