Specifications Budget

From OpenPetra Wiki
Revision as of 09:52, 9 December 2011 by Ctopenpetra (talk | contribs) (Added Budget Export)
Jump to navigation Jump to search

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

Export a budget

Budgets can be exported as a CSV file for manipulation in Excel.

Follow the code for exporting Gift batches, which includes a dialog to specify the filename to export to plus regional settings (date and number format) and separator character. The code location mirrors that for importing budgets, i.e. resides on the server.

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.