Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision |
gl_excel:parameters [2010/06/21 16:47 UTC] – clarified ColName and ColDate are edited inside General Ledger mwolfe | gl_excel:parameters [2014/03/13 12:14 UTC] – mwolfe |
---|
"3/1/2009", with StartDate of 1/31/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive | "3/1/2009", with StartDate of 1/31/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive |
"3/17/2009", with StartDate of 1/12/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive | "3/17/2009", with StartDate of 1/12/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive |
%fineprint{Used in: [[AvgBal]], [[LineAverage]], [[LineAverageRound]]}% | %fineprint{Used in: [[AvgBal]], [[FedRptAvgBal]], [[LineAverage]], [[LineAverageRound]]}% |
| |
==== BalanceDate ==== | ==== BalanceDate ==== |
"12/31/2009" Account balances prior to posting the year-end close out batch (ie, income + expense > 0) | "12/31/2009" Account balances prior to posting the year-end close out batch (ie, income + expense > 0) |
"12/31/2009 8:00 PM" Account balances after posting the year-end close out batch (ie, income + expense = 0) | "12/31/2009 8:00 PM" Account balances after posting the year-end close out batch (ie, income + expense = 0) |
%fineprint{Used in: [[Balance]], [[LineBalance]], [[LineRound]]}% | %fineprint{Used in: [[Balance]], [[FedRptBalance]], [[LineBalance]], [[LineRound]]}% |
==== BudgetDate ==== | ==== BudgetDate ==== |
The date that represents the **month and year** used to retrieve the budget numbers | The date that represents the **month and year** used to retrieve the budget numbers |
"3/1/2009" Returns the budget for March 2009 | "3/1/2009" Returns the budget for March 2009 |
"3/17/2009" Returns the budget for March 2009 | "3/17/2009" Returns the budget for March 2009 |
%fineprint{Used in: [[Budget]], [[LineBudget]], [[LineBudgetRound]]}% | %fineprint{Used in: [[Budget]], [[FedRptBudget]], [[LineBudget]], [[LineBudgetRound]]}% |
==== ColDate ==== | ==== 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. | 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. |
"CSB" CSB Services, Inc. | "CSB" CSB Services, Inc. |
| |
%fineprint{Used in: [[LineAverage]], [[LineBalance]], [[LineBudget]]}% | %fineprint{Used in: [[FedRptAvgBal]], [[FedRptBalance]], [[FedRptBudget]], [[LineAverage]], [[LineBalance]], [[LineBudget]]}% |
| |
==== LineCode ==== | ==== LineCode ==== |
"C15" | "C15" |
%fineprint{Used in: [[LineAverage]], [[LineAverageRound]], [[LineBalance]], [[LineBudget]], [[LineBudgetRound]], [[LineColumn]], [[LineDescription]], [[LineRound]]}% | %fineprint{Used in: [[LineAverage]], [[LineAverageRound]], [[LineBalance]], [[LineBudget]], [[LineBudgetRound]], [[LineColumn]], [[LineDescription]], [[LineRound]]}% |
| |
| ==== LineNum ==== |
| The abbreviated federal report line number. |
| "SC11" |
| "SO141" |
| "RI-4435" |
| %fineprint{Used in: [[FedRptAvgBal]], [[FedRptBalance]], [[FedRptBudget]], [[FedRptDescription]]}% |
| |
==== PosNeg ==== | ==== PosNeg ==== |
Limit results to **P**ositive, **N**egative, **D**ebit, or **C**redit only. You may spell out or abbreviate Positive, Negative, Debit, and Credit if you would like to make your formula more readable; the function performs a match on the first character only. | Limit results to **P**ositive, **N**egative, **D**ebit, or **C**redit only. You may spell out or abbreviate Positive, Negative, Debit, and Credit if you would like to make your formula more readable; the function performs a match on the first character only. |
"C" Show positive number if credit balance, otherwise display: Debit Balance | "C" Show positive number if credit balance, otherwise display: Debit Balance |
| |
%fineprint{Used in: [[AvgBal]], [[Balance]], [[LineAverage]], [[LineAverageRound]], [[LineBalance]], [[LineRound]]}% | %fineprint{Used in: [[AvgBal]], [[Balance]], [[FedRptAvgBal]], [[FedRptBalance]], [[LineAverage]], [[LineAverageRound]], [[LineBalance]], [[LineRound]]}% |
| |
| ==== RptName ==== |
| The name of the federal report (not its description) |
| "Call" |
| "TFR" |
| %fineprint{Used in: [[FedRptAvgBal]], [[FedRptBalance]], [[FedRptBudget]], [[FedRptDescription]]}% |
| |
==== StartDate ==== | ==== StartDate ==== |
The date that represents the month and year **from** which to compute the daily average balance (used only with the required AvgBalDate parameter). | The date that represents the month and year **from** which to compute the daily average balance (used only with the required AvgBalDate parameter). |
"1/31/2009", with AvgBalDate of 3/1/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive | "1/31/2009", with AvgBalDate of 3/1/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive |
"1/17/2009", with AvgBalDate of 3/12/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive | "1/17/2009", with AvgBalDate of 3/12/2009 Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive |
%fineprint{Used in: [[AvgBal]], [[LineAverageRound]]}% | %fineprint{Used in: [[AvgBal]], [[FedRptAvgBal]], [[LineAverageRound]]}% |
| |
==== UserRpt ==== | ==== UserRpt ==== |