gl_excel:balance

Differences

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

Link to this comparison view

Next revision		 Previous revision
Last revisionBoth sides next revision
gl_excel:balance [2010/06/18 15:57 UTC] – created mwolfegl_excel:balance [2010/06/18 15:58 UTC] – mwolfe
Line 1: Line 1:
 ====== Balance ====== ====== Balance ======
 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 9: 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