Atrieve Finance

Sub-Ledger Export

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
     1 - 12  = expense
     13 - 24 = not currently used

24 x 10

Export Record Total Length

459