| Description |
STEPS:
1. I ran this script first in 1520PT
--select * from INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME like '%Historical%'
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 tblGLAccountGroup
delete from tblICItemAccount
--select * from tblCMDataImportStatus
----update tblCMDataImportStatus set intUserId = NULL
--update tblCMDataImportStatus set dtmImportRun = NULL
--select * from dbo.tblSMPreferences
update tblSMPreferences set strValue = 'false' where strPreference = 'isHistoricalJournalImported'
--select * from glprcmst
--select * from glactmst where A4GLIdentity = 38338
--delete from glactmst where A4GLIdentity <> 38338
--delete from glprcmst where A4GLIdentity <> 2
--update glprcmst set glprc_sub_acct = 10000
--update glactmst set glact_acct9_16 = 10000
2. Run the Recreate Origin COA Setup
ISSUE:
!pastedImage_d34272_0.png!
|