Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Account Not Found Error - Fixed Asset GL Posting

Posted on by 24,406

One of my customer having the problem in fixed asset GL posting. While they posting GL, it through the error "Account Not Found" and batch is created with zero balance. But, all the assets are mapped with appropriate accounts & account group. Required Account option also marked in fixed asset company setup.

Is there any setup missing?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Account Not Found Error - Fixed Asset GL Posting

    Hi Soma,

    Need help. I have a similar situation. The user has posted a Payment Transaction entry and then voided it. However, the voiding entries are hitting to a blank account. I checked in Smart List as well. The description reads as "Account not found". Do you know how to fix this please?

    Thanks,

    Mangala

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Account Not Found Error - Fixed Asset GL Posting

    nope

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Account Not Found Error - Fixed Asset GL Posting

    Can you explain what exactly you did? I have come a same situation.

    Thanks.

  • Verified answer
    soma Profile Picture
    soma 24,406 on at
    RE: Account Not Found Error - Fixed Asset GL Posting

    Hi All,

    Thank you so much for you response....

    I have resolved this issue by updating the GLINTACCTINDX values in FA00902.

    I think, the cause of this issue would be Asset accounts are mapped after the depreciation has been calculated.

  • soma Profile Picture
    soma 24,406 on at
    RE: Account Not Found Error - Fixed Asset GL Posting

    Justin, thank so much for your reply.

    The problem is not on GL table. I verified the FA00902 tables, there are many rows having the empty GL index values. Currently, I am checking this on test server with the copy of live data.

    I will update once resolved this issue.....

  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Account Not Found Error - Fixed Asset GL Posting

    Hi Soma,

    Is the error appearing on the GL posting Journals?  If so, I'd recommend querying the GL tables to see what account indexes are being used.  Example:  Select * from GL 10001 where JRNENTRY = 'XXX'

    Following on from that, you can confirm if the account indexes exist in both the GL00100 and GL00105.

    Thanks,
    Justin

  • soma Profile Picture
    soma 24,406 on at
    RE: Account Not Found Error - Fixed Asset GL Posting

    Thanks Harry for your time.

    I will try to fix....

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Account Not Found Error - Fixed Asset GL Posting

    Soma - I would log a technical support incident at this point. The query should have picked up any transaction in the (FA00902 - Asset Financial Detail Master) table, which had an Account Index which didn't match up to a GL Account Index.  

    There must be a logical explanation to GP throwing this error.

  • soma Profile Picture
    soma 24,406 on at
    RE: Account Not Found Error - Fixed Asset GL Posting

    Harry,

    The above query does not return any records.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Account Not Found Error - Fixed Asset GL Posting

    Soma,

    Try running this query, it should show any records in the FA00902 table, that don't have a matching ACTINDX in the GL00100 table.

    select * from FA00902 A

    RIGHT JOIN GL00100 B

    on A.GLINTACCTINDX = B.ACTINDX

    WHERE B.ACTINDX is NULL

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans