Interfacing to General Ledger
  Overview
 

 

The General Ledger System is designed to work with other subsystems by communicating with them through a series of interface programs and data files. The use of these interface programs and files allows this communication to be established with minimal or no modification to the General Ledger System itself.

A set of sample programs are provided with the General Ledger System. The sample source code for these programs is located in the library named IFGEN. The programs provided will interface with the General Ledger System and other subsystems provided by Business Applications, Inc. They will not communicate with any other subsystems with out modification. Programs residing in library ARGEN are either General Ledger System target or source programs and should not be modified. All modifications should be done by copying source code to IFUSER and then be compiled to library IFUSER.

It is the user's responsibility to insure these programs are modified to communicate with the user's subsystems.

These programs can be either CL or RPG depending on the requirements of the task being performed. CL programs are normally used when library lists need to be changed or modified in order to access other subsystems.

The IFUSER library should always exist in the library list of any user while performing General Ledger functions.

For more information about Journal Entries, see:General Information - Journal Entries.

 

 

 
  Interface Calls To General Ledger
 

 

The following are calls which can be made to the General Ledger System to send information to the application, retrieve information from the application or to enter the application to display or work with information within the application. Samples of these programs can be found in QRPGSRC in library IFGEN.

 

Description Program Sample Program
Import Journal Entry GLFPXFR IFGEN/QRPGSRC/APSBS10
Import Journal Leg GLFQXFR IFGEN/QRPGSRC/APSBS11

Import Journal Entry Text

GLFRXFR IFGEN/QRPGSRC/see below
Import Journal Leg Text GLFSXFR IFGEN/QRPGSRC/see below
Post Journal Entry Request GLFTXFR IFGEN/QRPGSRC/APSBS12
Validate for External Use GLKCXFR IFGEN/QRPGSRC/APSBS05
Get Closing Date Status GLLSXFR IFGEN/QRPGSRC/APSBS20
Import G/L Account GLL4XFR IFGEN/QRPGSRC/see below
Get General Ledger Description

GLMEXFR

IFGEN/QRPGSRC/APSBS16

Import Budget Amount

GLMJXFR IFGEN/QRPGSRC/see below
Verify J/Es for Source
 GLPPXFR IFGEN/QRPGSRC/ARSBS40

 

GLFRXFR - Import Journal Entry

 
*ENTRY PLIST
PARM P0RTN 7 Return Code
P1A8NB PARM WP0001

2

0 Company Number
P1A0CD PARM WP0002 3 J/E Source Code
P1A0TX PARM WP0003 10 Journal Entry Source Reference
P1AIDT PARM WP0004 7 0 Journal Entry Date
P2A2TX PARM WP0005 60 J/E Description
P2BFTX PARM WP0006 15 J/E Descript Change User ID
P3CSST PARM P3CSST WP0007 1 Import J/E Return Code

 

GLFSXFR - Import Journal Leg Text

 
*ENTRY PLIST
PARM P0RTN 7 Return Code
P1A8NB PARM WP0001

2

0 Company Number
P1A0CD PARM WP0002 3 J/E Source Code
P1A0TX PARM WP0003 10 Journal Entry Source Reference
P1AIDT PARM WP0004 7 0 Journal Entry Date
P2A3TX PARM WP0005 10 Journal Leg Reference
P3AMVN PARM WP0006 10 J/E Leg Descript Change User ID
P3A4TX PARM WP0007 60 J/E Leg Description Text
P3BGTX PARM WP0008 15 J/E Leg Description Text Reference
P4CSST PARM P4CSST WP0009 1 Import J/E Return Code

 

GLL4XFR - Import G/L Account

 
I P1PARM DS
46
* I: MAP G/L Account Number
I P
1
3
 0 P1BSNB
* I : MAP G/L Sub Account Number
I
4
6
 P1BUTX
* I : MAP G/L Account Entry Date
I P
7
10
 P1ARDT
* I : MAP G/L Account Status
I
11
11
 P1BVST
* I : MAP G/L Account Type
I
12
12
 P1BZST
* I : MAP G/L Account Class
I
13
13
 P1B0ST
* I : MAP G/L Account A/R Use
I
14
14
 P1B1ST
* I : MAP G/L Account A/P Use
I
15
15
 P1B2ST
* I : MAP G/L Account Description
I
16
45
 P1AZTX
* I : MAP G/L Account Detail Post
I
46
46
 P1DOST

*ENTRY PLIST
PARM P0RTN 7 Return Code
PARM P1PARM

RCD: *Arrays
P2D2ST PARM P2D2ST WP0001 1 Import G/L Return Code

 

GLMJXFR - Import Budget Amount

*ENTRY PLIST
PARM P0RTN 7 Return Code
P1A8NB PARM WP0001

2

0 Company Number
P2BSNB PARM WP0002 5 0 G/L Account Number
P3BUTX PARM WP0003 3 G/L Sub Account Number
P4BTNB PARM WP0004 2 0 Facility Number
P5AHDT PARM WP0005 7 0 Period Closing Date
P6A6VA PARM WP0006 11 2 Budget Amount
P7DXST PARM WP0007 1 Update Action

 

 
  Interface Calls From General Ledger
 

 

These programs may need to be modified in order to correctly access the information from or to feed information to your applications. Many are required to be modified. Any modified programs should reside in library IFUSER. They will then be used in place of supplied BAI interface programs when called. DO NOT place these program in IFGEN library. If you do, they may be replaced when application updates are applied. Samples of these programs can be found in QRPGSRC in library IFGEN.

 

Program Description Note
GLSBS01 Display Sub Sys Dtls (3)
GLSBS06 Add SBS Close Date (1)
GLSBS07 Get SBS Close Dte Sts (1)
GLSBS08 Remove SBS Close Date (1)
GLSBS09 Ck Child SBS Close (1)
GLSBS12 Verify Sub Sys Dtl (2)

Notes:

(1). Only required if you want to coordinate closing dates between your applications and the General Ledger.

(2).

Only required if you are feeding the Journal Entries to the General Ledger and would like to have the General Ledger Verify the Journal Entries against your application when it is closed for a period.
(3).

Only required if you would like to be able to branch from Journal Entry Details within the General Ledger to your applications for detail supporting the Journal Entry.