The SUB-Ledger Export option creates an ASCII text file of sub-ledger records.
Format #
-
Enter the number opposite the format description. See the export profile menu to create a new format.
Account # of Conversion File
-
Enter the disk and directory where you will put the new export file.
Conversion File Name
-
Enter the name of the new export file.
Year for Sub-Ledger Information
-
Enter the year for which sub-ledger information is to be taken.
Starting Sub-Ledger
-
Enter the first sub-ledger number to be exported.
Ending Sub-Ledger
-
Enter the last sub-ledger number to be exported. The sub-ledger export creates a list file with statistics on the export run and a breakdown of the records in the export file. An example is shown below.
Sub-Ledger Export Run Statistics Listing
Export Record Breakout Map
|
Field |
Length |
|
Header |
Y/N : 1 |
|
Deleted |
Y/N : 1 |
|
Sub-ledger |
Y/N : 1 |
|
Budget |
Y/N : 1 |
|
Locked |
Y/N : 1 |
|
Year |
: 4 |
|
Sub-ledger Account |
: 8 |
|
Account Description |
: 34 |
|
Opening Expenditures |
#######.## : 10 |
|
Opening Commitments |
#######.## : 10 |
|
Opening Units |
#######.## : 10 |
|
Opening Budget |
#######.## : 10 |
|
Current Expenditures |
#######.## : 10 |
|
Current Commitments |
#######.## : 10 |
|
Budget Revisions |
#######.## : 10 |
|
Materials Posting GL |
: 20 |
|
Materials Budget |
#######.## : 10 |
|
Labor Posting GL |
: 20 |
|
Labor Budget |
#######.## : 10 |
|
Variable Information
|
24 x 10 |
|
Export Record Total Length |
459 |