Description |
STEPS
1. Use the Federated db and follow the procedure below to produce test data
--Back up the records in the tblGLIjemst
select * into tblGLIjemstbak1014 from tblGLIjemst
--Delete the records in tblGLIjemst
delete from tblGLIjemst
--Insert October 2015 data
SET IDENTITY_INSERT glijemst ON
insert into glijemst
(
glije_period
,glije_acct_no
,glije_src_sys
,glije_src_no
,glije_line_no
,glije_date
,glije_time
,glije_ref
,glije_doc
,glije_comments
,glije_dr_cr_ind
,glije_amt
,glije_units
,glije_correcting
,glije_source_pgm
,glije_work_area
,glije_cbk_no
,glije_user_id
,glije_user_rev_dt
,A4GLIdentity
)
select
glije_period
,glije_acct_no
,glije_src_sys
,glije_src_no
,glije_line_no
,glije_date
,glije_time
,glije_ref
,glije_doc
,glije_comments
,glije_dr_cr_ind
,glije_amt
,glije_units
,glije_correcting
,glije_source_pgm
,glije_work_area
,glije_cbk_no
,glije_user_id
,glije_user_rev_dt
,A4GLIdentity
from tblGLIjemstbak1014 where glije_period = 201510 and glije_src_no not in ('1524', '1526','10020','1530','10040','10030')
SET IDENTITY_INSERT glijemst OFF
2. Import 2015 and period 10 in Subledger.
ISSUE:
Successful records in the header are showing duplicates.
!pastedImage_d44938_0.png!
ACCEPTED
Should show their own GJ ids
|