====== LineBalance ====== This function returns the balance of a user report line as of a certain date. **LineBalance(UserRpt, LineCode, BalanceDate, //Company//, //PosNeg//)** ==== Example Usage ==== * **=LineBalance("BALCON", "A01", "7/31/2009")** Returns the balance for line A01 of the BALCON user report as of July 31, 2009. * **=LineBalance("BALCON", "M02", "12/31/2009 8:00PM")** Returns the balance for line M02 of the BALCON user report following the 2009 year end closeout. * **=LineBalance("BALCON", "A01", "3/17/2009", , "C")** Returns 'Debit Balance' because the balance for line A01 of the BALCON user 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. * Note the extra comma between the BalanceDate and the PosNeg parameter. That must be included because the Company parameter is not specified. * **=LineBalance("BALCON", "A01", "3/17/2009", "Cit")** Returns the balance for the Citizens Savings Bank accounts in line A01 of the BALCON user report (ie, it excludes all of the service company accounts). See below for more information about the Company parameter. ==== Required Parameters ==== {{section>parameters#userrpt}} {{section>parameters#linecode}} {{section>parameters#balancedate}} ==== Optional Parameters ==== {{section>parameters#company}} {{section>parameters#posneg}}