Specifications Budget: Difference between revisions

From OpenPetra Wiki
Jump to navigation Jump to search
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 with the grid, 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
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.