You can set up formulas for account
calculations on the Chart of Accounts setup page.
You can enter formulas manually or build
them using the provided tools to specify and insert each component. If available for the
account, then you can select a predefined formula to use.
-
Select from the menu.
-
Select an existing account or create an account.
-
Expand the Calculations & Formulas section.
-
Select Custom for the Formula.
If the option is available for the account, then you can select
Predefined. A drop-down list appears for you to select a
predefined formula to use.
-
Select Customize Formula.
The Customize Formula page opens.
-
Select Data for the Type.
You can use a combination of both types to build your formula.
-
Select a Category.
Field availability updates based on the selected category.
-
Select an Account/Code, if applicable.
-
Select an Account or a Ratio
Code.
-
Select a Data Item, if applicable.
-
Select a Time Frame, and then select
Apply.
When you select the field, the Select Time Frames dialog box
opens for you to select historical, current, and future time frames.
Select the Method of Calculated when
the formula must calculate different amounts in future time frames.
An Aggregation field appears based on the
selected time frames.
-
Place the cursor where you want to place the data in the
Formula field.
-
Select Insert to add the data to the
Formula field.
-
Select Functions for the Type.
-
Place the cursor where you want to place the function in the
Formula field.
-
Select a Function.
-
Select Insert to add the function to the
Formula field.
-
Switch between the two types until your formula is complete.
You can manually enter formula data in the Formula field as
needed.
-
Select Apply to save the formula and return to the
Chart of Accounts page.
Select Results
during and after you build the formula to view the calculation results. You can select a
different Organization and Time Frame to
view.
