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
gl_excel:balance [2010/06/18 15:58 UTC] mwolfegl_excel:balance [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1
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{Balance(AcctNum, BalanceDate, //PosNeg//)}%+**Balance(AcctNum, BalanceDate, //PosNeg//)**
  
 ==== Example Usage ==== ==== Example Usage ====
-  * %InlineCode{=Balance("1010-000", "7/31/2009")}%  Returns the balance for account 1010-000 as of the end of the day July 31, 2009. +  * **=Balance("1010-000", "7/31/2009")**  Returns the balance for account 1010-000 as of the end of the day July 31, 2009. 
-  * %InlineCode{=Balance("SC110", "1/31/2009")}% Returns the balance for TFR line number SC110 as of the end of the day January 31, 2009. +  * **=Balance("SC110", "1/31/2009")** Returns the balance for TFR line number SC110 as of the end of the day January 31, 2009. 
-  * %InlineCode{=Balance("3110-000", "12/31/2009")}% Returns the balance for income account 3110-000 just prior to the 2009 year-end closeout. +  * **=Balance("3110-000", "12/31/2009")** Returns the balance for income account 3110-000 just prior to the 2009 year-end closeout. 
-  * %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. +  * **=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. +  * **=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.1276876683.txt.gz
  • Last modified: 2010/06/18 15:58 UTC
  • by mwolfe