I had a client at which I imported approximately 3900 Fixed Assets using the Integration Manager integration. The Assets all had valid account groups assigned and were imported correctly.
However, when creating the GL Posting for the Additions after the upload, the Assets that were added via Integration Manager all had no account numbers for the FAADD lines in the posting file. If you go ahead and post the GL Posting the error you get is "Account Not Found". Interestingly, the assets that were added manually or through Purchasing were fine on the FAADD lines - they had account numbers for the Asset Cost and Clearing accounts.
I did quite a bit of research and found some interesting items regarding the Require Account trigger in the FA Company Set up - it must be checked! But not other research could tell me why this was happening. No amount of changing up settings was working so I dived into SQL.. The assets all had valid GL Account Indexes in their setups.
Long story short - here is the fix - run it against the offending company database:
------Run the following against the company DB to ensure that existing financial detail records have accounts mapped correctly---------
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'
After this was run, I re-ran the GL Posting and all of the accounts populated!
I hope this helps someone in the future!!!
---Jo Ann de Ruiter
Sr. Dynamics GP Consultant
Ace Microtechnologies
Your script saved the day, thank you very much...and we did use Account Groups to add the assets; however, some of the groups were missing GL accounts because our need for them vary so much.
Hi Kayla:
That sounds like you may not have your Account Groups tied to your Classes and/or you did not successfully add the appropriate Account Group to your asset(s).
To manually add an account group: In Cards>Fixed Assets>Account Groups select your asset and look up or type in the necessary Account Group for that asset.
To automate the addition of account groups: in Financial>Setup>Fixed Assets>Class select each of your classes and associate the corresponding Account Group so that when you add and asset and select the class it should be in, the Accounts auto populate.
To ensure that all assets have a generic Account Group in case you miss one, in Financial>Setup>Company tick off "Require Account" and you'll be prompted to enter the default accounts for the case of an asset being added and not selecting an account group.
If you verify that you HAVE added the Account Groups, then I would recommend backing up your database and running CheckLinks on those items.
Let us know if you have any further questions.
I do not see an option for Fixed Assets in CheckLinks. Where is this? I ran the script above and it did not help. Used IM to import 700 assets and a couple dozen came into the FA to GL with blank accounts. Very strange that not all or none.
My assets all have accounts but FA00400 is empty any ideas?