General Ledger Output File

Related Topics

Finance Reports > Reports

The GLFILEMGSI report, GL ASCII Output File, creates formatted fixed-length records of general ledger information that can be saved as an ASCII text file for importing into financial software systems. 

The structure of output records appears in the chart: "GLFILEMGSI Output Record Format."

GLFILEMGSI Output Record Format

Position

Length

Format

Description

1-10

10

Alphanumeric

GL account code  (determines record sort order)

11-40

30

Alphanumeric

GL account description

41-41

1

C or D

Credit or debit account type

42-51

10

Alphanumeric

Labor segment 1 code

52-61

10

Alphanumeric

Labor segment 2 code

62-71

10

Alphanumeric

Labor segment 3 code

72-81

10

Alphanumeric

Labor segment 4 code

82-91

10

01/01/2009

Payroll check date

92-101

10

Alphanumeric

GL account miscellaneous information

102-113

12

999999.99

General ledger dollars

114-123

10

999.99

General ledger hours

124-124

1

Y or N

Accrual record (Y) or non-accrual record (N)