Hi all,
Can someone explain to me the workings of the FA module versus the FA GL? I can't find an explanation on how the FA module works. I inherited a mess of a Fixed Assets listing and there has been large difference of the assets listed in the FA module (1 mil +) compared to the TB/GL listing. I'm trying to figure out how to reconcile them and not have 2 different reports on what is within our Fixed Assets. Thanks so much!
Hello Carp2011,
I have attached a great Fixed Assets Module pdf document for you here. Chapter 14 specifically talks about how Fixed Assets transactions can be integrated to General Ledger.
FixedAssets.pdf
Here’s a very quick overview around how posting to/integrating with GL works in Fixed Assets:
There is a great report called the Fixed Assets to General Ledger Reconciliation report that will show you if there are Fixed Assets transactions that have not been interfaced/posted to GL. This is the report we’d recommend you start with when it comes to reconciling Fixed Assets amounts to GL. You can print that report by clicking on Reports >> Fixed Assets >> Activity >> click on the drop down and select Fixed Assets to General Ledger Reconciliation >> New (and add your report options from there).
Additionally, a while back we created a nice SQL View (that you can use to create a smart list with smart list designer) that will show you what has and has not been interfaced/posted to GL from Fixed Assets. Here’s a link to a great blog that talks about using SQL Views to create a smart list. You can download the Fixed Assets Interface view from the word document attached to that blog:
https://community.dynamics.com/gp/b/dynamicsgp/posts/microsoft-dynamics-gp-sql-views-for-smartlist-designer-to-enhance-reporting
I hope this helps!
Thank you for using Microsoft Dynamics Communities,
Andrea Melroe
Sr. Technical Advisor
Microsoft Dynamics GP
Thank you so much! This has helped greatly
Thanks, Andrea for sharing this info.
Is that possible can share the SQL Script for FA Reconcile to GL?
Regards,
Syed
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,047
André Arnaud de Cal... 885 Super User 2025 Season 2
Sohaib Cheema 592 User Group Leader
