Description |
*ISSUE:*
When we do Origin COA conversion, the COA's Description is being regenerated by the i21's Description format (Code - Segment's description). Thus, can change the Description that is originally in the Origin's table.
*ACCEPTANCE CRITERIA*
We should be able to retain the Origin Description by adding the following codes in the stored procedure to import Origin COA
1. Back up the glactmst prior to conversion
select * into ##glactmstbackup from glactmst
2. After that COA is built, update the description of the glactmst's description based on temp table.
update A
set A.glact_desc = B.glact_desc
from glactmst A
inner join ##glactmstbackup B
on A.glact_acct1_8 = B.glact_acct1_8
where A.glact_acct9_16 = B.glact_acct9_16
3. Update the i21 COA's description based on the glactmst description.
update A
set A.strDescription = C.glact_desc
from tblGLAccount A
inner join tblGLCOACrossReference B
on A.intAccountId = B.inti21Id
inner join glactmst C
on C.A4GLIdentity = B.intLegacyReferenceId
select * from tblGLAccount A
inner join tblGLCOACrossReference B
on A.intAccountId = B.inti21Id
inner join glactmst C
on C.A4GLIdentity = B.intLegacyReferenceId
|