Fix why Org and OrgR are swapped when copying the expense from the 204AcctXProjV into 204AcctXProj table

Question

Fix why Org and OrgR are swapped when copying the expense from the 204AcctXProjV into 204AcctXProj table

Closed this issue 8 years ago · 1 comments

Which stored procedure handles this: [dbo].[sp_Repopulate_AD419_204]
Does it do a straight across copy, i.e. Insert into 204AcctXProj Select * from 204AcctXProjV? or are the column names specified, potentially causing the issue? Yes, that was the issue. Fixed.

Answer 1 · 2016-09-09T15:53:43.000Z

The column names were specified in sp_Repopulate_AD419_204, and there was a swap between OrgR in the insert column list and select column name list. This has been resolved.