For version 17.1 add running total to the GL detail grid and ensure it exports

Issue No: GL-3062
Created 12/8/2016 4:32:38 PM
Type Feature
Priority Minor
Status Closed
Resolution Fixed
Fixed Version 17.1
Description *Test Cases*   *{color:#ff0000}One adjustment - {color}*   * *{color:#ff0000}When inquiring on an Income Statement account do not let the user enter a date prior to the beginning of the fiscal year{color}* *{color:#ff0000} that the to date is in{color}* * *{color:#ff0000}Or do not let the from date go outside the date of the fiscal period.{color}*   *{color:#ff0000}{color}*   *{color:#ff0000} !pastedImage_d66614_0.png! {color}*       |Type of account|Test Case|Example|GL Account to review in source with data|Begin Date|End Date|Beginning Balance expcted| |Income statement|ensure that the income statement does not "roll prior year amounts|FY 2011 account has data - 2012 opening balance should be zero as of 1/1/2012|40000-0000-001|1/1/2012|xx/xx/xxxx|0| |Income statement accounts|Cross fiscal years|??|??| | | | |Income statment accounts|Enure that an income statment account with inquiry beginning not at the begging of the year has an opening balance| |40000-0000-001|6/1/2011|xx/xx/xxxx|15| |Balance sheet|Beginning balance should aways be from beginning of time no matter the range set on inquiry| |10003-0000-000|1/1/2012|xx/xx/xxxx|78| |Balance sheet| | |10003-0000-000|12/1/2011|xx/xx/xxxx|66| |Balance sheet| | |10003-0000-000|11/1/2011|xx/xx/xxxx|55| | | | | | | | |       We need to add two columns to the GL Account detail - which are Beginning blance and ending balance. it should work just like the general ledger by account id detail. once this is fixed we can shut down the gl by account id detail report noted below.     Example in inventory valuation report written by FEB     test to ensure that the report exports to excel per below     !pastedImage_d66614_1.png!     !pastedImage_d66614_2.png!           !pastedImage_d66614_3.png!   !pastedImage_d66614_4.png!