gl_excel:linecolumn

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)

  • =LineColumn("BALCON", "A02", "AVG BAL", "12/31/2008") Returns the user-entered value for line A02 of the "AVG BAL" user-created column within the BALCON user report for 12/31/2008.
  • =LineColumn("BALCON", "A01", "YTD Avg Bal (Month End Adjusted)", "12/31/2009") Returns the General Ledger-calculated month-end adjusted year-to-date average balance for line A01 of the BALCON user report for 12/31/2009.

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}%

  • gl_excel/linecolumn.txt
  • Last modified: 2023/07/24 14:33 UTC
  • by 127.0.0.1