Load Budget
The Load Budget function is used to load a budget amount based on the parameters that you enter. Clicking the Load Budget function on the Budget Wand toolbar will open the Load Budget Wizard.
*Journal Name, Line Description and Journal Category are only used when loading budget journals.
Debits and Credits
Values in the Input Value parameter in the load budget function should be entered in the same sign as values returned by Get Balances. For example credit values for revenue accounts are returned as negatives and would therefore need to be entered as negatives and similarly debit values for expenses would need to be entered as positives. Please see the Budget Wand User Options sections should you wish to disable this functionality.
This is different to how Budget ADI works. Budget ADI requires all values to be entered as positives in the spreadsheet which is inconsistent to how GL Wand returns values and would therefore be confusing to users.
Budget Amount
Budget Wand will replace the existing budget amount in Oracle with the new budget amount, unless Budget Journals are required.
Input Value | New Budget Amount | |
---|---|---|
Initial Budget Load | 100 | 100 |
Load Budget | 50 | 50 |
Load Budget | -75 | -75 |
Budget Journal
Budget Wand will load Budget Journals only if the “Require Budget Journals” check box is enabled on the budget definition in Oracle.
Using Budget journals will incrementally update the budget amounts.
Input Value | New Budget Amount | |
---|---|---|
Initial Budget Load | 100 | 100 |
Load Budget Journal | 50 | 150 |
Load Budget Journal | 50 | 200 |
Load Budget Journal | -75 | 125 |
Posting of journals is required for new budget amounts to be correctly reflected. By default Budget Wand does not automatically post any Budget Journals it creates. Budget Wand can be configured to perform Auto Posting. Please see the Budget Wand User Options section for more information.
In order to upload budget journals the seeded journal source “Budget Journal” must exist and none of its properties may be modified.