Description |
ISSUE:
!pastedImage_d33793_0.png! STEPS
1.Run the script
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 tblGLJournal
delete from tblGLJournalDetail
delete from tblGLJournalRecurringDetail
delete from tblGLAccountSegment
delete from tblGLAccountStructure
delete from tblGLCOACrossReference
delete from tblICItemAccount
update tblCMDataImportStatus set intUserId = NULL
update tblCMDataImportStatus set dtmImportRun = NULL
update tblSMPreferences set strValue = 'false' where strPreference = 'isHistoricalJournalImported'
2. Import the GL Account first
ACCEPTANCE CRITERIA
Should be enabled.
|