10
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!
Thanks, Andrea for sharing this info.
Is that possible can share the SQL Script for FA Reconcile to GL?
Regards,
Syed
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.
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:
I hope this helps!
Thank you for using Microsoft Dynamics Communities,
Andrea Melroe
Sr. Technical Advisor
Microsoft Dynamics GP
#1
Martin Dráb
601
Most Valuable Professional
#2
Abhilash Warrier
416
#3
Adis
384
Super User 2025 Season 1
Share
Report
All responses (
Answers (
