Description |
ISSUE:
!pastedImage_d36426_0.png!
Prior to this, I made sure that the I cleaned all data in
--delete COA
--select * from INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME like '%Historical%'
--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 tblGLAccountSegment
delete from tblGLAccountGroup
delete from tblICItemAccount
delete from tblICInventoryReceipt
delete from tblPOPurchaseDetail
delete from tblPOPurchase
delete from tblAPVendor
--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
|