Dynamics Community Forum Thread Details

Integration Manager and SQL script

We are on GP13 with sp1 and every time we run a IM to upload assets into GP and run Projections/Depreciation, it errors out. Here is a script that I can run after the upload that prevents the error. I am running the script after the upload against the company database. I was told that there is a way to add this script to IM so I don't have to run the script each time.

This is my first time doing this. Any help will be greatly appreciated.

Here is the script:

update a set a.GLINTACCTINDX=b.DEPRRESVACCTINDX from FA00902 a join FA00400 b on a.ASSETINDEX=b.ASSETINDEX

where a.TRANSACCTTYPE = '1' and a.GLINTACCTINDX='0'

update a set a.GLINTACCTINDX=b.DEPREXPACCTINDX from FA00902 a join FA00400 b on a.ASSETINDEX=b.ASSETINDEX

where a.TRANSACCTTYPE = '2' and a.GLINTACCTINDX='0'

update a set a.GLINTACCTINDX=b.ASSETCOSTACCTINDX from FA00902 a join FA00400 b on a.ASSETINDEX=b.ASSETINDEX

where a.TRANSACCTTYPE = '3' and a.GLINTACCTINDX='0'

update a set a.GLINTACCTINDX=b.PROCEEDSACCTINDX from FA00902 a join FA00400 b on a.ASSETINDEX=b.ASSETINDEX

where a.TRANSACCTTYPE = '4' and a.GLINTACCTINDX='0'

update a set a.GLINTACCTINDX=b.RECGAINLOSSACCTINDX from FA00902 a join FA00400 b on a.ASSETINDEX=b.ASSETINDEX

where a.TRANSACCTTYPE = '5' and a.GLINTACCTINDX='0'