Account Not Found Error - Fixed Asset GL Posting

(0) Share

Report

Posted on by soma

24,410

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

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

Soma,

Here is an earlier post, which is similar to your own. It contains some good advice.

https://community.dynamics.com/gp/f/32/t/38785.aspx

I would recommend the Fixed Asset SmartList, Add Columns, Sort By Type, Goto Account Index and add the account numbers for Depreciation Expense Account and Depreciation Reserve Account, and then determine which, if any, Assets don't have accounts assigned.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

Harry,

Thanks for the quick response.

I have already checked this post and all the assets are showing the account index for all accounts fields in Fixed Asset smartlist. But, the problem is still same.

Anything else do I need to check?

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

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

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

Harry,

The above query does not return any records.

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

Thanks Harry for your time.

I will try to fix....

Was this reply helpful? Yes No
Justin Thorp 2,265 on at

Like (0)

Report

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

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

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.....

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Thanks.

Was this reply helpful? Yes No