New Company DB should populate default Account Structure data

Issue No: GL-1514
Created 2/8/2015 9:54:06 PM
Type Task
Priority Major
Status Closed
Resolution Fixed
Fixed Version 15.1
Description STEPS:   I ran the scripts below prior to upgrading so that I will have a fresh i21 GL table database without any data. This will mimic customer database as if this is the first the will be upgrading/installing to i21.   delete from tblGLAccountSegmentMapping delete from tblGLCOAImportLog delete from tblGLCOAImportLogDetail delete from tblGLAccountAllocationDetail delete from tblGLCOAImportLog delete from tblGLAccountReallocationDetail delete from tblGLCOATemplate delete from tblCMBankTransactionDetail delete from tblAPPayment delete from tblCMBankTransaction delete from tblCMCheckNumberAudit delete from tblCMBankReconciliation delete from tblCMBankAccount delete from tblGLDetail delete from tblAPBillDetail delete from tblGLBudget delete from tblAPBill delete from tblAPBillBatch delete from tblAPVendor delete from tblGLAccount delete from tblGLSummary delete from tblGLJournalDetail delete from tblGLJournalRecurringDetail delete from tblGLAccountSegment delete from tblGLAccountStructure delete from tblGLCOACrossReference delete from tblGLAccountGroup   --select * from dbo.tblSMPreferences update tblSMPreferences set strValue = 'false' where strPreference = 'isHistoricalJournalImported'   *ISSUE:*   The installer will fail because Profit Center segment does exist which is ok. A data fix was provided that will insert the Location segment in the Account Structure table if the table is empty.   *ACCEPTANCE CRITERIA*   Populate the same data row records as shown below. Only that we have to use the Location.     !pastedImage_d32602_0.png!     *Note that the screenshot above was taken in 14.4 schema and upgraded to the 14.4 build.