Table of Contents

LineColumn

This function returns the value of a user defined column from the General Ledger. Before using this function in Excel, the column(s) must be added and populated from within the General Ledger by clicking on the Edit Columns button on the User Reports form.

LineColumn(UserRpt, LineCode, ColName, ColDate)

Example Usage

Required Parameters

UserRpt

The name of the user report (not its description)

"BALCON"
"INCST2"

%fineprint{Used in: LineAverage, LineAverageRound, LineBalance, LineBudget, LineBudgetRound, LineColumn, LineDescription, LineRound}%

LineCode

The 3-digit user report line item code.

"A01"
"C15"

%fineprint{Used in: LineAverage, LineAverageRound, LineBalance, LineBudget, LineBudgetRound, LineColumn, LineDescription, LineRound}%

ColName

Name of the user report column created by going to Edit Columns from the Edit User Report form in the General Ledger. The column must be manually added in the General Ledger in order for it to work in the Excel function.

"AVG BAL"
"QTD Average Balance"
"YTD Avg Bal (Month End Adjusted)"

%fineprint{Used in: LineColumn}%

ColDate

The date of the user report column created by going to Edit Columns from the Edit User Report form in the General Ledger. The date must be manually added in the General Ledger in order for it to work in the Excel function.

"12/31/2009"
 "5/31/2009"

%fineprint{Used in: LineColumn}%