Share
ReportWe 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'
update a set a.GLINTACCTINDX=b.NONRECGAINLOSSACCTINDX from FA00902 a join FA00400 b on a.ASSETINDEX=b.ASSETINDEX
where a.TRANSACCTTYPE = '6' and a.GLINTACCTINDX='0'
update a set a.GLINTACCTINDX=b.CLEARINGACCTINDX from FA00902 a join FA00400 b on a.ASSETINDEX=b.ASSETINDEX
where a.TRANSACCTTYPE = '7' and a.GLINTACCTINDX='0'
*This post is locked for comments
All responses (
Answers (
3,561
