This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revisionBoth sides next revision |
gl_excel:balance [2010/06/18 15:58 UTC] – mwolfe | gl_excel:balance [2010/06/18 15:58 UTC] – mwolfe |
---|
* %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}} |