Specifications Budget: Difference between revisions
Line 8: | Line 8: | ||
*the data is stored in the tables a_budget and a_budget_period. | *the data is stored in the tables a_budget and a_budget_period. | ||
Progress Code: progress\petra\finance\budget\gb1100o.w is the browse screen | Progress Code: progress\petra\finance\budget\gb1100o.w is the browse screen, gb1100b.w is the browse itself (including code to delete a budget), gb1100e.w is the edit screen. gb1110o.w for adhoc budgets, gb1120o.w Same Each Period budget, gb1130o.w Maintain Split Budget, gb1140o.w Maintain Inf.base Budget, gb1150o.w Maintain Inf.n Budget | ||
=== Import a budget === | === Import a budget === |
Revision as of 11:45, 11 November 2011
Intro
- See the old Petra 2.x finance manuals for an introduction to the budget system.
Functionality involved
Preparing a budget (maintain)
- This is the main screen, where you can edit the budgets for account/costcentre combinations.
- You can edit the budget for the current financial year, and the next year.
- the data is stored in the tables a_budget and a_budget_period.
Progress Code: progress\petra\finance\budget\gb1100o.w is the browse screen, gb1100b.w is the browse itself (including code to delete a budget), gb1100e.w is the edit screen. gb1110o.w for adhoc budgets, gb1120o.w Same Each Period budget, gb1130o.w Maintain Split Budget, gb1140o.w Maintain Inf.base Budget, gb1150o.w Maintain Inf.n Budget
Import a budget
Budgets can be prepared in Excel and imported as a CSV file.
Progress Code: gb1500o.w
Auto generate a budget
Using the data from the last years, the actuals or the old budget
Progress Code: gb4000o.w
Submitting a budget (consolidate)
This is the process when the budget data is written to the table a_general_ledger_master_period
Progress Code: gb2000.p and gb5300.p
GL Posting warns on budget overrun
Test for Valid Transaction, depending on a_ledger.a_budget_control_flag_l
Progress Code: finance/gl/gl4330.p
Reports on Budget
Progress Code: gb3000p.w
See Income/Expense Statement and Balance Sheet which should already be working.