This shows you the differences between two versions of the page.
| |
| gl_excel:linecolumn [2010/06/21 17:01 UTC] – created mwolfe | gl_excel:linecolumn [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 |
|---|
| 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. | 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. |
| |
| %InlineCode{LineColumn(UserRpt, LineCode, ColName, ColDate)}% | **LineColumn(UserRpt, LineCode, ColName, ColDate)** |
| |
| ==== Example Usage ==== | ==== Example Usage ==== |
| * %InlineCode{=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", "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. |
| * %InlineCode{=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. | * **=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. |
| |
| ==== Required Parameters ==== | ==== Required Parameters ==== |