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
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
nope
Can you explain what exactly you did? I have come a same situation.
Thanks.
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.
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.....
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
Thanks Harry for your time.
I will try to fix....
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.
Harry,
The above query does not return any records.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156