Option 4Prepare Balances for Spreadsheet

Use this function to create an alphanumeric Account Balances file that can be transferred to a spreadsheet. Exact procedures for this task are available in Appendix B of this manual, “interfacing Balances with a Spreadsheet”. The following processing steps accomplish this job.

1. Step 1In preparation for performing a sort/selection process on the Account Balances information, this step provides you with a default sequencing of data records by 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 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 Account Balances. The entire contents of the Balances to Spreadsheet field will be deleted. The Balances to Spreadsheet file will be created. Under certain conditions, records in the Balances to Spreadsheet file will be added. Generalized routines are performed to move any minus signs to the left side of the amounts.