The G/L Buffer is a field that allows manipulation of multiple variables in a derivation expression in UPGLF. The variables, and their meaning are as described for the IDIF X_INF_VARIABLE_NAME (01).

This variable, if left alone will return a 672 byte value which is a concatenation of the values used in the generation of each record for the GL file.  Using the SQL substring function SUBSTR, we can extract bits and pieces and manipulate it within the derivation expression.

This can be used in quite sophisticated derivations, as shown in these examples:

1. Burden Code manipulation
2. Using GL Buffer to determine bypassing
3. Changing Dates based on Journal Source

Note: Some of the values below will only be accessible when the IDGA ‘Retain Detail’ toggle is turned on. If the toggle is not turned on, then the G/L Accounts are posted in Summary and therefore each employee’s information will be re-set to NULL. When posting in Summary, some items such as the check number will not be populated.

The substring values for GL BUFFER are as follows:

Notes#