gl_excel:balance

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
Last revisionBoth sides next revision
gl_excel:balance [2010/06/18 15:57 UTC] – mwolfegl_excel:balance [2010/06/18 15:58 UTC] – mwolfe
Line 2: Line 2:
 This function returns the balance of a GL account or TFR line number as of a certain date. This function returns the balance of a GL account or TFR line number as of a certain date.
  
-%InlineCode{AvgBal(AcctNum, BalanceDate, //PosNeg//)}%+%InlineCode{Balance(AcctNum, BalanceDate, //PosNeg//)}%
  
 ==== Example Usage ==== ==== Example Usage ====
Line 10: Line 10:
   * %InlineCode{=Balance("3110-000", "12/31/2009 8:00PM")}% Returns 0.00 because 3110-000 is an income account and 8:00 PM is past the year-end closeout time.   * %InlineCode{=Balance("3110-000", "12/31/2009 8:00PM")}% Returns 0.00 because 3110-000 is an income account and 8:00 PM is past the year-end closeout time.
   * %InlineCode{=Balance("1010-000", "3/17/2009", "C")}%  Returns 'Debit Balance' because the balance for account 1010-000 on March 17, 2009 was a debit balance and the "C" in our formula told Excel to only display the balance if it was a credit.  See below for more information about the PosNeg parameter.   * %InlineCode{=Balance("1010-000", "3/17/2009", "C")}%  Returns 'Debit Balance' because the balance for account 1010-000 on March 17, 2009 was a debit balance and the "C" in our formula told Excel to only display the balance if it was a credit.  See below for more information about the PosNeg parameter.
- +==== Required Parameters ====
- +
-==== Required Paramaters ====+
 {{section>parameters#acctnum}} {{section>parameters#acctnum}}
 {{section>parameters#balancedate}} {{section>parameters#balancedate}}
 +
 ==== Optional Parameters ==== ==== Optional Parameters ====
 {{section>parameters#posneg}} {{section>parameters#posneg}}
  • gl_excel/balance.txt
  • Last modified: 2023/07/24 14:33 UTC
  • by 127.0.0.1