You define budget formulas to calculate budget amounts. Your budget formulas can be simple or complex. You can use any combination of fixed amounts and account balances, including actual or budget amounts, statistics, and period-to-date or year-to-date balances from the current period, prior period or same period last year.
When you define budget formulas, you create a budget formula batch. The batch contains one or more budget entries, and each entry contains one or more formulas. Use budget batches and entries to group your budget formulas. For example, you might combine all formulas for a single department or division into one batch, or group all formulas for certain types of calculations into separate entries.
When you calculate budgets using a budget formula, General Ledger replaces any existing budget amounts directly; it does not create a budget journal.
Data Access Sets
You must have Read and Write access to the ledger and the balancing segment value or management segment value used in the Budget Formula to update budget amounts. If you have insufficient access, such as Read Only access to the ledger and segment value, your Budget Formula will complete with an error status and no budget amounts will be updated. See Data Access Sets.
Prerequisites
Define your budget organizations and assign the budget entry type "Calculated" to the accounts to which you want to budget.
Define your budgets.
Navigate to the Define Budget Formula window.
Enter a Name and Description for the budget formula batch.
Choose a ledger for this batch.
If you use reporting currencies (journal or subledger level), you can choose reporting currency.
If you want to copy budget formula entries from an existing batch to your new batch, choose AutoCopy.
Create budget formula entries for the batch.