Summary

The PGPRGENE002 – GL Journal report lists details of the General Ledger Journal, and it creates a file for export into a specified General Ledger/Accounting package. You can specify the General Ledger type on the Company Settings | General Ledger tab.

The following table explains the text file format for the Sun Systems GL interface.

Field No

Field Width

Source

Description

Character Position

1

10

CostCentre.GeneralLedgerCode

Account code

1 – 10

2

5

Pad ‘ ‘

11 – 16

3

7

Date To: in setup dialog

Accounting period

17 – 24

4

8

Date To: in setup dialog

Transaction date

25 – 33

5

2

Pad ‘ ‘

34 – 35

6

1

‘M’

36

7

7

Pad ‘ ‘

37 – 44

8

5

Pad ‘ ‘

45 – 50

9

2

Pad ‘ ‘

51 – 52

10

18

HistoricalAllowance.TotalAmount

or

HistoricalDeduction.TotalAmount

Transaction Total

53 – 71

11

1

HistoricalAllowance.TotalAmount

or

HistoricalDeduction.TotalAmount

‘D’ or ‘C’ (Debit or Credit)

72

12

1

Pad ‘ ‘

73

13

5

‘WIJ’

Wages Interface Journal

74 – 79

14

5

Pad ‘ ‘

80 – 85

15

15

Pad ‘ ‘

86 – 101

16

25

CostCentre.GeneralLedgerDesc

Transaction reference

102 – 127

17

124

Pad ‘ ‘

128 – 252

18

15

CostCentre.GeneralLedgerCode

Branch code

253 – 268

19

15

CostCentre.GeneralLedgerCode

Funding source code

269 – 284