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.
|