Option 4Prepare Budgets for Spreadsheet

This function creates a Budget Amounts file that can be transferred to spreadsheet software for further work. More information is available in Appendix A of this manual, “Interfacing Budgets to Spreadsheet”. The following processing steps accomplish this job.

1. Step 1In preparation for performing a sort/selection process on the Budget Amounts information, this step provides you with a default sequencing of data records by Budget Type, Fiscal Year and Account, giving additional sort order choice by Account Component, with the option to change modifiable parameters at run time. Selection of data records is provided by Budget Type, Fiscal Year, Account, and Account Component, with the option to enter user-specified comparisons at run time.
2. Step 2This disposition type is used for all standard processing functions within General Ledger.
3. Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
4. Step 4This step processes the information for Budget Amounts. The entire contents of the Budgets to Spreadsheet file will be deleted. The Budgets to Spreadsheet file will be created. Under certain conditions, records in the Budgets to Spreadsheet file will be added. Generalized routines are performed to move any minus signs from the right side to the left side of the Budget Amounts.