Account Not Found Error - Fixed Asset GL Posting

(0) Share

Report

Posted on by soma

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

All responses (12)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

RE: Account Not Found Error - Fixed Asset GL Posting

nope
Community Member Microsoft Employee on at

Like (0)

Report

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 24,406 on at

Like (0)

Report

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 24,406 on at

Like (0)

Report

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 2,265 on at

Like (0)

Report

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 24,406 on at

Like (0)

Report

RE: Account Not Found Error - Fixed Asset GL Posting

Thanks Harry for your time.

I will try to fix....
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

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 24,406 on at

Like (0)

Report

RE: Account Not Found Error - Fixed Asset GL Posting

Harry,

The above query does not return any records.
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

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