Skip to main content
Skip table of contents

GLRP - SR19JB

Detail Line Reformatting GL Standard Report 19
The detail line in GL Standard Reports 1, 14, 19 and in the GL Transaction File Listing Report (GLREFLTR) can be reformatted on a subsystem basis. This is the setup for GL Standard Report 19 in verbose format, setup is similar for GLREFLTR and the other Standard Reports (see other common code descriptions). When the common code is "ON" certain fields can be concatenated, shortened or moved to a new location on the same detail line based on the subsystem ID(s) specified in the common code. Note-Reformatted fields only write over what was previously on the detail line, they are not inserted.
Once this common code is turned "ON" a header will need to be made in NUUPHD. The new header must have the name "GLHD1901." If this report is being run in Short Format, a header should be made using the name "GLHD1902."
Code Category: GLRP
Code Value: SR19JB (Change "JB" to "SH" if running report in Short Format).
Short Description: Enter "OFF" to disable this common code. Enter "ON" to enable.
Medium Description: Enter "ON" to enable Concatenation Mode. Enter "OFF" to insert a space before and after each reformatted field.
Long Description: Used to describe the common code.
Associated Numeric Values
1-5: Reserved for future use.
Associated Codes
1-5: Enter subsystem IDs to which reformatting applies (only 6 subsystems will fit on one line). Only reformatting on corresponding "Associated Descriptions" line will be applied to these subsystems (i.e., reformatting in "Associated Descriptions" line 1 only applies to subsystems listed in "Codes" line 1).
Associated Descriptions
1-5: Enter reformatting here in the following format (exclude "<"and ">") <Variable Name><Starting Column><Length> If more than one field needs to be reformatted, concatenate the pattern until "Associated Descriptions" line is full. Only four fields will fit on one "Associated Descriptions" line, and there will always be at least two blank spaces at the end of each "Associated Descriptions" line. Reformatting only applies to subsystems listed on corresponding "Codes" line.

Valid <Variable Names>

Maximum Length**

REF Primary Reference

16

PID Payee ID

12

PER Fiscal Period

2

TYP Transaction Type

2

DES Associated Description

30

MIS Miscellaneous Code

4

RF2 Secondary Reference

16

DT2 Secondary Reference Date

8

BAT Batch ID

8

SBS Subsystem ID

2

PED Person Entity DB Code

2

CKI Check Stock ID

2

CKNCheck Number

6

CNCCKI and CKN concatenated

8

GWOWork Order (for future use)

12

CURForeign Currency Code

4

DATPrimary Transaction Date

8

PEPPreparer's ID

4

CNOContract Number

16

OFYOriginal Fiscal Year

4

Larger Maximum Lengths can be used, but nothing will be printed beyond the Maximum Length.
Example:
For the following setup of common code GLRE-SR19JB, all detail line entries with a subsystem ID in the list on line one of the "Codes" column (AR, CR, EN, OH, FA, SI) will have- the Primary Reference (REF) printed in column 1 for a length of 10 characters (only the first 10 characters will be printed), the Subsystem ID (SBS) printed in column 11 for a length of 2, the Check Stock ID (CKI) printed in column 13 for a length of 2, and only the first 3 characters of the Check Number (CKN) will be printed starting in column 15.
All detail line entries with a subsystem ID listed on line two of the "Codes" column (JE) will have the Preparer's ID (PEP) printed in column 3 for a length of 16. Since the Preparer's ID has a maximum length of 4, and since the common code setup specifies a length of 16, the last 12 characters will be blank.
All detail line entries with a subsystem ID listed on line three of the "Codes" column (JE) will have the Primary Transaction Date printed in column 6 for a length of 26. As with the Preparer's ID, since the specified print length (26) is longer than the maximum length for the Primary Transaction Date field (8), the last 18 characters will be blank.

Codes

Descriptions

AR

REF0110SBS1102CKI1302CKN1503

CR

PEP0316

JE

DAT0626

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.