{{ model.title }}
This page is currently being edited by {{ model.editingBy }}.Budget Prep > Accounts > Export Budget Prep Account Details
Recent Change:
6.134
- Removing validation on dates for Historical budget prep data export.
6.130
- Added account description to the end of the files created. Changed the delimiter from comma to pipe.
6.126
- Added new menu option to create export files for historical/future budget prep data for use with OpenGov.
Introduction
This option is available only if the 'OpenGov' interface is set in the license file.The Export Budget Account detail feature allows users to export historical account actuals/budgets for specified date range or future budgets for a specified budget version to a .txt file. This was developed to provide export files for clients who want to use OpenGov for Budgeting and Reporting purposes.
Input Criteria
- Historical/Actual Budgets - If this option is selected the user can select a date range to allow them to export budget/actual transaction details for multiple fiscal years. It will create two .txt files one for Actual and one for Budget amounts.
Export File Layout For Historical budget data :
http://rand-wiki.harriscomputer.com/Page/5774/OpenGovBudgetPrepLayout
- Future Budgets - If this option is selected the user can select a budget version for a future fiscal year to export as a .txt file.
For Future Budget Export Layout
Field | Comments |
---|---|
Account Number | fl141.cacct |
Fund | fl141141Segments.Fund |
Fund Name | csi21.cfunddesc |
Department | fl141Segments.Department |
Department Name | csi25.cdeptdesc |
Object | fl141Segments.Object |
Object Name | csi23.cobjname |
Account Type | |
Function | fl141Segments.Func |
Function Name | csi22.cfuncdesc |
Location | fl141Segments.Location |
Location Name | csi24.clocdesc |
Object Group | fl141Segments.ObjectGroup |
Object Group Name | csi30.cprogdesc |
Cost Center | fl141Segments.CostCenter |
Cost Center Name | csi36.ccostdesc |
Job Class | fl141Segments.JobClass |
Job Class Name | csi35.cjobdesc |
Modifier | fl141Segments.Modifier |
Modifier Name | csi34.cmodifdesc |
Fiscal Year | |
Recommended | AccountBudget.Recommended |
Requested | AccountBudget.Requested |
Forecasted | AccountBudget.Forecasted |
AccountDescription | fl141.cacctdesc |