Cannot Insert NULL value into intAccountStructure tabl

Issue No: GL-1505
Created 2/4/2015 3:29:58 AM
Type Bug
Priority Major
Status Closed
Resolution Fixed
Fixed Version 15.1
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.