| Next revision | Previous revision |
| gl_excel:fedrptbalance [2014/03/13 21:38 UTC] – created mwolfe | gl_excel:fedrptbalance [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 |
|---|
| This function returns the balance of a Federal Report line as of a certain date. | This function returns the balance of a Federal Report line as of a certain date. |
| |
| %InlineCode{FedRptBalance(RptName, LineNum, BalanceDate, //Company//, //PosNeg//)}% | **FedRptBalance(RptName, LineNum, BalanceDate, //Company//, //PosNeg//)** |
| |
| ==== Example Usage ==== | ==== Example Usage ==== |
| * %InlineCode{=FedRptBalance("TFR", "SC11", "7/31/2009")}% Returns the balance for line SC11 of the TFR Federal Report as of July 31, 2009. | * **=FedRptBalance("TFR", "SC11", "7/31/2009")** Returns the balance for line SC11 of the TFR Federal Report as of July 31, 2009. |
| * %InlineCode{=FedRptBalance("Call", "RI-4518", "12/31/2009 8:00PM")}% Returns the balance for line RI-4518 of the Call Federal Report following the 2009 year end closeout. | * **=FedRptBalance("Call", "RI-4518", "12/31/2009 8:00PM")** Returns the balance for line RI-4518 of the Call Federal Report following the 2009 year end closeout. |
| * %InlineCode{=FedRptBalance("TFR", "SC26", "3/17/2009", , "C")}% Returns 'Debit Balance' because the balance for line SC26 of the TFR Federal Report on March 17, 2009 is 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. | * **=FedRptBalance("TFR", "SC26", "3/17/2009", , "C")** Returns 'Debit Balance' because the balance for line SC26 of the TFR Federal Report on March 17, 2009 is a debit balance. 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. |
| * Note the extra comma between the BalanceDate and the PosNeg parameter. That must be included because the Company parameter is not specified. | * Note the extra comma between the BalanceDate and the PosNeg parameter. That must be included because the Company parameter is not specified. |
| * %InlineCode{=FedRptBalance("TFR", "SC26", "3/17/2009", "Cit")}% Returns the balance for the Citizens Savings Bank accounts in line SC26 of the TFR Federal Report (ie, it excludes all of the service company accounts). See below for more information about the Company parameter. | * **=FedRptBalance("TFR", "SC26", "3/17/2009", "Cit")** Returns the balance for the Citizens Savings Bank accounts in line SC26 of the TFR Federal Report (ie, it excludes all of the service company accounts). See below for more information about the Company parameter. |
| |
| ==== Required Parameters ==== | ==== Required Parameters ==== |