Description |
Steps
1. Clean up the data using the scripts bekiw
--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 tblGLJournalDetail
delete from tblGLJournalRecurringDetail
delete from tblGLAccountSegment
delete from tblGLAccountStructure
--select * from dbo.tblSMPreferences
update tblSMPreferences set strValue = 'false' where strPreference = 'isHistoricalJournalImported'
2. Made sure I have these data in glactmst and glprcmst. Same segment code and primary code.
!pastedImage_d32378_0.png! 3. Run Import Origin: Structure then Segment
*ISSUE:*
When importing the location here is what happened.
!pastedImage_d32378_1.png!
Primary is imported but not the Location Segments
ACCEPTANCE CRITERIA
Segment should be imported.
|